@RajuKV The table definition "LINES TERMINATED BY" only supports newline '\n' right now. This is a known issue and Jira Hive 11996 has already been raised for the issue. ... View more

@ARUN Refer below HCC article for the sample DB sizing: https://community.hortonworks.com/articles/98489/hdp-supporting-database-sizing-guidelines.html ... View more

@nshelke 1) Edit the Advanced topology of your KNOX service to add LLAP service <service> <role>LLAP</role> <url>http://<LLAP server host>:<HTTP PORT NUMBER>/{{hive_http_path}}</url> </service> 2) Go to the below location in your KNOX server machine:- /usr/hdp/<HDP VERSION>/knox/data/services 3) Copy the hive directory present in the location and rename it as llap 4) Edit the services.xml and rewrite.xml as below:- servcies.xml ------------ <service role="LLAP" name="llap" version="0.13.0"> <routes> <route path="/llap"/> </routes> <dispatch classname="org.apache.hadoop.gateway.hive.HiveDispatch" ha-classname="org.apache.hadoop.gateway.hive.HiveHaDispatch"/> </service> <rules> <rule dir="IN" name="LLAP/llap/inbound" pattern="*://*:*/**/llap"> <rewrite template="{$serviceUrl[LLAP]}"/> </rule> </rules> Use the http path as 'gateway/default/llap' while connecting to LLAP via KNOX. ... View more

@Kiran Kumar You can see when Full Support and Technical Guidance periods end. It's in the table at the bottom of this page: https://hortonworks.com/agreements/support-services-policy/ ... View more