Hive View 2.0 : Statistics not supported for partitioned table in Hive Server version lesser than 2.1. Your current Hive Server version is 1.2

[#1]

Hi Team,

We are getting below error when clicking on Statistics tab in Hive View for partitioned table. 

I found one bug which seems to be relevant but this is already resolved in 2.5.0. Ambari version which I am using is 2.6.2.2. Hive view 2.0.

https://issues.apache.org/jira/browse/AMBARI-20113

Any help on this issue.

Regards,

Shyam

[#2]

@shyamshaw 
Hive LLAP uses Hive 2.x, So please check if you have enabled the LLAP interactive query in order to get the statistics for the partition table.

Also can you please verify if you have "Interactive Mode" is enabled for the Hive View ?

Ambari UI --> Manage Ambari --> Views --> Hive > Hive View 2.0

Find the "Settings" section, and verify if the "Interactive Mode" is set to "true" or not?

If not then can you try to set it to "true" and then hard refresh the browser and then try again.

[#3]

@jsensharma Thank you for your response.

please check if you have enabled the LLAP interactive query in order to get the statistics for the partition table : I have configured HiveServer2 Interactive but how can I verify whether it is being enabled to get the statistics for the partition table.

"Interactive Mode" was set to "false" and I changed it to "true" and did hard refresh of the browser but still the same issue.