187.Sqoop Import – Dealing with Composite Keys

  • Command to get list of tables in nyse database
    • sqoop eval --connect jdbc:mysql://ms.itversity.com:3306/nyse --username nyse_user --password itversity -e "SHOW tables"
  • Command to get information on a table
    • sqoop eval --connect jdbc:mysql --username nyse_user --password itversity -e "DESCRIBE stock_eod"

Share this post