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.
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.
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
-
Inappropriate?Hi Jonathan,
Good catch; I'll add this to the bug queue.
- Aaron -
Inappropriate?Initial code is ready for this at https://issues.apache.org/jira/browse... -- this'll be integrated into Apache and CDH within a few weeks.
Loading Profile...


