sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jarek Jarcec Cecho <jar...@apache.org>
Subject Re: Oracle Synonym import error
Date Sun, 25 Aug 2013 17:00:36 GMT
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" <jarcec@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
> >>> 

Mime
View raw message