[jira] [Resolved] (SQOOP-407) sqoop free-form query "Duplicate Column identifier" error on JOIN when a table has only one column and both tables have the same name for column

["Jarek Jarcec Cecho (Resolved) (JIRA)" <ji...@apache.org>]

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

Jarek Jarcec Cecho resolved SQOOP-407.
--------------------------------------

    Resolution: Won't Fix

I'm closing this issue for now because it seems that it's intentional behavior of sqoop. 

If anyone have any additional comments, please feel free to reopen this ticket.

Jarcec
                
> sqoop free-form query  "Duplicate Column identifier" error on JOIN  when a table has only one column and both tables have the same name for column
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: SQOOP-407
>                 URL: https://issues.apache.org/jira/browse/SQOOP-407
>             Project: Sqoop
>          Issue Type: Bug
>          Components: connectors/mysql
>    Affects Versions: 1.4.1-incubating
>         Environment: Ubuntu 10.04 ; mysql Server version:		5.1.41-3ubuntu12.10 (Ubuntu)
>            Reporter: Eric Hernandez
>            Priority: Minor
>
> If you try to join two tables that only have one column and both columns have the same name you get an error.
> Example
> | actor | CREATE TABLE `actor` (
>   `actor_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
>   PRIMARY KEY (`actor_id`)
> ) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8 |
> CREATE TABLE `actor_test` (
>   `actor_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
>   PRIMARY KEY (`actor_id`)
> ) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8
> ./sqoop import --connect jdbc:mysql://localhost/sakila -m1 --username sqoop --password sqoop --query 'SELECT a.*,b.* FROM actor a JOIN actor_test b ON a.actor_id=b.actor_id WHERE $CONDITIONS' --target-dir /user/eric/bugreport/
> Warning: /usr/lib/hbase does not exist! HBase imports will fail.
> Please set $HBASE_HOME to the root of your HBase installation.
> 11/12/09 13:54:50 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
> 11/12/09 13:54:50 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
> 11/12/09 13:54:50 INFO tool.CodeGenTool: Beginning code generation
> 11/12/09 13:54:50 INFO manager.SqlManager: Executing SQL statement: SELECT a.*,b.* FROM actor a JOIN actor_test b ON a.actor_id=b.actor_id WHERE  (1 = 0) 
> 11/12/09 13:54:50 INFO manager.SqlManager: Executing SQL statement: SELECT a.*,b.* FROM actor a JOIN actor_test b ON a.actor_id=b.actor_id WHERE  (1 = 0) 
> 11/12/09 13:54:50 ERROR tool.ImportTool: Imported Failed: Duplicate Column identifier specified: 'actor_id'
> This schema is a modified version of the sakila database from http://dev.mysql.com/doc/index-other.html
> To recreate, load sakila database.
> USE sakila;
> CREATE TABLE actor_test LIKE actor;
> INSERT INTO actor_test SELECT * FROM actor;
> ALTER TABLE actor DROP first_name; ALTER TABLE actor DROP last_name; ALTER TABLE actor DROP last_update;
> ALTER TABLE actor_test DROP first_name; ALTER TABLE actor_test DROP last_name; ALTER TABLE actor_test DROP last_update;

--
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