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] [Updated] (DRILL-1042) Query with order by fails against a partitioned hive table
Date Fri, 20 Jun 2014 00:10:24 GMT

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

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

    Attachment: doctors.avro

avro data file used. 

> 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, 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)

Mime
View raw message