@ranger , By default, HS2 uses 10000 port number, can you please confirm the value for "hive.server2.thrift.port"? Do you have LB setup? ... View more

@prossblad , In Cloudera's Hive JDBC driver the default value for UseNativeQuery is 0, please refer to below doc: https://www.cloudera.com/documentation/other/connectors/hive-jdbc/latest/Cloudera-JDBC-Driver-for-Apache-Hive-Install-Guide.pdf Simba jdbc Spark driver also uses 0 as default value for UseNativeQuery, see below: https://www.simba.com/products/Spark/doc/JDBC_InstallGuide/content/jdbc/hi/options/usenativequery.htm Cheers Eric ... View more

@ranger , What is port 10002? I can see you only configured 10001 for HS2. Cheers Eric ... View more

@kvinod Looks like you just need a bit more memory, please try 4G, then 6G or 8G and see at what point you can get your hbase command working. How big is your hbase database and tables? Have you tried to run the similar command before or first time? Cheers Eric ... View more

Hi Vijay, Thanks for the detailed output. Looks like both Hue and Beeline have the same issue, that both of they were not able to retrieve results from HS2. A few more questions: 1. how many HS2 hosts do you have? 2. Can you check the HS2 log on the host that Hue and Beeline connects to and see what error you can get from there? It might tell more story on why it failed 3. Can you also try below queries: select * from tdb1.t1 where bs1_dt=2017-06-23; select * from tdb1.t1 where bs1_dt=2017-06-26; And see which partition might be causing the issue, or is it both? Thanks Eric ... View more

Try to update password using kadmin.local after you log into the KDC server, reference here: http://web.mit.edu/KERBEROS/krb5-1.4/krb5-1.4.1/doc/krb5-admin/Changing-Passwords.html Cheers ... View more

Hi Vijay, Can you please share the output of running "select * from db1.t1;" in Hue and how it exited in beeline? This can help to clarify the behaviour. What is the output of below query: SELECT bs1_dt, COUNT(*) FROM db1.t1 GROUP BY bs1_dt; Please also run below query in Impala, as it will show the partition location: show partitions db1.t1; Finally, output of "SHOW CREATE TABLE db1.t1" so that I can see the table definition. Thanks Eric ... View more

Hi Aaron, This is not the log file that I was after. Can you add: LogPath=/path/to/dir LogLevel=6 Into ODBC driver configuration file and test again? Then the trace logs for the driver should be logged under /path/to/dir and see what error we can get from there. Cheers ... View more

@ChineduLB You need to be running the command using "hdfs" user, which is a superuser in HDFS. Please try again with that. Cheers Eric ... View more