Before getting into actual Sqoop commands such as import and export, it is important to understand how we can get information about databases, tables and data using
Almost all sqoop commands use connect string using
--connect. It require following information:
- Database type (mysql, oracle etc)
- Port number
- Database Name (in case of mysql)
Sqoop list commands
Sqoop list, facilitate us to see list of databases or tables from the database.
Run queries using Sqoop eval
Any valid sql query or command can be run using sqoop eval. It is primarily used to load or query log tables while running Sqoop jobs at regular intervals.