@piyushgauri   select count(1) from system.stats where PHYSICAL_NAME='tablename' and GUIDE_POSTS_WIDTH is not null; ... View more

@piyushgauri you can try executing below query for identifying the guide_post value select count(1) from system.stats where guide_post_key is not null and PHYSICAL_NAME='table_name'; ... View more

Hello @ryu ,   Refer below link for Enabling PQS via ambari ++++++++++++ https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.5.3/bk_data-access/content/ch_using-phoenix.html#enabling-phoenix   </snippet from the link> To enable Phoenix with Ambari: Open Ambari. Select   Services   tab >   HBase   >   Configs   tab. Scroll down to the Phoenix SQL settings. (Optional) Reset the Phoenix Query Timeout. Click the   Enable Phoenix   slider button. ++++++++++++   Also would recommend to review below doc for installing phoenix via command line   https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.5.3/bk_command-line-installation/content/ch_install_phoenix_chapter.html     ... View more

Require inputs on below query   FreeIPA 4.8.9 will be supported with HDP 3.x and Ambari 2.7.x?   If YES, kindly provide document link for the same ... View more