Re: integration issure about hive and hbase

2013-07-07 Thread Cheng Su
Did you hbase cluster start up? The error message is more like that something wrong with the classpath. So maybe you'd better also check that. On Mon, Jul 8, 2013 at 1:54 PM, ch huang wrote: > i get error when try create table on hbase use hive, anyone can help? > > hive> CREATE TABLE hive_hba

integration issure about hive and hbase

2013-07-07 Thread ch huang
i get error when try create table on hbase use hive, anyone can help? hive> CREATE TABLE hive_hbasetable_demo(key int,value string) > STORED BY 'ora.apache.hadoop.hive.hbase.HBaseStorageHandler' > WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val") > TBLPROPERTIES ("hbase.t

Need help in Hive

2013-07-07 Thread Maheedhar Reddy
Hi All, I have Hive 0.8.0 version installed in my single node Apache Hadoop cluster. I have a time column which is in format *MM:SS* (Minutes:seconds). I tried the date functions to get the value in MM:SS format. But its not working out. Below is my column for your reference. *Active Time* *12: