@bgooley @Shelton So, I am able to connect to SQL Developer/SQL Plus for the kerberos authenticated DB. Steps followed: 1. kinit -k -t <keytabfile> <user>@<Realm/domain> 2. A ticket is created by the above command. Point the credential file location in SQL Developer to this ticket file location. 3. Provide host,post and DB service name. Click on the checkbox where it mentions Kerberos authentication. 4. Voila, SQL Developer connects to the database (without passing username/password) But, similar set of steps fails in Sqoop to connect to the db since there is no option in Sqoop to mention that the DB has to connected using kerberos authentication (There was a checkbox in sqldeveloper). Is there any way to do the same in Sqoop? My sqoop command is as below: sqoop export -Dmapred.job.queue.name=<processingqueue> --connect "jdbc:oracle:thin:@hostname:portnumber/DBNAME" --table <targettable> --hcatalog-table <tableinhive> --hcatalog-partition-keys <partitioncolumn> --hcatalog-partition-values <partitionvalue> --hcatalog-database <dbname> The above command works fine when I provide a username and password for an on-premise database but for a database with kerberos authentication (where you are not supposed to provide any username/password, it fails)
... View more
