@Prakash Punj Could you publish your hue.ini files as text? The screenshots provided are a bit difficult to read and I would like to see the actual content. Side question: which version of OS and HDP you use? Hue on Centos 7 and HDP 2,4 is not supported. ... View more

@Mehul Ramani Since you want to make the call from GetHTTP NiFi processor, to be able to make a https call you need to setup 'SSL Context Service' . Summarily, you will need to configure the truststore properties with for your SSL Context Service instance with the path to the default cacerts truststore that comes bundled with your Java installation, located at JAVA_HOME/jre/lib/security/cacerts. TrustStore is of type JKS, and the default password for Truststore is "changeit" . If $JAVA_HOME Is set on your system, it should help point you in the right direction. If not, the location of cacerts varies depending on environment, but is approximately the following for their respective OS OSX: /Library/Java/JavaVirtualMachines/jdk<version>.jdk/Contents/Home/jre/lib/security/cacerts. You can additionally use $(/usr/libexec/java_home) to find the path. Windows: C:\Program Files\Java\jdk<version>\jre\lib\security\cacerts Linux: /usr/lib/jvm/java-<version>/jre/lib/security/cacerts. You can additionally use $(readlink -f $(which java)) If this response was helpful, vote/accept it as the best answer. ... View more

@Prakash Punj You say "modified all the parameter in HUE.INI". Does it mean you manually made those changes? If so, have you restarted Hue to account for the new changes? Look also at the ownership of the file. It may not be owned by Hue if you made the changes under a different account. If after restart, you still have the issue, are you pointing to the server that runs the Hive2 Server? If helpful, vote/accept response. ... View more

@Sunile Manjee Yes. You already applied map-side join which does pretty much the same and also you seem to have the small table last in the sequence. I assume that your small table fits in the memory. My take is that when you use so many columns (almost all) in the join, you practically deny the benefit of columnar. Have you gathered statistics? Without the statistics the CBO will not propose the best plan. What does the EXPLAIN PLAN says? ... View more

@Sunile Manjee As I understand, you have a small table and a big table. It is a good practice, with and without ORC, to provide a hint that will stream a table in your kind of join. Have you tried that? Check this: https://www.linkedin.com/pulse/20141002060036-90038370-hive-join-optimization-stream-table-in-joins ... View more