sqoop - Use Sqoop to copy an Oracle table to Hadoop - apache sqoop - sqoop tutorial - sqoop hadoop



Use Sqoop to copy an Oracle table to Hadoop

  • Step 1) Get the Oracle JDBC driver
  • sudo su -
    cd /var/lib/sqoop
    curl -L https://pkothuri.web.cern.ch/pkothuri/ojdbc6.jar -o ojdbc.jar
    exit
    Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team
  • Step 2) Run the sqoop job
  • sqoop import \
    --connect jdbc:oracle:thin:@devdb11-s.cern.ch:10121/devdb11_s.cern.ch \
    --username hadoop_tutorial \
    -P \
    --num-mappers 1 \
    --target-dir visitcount_rfidlog \
    --table VISITCOUNT.RFIDLOG
    Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team

    Use Sqoop to copy an Oracle table to Hadoop, multiple mappers

  • Step 1: Use Sqoop to copy an Oracle table to Hadoop, multiple mappers
  • sqoop import \
    --connect jdbc:oracle:thin:@devdb11-s.cern.ch:10121/devdb11_s.cern.ch \
    --username hadoop_tutorial \
    -P \
    --num-mappers 2 \
    --split-by alarm_id \
    --target-dir lemontest_alarms \
    --table LEMONTEST.ALARMS \
    --as-parquetfile
    
  • Step 2: Check the size and number of files
  • hdfs dfs -ls lemontest_alarms/    

    SQOOP forum

    Sqoop Installation and Download :

    Connecting Sqoop to other databases/datastores :

  • Import data directly into Hive Warehouse
  • Import data from RDBMS to HBase table
  • Import data to new catalog
  • Import the results of a query from a relational database into HDFS
  • Load JDBC Driver
  • Sqoop Export :

  • Sqoop Export basic example
  • Sqoop Import RDBMS Table to HDFS :

  • Sqoop Import RDBMS Table to HDFS
  • Merge data-sets imported via incremental import using Sqoop :

  • Import New as well as Updated Data - lastmodified mode - Append Mode
  • Hadoop with Kite SDK :

  • Kite SDK to demonstrate copying of various file formats to Hadoop
  • Sqoop Advanced :

  • Use Sqoop to copy an Oracle table to Hadoop

  • Related Searches to Use Sqoop to copy an Oracle table to Hadoop