hadoop-hdfs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravi Prasad <raviprasa...@gmail.com>
Subject How to automate the Sqoop script in Production environment
Date Fri, 24 Oct 2014 11:05:13 GMT
Hi all,

1)  Can anyone please suggest me , how to automate the Sqoop scripts in the
production environment.

I  need to import data from Oracle tables to  Hadoop Hive tables using the
below scripts.

sqoop import  --connect jdbc:oracle:thin:@<ipaddress>:1521/<DB> --username
username --password *password *--table <tablename> --columns column1
,column2,column3--hive-import --hive-overwrite  --hive-table
default.oracreport --lines-terminated-by '\n' --fields-terminated-by ','
--target-dir /user/hdfs/


2) Is there any way to hide the password.

----------------------------------------------
Regards,
RAVI PRASAD. T

Mime
View raw message