Support Questions
Find answers, ask questions, and share your expertise

Beeline/Hive query HBase table that uses schema

Beeline/Hive query HBase table that uses schema

New Contributor

In HBase, I have a table similar to:


hbase(main):001:0> desc 'schema:table'
Table schema:table is ENABLED
{NAME => 'data', . . . }

1 row(s) in 1.0230 seconds


Key thing here is the table is referenced with a colon.  We have to use schema names here.


In Beeline (Hive):

beeline shell
beeline> !connect jdbc:hive2:// user pass
scan complete in 1ms
Connecting to jdbc:hive2://
Connected to: Apache Hive (version 1.1.0-cdh5.16.2)
Driver: Hive JDBC (version 1.1.0-cdh5.16.2)

0: jdbc:hive2://> desc schema:table;
Error: Error while compiling statement: FAILED: ParseException line 1:13 missing EOF at ':' near 'schema' (state=42000,code=40000)


Any way around the colon problem?  Thanks.