[SQOOP-368] Resolve ERROR tool.ImportTool: Imported Failed: Duplicate Column identifier specified: 'COLUMN-NAME'

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.0-incubating
• Fix Version/s: 1.4.0-incubating
• Component/s: tools
• Labels: alias column import mysql query sqoop

Environment

64bit Ubuntu 10.10 Linux, Java build 1.6.0_24-b07, mysql 5.1.49-1ubuntu8.1

• Assignee: guoyun
• Reporter: guoyun
• Due: 31/Oct/11
• Created: 20/Oct/11 03:41
• Updated: 28/Nov/16 05:58
• Resolved: 21/Oct/11 02:40

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