Re: no data in external table

2012-10-05 Thread alxsss
Hi, I upgraded to hadoop-1.0.3, but still have the same results. I did as you suggested. When I do "select * from hbase_table_2" it does not output any job information. When I do "select value from hbase_table_2" it outputs job information. In both cases there is no data returned. Thanks.

Re: no data in external table

2012-10-04 Thread alxsss
Hi, In the hbase table I do not see column qualifier, only family. For testing connection to hbase I also created a table using CREATE TABLE hbase_table_1(key int, value string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,c

Re: no data in external table

2012-10-04 Thread alxsss
Hi, In hive shell I did create external table myextrenaltable (key string, metadata string, inlinks string, outlinks string) stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' with serdeproperties ("hbase.columns.mapping" = ":key,mtdt:string,il:string,ol:string") tblproperties ("

no data in external table

2012-10-04 Thread alxsss
Hello, I use hive-0.9.0 with hadoop-0.20.2 and hbase -0.92.1. I have created external table, mapping it to an existing table in hbase. When I do "select * from myextrenaltable" it returns no results, although scan in hbase shows data, and I do not see any errors in jobtracker log. Any ideas ho