Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

hive llap views strange behaviour

I am facing very strange behavior on hive llap . When I change database from default to some other data then for one user

Under tables there is statistics tab which is available for he user but for different user it is not available and for another one

its shows "statistics not supported for partitioned table in hiveserver version 2.1 " but when I change user on the same environment it is working fine .

5 REPLIES 5

Super Mentor

@Anurag Mishra

Can you please check if you have enabled the "Use Interactive Mode" for your Hive View 2.0 ?

Login to Ambari UI --> admin (Drop down) --> "Manage Ambari" -->  "Views" -->  "Hive" -->  "Hive View 2.0"


Click on "Settings" --> "Edit" then change the Set "Use Interactive Mode*" to "true"

.

Logout and login back to Ambari or try restarting the server once and then check the view again.

@Jay Kumar SenSharma

value for Use Interactive Mode is already set to true .

@Jay Kumar SenSharma

Hi Jay,I am getting statistics tab for tables but for views I am not getting the statistics tab

@Jay Kumar SenSharma

Hi Jay,I am getting statistics tab for tables but for views I am not getting the statistics tab

@Jay Kumar SenSharma

can you please explain what is user interactive mode or what it really does when we set its value to true .

This worked for my different cluster setting its value to true .