Hi All   We are able to make non-secure SSL SQOOP connection with AS400 using below commands SQOOP import \ –driver com.ibm.as400.access.AS400JDBCDriver \ –connect jdbc:as400://as400servername/dbname \ –username  –password \ –query ‘SELECT * FROM table where $CONDITIONS’ \ –hive-import \ –hive-table table \ –target-DIR /user/HDFS/example \ –fields-terminated-by ’01’ \ –split-by <id> \ -m 4; I am looking for a way to make it Secured connection . Even though i use secured port 9471 , it defaults to non secured port .   please help  ... View more