Sqoop-Access denied issue


#1

hi team,

When i am trying to import data table from local to HDFS or Warehouse getting the below access denied issue .

Please provide the access on all the databases and tables, so that i can use the lab efficiently because every time i am getting access denied for some other databases, ex. information schema,retails_export and table.
Please provide the host by using them i can access all the databases and tables.

Regards,
Vivek


#2

Change the jdbc url to ms.itversity.com and try

sqoop import \
  --connect jdbc:mysql://ms.itversity.com:3306/retail_db \
  --username retail_user \
  --password itversity \
  --table order_items \
  --warehouse-dir /user/username/sqoop_import/retail_db

#3

@vivek_kumar2 To access mysql credentials in labs. Refer this discuss.