drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramana Inukonda Nagaraj (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1042) Query with order by fails against a partitioned hive table
Date Fri, 20 Jun 2014 00:08:24 GMT
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)

Mime
View raw message