You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@sqoop.apache.org by "Vikash Talanki -X (vtalanki - Infosys Limited at Cisco)" <vt...@cisco.com> on 2013/08/16 20:44:32 UTC
Oracle Synonym import error
Hi ,
I am trying to import a synonym from oracle. I have gone through the latest PDF available on sqoop and trying to import synonym by below query :
sqoop import \
--connect jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com \
--username NAI_DATA \
--password nai_data \
-m 1 \
--table NITA_CNTRCT_MON_PRICE \
--hive-import --hive-table nita_rcc.nita_cntrct_mon_price_synonym_test \
--driver oracle.jdbc.OracleDriver \
--connection-manager org.apache.sqoop.manager.GenericJdbcManager
But when I do this I am getting the below exception :
[dev@TSPM-SJ-ED1 ~]$ sqoop import --connect jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com --username NAI_DATA --password nai_data -m 1 --table NITA_CNTRCT_MON_PRICE --hive-import --hive-table nita_rcc.nita_cntrct_mon_price_synonym_test --driver oracle.jdbc.OracleDriver --connection-manager org.apache.sqoop.manager.GenericJdbcManager
13/08/16 11:18:21 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
13/08/16 11:18:21 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
13/08/16 11:18:21 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
13/08/16 11:18:21 INFO manager.SqlManager: Using default fetchSize of 1000
13/08/16 11:18:21 INFO tool.CodeGenTool: Beginning code generation
13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:194)
at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:178)
at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:114)
at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1235)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1060)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
at org.apache.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:129)
at org.apache.sqoop.manager.SqlManager.getColumnNames(SqlManager.java:113)
at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1207)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1062)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
13/08/16 11:18:22 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
java.lang.NullPointerException
at org.apache.sqoop.orm.ClassWriter.cleanColNames(ClassWriter.java:1045)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1066)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
[dev@TSPM-SJ-ED1 ~]$
Please kindly help me out how can I resolve this issue
Regards
-----------------------
Vikash T
+1 (408)506 2024
Re: Oracle Synonym import error
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
Hi Vikash,
I've actually tried the scenario and it seems that current versions of the Generic JDBC Connector do not supports Oracle database. The problem is that generated query for fetching the metadata is something like the following:
SELECT t.* FROM table AS t WHERE 1=0
However at least the version of oracle that I'm running is not supporting the keyword "AS" and requires to execute the query following way:
SELECT t.* FROM table t WHERE 1=0
Jarcec
On Sun, Aug 25, 2013 at 04:29:20PM +0000, Vikash Talanki -X (vtalanki - Infosys Limited at Cisco) wrote:
> I shall try that definitely. But is it something like 1.4.1 doesn't support importing synonyms?
>
> Sent from my iPhone
> Excuse typos
>
> On 25-Aug-2013, at 9:13, "Jarek Jarcec Cecho" <ja...@apache.org> wrote:
>
> > Hi Vikash,
> > would you mind trying to upgrade to the latest 1.4.4 and trying it there?
> >
> > Jarcec
> >
> > On Sun, Aug 25, 2013 at 07:06:44AM +0000, Vikash Talanki -X (vtalanki - Infosys Limited at Cisco) wrote:
> >> Hi Jarcec,
> >>
> >> I am using sqoop 1.4.1
> >>
> >> Regards
> >> -----------------------
> >> Vikash T
> >> +1 (408)506 2024
> >>
> >> -----Original Message-----
> >> From: Jarek Jarcec Cecho [mailto:jarcec@apache.org]
> >> Sent: Saturday, August 24, 2013 4:09 PM
> >> To: user@sqoop.apache.org
> >> Subject: Re: Oracle Synonym import error
> >>
> >> Hi Vikash,
> >> what Sqoop version are you using?
> >>
> >> Jarcec
> >>
> >> On Fri, Aug 16, 2013 at 06:44:32PM +0000, Vikash Talanki -X (vtalanki - Infosys Limited at Cisco) wrote:
> >>> Hi ,
> >>>
> >>> I am trying to import a synonym from oracle. I have gone through the latest PDF available on sqoop and trying to import synonym by below query :
> >>>
> >>> sqoop import \
> >>> --connect jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com \
> >>> --username NAI_DATA \ --password nai_data \ -m 1 \ --table
> >>> NITA_CNTRCT_MON_PRICE \ --hive-import --hive-table
> >>> nita_rcc.nita_cntrct_mon_price_synonym_test \ --driver
> >>> oracle.jdbc.OracleDriver \ --connection-manager
> >>> org.apache.sqoop.manager.GenericJdbcManager
> >>>
> >>> But when I do this I am getting the below exception :
> >>>
> >>> [dev@TSPM-SJ-ED1 ~]$ sqoop import --connect
> >>> jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com --username
> >>> NAI_DATA --password nai_data -m 1 --table NITA_CNTRCT_MON_PRICE
> >>> --hive-import --hive-table nita_rcc.nita_cntrct_mon_price_synonym_test
> >>> --driver oracle.jdbc.OracleDriver --connection-manager
> >>> org.apache.sqoop.manager.GenericJdbcManager
> >>> 13/08/16 11:18:21 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
> >>> 13/08/16 11:18:21 INFO tool.BaseSqoopTool: Using Hive-specific
> >>> delimiters for output. You can override
> >>> 13/08/16 11:18:21 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
> >>> 13/08/16 11:18:21 INFO manager.SqlManager: Using default fetchSize of
> >>> 1000
> >>> 13/08/16 11:18:21 INFO tool.CodeGenTool: Beginning code generation
> >>> 13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement:
> >>> SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
> >>> 13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement:
> >>> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> >>> ended
> >>>
> >>> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> >>> ended
> >>>
> >>> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
> >>> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
> >>> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
> >>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
> >>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
> >>> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
> >>> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
> >>> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
> >>> at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
> >>> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
> >>> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
> >>> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
> >>> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
> >>> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
> >>> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
> >>> at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:194)
> >>> at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:178)
> >>> at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:114)
> >>> at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1235)
> >>> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1060)
> >>> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> >>> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> >>> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> >>> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> >>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> >>> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> >>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> >>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> >>> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> >>> 13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement:
> >>> SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
> >>> 13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement:
> >>> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> >>> ended
> >>>
> >>> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> >>> ended
> >>>
> >>> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
> >>> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
> >>> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
> >>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
> >>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
> >>> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
> >>> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
> >>> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
> >>> at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
> >>> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
> >>> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
> >>> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
> >>> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
> >>> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
> >>> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
> >>> at org.apache.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:129)
> >>> at org.apache.sqoop.manager.SqlManager.getColumnNames(SqlManager.java:113)
> >>> at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1207)
> >>> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1062)
> >>> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> >>> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> >>> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> >>> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> >>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> >>> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> >>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> >>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> >>> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> >>> 13/08/16 11:18:22 ERROR sqoop.Sqoop: Got exception running Sqoop:
> >>> java.lang.NullPointerException java.lang.NullPointerException
> >>> at org.apache.sqoop.orm.ClassWriter.cleanColNames(ClassWriter.java:1045)
> >>> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1066)
> >>> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> >>> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> >>> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> >>> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> >>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> >>> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> >>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> >>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> >>> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> >>> [dev@TSPM-SJ-ED1 ~]$
> >>>
> >>> Please kindly help me out how can I resolve this issue
> >>>
> >>> Regards
> >>> -----------------------
> >>> Vikash T
> >>> +1 (408)506 2024
> >>>
Re: Oracle Synonym import error
Posted by "Vikash Talanki -X (vtalanki - Infosys Limited at Cisco)" <vt...@cisco.com>.
I shall try that definitely. But is it something like 1.4.1 doesn't support importing synonyms?
Sent from my iPhone
Excuse typos
On 25-Aug-2013, at 9:13, "Jarek Jarcec Cecho" <ja...@apache.org> wrote:
> Hi Vikash,
> would you mind trying to upgrade to the latest 1.4.4 and trying it there?
>
> Jarcec
>
> On Sun, Aug 25, 2013 at 07:06:44AM +0000, Vikash Talanki -X (vtalanki - Infosys Limited at Cisco) wrote:
>> Hi Jarcec,
>>
>> I am using sqoop 1.4.1
>>
>> Regards
>> -----------------------
>> Vikash T
>> +1 (408)506 2024
>>
>> -----Original Message-----
>> From: Jarek Jarcec Cecho [mailto:jarcec@apache.org]
>> Sent: Saturday, August 24, 2013 4:09 PM
>> To: user@sqoop.apache.org
>> Subject: Re: Oracle Synonym import error
>>
>> Hi Vikash,
>> what Sqoop version are you using?
>>
>> Jarcec
>>
>> On Fri, Aug 16, 2013 at 06:44:32PM +0000, Vikash Talanki -X (vtalanki - Infosys Limited at Cisco) wrote:
>>> Hi ,
>>>
>>> I am trying to import a synonym from oracle. I have gone through the latest PDF available on sqoop and trying to import synonym by below query :
>>>
>>> sqoop import \
>>> --connect jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com \
>>> --username NAI_DATA \ --password nai_data \ -m 1 \ --table
>>> NITA_CNTRCT_MON_PRICE \ --hive-import --hive-table
>>> nita_rcc.nita_cntrct_mon_price_synonym_test \ --driver
>>> oracle.jdbc.OracleDriver \ --connection-manager
>>> org.apache.sqoop.manager.GenericJdbcManager
>>>
>>> But when I do this I am getting the below exception :
>>>
>>> [dev@TSPM-SJ-ED1 ~]$ sqoop import --connect
>>> jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com --username
>>> NAI_DATA --password nai_data -m 1 --table NITA_CNTRCT_MON_PRICE
>>> --hive-import --hive-table nita_rcc.nita_cntrct_mon_price_synonym_test
>>> --driver oracle.jdbc.OracleDriver --connection-manager
>>> org.apache.sqoop.manager.GenericJdbcManager
>>> 13/08/16 11:18:21 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
>>> 13/08/16 11:18:21 INFO tool.BaseSqoopTool: Using Hive-specific
>>> delimiters for output. You can override
>>> 13/08/16 11:18:21 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
>>> 13/08/16 11:18:21 INFO manager.SqlManager: Using default fetchSize of
>>> 1000
>>> 13/08/16 11:18:21 INFO tool.CodeGenTool: Beginning code generation
>>> 13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement:
>>> SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
>>> 13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement:
>>> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
>>> ended
>>>
>>> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
>>> ended
>>>
>>> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
>>> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
>>> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
>>> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
>>> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
>>> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
>>> at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
>>> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
>>> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
>>> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
>>> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
>>> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
>>> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
>>> at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:194)
>>> at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:178)
>>> at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:114)
>>> at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1235)
>>> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1060)
>>> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
>>> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
>>> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
>>> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
>>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>>> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
>>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
>>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
>>> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
>>> 13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement:
>>> SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
>>> 13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement:
>>> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
>>> ended
>>>
>>> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
>>> ended
>>>
>>> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
>>> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
>>> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
>>> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
>>> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
>>> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
>>> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
>>> at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
>>> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
>>> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
>>> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
>>> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
>>> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
>>> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
>>> at org.apache.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:129)
>>> at org.apache.sqoop.manager.SqlManager.getColumnNames(SqlManager.java:113)
>>> at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1207)
>>> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1062)
>>> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
>>> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
>>> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
>>> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
>>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>>> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
>>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
>>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
>>> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
>>> 13/08/16 11:18:22 ERROR sqoop.Sqoop: Got exception running Sqoop:
>>> java.lang.NullPointerException java.lang.NullPointerException
>>> at org.apache.sqoop.orm.ClassWriter.cleanColNames(ClassWriter.java:1045)
>>> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1066)
>>> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
>>> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
>>> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
>>> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
>>> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
>>> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
>>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
>>> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
>>> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
>>> [dev@TSPM-SJ-ED1 ~]$
>>>
>>> Please kindly help me out how can I resolve this issue
>>>
>>> Regards
>>> -----------------------
>>> Vikash T
>>> +1 (408)506 2024
>>>
Re: Oracle Synonym import error
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
Hi Vikash,
would you mind trying to upgrade to the latest 1.4.4 and trying it there?
Jarcec
On Sun, Aug 25, 2013 at 07:06:44AM +0000, Vikash Talanki -X (vtalanki - Infosys Limited at Cisco) wrote:
> Hi Jarcec,
>
> I am using sqoop 1.4.1
>
> Regards
> -----------------------
> Vikash T
> +1 (408)506 2024
>
> -----Original Message-----
> From: Jarek Jarcec Cecho [mailto:jarcec@apache.org]
> Sent: Saturday, August 24, 2013 4:09 PM
> To: user@sqoop.apache.org
> Subject: Re: Oracle Synonym import error
>
> Hi Vikash,
> what Sqoop version are you using?
>
> Jarcec
>
> On Fri, Aug 16, 2013 at 06:44:32PM +0000, Vikash Talanki -X (vtalanki - Infosys Limited at Cisco) wrote:
> > Hi ,
> >
> > I am trying to import a synonym from oracle. I have gone through the latest PDF available on sqoop and trying to import synonym by below query :
> >
> > sqoop import \
> > --connect jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com \
> > --username NAI_DATA \ --password nai_data \ -m 1 \ --table
> > NITA_CNTRCT_MON_PRICE \ --hive-import --hive-table
> > nita_rcc.nita_cntrct_mon_price_synonym_test \ --driver
> > oracle.jdbc.OracleDriver \ --connection-manager
> > org.apache.sqoop.manager.GenericJdbcManager
> >
> > But when I do this I am getting the below exception :
> >
> > [dev@TSPM-SJ-ED1 ~]$ sqoop import --connect
> > jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com --username
> > NAI_DATA --password nai_data -m 1 --table NITA_CNTRCT_MON_PRICE
> > --hive-import --hive-table nita_rcc.nita_cntrct_mon_price_synonym_test
> > --driver oracle.jdbc.OracleDriver --connection-manager
> > org.apache.sqoop.manager.GenericJdbcManager
> > 13/08/16 11:18:21 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
> > 13/08/16 11:18:21 INFO tool.BaseSqoopTool: Using Hive-specific
> > delimiters for output. You can override
> > 13/08/16 11:18:21 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
> > 13/08/16 11:18:21 INFO manager.SqlManager: Using default fetchSize of
> > 1000
> > 13/08/16 11:18:21 INFO tool.CodeGenTool: Beginning code generation
> > 13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement:
> > SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
> > 13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement:
> > java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> > ended
> >
> > java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> > ended
> >
> > at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
> > at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
> > at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
> > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
> > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
> > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
> > at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
> > at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
> > at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
> > at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
> > at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
> > at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
> > at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
> > at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
> > at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
> > at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:194)
> > at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:178)
> > at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:114)
> > at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1235)
> > at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1060)
> > at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> > at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> > at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> > at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> > at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> > 13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement:
> > SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
> > 13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement:
> > java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> > ended
> >
> > java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> > ended
> >
> > at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
> > at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
> > at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
> > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
> > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
> > at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
> > at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
> > at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
> > at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
> > at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
> > at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
> > at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
> > at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
> > at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
> > at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
> > at org.apache.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:129)
> > at org.apache.sqoop.manager.SqlManager.getColumnNames(SqlManager.java:113)
> > at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1207)
> > at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1062)
> > at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> > at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> > at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> > at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> > at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> > 13/08/16 11:18:22 ERROR sqoop.Sqoop: Got exception running Sqoop:
> > java.lang.NullPointerException java.lang.NullPointerException
> > at org.apache.sqoop.orm.ClassWriter.cleanColNames(ClassWriter.java:1045)
> > at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1066)
> > at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> > at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> > at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> > at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> > at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> > at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> > at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> > [dev@TSPM-SJ-ED1 ~]$
> >
> > Please kindly help me out how can I resolve this issue
> >
> > Regards
> > -----------------------
> > Vikash T
> > +1 (408)506 2024
> >
RE: Oracle Synonym import error
Posted by "Vikash Talanki -X (vtalanki - Infosys Limited at Cisco)" <vt...@cisco.com>.
Hi Jarcec,
I am using sqoop 1.4.1
Regards
-----------------------
Vikash T
+1 (408)506 2024
-----Original Message-----
From: Jarek Jarcec Cecho [mailto:jarcec@apache.org]
Sent: Saturday, August 24, 2013 4:09 PM
To: user@sqoop.apache.org
Subject: Re: Oracle Synonym import error
Hi Vikash,
what Sqoop version are you using?
Jarcec
On Fri, Aug 16, 2013 at 06:44:32PM +0000, Vikash Talanki -X (vtalanki - Infosys Limited at Cisco) wrote:
> Hi ,
>
> I am trying to import a synonym from oracle. I have gone through the latest PDF available on sqoop and trying to import synonym by below query :
>
> sqoop import \
> --connect jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com \
> --username NAI_DATA \ --password nai_data \ -m 1 \ --table
> NITA_CNTRCT_MON_PRICE \ --hive-import --hive-table
> nita_rcc.nita_cntrct_mon_price_synonym_test \ --driver
> oracle.jdbc.OracleDriver \ --connection-manager
> org.apache.sqoop.manager.GenericJdbcManager
>
> But when I do this I am getting the below exception :
>
> [dev@TSPM-SJ-ED1 ~]$ sqoop import --connect
> jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com --username
> NAI_DATA --password nai_data -m 1 --table NITA_CNTRCT_MON_PRICE
> --hive-import --hive-table nita_rcc.nita_cntrct_mon_price_synonym_test
> --driver oracle.jdbc.OracleDriver --connection-manager
> org.apache.sqoop.manager.GenericJdbcManager
> 13/08/16 11:18:21 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
> 13/08/16 11:18:21 INFO tool.BaseSqoopTool: Using Hive-specific
> delimiters for output. You can override
> 13/08/16 11:18:21 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
> 13/08/16 11:18:21 INFO manager.SqlManager: Using default fetchSize of
> 1000
> 13/08/16 11:18:21 INFO tool.CodeGenTool: Beginning code generation
> 13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement:
> SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
> 13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement:
> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> ended
>
> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> ended
>
> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
> at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
> at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:194)
> at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:178)
> at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:114)
> at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1235)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1060)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> 13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement:
> SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
> 13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement:
> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> ended
>
> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly
> ended
>
> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
> at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
> at org.apache.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:129)
> at org.apache.sqoop.manager.SqlManager.getColumnNames(SqlManager.java:113)
> at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1207)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1062)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> 13/08/16 11:18:22 ERROR sqoop.Sqoop: Got exception running Sqoop:
> java.lang.NullPointerException java.lang.NullPointerException
> at org.apache.sqoop.orm.ClassWriter.cleanColNames(ClassWriter.java:1045)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1066)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> [dev@TSPM-SJ-ED1 ~]$
>
> Please kindly help me out how can I resolve this issue
>
> Regards
> -----------------------
> Vikash T
> +1 (408)506 2024
>
Re: Oracle Synonym import error
Posted by Jarek Jarcec Cecho <ja...@apache.org>.
Hi Vikash,
what Sqoop version are you using?
Jarcec
On Fri, Aug 16, 2013 at 06:44:32PM +0000, Vikash Talanki -X (vtalanki - Infosys Limited at Cisco) wrote:
> Hi ,
>
> I am trying to import a synonym from oracle. I have gone through the latest PDF available on sqoop and trying to import synonym by below query :
>
> sqoop import \
> --connect jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com \
> --username NAI_DATA \
> --password nai_data \
> -m 1 \
> --table NITA_CNTRCT_MON_PRICE \
> --hive-import --hive-table nita_rcc.nita_cntrct_mon_price_synonym_test \
> --driver oracle.jdbc.OracleDriver \
> --connection-manager org.apache.sqoop.manager.GenericJdbcManager
>
> But when I do this I am getting the below exception :
>
> [dev@TSPM-SJ-ED1 ~]$ sqoop import --connect jdbc:oracle:thin:@173.36.136.11:1521/afprod.cisco.com --username NAI_DATA --password nai_data -m 1 --table NITA_CNTRCT_MON_PRICE --hive-import --hive-table nita_rcc.nita_cntrct_mon_price_synonym_test --driver oracle.jdbc.OracleDriver --connection-manager org.apache.sqoop.manager.GenericJdbcManager
> 13/08/16 11:18:21 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
> 13/08/16 11:18:21 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
> 13/08/16 11:18:21 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
> 13/08/16 11:18:21 INFO manager.SqlManager: Using default fetchSize of 1000
> 13/08/16 11:18:21 INFO tool.CodeGenTool: Beginning code generation
> 13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
> 13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
>
> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
>
> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
> at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
> at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:194)
> at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:178)
> at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:114)
> at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1235)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1060)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> 13/08/16 11:18:22 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM NITA_CNTRCT_MON_PRICE AS t WHERE 1=0
> 13/08/16 11:18:22 ERROR manager.SqlManager: Error executing statement: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
>
> java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
>
> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
> at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
> at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
> at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:487)
> at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:496)
> at org.apache.sqoop.manager.SqlManager.getColumnNamesForRawQuery(SqlManager.java:129)
> at org.apache.sqoop.manager.SqlManager.getColumnNames(SqlManager.java:113)
> at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1207)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1062)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> 13/08/16 11:18:22 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.NullPointerException
> java.lang.NullPointerException
> at org.apache.sqoop.orm.ClassWriter.cleanColNames(ClassWriter.java:1045)
> at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1066)
> at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82)
> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:367)
> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)
> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)
> [dev@TSPM-SJ-ED1 ~]$
>
> Please kindly help me out how can I resolve this issue
>
> Regards
> -----------------------
> Vikash T
> +1 (408)506 2024
>