Hi @Vinicius Higa Murakami, The problem is resolved, I was using Ambari Hive 2.0 view to execute the queries. When I used the Hive 2.1 JDBC drivers and jars it was working as expected. Thanks for the help ... View more

Hi @Vinicius Higa Murakami, Adding "Order by" clause din't help. I am trying to run the query in Hive view 2.0 , after enabling HiveServer2 Interactive, Is this right ? ... View more

@Vinicius Higa Murakami I enabled Hive 2.0 and when tried the below query, I am getting an exception <small>org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:38 missing EOF at ',' near '1'<br></small> select * from dummy_schema.dummy1 limit 1,2 Can you help on using the limit clause in the case where offset needs to be applied. ... View more