Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id C420A200D1F for ; Fri, 13 Oct 2017 17:47:51 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id C29B01609E9; Fri, 13 Oct 2017 15:47:51 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 141F61609D1 for ; Fri, 13 Oct 2017 17:47:50 +0200 (CEST) Received: (qmail 97409 invoked by uid 500); 13 Oct 2017 15:47:50 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Delivered-To: moderator for dev@phoenix.apache.org Received: (qmail 60033 invoked by uid 99); 13 Oct 2017 06:19:48 -0000 X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=vY29xjWBaqu+rvTa1ozujFHwE0IyeMRkxiMd4uCoEh4=; b=N4UB2sGnYoh5+dfFaBjjyas4OwuNtB/KjzgXw7v5RTcj1ySJb0VNEhlFW576H2DZ4k ETXi395mwSiQD9yreFHD4kxiP3BfBEyTWpNcIspAM/eDIFEb6oJaooWMAsFxuk7jepQ1 jtNYON1CLFnYbdiJlfj21wpEQHw50jOXpzgHV6Ub143hMRPrr0CNREQAzVwf0LeTKM6G IskSMkHn+lOXF9SXXJZWANDPVz0xPrD461eusp20oIv2yn/w8U9fnWRqgl+dnBT2kuAQ mRtsh1kGqdGPBmk5r43s38dfu48kqdEVxrJr1dARmpt/VNbmxl8p0k65ZiUTdvMixAq8 CQoA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=vY29xjWBaqu+rvTa1ozujFHwE0IyeMRkxiMd4uCoEh4=; b=qTvEE6lB83Tehn3n7wxH1i400IO735JVAsa725j1kK/VgPR38Q9mdKnhBqluylGzkM vdBoV3TK57cBfgI+0UonOf/6c7JKLKVLNrTK54T+xeSztqGAgJ7CLFcYb/GpTgf/E5Tp 8lEzcQz1fCEYZI7R9KVsFxy70JiAOoyUA629AvwFFDWXx+/Jqeva9JAIW+2QDrnMRGJM g3Z+salfwxl1N61iOBFLjEz1rxvdj7G68bre7NmQlsREZUKufSS6ZI38q7Z7ayVNSQLZ 7JK37MCyKVJahpDf1dMpO5vjbf7dq7uZ9x8u0q2IQdLw7MSVAd4/cYSYzKsWsCz6YoaE UQrg== X-Gm-Message-State: AMCzsaWqfN29CQeeTS3d8Vj0FvT1XEPS48W0wN/K5zvSTysF5Emk0jy0 skeKZn8L8Xuxs5sxue91nB90J/kPo9tR6TsdB4sU1w== X-Google-Smtp-Source: AOwi7QCdUammTnsqK48ZS/e6IvOKUJZwnocIL+flngD/xaXJUihHHFzX6unq7CIO53PrsG28XptEqfP3yJxv/f+J35I= X-Received: by 10.37.114.70 with SMTP id n67mr208739ybc.77.1507874894400; Thu, 12 Oct 2017 23:08:14 -0700 (PDT) MIME-Version: 1.0 From: Anjan K Date: Fri, 13 Oct 2017 11:38:13 +0530 Message-ID: Subject: Spark dataframe returning only structure when connected to Phoenix query server To: dev@phoenix.apache.org Content-Type: multipart/alternative; boundary="94eb2c00420272570a055b677b9a" archived-at: Fri, 13 Oct 2017 15:47:52 -0000 --94eb2c00420272570a055b677b9a Content-Type: text/plain; charset="UTF-8" Hi All, I am connecting to hbase ( ver 1.2) via phoenix (4.11) queryserver from Spark 2.2.0, but the dataframe is returning the only table structure with empty rows thoug data is present in table. Here is the code I am using to connect to queryserver. // ---jar ----phoenix-4.11.0-HBase-1.2-thin-client.jar val prop = new java.util.Properties prop.setProperty("driver", "org.apache.phoenix.queryserver.client.Driver") val url = "jdbc:phoenix:thin:url=http://localhost:8765;serialization =PROTOBUF" val d1 = spark.sqlContext.read.jdbc(url,"TABLE1",prop) d1.show() Can anyone please help me in solving this issue. Thanks in advance --94eb2c00420272570a055b677b9a--