Mailing-List: contact dev-help@sqoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@sqoop.apache.org
Received-SPF: pass (nike.apache.org: domain of s28sweet@gmail.com designates
 209.85.217.173 as permitted sender)
MIME-Version: 1.0
From: shakun grover <s28sweet@gmail.com>
Date: Wed, 8 Oct 2014 16:46:24 +0530
Message-ID: 
 <CAEap9pXdk9cq3OMdEWtcW0gGD5=DNZ1uq49mOUpZsxzjpcUS9A@mail.gmail.com>
Subject: Sqoop2:Duplicate Column Name in Multiple Tables Import
To: dev@sqoop.apache.org
Content-Type: multipart/alternative; boundary=001a11c334206df3e70504e7734e

--001a11c334206df3e70504e7734e
Content-Type: text/plain; charset=UTF-8

Hi All,

I want to import multiple tables' data to HDFS. But while doing this, if
same column name is there in more than one table. It gives me exception
while starting the job.

*Job:*
Name: testMultipleTables

Database configuration

Schema name:
Table name:
Table SQL statement: select tbl1.name , tbl1.description, tbl1.id,
tbl2.class, tbl2.id from test.table_1 as tbl1, test.table_2 as tbl2 WHERE
${CONDITIONS}
Table column names:
Partition column name: tbl1.id
Nulls in partition column:
Boundary query:

Output configuration

Storage type:
  0 : HDFS
Choose: 0
Output format:
  0 : TEXT_FILE
  1 : SEQUENCE_FILE
Choose: 0
Output directory: /tmp/multitables/3

*Exception while starting the job on the console:*
Exception has occurred during processing command
Server has returned exception: Exception: java.lang.Throwable Message:
GENERIC_JDBC_CONNECTOR_0002:Unable to execute the SQL statement

*Exception in the logs:*

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Duplicate column name 'id'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

Could you please tell me a solution for this?
-- 
Thanks & Regards,
Shakun Grover

--001a11c334206df3e70504e7734e--