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

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

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)