Hortonworks Sandbox Forum
Connection to table on Hive not working
I am trying to connect Jasperreports to HDP Sanbox and access a table(nyse_stocks) on the default database of Hive. I am able to establish the connection but when I try access the tables/objects within the ‘default’ and other databases, it shows ‘Cannot get database meta info’ ..which indicates the underlying objects are not accessible. Based on the other post <http://hortonworks.com/community/forums/topic/hive-permissions-in-2-1-sandbox/>, I have set hive authorization entry to the following:
Still there is no change. I tried with hue, root and even with a new user. There is no change. How do I fix this?
Support from the Experts
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Become HDP Certified
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world