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
schema:table
COLUMN FAMILIES DESCRIPTION
{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://my.server.com:10000 user pass
scan complete in 1ms
Connecting to jdbc:hive2://my.server.com:10000
Connected to: Apache Hive (version 1.1.0-cdh5.16.2)
Driver: Hive JDBC (version 1.1.0-cdh5.16.2)

0: jdbc:hive2://my.server.com:> 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.