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
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
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
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
hdfs dfs -ls lemontest_alarms/