Details
Description
There are two tables foo, bar in mysql with the same schema:
-------------------------------------+
Field | Type | Null | Key | Default | Extra |
-------------------------------------+
id | int(11) | NO | PRI | NULL | |
msg | varchar(32) | YES | NULL | ||
bar | int(11) | YES | NULL |
-------------------------------------+
When issuing command like this:
sqoop import --connect jdbc:mysql://localhost/sqoop_test --username root --password xxx --query 'select foo.id as foo_id, bar.id as bar_id from foo,bar WHERE $CONDITIONS' --target-dir foo -split-by foo.id,
it produces the following lines:
11/04/02 10:30:35 INFO tool.CodeGenTool: Beginning code generation
11/04/02 10:30:36 INFO manager.MySQLManager: Executing SQL statement: select foo.id as "foo_id", bar.id as "bar_id" from foo,bar WHERE (1 = 0)
11/04/02 10:30:36 INFO manager.MySQLManager: Executing SQL statement: select foo.id as "foo_id", bar.id as "bar_id" from foo,bar WHERE (1 = 0)
11/04/02 10:30:36 INFO orm.CompilationManager: HADOOP_HOME is /home/angus/src/hadoop
/tmp/sqoop-angus/compile/f564879790875928ab1158130214a481/QueryResult.java:41: id is already defined in QueryResult
private Integer id;
^
/tmp/sqoop-angus/compile/f564879790875928ab1158130214a481/QueryResult.java:42: get_id() is already defined in QueryResult
public Integer get_id() {