hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Hawkins (JIRA)" <>
Subject [jira] [Commented] (HIVE-11454) Using select columns vs. select * results in long running query
Date Tue, 18 Aug 2015 12:49:45 GMT


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:
>             Project: Hive
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 0.13.1
>            Reporter: Steven Hawkins
> Originally logged as
> 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 :
> "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

View raw message