Trafodion 查看原生Hive表

Trafodion中的get命令可以用来查看Hive中有哪些表，具体方法如下，
关于get命令的详细用法，请参考官方文档：http://trafodion.incubator.apache.org/docs/sql_reference/index.html#get_statement

1 hive命令查看hive中的表

hive> show tables in default;
OK
aa
eboxdata
eboxdata30w
eboxdata_30m
eboxdata_30m_tmp
native_zhiyi
Time taken: 0.024 seconds, Fetched: 6 row(s)

hive> show schemas;
OK
default
pksaas
Time taken: 1.814 seconds, Fetched: 2 row(s)

2 Trafodion查看hive中的表

[trafodion@n12 ~]$ trafci

Welcome to EsgynDB Enterprise Command Interface
Copyright (c) 2015-2016 Esgyn Corporation

Host Name/IP Address: n12:23400
User Name: zz

Connected to EsgynDB Advanced

SQL>get tables in schema hive.hive;

aa
eboxdata
eboxdata_30m
eboxdata_30m_tmp
eboxdata30w
native_zhiyi

--- SQL operation complete.

SQL>get tables in schema hive.pksaas;

eboxdata

--- SQL operation complete.