我可以使用apachedrill查询命名空间中的hbase表吗?

doinxwow  于 2021-06-09  发布在  Hbase
关注(0)|答案(1)|浏览(360)

当我说show tables时,我看到hbase中的表;

jdbc:drill:zk=<zkhost>> USE hbase;
+-------+------------------------------------+
|  ok   |              summary               |
+-------+------------------------------------+
| true  | Default schema changed to [hbase]  |
+-------+------------------------------------+

ns is the namespace
table1,2,3 are tables inside the namespace.

: jdbc:drill:zk=<zkhost>> show tables;
+---------------+----------------------------------+
| TABLE_SCHEMA  |            TABLE_NAME            |
+---------------+----------------------------------+
| hbase         | ATLAS_ENTITY_AUDIT_EVENTS        |
| hbase         | ns:table1                        |
| hbase         | ns:table2                        |
| hbase         | ns:table3                        |
| hbase         | atlas_janus                      |
+---------------+----------------------------------+
6 rows selected (30.111 seconds)

但是当我尝试查询表时,drill并没有标识名称空间中的表。

0: jdbc:drill:zk=vginthw496> select * from hbase.table2 limit 10;
Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 19: Object 'table2' not found within 'hbase'

[Error Id: 02353729-39b2-4894-a21f-b6662a2a7a3c on <hostname>:31010] (state=,code=0)

如何使用apachedrill查询命名空间内的hbase表?

xqkwcwgp

xqkwcwgp1#

使用 ```` ,如下所示:

select * from `namespace:table` limit 1;

相关问题