questions is re: Nifi not Oozie ... View more

@Shishir Saxena you can wrap the sqoop command in shell script and use ExecuteProcess if you'd like, would love to see it as an article on HCC when you get it done. ... View more

@rajdip chaudhuri give it right permissions, and you can also specify it explicitly you can use Sqoop with any other JDBC-compliant database. First, download the appropriate JDBC driver for the type of database you want to import, and install the .jar file in the $SQOOP_HOME/lib directory on your client machine. (This will be /usr/lib/sqoop/lib if you installed from an RPM or Debian package.) Each driver .jar file also has a specific driver class which defines the entry-point to the driver. For example, MySQL’s Connector/J library has a driver class of com.mysql.jdbc.Driver . Refer to your database vendor-specific documentation to determine the main driver class. This class must be provided as an argument to Sqoop with --driver . ... View more

@sasmita panigrahi take a look in /var/log/hive on the server that has your hive server installation. The logs you'd sent are not valid. ... View more

place the mysql-connector-java.jar into /usr/hdp/sqoop-client/lib @rajdip chaudhuri review the docs https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_dataintegration/content/ch_using-sqoop.html ... View more

Please paste the XML file snippet where you pasted the code it requested. @Lubin Lemarchand you probably didn't close a tag or outside the tags ... View more

@Steven Cardella try using the avro-tools utility to generate schema file. It has a lot of helpful utilities. I remember messing alot with schema before it accepted but avro tools jar is essential ... View more

@Prakash Punj you're most likely encountering this problem please see https://community.hortonworks.com/questions/8518/hcatloader-error.html There's a known bug in sandbox ... View more