search

harbby / presto-connectors

facebook presto connectors
Apache License 2.0
49 stars 22 forks source link

presto-hbase create external table failed #11

Closed newfan closed 5 years ago

newfan commented 5 years ago

presto:default> CREATE TABLE wxapp_user_info (rowkey VARCHAR,user_id VARCHAR,nick VARCHAR)WITH (external = true,column_mapping = 'user_id:cf:user_id,nick:cf:nick');

Query 20190213_060157_00014_yundz failed: Catalog 'hive' does not support table property 'external'

this is my environment：

hive version 2.1.1 hbase version 1.2.4 presto: 0.216

newfan commented 5 years ago

Has been resolved：

add use hbase.default;

presto:default> use hbase.default; presto:default> CREATE TABLE wxapp_user_info (rowkey VARCHAR,user_id VARCHAR,nick VARCHAR)WITH (external = true,column_mapping = 'user_id:cf:user_id,nick:cf:nick');