Hello the list,
Today I created a table in HDFS space:
apache drill (hdfs.tmp)> create table tt1 as select * from `people.csvh`
limit 1000;
I can run query to this table:
apache drill (hdfs.tmp)> select count(*) from tt1;
+--------+
| EXPR$0 |
+--------+
| 1000 |
+--------+
1 row selected (0.217 seconds)
And the table located in HDFS by listing the directory:
$ hdfs dfs -ls /tmp/test/tt1
Found 1 items
-rw-rw-r-- 3 pyh supergroup 100618 2022-04-06 09:37
/tmp/test/tt1/0_0_0.parquet
But the `show table` command does not work:
apache drill (hdfs.tmp)> show tables;
+--------------+------------+
| TABLE_SCHEMA | TABLE_NAME |
+--------------+------------+
No rows selected (0.177 seconds)
Do you know why?
Thanks.