Support Questions

Find answers, ask questions, and share your expertise

Hive privilege for default DB

Explorer

Hi,

I just installed HDP sandbox 3.0.1.
I was configuring superset (as hive is not avail anymore) and realize that hiveserver 2 or superset cannot see ANY tables under default database...

I can see them fine in zeppelin/spark though

I urgently need to have this (my tables are under default). This is clearly a privilege issue, but cannot find where/what.

Thx,

Arnaud

2 REPLIES 2

Contributor

@Arnaud Bohelay Hive is still available, only hive view is deprecated in the HDP 3.x. The HDP 3.x sandbox should have DAS installed which is a replacement for hive views. Can you try using that ?

Explorer

nope. the web app service keeps on shutting down after a minute (106 Gb memory). but even though, tables need to be accessible to hiveserver 2 and they are not (they were on latest sandbox 2.6.5)