[jira] [Updated] (DRILL-1042) Query with order by fails against a partitioned hive table

["Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramana Inukonda Nagaraj updated DRILL-1042:
-------------------------------------------

    Attachment: avro_partitioned.q

Hive ddl file. 

> Query with order by fails against a partitioned hive table
> ----------------------------------------------------------
>
>                 Key: DRILL-1042
>                 URL: https://issues.apache.org/jira/browse/DRILL-1042
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Hive
>            Reporter: Ramana Inukonda Nagaraj
>            Assignee: Venki Korukanti
>         Attachments: avro_partitioned.q
>
>
> Have a hive avro table partitioned on an integer.
> Able to query the table successfully in drill, select * works, select columns work also filter and similar operations work.
> However when I have an order by query succeeds but return 0 rows. This happens irrespective of which column the order by is on. 
> 0: jdbc:drill:schema=hive> select * from episodes_partitioned WHERE doctor_pt >6 order by air_date;
> +--+
> |  |
> +--+
> +--+
> result from hive
> The Doctor's Wife	14 May 2011	11	11
> Rose	26 March 2005	9	9
> The Eleventh Hour	3 April 2010	11	11



--
This message was sent by Atlassian JIRA
(v6.2#6252)