Details
Description
for execute this command:
import --connect jdbc:mysql://localhost/sqoop_datas --username root --password 123456 --query "select sqoop_source_datas.id as foo_id, sqoop_2.id as bar_id from sqoop_source_datas ,sqoop_2 WHERE $CONDITIONS" --target-dir /tmp/sqoop/foo -split-by foo_id --hadoop-home=/home/guoyun/Downloads/hadoop-0.20.2-CDH3B4
because table sqoop_source_datas and table sqoop_2 have the same column:id.so it will report error:resolve ERROR tool.ImportTool: Imported Failed: Duplicate Column identifier specified: 'ID'
For patch:query-column.alias.patch,we must set the parameter split-by to real column name.for my example,i must set split-by to sqoop_source_datas.id,not foo_id