[jira] [Commented] (DRILL-3623) Hive query hangs with limit 0 clause

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

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

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

GitHub user StevenMPhillips opened a pull request:

    https://github.com/apache/drill/pull/364

    DRILL-3623: Optimize limit 0 queries

    This pulls some patches that Sudheesh had previously worked on but not committed. In addition, fixes some problems when the type is not one of the json ExtendTypes.
    
    There are still problems with float, decimal, and interval_day/year.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/StevenMPhillips/drill limit_0

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/drill/pull/364.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #364
    
----
commit 8c3f2e8911dabc93f7b3f381600ccfaccc008938
Author: Sudheesh Katkam <sk...@maprtech.com>
Date:   2015-11-17T23:12:48Z

    DRILL-3623: Use shorter exec path for LIMIT 0 queries when schema of the root logical node is known
    
    + DRILL-4043: Perform LIMIT 0 optimization before logical transformation

commit 3be63cd5b95891cbfee1bdb6cfa2baaaf18f31c8
Author: Sudheesh Katkam <sk...@maprtech.com>
Date:   2015-12-22T19:07:39Z

    WIP

commit b4061e46fe91b747bc2afe82e66cd6d0bc060d1b
Author: Steven Phillips <st...@dremio.com>
Date:   2016-01-31T01:49:04Z

    Make limit 0 return correct type for VARCHAR
    
    Still does not work correctly for float4, decimal, or interval types

----


> 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
>            Assignee: Sudheesh Katkam
>             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)