Also, found this link: https://help.pentaho.com/Documentation/7.1/0H0/Set_Up_Pentaho_to_Connect_to_a_Hortonworks_Cluster Not sure if it's gonna help you 🙂 ... View more

Hi @Teresa Tavernelli! Could you try one thing? Test to change the localhost for the name of the sandbox machine (should be something like this: sandbox-hdp.hortonworks.com:10000). Since I'm not aware of Pentaho tools, do you've any config from Kettle where you can put the hive-site.xml (configs for Hive). Hope this helps! ... View more

Done! Thanks 🙂 ... View more

Hello @sandra Alvarez! I'm glad you made it 🙂 If you found this answer helpful, please I'd kindly ask you to accept this as the best answer. Doing this will engage other HCC users to keep doing a good job, and also will help others to find the answer faster. Thank you. ... View more

Hi @Marshal Tito! I'm glad you made it 🙂 So, regarding the aux jar, did you set this through ambari? If so, you should be able to use the jar without add. Otherwise, try to take these steps: https://community.hortonworks.com/content/supportkb/48734/how-to-permanently-add-custom-jar-files-to-hive-in.html Hope this helps. ... View more

Hello @Marshal Tito! Which message do you face if you enable the DEBUG? And also, just to confirm, do you see your jar added in the aux libs? hive -e "set hive.aux.jars.path;" Hope this helps. ... View more

Hello @Maxim Neaga! I'm glad that I could help you 🙂 Yeah, make totally sense your question. I'd say because you've 3 truststore's: - 1 x truststore's for the nifi nodes - 1 x For the Ranger x Nifi plugin - 1 x For Ranger Admin (which is the java default cacerts). Hope this helps! ... View more

Hi @A C. At first, glance, I can't see anything misconfig. Take a look at this article, to see if helps you on smtg: https://community.hortonworks.com/articles/84071/apache-ambari-workflow-manager-view-for-apache-ooz-2.html Hope this helps ... View more

Hi @A C. You're right, this is the YARN WEB UI 🙂 Hm, so from what I can see, it looks like yarn didn't launch your spark application. Do you mind to share with us your oozie workflow xml? Thanks. ... View more

Hmm, @tauqeer khan good question. I've never tested it myself. But at first, glance, guess you can take a look at the following answer: https://community.hortonworks.com/questions/182344/how-to-copy-data-from-a-hive-table-recurrently-usi.html And try to build something similar 🙂 BTW, it's a good idea to test it, let us know if it works or if you face anything. Hope this helps! ... View more