Under Process Group Configuration look for a triangle next to HiveConnectionPool. if you enabled it and there's no warning, you are good. also check the bulletin board for error message or ..nifi/log/ log files. ... View more

Try with Zeppelin: https://community.hortonworks.com/questions/34894/apache-zeppelin-with-hive.html Makes it really easy to try things out. See this article: https://community.hortonworks.com/content/kbentry/34784/data-ingest-with-apache-zeppelin-apache-spark-16-h.html ... View more

this is probably bad SQL returning NULL killing Java. Test that query from CLI or try another query. Is there data in that table? does that query return any values? ... View more

does the query run in beeline or ambari hive view or zeppelin? is there data in the table? It seems like CAST on null may be an issue. does the user used by NiFi to access Hive have permissions to that table? is your Hive connection pool in NiFi setup and working? ... View more

are there any logs? browser messages in javascript console? what browser and platform are you running client from? who added the other service or are those the OOTB ones? ... View more

No YARN in HDF, that's why it's a separate cluster. To get YARN you need all the other Hadoop pieces and that makes for a much larger node. ... View more

can you connect to mysql from mysql cli or mysqladmin? make sure its working make sure you have rwx permissions for mysql directories check the /var/log/mysql logs make sure you can access mysql telnet localhost 3306 make sure you have iptables and firewalls on your machine (and any on your network off) some firewalls in corporate or on your comcast/verizon/cable router will block some mysql ports) See here: http://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysql Is mysql setup and running? make sure your bind-address is set correctly to 127... or 0.. Linux: /etc/mysql/my.cnf or /etc/my.cnf ... View more

can you post a screen shot? Perhaps it's security permissions make sure your user dir is created and has permissions https://community.hortonworks.com/questions/33396/users-can-upload-and-create-directories-using-file.html http://hortonworks.com/hadoop-tutorial/loading-data-into-the-hortonworks-sandbox/ ... View more

make sure you have the avro package loaded for the shell. and hdfs with thw correct path and permissions is required. also if you are using kerberos there are other steps. a better experience than repl is zeppelin give it a try ... View more