drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3623) Hive query hangs with limit 0 clause
Date Fri, 09 Oct 2015 13:26:26 GMT

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

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

Github user jacques-n commented on a diff in the pull request:

    https://github.com/apache/drill/pull/193#discussion_r41628985
  
    --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/planner/sql/handlers/DefaultSqlHandler.java
---
    @@ -162,6 +166,9 @@ public PhysicalPlan getPlan(SqlNode sqlNode) throws ValidationException,
RelConv
     
         log("Optiq Logical", queryRelNode, logger);
         DrillRel drel = convertToDrel(queryRelNode, validatedRowType);
    +    if (otherPlan != null) {
    --- End diff --
    
    This is a hack. Let's create a relnode which is equivalent to using a pojorecord reader
and then when we create the plan, it will effectively be a direct plan.


> Hive query hangs with limit 0 clause
> ------------------------------------
>
>                 Key: DRILL-3623
>                 URL: https://issues.apache.org/jira/browse/DRILL-3623
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Hive
>    Affects Versions: 1.1.0
>         Environment: MapR cluster
>            Reporter: Andries Engelbrecht
>             Fix For: Future
>
>
> Running a select * from hive.table limit 0 does not return (hangs).
> Select * from hive.table limit 1 works fine
> Hive table is about 6GB with 330 files with parquet using snappy compression.
> Data types are int, bigint, string and double.
> Querying directory with parquet files through the DFS plugin works fine
> select * from dfs.root.`/user/hive/warehouse/database/table` limit 0;



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

Mime
View raw message