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" = '1-Apr-08';
> +---+---
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
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 using
> $HBASE_HOME/bin/hba
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,
stock_info:stock,stock_info:ticker,stock_daily:Date,stock_daily:open,stoc