[ 
https://issues.apache.org/jira/browse/HIVE-27583?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Zhihua Deng reassigned HIVE-27583:
----------------------------------

    Assignee: Zhihua Deng

> Get the meta of query with limit 0 in JDBC storage handler
> ----------------------------------------------------------
>
>                 Key: HIVE-27583
>                 URL: https://issues.apache.org/jira/browse/HIVE-27583
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Zhihua Deng
>            Assignee: Zhihua Deng
>            Priority: Major
>
> Following the discussion on HIVE-27487, In general the JDBC storage handler 
> adds limit 1 to the query in order to fetch the metadata, say the column 
> names and its types. This jira is trying to explore if we can add "limit 0" 
> to the query as we don't care about the records returned, and confirm that 
> the predicate is pushed down to the storage, this will reduce the overhead of 
> executing the query.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to