sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 郭芸 (Updated) (JIRA) <j...@apache.org>
Subject [jira] [Updated] (SQOOP-368) Resolve ERROR tool.ImportTool: Imported Failed: Duplicate Column identifier specified: 'COLUMN-NAME'
Date Thu, 20 Oct 2011 09:42:14 GMT

     [ https://issues.apache.org/jira/browse/SQOOP-368?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

郭芸 updated SQOOP-368:
---------------------

           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'



  was:
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'



                Labels: alias column import mysql sqoop  (was: import mysql sqoop)
    Remaining Estimate: 48h  (was: 504h)
     Original Estimate: 48h  (was: 504h)
               Summary: Resolve ERROR tool.ImportTool: Imported Failed: Duplicate Column identifier
specified: 'COLUMN-NAME'  (was: resolve ERROR tool.ImportTool: Imported Failed: Duplicate
Column identifier specified: 'ID')
    
> Resolve ERROR tool.ImportTool: Imported Failed: Duplicate Column identifier specified:
'COLUMN-NAME'
> ----------------------------------------------------------------------------------------------------
>
>                 Key: SQOOP-368
>                 URL: https://issues.apache.org/jira/browse/SQOOP-368
>             Project: Sqoop
>          Issue Type: Bug
>          Components: tools
>    Affects Versions: 1.4.0
>         Environment: 64bit Ubuntu 10.10 Linux, Java build 1.6.0_24-b07, mysql 5.1.49-1ubuntu8.1
>            Reporter: 郭芸
>              Labels: alias, column, import, mysql, sqoop
>             Fix For: 1.4.0
>
>         Attachments: query-column.alias.patch
>
>   Original Estimate: 48h
>  Remaining Estimate: 48h
>
> 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'

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

       

Mime
View raw message