amp(event_time) is:
Wed May 30 16:15:06 CST 2012, should I should the value as long type?
Regards,
Peyton
-原始邮件-
From: Mark Grover
Sent: Thursday, May 31, 2012 11:14 AM
To: user@hive.apache.org
Subject: Re: How to execute query with timestamp type (Hbase/Hive
integeration)
Hi Pey
should the value as long type?
Regards,
Peyton
-原始邮件-
From: Mark Grover
Sent: Thursday, May 31, 2012 11:14 AM
To: user@hive.apache.org
Subject: Re: How to execute query with timestamp type (Hbase/Hive
integeration)
Hi Peyton,
It seems like something to do with timestamp mapping.
What
ubject: Re: How to execute query with timestamp type (Hbase/Hive integeration)
Actually I can execute the first sql and it works well, all the libs you
specified is under the hive lib folder,
I doubt if the issue is caused by the timestamp mapping between hbase with
hive..
Regards,
Peyton
@hive.apache.org
Subject: Re: How to execute query with timestamp type (Hbase/Hive integeration)
Add these file to hive lib folder
>>> hadoop-0.20-core.jar
>>> hive/lib/hive-exec-0.7.1.jar
>>> hive/lib/hive-jdbc-0.7.1.jar
>>> hive/lib/hive-metastore-0.7.1.jar
>>
Add these file to hive lib folder
>>> hadoop-0.20-core.jar
>>> hive/lib/hive-exec-0.7.1.jar
>>> hive/lib/hive-jdbc-0.7.1.jar
>>> hive/lib/hive-metastore-0.7.1.jar
>>> hive/lib/hive-service-0.7.1.jar
>>> hive/lib/libfb303.jar
>>> lib/commons-logging-1.0.4.jar
>>> slf4j-api-1.6.1.jar
>>> slf4j-log4j
Hi,
I build the hive table mapped with hbase table,
CREATE TABLE http_access(key string, client_ip string, client_port int,
request_method string, event_time timestamp)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
"hbase.columns.mapping" =
":key,client:ip