Re: ERROR 201 (22000) illegal data error, expected length at least 4 but had ...

2016-08-11 Thread Dong-iL, Kim
Thank you so much. > On Aug 9, 2016, at 6:27 PM, Ankit Singhal wrote: > > Hi Dong-iL Kim, > > As you said , you are inserting data from hbase, so the exception can be seen > if the primary key and columns are not properly represented or encoded as per > Phoenix. > > Please see for more detai

Re: monitoring status of CREATE INDEX operation

2016-08-11 Thread James Taylor
Hi Nathan, If your table is large, I'd recommend creating your index asynchronously. To do that, you'd add the ASYNC keyword to the end of your CREATE INDEX call. In this case, the index will be built through Map Reduce in a more resilient manner (i.e. the client going up or down won't impact it an

monitoring status of CREATE INDEX operation

2016-08-11 Thread Nathan Davis
Hi All, I executed a CREATE INDEX against a fairly large table. And I received a timeout error after a minute or two, which I understand is expected. `!tables` in sqlline shows the index is still in BUILDING state after 2 hours, which may be accurate since it is a pretty large table and my cluster

Issues while Running Apache Phoenix against TPC-H data

2016-08-11 Thread Amit Mudgal
> > Hi team, > > I was evaluating Apache Phoenix against the TPC-H data based on the > presentation given at Hadoop summit in june stating that most TPC-H queries > should run. > Here is the setup details i have in my local environment : > > 1. One master node and 3 region servers with 3.6 TB

Re: Phoenix Ifnull

2016-08-11 Thread James Taylor
Lukáš is correct, but if the CASE WHEN variant of the same didn't work, please file a JIRA (ideally with a unit test that repros the problem). Thanks, James On Thu, Aug 11, 2016 at 12:20 AM, Lukáš Lalinský wrote: > On Thu, Aug 11, 2016 at 9:00 AM, ankit beohar > wrote: > >> I want to implement

Re: Problems with Phoenix bulk loader when using row_timestamp feature

2016-08-11 Thread Ankit Singhal
Samarth, filed PHOENIX-3176 for the same. On Wed, Aug 10, 2016 at 11:42 PM, Ryan Templeton wrote: > 0: jdbc:phoenix:localhost:2181> explain select count(*) from > historian.data; > > *+--+* > > *| * * PLAN ** |* > > *+--

Apache Phoenix in Unix Shell

2016-08-11 Thread ankit beohar
Hi All, I want to write unix shell script for phoenix query like we are doing in MySQL. Can anybody share the way. Best Regards, ANKIT BEOHAR

Phoenix-queryserver-client jar is too fat in 4.8.0

2016-08-11 Thread YoungWoo Kim
Hi, It looks like thin client jar in 4.8.0 (rc2) is fat. I'm runng into problem to make my applications working with 4.8.0 thin driver. There are many conflicts with my existing dependencies. 28mb for thin client jar is strange for me. I missed something about new thin client? Youngwoo

Re: Phoenix Ifnull

2016-08-11 Thread Lukáš Lalinský
On Thu, Aug 11, 2016 at 9:00 AM, ankit beohar wrote: > I want to implement If null in apache phoenix like mysql. > > select ifnull(rowkey,myvalue),ifnull(col1,mycolvalue) from table where > rowkey='abc'; > > I tried below query but did not work:- > > select case when APP_KEY is null then 'nullval

Phoenix Ifnull

2016-08-11 Thread ankit beohar
Hi All, I want to implement If null in apache phoenix like mysql. select ifnull(rowkey,myvalue),ifnull(col1,mycolvalue) from table where rowkey='abc'; I tried below query but did not work:- select case when APP_KEY is null then 'nullvalue' else APP_KEY end from "CheckDump"; Best Regards, ANKI