Hello the community,

Given the case I run a SQL query to hive table.
Will this statement run by drill, or by Hive, or both?

for example,

apache drill (hive.default)> show tables;
+--------------+------------+
| TABLE_SCHEMA | TABLE_NAME |
+--------------+------------+
| hive.default | hivemysql  |
+--------------+------------+
1 row selected (5.613 seconds)

apache drill (hive.default)> select * from hivemysql;
+----+-----------+------------+
| id |   name    |    born    |
+----+-----------+------------+
| 1  | john doe  | 1999-02-02 |
| 2  | lisa holt | 1977-01-01 |
+----+-----------+------------+
2 rows selected (3.979 seconds)

Thank you.

Reply via email to