While creating external table with location i am getting error I tried with location option getting an error CREATE external TABLE user_db.test_hbase( col_1 String, col_2 String ) CLUSTERED BY (col_1) INTO 6 BUCKETS STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,test_hbase:col_2") LOCATION '/user/production/' TBLPROPERTIES("hbase.table.name" = "user_db:test_hbase"); FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:LOCATION may not be specified for HBase.) ... View more

Hi Guys, Is there a way to check hive external tables which are created N days before and drop those tables along with underlying hdfs data. Can this be achieved in unix script? ... View more