Hhi @smanjee hi @Sridhar Reddy I try to add the phoenix-hive.jar to hive permanently and general available for external applications but I don't know exactly how to do that with ambari. I set the hive.aux.jars.path property in cusmto hive-site in abari to a location in hdfs to centrally reach the jars but it is not working. If I create a auxlib folder in a node, then it works but only for this node. Any comment will be appreciated. Kind regards, Paul ... View more

This worked for me as well (when replacing Spark-1 with a private build based on Apache Spark) ... View more

@Gangadhar Kadam Thank you.. Steps you mentioned help me to resolve the problem , Thank you @Gangadhar Kadam ..Steps you provided help us to resolve the issue ... View more

@Sri Bandaru, you can get the queue related metrics through AMS. AMS has various queue related metrics like ActiveApplications, AggregateContainersAllocated, AggregateContainersReleased, AllocatedContainers, AllocatedMB, AllocatedVCores, AppsPending, AppsSubmitted, AvailableMB, AvailableVCores, PendingContainers, PendingMB, PendingVCores, ReservedContainers, ReservedMB, ReservedVCores, running_0, running_60, running_300, running_1440 etc. This will provdie you what your are looking for. Also if you are on Ambari 2.2.2+ you will have graphana UI in AMS where you can create your dashboards for the metrics of your interest. ... View more

The phoenix-sqlline command is not using PQS. You want to use /usr/hdp/current/phoenix-client/bin/sqlline-thin.py to interactive with PQS. ... View more

Thanks for the update. ... View more

Yep, you're right: over time, compactions will bring data local and help with locality concerns. Lots of factors play into this, but I'm more of the mindset that just having homogeneous nodes is helpful in deployments. One less thing to worry about 🙂 ... View more

No. the above command is to be used inside beeline. I am assuming you are trying to connect to phoenix python shell in which case these are the commands. these are the commands in linux shell using which I was able to use to get in to phoenix shell in kerberized cluster. export HBASE_CONF_PATH=/etc/hbase/conf:/etc/hadoop/conf if you are logged in as your own user kinit /usr/hdp/current/phoenix-client/bin/sqlline.py hostname.domain.com:2181:/hbase-secure if using logged in as hbase user kinit -k -t /etc/security/keytabs/hbase.headless.keytab hbase /usr/hdp/current/phoenix-client/bin/sqlline.py hostname.domain.com:2181:/hbase-secure:hbase@domain.com:/etc/security/keytabs/hbase.headless.keytab then you can run following commands to show list of phoenix tables !tables ... View more

Per the JIRA from Jeff, looks like the feature did not work prior to Ambari 2.2+. The relevant doc section in Ambari 2.2.0.0 looks ok so I think we are good. Although it might be good to update older docs to explicitly call out the fact that running queries as logged in user won't work. ... View more