Even with"AS" operator, it is not working:
*Job:*
Name:
Database configuration
Schema name:
Table name:
Table SQL statement: select list.action,list.description,list.id AS
listId,cl.class,cl.id AS classId from test.action_list AS list,test.class
AS cl WHERE ${CONDITIONS}
Table column names:
Partition column name: listId
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/5
*LOGS:*
org.apache.sqoop.common.SqoopException: SCHEMA_0002:Duplicate column name -
Column: FixedPoint{name=id,nullable=null,byteSize=null,unsigned=null}
at org.apache.sqoop.schema.Schema.addColumn(Schema.java:88)
at
org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer.getSchema(GenericJdbcImportInitializer.java:99)
at
org.apache.sqoop.connector.jdbc.GenericJdbcImportInitializer.getSchema(GenericJdbcImportInitializer.java:40)
at org.apache.sqoop.framework.JobManager.submit(JobManager.java:388)
at
org.apache.sqoop.handler.SubmissionRequestHandler.submissionSubmit(SubmissionRequestHandler.java:152)
at
org.apache.sqoop.handler.SubmissionRequestHandler.handleActionEvent(SubmissionRequestHandler.java:122)
at
org.apache.sqoop.handler.SubmissionRequestHandler.handleEvent(SubmissionRequestHandler.java:75)
at
org.apache.sqoop.server.v1.SubmissionServlet.handlePostRequest(SubmissionServlet.java:44)
at
org.apache.sqoop.server.SqoopProtocolServlet.doPost(SqoopProtocolServlet.java:63)
On Thu, Oct 9, 2014 at 4:49 AM, Abraham Elmahrek <[email protected]> wrote:
> Sorry,
>
> I just noticed I didn't add the "AS" operator: "SELECT tbl1.name,
> tb1.description, tbl1.id AS t1_id, tbl2.class tbl2.id AS t2_id FROM
> test.table_1 as tbl1, test.table_2 as tbl2 WHERE ${CONDITIONS}".
>
> On Wed, Oct 8, 2014 at 12:22 PM, Abraham Elmahrek <[email protected]>
> wrote:
>
> > MySQL should support the "AS" operator. Could you try that?
> >
> > "SELECT tbl1.name, tb1.description, tbl1.id, tbl2.class tbl2.id FROM
> > test.table_1 as tbl1, test.table_2 as tbl2 WHERE ${CONDITIONS}".
> >
> > On Wed, Oct 8, 2014 at 4:16 AM, shakun grover <[email protected]>
> wrote:
> >
> >> 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
> >>
> >
> >
>
--
Thanks & Regards,
Shakun Grover
