问题小记（使用 sqoop 向 hdfs 中导入数据）

要求：1. 使用 sqoop,将 information_schema.TABLES 表中的数据导入到 hdfs 的/tables 目录中，要求： 以 tab 键分隔 只导入 TABLE_CATALOG，TABLE_SCHEMA， TABLE_NAME，TABLE_TYPE 这 4 列 只导入表中行数大于 10 的表
我写的语句：

[pm@pm ~]$ sqoop import \
--connect jdbc:mysql://xx:3306/information_schema \
--username root \ 
--password root \ 
--target-dir /tables \ 
--delete-target-dir \ 
--num-mappers 1 \ 
--fields-terminated-by "\t" \ 
--query 'select TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE from TABLES limit 10,172 and $CONDITIONS'

报错：

20/04/10 11:06:31 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7
20/04/10 11:06:31 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
20/04/10 11:06:32 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
20/04/10 11:06:32 INFO tool.CodeGenTool: Beginning code generation
20/04/10 11:06:32 INFO manager.SqlManager: Executing SQL statement: select TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,TABLE_TYPE from TABLES limit 10,172 and  (1 = 0) 
20/04/10 11:06:32 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and  (1 = 0)' at line 1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your My