@mrizvi I didnt mean that. Its not compulsory for this operation. The api end point which I provided should grant the necessary role. But the issue which you are facing might be due to some corrupted configs and need to be debugged further. Can you please post the output of /var/log/ambari-server/ambari-server.log ... View more

It ran, I replaced quotes with a single apostrophe and it worked. Thanks a lot. ... View more

Another possible reason is that the file is not existing on the node where Hive server is running. The file needs to be present on the node where Hive server is running. Sometimes Hive server might not be running on the same node from where you are invoking the beeline client. ... View more

@Ravikumar Kumashi glad it works, please accept/upvote helpful answers to guide others. ... View more

The pictures are not visible to me as well. Beside that I get a strange error java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: ERROR 2007 (INT09): Outdated jars. The following servers require an updated phoenix.jar to be put in the classpath of HBase: region=SYSTEM.CATALOG. The odbc driver works smoothly. ... View more

I have successfully integrated Phoenix with Squirrel and also published an article on how to setup. Please have a look here ... View more

Hi @Timothy Spann, there is a bug from Ambari perspective, it is not generating hiveserver2-site.xml. So any changes made in Advanced Hiveserver2 site section from Ambari are not getting reflected, (we make changes in hiveserver2-site.xml for Ranger) so if you disable authorization from the general settings as mentioned above, you will be able to run Hive cli but Ranger policies will not work as expected. This issue has been raised up and will be resolved soon in the upcoming releases of Sandbox. For now, you can use Hive but without any Ranger policies. ... View more

I meet this question after upgrading from 2.3 to 2.5, then now it's solved by this workarround. ... View more