Search

What is the example connect string for Oracle database to import tables into HDFS?



We need to use Oracle JDBC Thin driver while connecting to Oracle database via Sqoop. Below is the sample import command to pull table employees from oracle database testdb.
MySQL
sqoop import \
--connect jdbc:oracle:thin:@127.0.0.1/testdb \
--username SQOOP \
--password sqoop \
--table employees
Posted by at
Labels: ,
  • What are the main components of Mapreduce Job ?
      Main driver class which provides job configuration parameters. Mapper class which must extend org.apache.hadoop.mapredu...
  • TO_CHAR
       This will be used to extract various date formats.     The available date formats as follows.     Syntax: to_char ( date , fo...