This article will help you to implement kerberos and add kerberos principal: https://sqoop.apache.org/docs/1.99.7/security/AuthenticationAndAuthorization.html ... View more

I don't think that Sqoop supports importing from Hive or exporting to Hive. It is intended as a bridge between Hive and RDBMS. However, you should be able to do, From within hive, run the following command: insert overwrite local directory '/home/user/staging' row format delimited fields terminated by','select*from table; This command will save the results of the select on the table to a file on your local system, then export csv to Oracle. ... View more

This link may help you in understanding, http://docs.aws.amazon.com/emr/latest/ManagementGuide/emr-plan-file-systems.html ... View more

@satya gaurav Directory path is where, your hive data resides, if you give empty folder then table will be empty, so you cannot change if you want the same data to be loaded to the table. The columns with will null is due to the number columns you defined in schema may more than the delimited data. ... View more

Check the directories entry assigned in HDFS config, Ambari will consider only these directory space,for reference check the below image, ... View more

Adding to @Kuldeep Kulkarni comments, And make sure that appropriate driver jar on oozie shared lib hdfs location. ... View more

Once the "Ambari" setup done, you can achieve all other thing in automated way. ... View more

@Angelo Alexander If you are using the "--target-dir" option with sqoop, then it is just a location on HDFS, where your output sits, you can create a external hive table on the target-dir location. Or you can use hive-create-table option with sqoop to directly create a table on hive. ... View more

@Angelo Alexander If you are trying the "sqoop" command, you have to try on linux CLI, where sqoop client should have installed. And proper JDBC driver should be copied to sqoop lib location. ... View more

@omkar pathallapalli Just add the SQL Server jdbc jar(sqljdbc42.jar) to the sqoop lib folder and try to sqoop using the syntax provided above bu Sunile. ... View more