[
https://issues.apache.org/jira/browse/DRILL-3623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14717327#comment-14717327
]
Rahul Challapalli commented on DRILL-3623:
------------------------------------------
The below query returned just fine (on top of hive partitioned table)
{code}
select * from hive.lineitem_text_partitioned_hive_hier_intint limit 0;
+-------------+------------+------------+---------------+-------------+------------------+-------------+--------+---------------+---------------+-------------+---------------+----------------+-----------------+-------------+------------+-------+--------+
| l_orderkey | l_partkey | l_suppkey | l_linenumber | l_quantity |
l_extendedprice | l_discount | l_tax | l_returnflag | l_linestatus |
l_shipdate | l_commitdate | l_receiptdate | l_shipinstruct | l_shipmode |
l_comment | year | month |
+-------------+------------+------------+---------------+-------------+------------------+-------------+--------+---------------+---------------+-------------+---------------+----------------+-----------------+-------------+------------+-------+--------+
+-------------+------------+------------+---------------+-------------+------------------+-------------+--------+---------------+---------------+-------------+---------------+----------------+-----------------+-------------+------------+-------+--------+
No rows selected (5.616 seconds)
{code}
I also created a view on top of the above partitioned hive table and was able
to run a "limit 0" query on top of it..
One thing to note however is that the query took a lot of time to return for a
small data set (~6 seconds)
> 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: Venki Korukanti
>
> 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)
