Re: where clause on Phoenix view built on Hbase table throws error

2016-10-05 Thread Dima Spivak
I think you might have better luck with Phoenix questions on the Phoenix user mailing list. :) -Dima On Wed, Oct 5, 2016 at 7:34 AM, Mich Talebzadeh wrote: > Thanks John. > > 0: jdbc:phoenix:rhes564:2181> select "Date","volume" from "tsco" where > "Date" =

Re: where clause on Phoenix view built on Hbase table throws error

2016-10-05 Thread Mich Talebzadeh
Thanks John. 0: jdbc:phoenix:rhes564:2181> select "Date","volume" from "tsco" where "Date" = '1-Apr-08'; +---+---+ | Date| volume | +---+---+ | 1-Apr-08 | 49664486 | +---+---+ 1 row selected (0.016 seconds) BTW I believe double quotes in

Re: where clause on Phoenix view built on Hbase table throws error

2016-10-05 Thread John Leach
Remove the double quotes and try single quote. Double quotes refers to an identifier… Cheers, John Leach > On Oct 5, 2016, at 9:21 AM, Mich Talebzadeh wrote: > > Hi, > > I have this Hbase table already populated > > create 'tsco','stock_daily' > > and populated

where clause on Phoenix view built on Hbase table throws error

2016-10-05 Thread Mich Talebzadeh
Hi, I have this Hbase table already populated create 'tsco','stock_daily' and populated using $HBASE_HOME/bin/hbase org.apache.hadoop.hbase.mapreduce.ImportTsv -Dimporttsv.separator=',' -Dimporttsv.columns="HBASE_ROW_KEY,

Re: HBase thrift C# impersonation

2016-10-05 Thread kumar r
Hi Dima, Thanks for the update. Let me check further. On Wed, Oct 5, 2016 at 2:28 AM, Dima Spivak wrote: > Hey Kumar, > > The ref guide section on enabling security for the Thrift gateway [1] is a > good place to start. Have you gone through that? > > 1.