hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Biswajit Nayak <biswa...@altiscale.com>
Subject Hive Cli ORC table read error with limit option
Date Tue, 01 Mar 2016 04:50:44 GMT
Hi All,

I am trying to run a simple query of select with limit option, it fails.
Below are the details.

Versions:-

Hadoop :-  2.7.1
Hive      :-  1.2.0
Sqoop   :-  1.4.5


Query:-

The table table_orc is partitioned based on year, month and day. And the
table is ORC storage.

hive> select date from testdb.table_orc where year = 2016 and month =1
and day =29 limit 10;
OK
Failed with exception java.io.IOException:java.lang.RuntimeException:
serious problem
Time taken: 0.32 seconds
hive>


While the query select date from testdb.table_orc where year = 2016 and
month =1 and day =29 limit 10;   without limit works perfectly. Even the
count (*) or select * works perfectly fine.


Any one faced this issue.

Regards
Biswa

Mime
View raw message