Thank you! On Wed, Oct 8, 2014 at 11:24 PM, shakun grover <[email protected]> wrote:
> Thanks Abe. > I have opened a bug in Jira i.e. > https://issues.apache.org/jira/browse/SQOOP-1572 > > On Thu, Oct 9, 2014 at 11:31 AM, Abraham Elmahrek <[email protected]> > wrote: > > > 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 > > > > > > > > > -- > Thanks & Regards, > Shakun Grover >
