[ANNOUNCE] Apache Phoenix 4.8.1 is available for download

2016-09-27 Thread larsh
The Phoenix Team is pleased to announce the immediate release of Apache Phoenix 4.8.1. Download it from your favorite Apache mirror [1]. Apache Phoenix 4.8.1 a bug fix release for the Phoenix 4.8 release line, compatible with Apache HBase 0.98, 1.0, 1.1 & 1.2. This release fixes the following 4

Re: Phoenix ResultSet.next() takes a long time for first row

2016-09-27 Thread Sasikumar Natarajan
Any one has suggestions for the performance issue discussed in this thread?. Your suggestions would help me resolve this issue. Infrastructure details: Azure HDInsight HBase Type Node SizeCores Nodes Head D3 V2 8 2 Region D3 V2 16 4 ZooKeeper D3 V2 12 3 Thanks, Sasikumar Natarajan.

Re: Hash join confusion

2016-09-27 Thread Sumit Nigam
Hi, Is there any document which can help me understand explain plan output in detail? Or, which piece of code should I look at, to get an idea? Here is explain plan for inner join query below. Can anyone help in explaining it to me? Like, as per the plan which table is being cached, etc.?Here,  i

Data present in HBase, phoenix not returning anything

2016-09-27 Thread Venkat Uk
Hi, The process which we followed is as : 1. Clone a hbase snapshot to a table 2. Create schema in phoenix for new table 3. Create index for the table. When I query the data, this is what I'm getting: select /*+ NO_INDEX */ count(*) from "schema".CUSTOMERS where "id"=1234; +

Re: property object is being modified

2016-09-27 Thread Josh Elser
Thanks bud! Prabhjyot Singh wrote: Yes, I did, https://issues.apache.org/jira/browse/PHOENIX-3315. and somehow didn't tag you. On 27 September 2016 at 07:57, Josh Elser mailto:josh.el...@gmail.com>> wrote: Did you ever create this issue, Prabhjyot? I don't recall seeing it come across

Hash join confusion

2016-09-27 Thread Sumit Nigam
Hi, I am using hbase 1.1 with phoenix 4.6.  I have a table with row key as (current_timestamp, id) which is salted and index on (id). This table has ~3 million records. I have a query like given below.  SELECT  ID, CURRENT_TIMESTAMP, from TBL                        as a inner join (             

bulk-upsert spark phoenix

2016-09-27 Thread Antonio Murgia
Hi, I would like to perform a Bulk insert to HBase using Apache Phoenix from Spark. I tried using Apache Spark Phoenix library but, as far as I was able to understand from the code, it looks like it performs a jdbc batch of upserts (am I right?). Instead I want to perform a Bulk load like the one