Try Accessing via Spark SQL -++ Lokesh On Aug 10, 2015 5:30 PM, "Andries Engelbrecht (JIRA)" <[email protected]> wrote:
> Andries Engelbrecht created DRILL-3623: > ------------------------------------------ > > Summary: 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) >
