Secondary indexes updates are taking longer.

2016-02-23 Thread Saurabh Agarwal (BLOOMBERG/ 731 LEX)
Hi, I have created a table with 40 columns and secondary index on 35 of the columns individually. Loaded around half million records. Data in all columns is smaller size. For a long time, the index had not been updated. It almost took overnight to catch up with all the records. Is this us

Dynamic Fields And Views

2016-02-23 Thread Steve Terrell
I have a table with many dynamic fields. Works great. However, it's a bit of a nuisance to have to supply each dynamic field's type in every query. Example: select "dynamic_field" from MY_TABLE("dynamic_field" varchar) This example is not too bad, but image it with 5+ dynamic fields being used.

Re: Looks Like a SELECT Bug, But LIMIT Makes It Work

2016-02-23 Thread Steve Terrell
Done! https://issues.apache.org/jira/browse/PHOENIX-2709 . On Tue, Feb 23, 2016 at 3:15 PM, Sergey Soldatov wrote: > Hi Steve, > It looks like a bug. So, please file a JIRA. > > Thanks, > Sergey > > On Tue, Feb 23, 2016 at 12:52 PM, Steve Terrell > wrote: > > I came across a 4.6.0 query that I

Re: Looks Like a SELECT Bug, But LIMIT Makes It Work

2016-02-23 Thread Sergey Soldatov
Hi Steve, It looks like a bug. So, please file a JIRA. Thanks, Sergey On Tue, Feb 23, 2016 at 12:52 PM, Steve Terrell wrote: > I came across a 4.6.0 query that I could not make work unless I add a > "limit" to the end, where it should be totally unnecessary. > > select * from BUGGY where F1=1 an

Looks Like a SELECT Bug, But LIMIT Makes It Work

2016-02-23 Thread Steve Terrell
I came across a 4.6.0 query that I could not make work unless I add a "limit" to the end, where it should be totally unnecessary. select * from BUGGY where F1=1 and F3 is null results in no records found select * from BUGGY where F1=1 and F3 is null limit 999 results (correctly) in one record fou

Re: Phoenix creates 224 regions for SYSTEM.SEQUENCE and then it kills all region servers

2016-02-23 Thread Johannes
Thank you very very much. I solved it! $HBASE_HOME was not set. HBASE_HOME=/etc/hbase export HBASE_HOME /usr/bin/phoenix-sqlline.py localhost:2181:/hbase -- Johannes Am 22.02.2016 um 17:01 schrieb James Taylor: Your client-side hbase-site.xml is likely not getting picked up. Make sure it's on t

Re: Phoenix rowkey

2016-02-23 Thread Sanooj Padmakumar
Thanks Sergey. I tried as per the suggestion and by having a look at the Phoenix code base. But still dont get the expected result. I have pasted the java code, *valueStr * is always coming as null for me. Also tried appending 0x00 that didnt give me result as well. *Primary Column Values : *