Please use "show files" [1] here. For files on DFS which are pre-existing and new files created via Drill CTAS, the "show files" command must be used. I think the word "table" in "create table as" is kind of a misnomer, remnant of the relational world.
For Hive, HBase, MapR-DB & such, you will be able to use the "show tables" [2] command. [1] https://drill.apache.org/docs/show-files/ [2] https://drill.apache.org/docs/show-tables/ On Tue, Jul 5, 2016 at 6:14 AM, 潘志伟 <[email protected]> wrote: > hello, > i am use drill 1.7 version,i create table ,but use show tables command > can't find the table; > > please tell me why,thank you ! > > 0: jdbc:drill:drillbit=localhost> create table `user_log` as select > count(*) from hdfs.`/data/test_tab_0/` ; > +-----------+----------------------------+ > | Fragment | Number of records written | > +-----------+----------------------------+ > | 0_0 | 1 | > +-----------+----------------------------+ > > then ,i use show tables command,but can't find the created tables; > > 0: jdbc:drill:drillbit=localhost> show tables; > +---------------+-------------+ > | TABLE_SCHEMA | TABLE_NAME | > +---------------+-------------+ > +---------------+-------------+ > > but , can select data from the table > > 0: jdbc:drill:drillbit=localhost> select * from `user_log`; > +---------+ > | EXPR$0 | > +---------+ > | 10 | > +---------+ > > > ------------------ > > > > 潘志伟 > > 电话：13402077855 > > 诸葛天下（北京）信息技术股份有限公司 > > 北京通州区万达广场B座29层
