[ 
https://issues.apache.org/jira/browse/DRILL-4127?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15045989#comment-15045989
 ] 

ASF GitHub Bot commented on DRILL-4127:
---------------------------------------

Github user vkorukanti commented on the pull request:

    https://github.com/apache/drill/pull/286#issuecomment-162705796
  
    Have some minor comments on the DRILL-4127. LGTM, +1.


> HiveSchema.getSubSchema() should use lazy loading of all the table names
> ------------------------------------------------------------------------
>
>                 Key: DRILL-4127
>                 URL: https://issues.apache.org/jira/browse/DRILL-4127
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Jinfeng Ni
>            Assignee: Jinfeng Ni
>
> Currently, HiveSchema.getSubSchema() will pre-load all the table names when 
> it constructs the subschema, even though those tables names are not requested 
> at all. This could cause considerably big performance overhead, especially 
> when the hive schema contains large # of objects (thousands of tables/views 
> are not un-common in some use case). 
> In stead, we should change the loading of table names to on-demand. Only when 
> there is a request of get all table names, we load them into hive schema.
> This should help "show schemas", since it only requires the schema name, not 
> the table names in the schema. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to