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