hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Russell Pierce (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11454) Using select columns vs. select * results in long running query
Date Mon, 17 Aug 2015 23:40:46 GMT

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

Russell Pierce commented on HIVE-11454:
---------------------------------------

How sure are you that you are looking at a JDBC issue?  On 0.13.1 HiveServer1 was still around
and I'm seeing slower query performance for the select columns than select * without JDBC
being (as far as I know, and I'm a novice here - so I might be wrong) involved.  The slow
down (as far as I can tell) is associated with the time to start the Hadoop job... that is,
select columns triggers a hadoop job but select * does not.

> 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)

Mime
View raw message