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