[
https://issues.apache.org/jira/browse/HIVE-11454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14701197#comment-14701197
]
Steven Hawkins commented on HIVE-11454:
---------------------------------------
No, I'm not sure that it's just a JDBC issue. That's just the entry point we
were using. So then the followup questions are:
Is this expected behavior?
And is there a way to mitigate the slowdown? For example is it better to just
issue "select *" when possible and perform column projection at the client
side? Or will we hit this for a broad class of queries?
> Using select columns vs. select * results in long running query
> ---------------------------------------------------------------
>
> Key: HIVE-11454
> URL: https://issues.apache.org/jira/browse/HIVE-11454
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.13.1
> Reporter: Steven Hawkins
>
> Originally logged as https://issues.jboss.org/browse/TEIID-3580
> When using the JDBC jars for Hive 0.13.1 running on HDP 2.1, some queries
> executed against table 'default.sample_07' takes approximately 20-30 seconds
> to return.
> The Hive JDBC jars for version 0.13.1 can be found here :
> https://github.com/vchintal/hive-jdbc-jars-archive
> "SELECT g_0.code, g_0.description, g_0.total_emp, g_0.salary FROM sample_07
> AS g_0" run from a standalone JDBC project results in a 20+ second delay.
> However "SELECT * FROM sample_07" has no delay. The same 500 are returned
> either way.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
