Ramana Inukonda Nagaraj created DRILL-1042:
----------------------------------------------
Summary: 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)
