Got it. This looks like a legitimate bug. Would you mind filing a Jira describing what you're seeing at https://issues.apache.org/jira. We're actively developing Sqoop2 and it's still in what I'd consider its developmental stages. I sent out a potential roadmap about a week ago, so hopefully Sqoop2 will be feature packed and more stable in the months to come.
-Abe On Wed, Oct 8, 2014 at 10:51 PM, shakun grover <[email protected]> wrote: > 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 >
