@Sunile Manjee, is your Ambari Metrics Service running ? (specifically Ambari Metric Collector)? You may want to try restarting AMS Collector and then restart Activity Explorer. ... View more

I found the issue. I was using PQS on node which is did not install PQS. I created secondary index pointing to PQS installed by ambari and all is good. ... View more

@Sunile Manjee Integration between Spark and HBase relies simply on HBaseContext which provides HBase configuration to Spark Executor. So, to answer which protocol is used, the answer is simple RPC. Please check following link for more details. https://hbase.apache.org/book.html#spark and here is the github link to HBase Spark module. https://github.com/apache/hbase/tree/master/hbase-spark/src/main/scala/org/apache/hadoop/hbase/spark ... View more

Hi @Sunile. I suspect this is not a firm number but a bang-for-the-buck recommendation - i.e. you will get the most substantial relative performance improvements with dataset sizes that can remain in-cache. In Carter and Nita's recent blog post, they go into testing 10TB TPC-DS datasets - much larger than the aggregate cluster LLAP cache size. They wanted to see (direct quote) "if LLAP can truly tackle the big data challenge or if it’s limited to reporting roles on smaller datasets." What they found was that (another quote) "If we look at the full results, we see substantial performance benefits across the board, with an average speedup of around 7x. The biggest winners are smaller-scale ad-hoc or star-schema-join type queries, but even extremely complex queries realized almost 2x benefit versus Hive 1." ... View more

argh never mind. I found it. you have to go to ambari, hive, config, and enable interactive query. then it will go through install steps. ... View more