@Revlin Abbi try this : grant all privileges on *.* to 'root'@'localhost' identified by 'abcabcabc' with grant option; sqoop list-databases --connect jdbc:mysql://127.0.0.1:xxxx --username root --password abcabcabc root user does not have read/list permissions. ERROR manager.CatalogQueryManager: Failed to list databases java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) ... View more

@Mihai Mihai for the file upload - you can leverage webhdfs https://hadoop.apache.org/docs/current/hadoop-project-dist/hadoop-hdfs/WebHDFS.html Oozie can help to schedule the workflow to do the processing ... View more