[ https://issues.apache.org/jira/browse/DRILL-4577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15226708#comment-15226708 ]
ASF GitHub Bot commented on DRILL-4577: --------------------------------------- GitHub user hsuanyi opened a pull request: https://github.com/apache/drill/pull/461 DRILL-4577: Construct a specific path for querying all the tables fro… …m a hive database @vkorukanti Can you help review? Thanks. You can merge this pull request into a Git repository by running: $ git pull https://github.com/hsuanyi/incubator-drill DRILL-4577 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/drill/pull/461.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #461 ---- commit 135464f53fe1a3070df4495e350be3e540183bfe Author: Hsuan-Yi Chu <hsua...@usc.edu> Date: 2016-04-04T23:05:04Z DRILL-4577: Construct a specific path for querying all the tables from a hive database ---- > Improve performance for query on INFORMATION_SCHEMA when HIVE is plugged in > --------------------------------------------------------------------------- > > Key: DRILL-4577 > URL: https://issues.apache.org/jira/browse/DRILL-4577 > Project: Apache Drill > Issue Type: Improvement > Components: Storage - Hive > Reporter: Sean Hsuan-Yi Chu > Assignee: Sean Hsuan-Yi Chu > Fix For: 1.7.0 > > > A query such as > {code} > select * from INFORMATION_SCHEMA.`TABLES` > {code} > is converted as calls to fetch all tables from storage plugins. > When users have Hive, the calls to hive metadata storage would be: > 1) get_table > 2) get_partitions > However, the information regarding partitions is not used in this type of > queries. Beside, a more efficient way is to fetch tables is to use > get_multi_table call. -- This message was sent by Atlassian JIRA (v6.3.4#6332)