Table not found error in sqoop


#1

Hi ,

I have created a table in mysql under retail_export. While trying to export with sqoop command from mysql its shows ‘com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table ‘retail_export.ktgender_submission’ doesn’t exist’

But the at the same time ‘orders’ table is present in retail_export as that is getting loaded.

Please help to resolve the issue.

Thanks


#2

@dileepdominic I’m able to view the table.


#3

Yes, Table is present, But sqoop shows not table.
sqoop import
–num-mappers 1
–connect jdbc:mysql://ms.itversity.com:3306/retail_export
–username=retail_user
–password=itversity
–table ktgender_submission
–as-textfile
–target-dir=/user/dileepdominic/sqoop_import/ktgender_submission


#4

@dileepdominic Please check with the host you are using. You have a table on nn01.itversity.com and you are trying in ms.itversity.com

sqoop import
–num-mappers 1
–connect jdbc:mysql://nn01.itversity.com:3306/retail_export
–username=retail_dba
–password=itversity
–table ktgender_submission
–as-textfile
–target-dir=/user/dileepdominic/sqoopimport/


#5