Got a hadoop server IPC version mismatch ERROR in TestCliDriver avro_joins.q

2013-01-13 Thread Bing Li
Hi, guys I applied the patches for HIVE-895 ( add SerDe for Avro serialized data ) and HIVE-3273 (Add avro jars into hive execution classpath ) on Hive-0.9.0. And then I ran the following command with hadoop-1.0.3 and avro-1.6.3 ant test -Dtestcase=TestCliDriver -Dqfile=avro_joins.

Re: Mapping HBase table in Hive

2013-01-13 Thread Ibrahim Yakti
Thanks Bejoy, Seems it worked, in the mapping of the column family I used ":key" and that's it, in addition as per some articles there should be no spaces in mapping, below is the create table sample: CREATE EXTERNAL TABLE hbase_orders(id bigint, value bigint, date_lastchange > string, date_inser

Re: Mapping HBase table in Hive

2013-01-13 Thread bejoy_ks
Hi Ibrahim. SQOOP is used to import data from rdbms to hbase in your case. Please get the schema from hbase for your corresponding table and post it here. We can point out how your mapping could be. Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- Fr

Re: Mapping HBase table in Hive

2013-01-13 Thread Ibrahim Yakti
Thanks Bejoy, what do you mean by: > If you need to map a full CF to a hive column, the data type of the hive > column should be a Map. > suppose I used sqoop to move data from mysql to hbase and used id as a column family, all the other columns will be QF then, right? The integration document