I'm trying to create an external table to a pre-existing HBase table
using Hive trunk, like so:

CREATE EXTERNAL TABLE hbase_metrics (key string, value map<string,int>)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH
SERDEPROPERTIES ("hbase.columns.mapping" = ":key,counters:")
TBLPROPERTIES ("hbase.table.name" = "metrics");

I'm getting this error:

http://xstevens.pastebin.mozilla.org/863392

The SDS table in MySQL doesn't have a default value for IS_COMPRESSED. 
How do I specify a value for this via create table?

Thanks,


-Xavier

Reply via email to