Hi - I'm new to Phoenix and love everything so far. Have installed a cluster
and developing some sample codes on it. I have the following question:
Can I use Hive to run queries on tables created by Phoenix? I used Phoenix
to create a new table name Person and inserted several rows through Java
API. It worked great. However, when trying to do this on Hive shell:
create external table if not exists hbasepersontable (id int, firstname
STRING, lastname STRING )
stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
with serdeproperties ('hbase.columns.mapping' = ':key, firstname:firstname,
lastname:lastname')
tblproperties ('hbase.table.name' = 'Person');
It threw an exception and said the table 'Person' does not exists. I assume
I can do that because these tables are created on Hbase. Please help.
Thanks,
William.
