Generally, both. Drill will push down as much of the query as it can to
Hive then apply the operations that it couldn't push down itself. You
can see a lot of what's going on by looking at the physical plan
recorded in the query profile, e.g. in the web UI.
On 2022/04/05 13:41, Wes Peng wrote:
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.
