Listed steps about how to move data from Mysql to HIVE using Sqoop and Hive to Mysql using sqoop.
Follow steps given in script.txt. It has HIVE/SQOOP/Linux and Hadoop scripts. You should have a knowledge on where to run what to try this excercise.
It covers:
- My sql (create databse, table, execute script file)
- Sqoop Import (--direct, --enclosed-by)
- Hive (CSV Serde, External table, various fields delimiter, avro, view, hive data to hdfs as file,)
- Hadoop (mkdir, put)
- Sqoop Export (records.per.statement, staging table