Get your own customer support community
 

sqoop needs to escape table names

I'm trying to run sqoop against my mysql database, but there are a couple of tables that it is choking on. These tables have names that cause a sql error. This could be solved by escaping the tablename in the query run by sqoop.

so my error is this:

09/10/25 18:34:00 INFO manager.MySQLManager: Executing SQL statement: SELECT t.* FROM Character AS t LIMIT 1
09/10/25 18:34:00 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corre

which chokes on the table named Character. The same query fails when i try to run it in phpmyadmin. but this query works

SELECT t.* FROM `Character` AS t LIMIT 1

this is similar to an earlier problem with unescaped column names.

Thanks for the tool and I'm looking forward to using it. let me know if there is any info I can offer to help.
Inappropriate?
1 person has this question

User_default_medium