[
https://issues.apache.org/jira/browse/DRILL-1042?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ramana Inukonda Nagaraj resolved DRILL-1042.
--------------------------------------------
Resolution: Fixed
Works fine now as of 687b9b0
> 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: Mehant Baid
> Fix For: 0.5.0
>
> Attachments: avro_partitioned.q, episodes.avro
>
>
> 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)
