Sqoop export ,table not found exception


#1

when i try to run this sqoop command ,

sqoop export \
--connect jdbc:mysql://nn01.itversity.com:3306/retail_export \
--username retail_dba \
--password itversity \
--export-dir /apps/hive/warehouse/customers \
--table hariharanp1094_customers

getting error as table not found

but the table is acutally present in mysql database


#2

@Hariharan_Palanicham You are using the wrong hostname for MySQL. Use hostname as ms.itversity.com.


#3

what is the user name to be used


#4

@Hariharan_Palanicham Please refer this link

How to access MySQL in Big data labs?