Created 02-20-2018 08:26 AM
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 .
Created 02-20-2018 08:57 AM
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.
Created 02-20-2018 09:29 AM
value for Use Interactive Mode is already set to true .
Created 02-20-2018 02:42 PM
Hi Jay,I am getting statistics tab for tables but for views I am not getting the statistics tab
Created 02-20-2018 02:43 PM
Hi Jay,I am getting statistics tab for tables but for views I am not getting the statistics tab
Created 02-23-2018 10:51 AM
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 .