Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Issue with SQOOP Internally creating View in the Teradata database while running the Free Form

Issue with SQOOP Internally creating View in the Teradata database while running the Free Form

Contributor

Hi All,

 

I am using CDH 5.1.1 with cloudera manager. When I tried to use SQOOP command 

sqoop --options-file /var/conf/import_conf.txt --query
'Select o.RPT_MTH, o.Data_Prod_Lvl1_Desc, o.svc_id_desc, SUM(o.TOTAL_PRODUCT_Rev) as Total_Prod_Rev, SUM(o.eop_subs) as EOP_Subs From NTL_PRD_ALLVM.OTHER_DP_SUM_FACT_V o Where RPT_MTH between 1110101 AND (date-1) and o.Data_Prod_Lvl1_Desc = 'ABC' AND $CONDITIONS group by 1, 2, 3 '
--split-by
o.RPT_MTH
 --num-mappers 4

 

I am getting :

 

14/08/25 10:09:52 INFO db.TeradataConnection: CREATE VIEW "V_100952563" ("c1","c2","c3","c4","c5") AS Select o.RPT_MTH, o.Data_Prod_Lvl1_Desc, o.svc_id_desc, SUM(o.TOTAL_PRODUCT_Rev) as Total_Prod_Rev, SUM(o.eop_subs) as EOP_Subs From NTL_PRD_ALLVM.OTHER_DP_SUM_FACT_V o Where RPT_MTH between 1110101 AND  (date-1) and  o.Data_Prod_Lvl1_Desc = 'ABC' AND (1 = 1) group by 1, 2, 3

14/08/25 10:09:53 INFO mapreduce.TeradataInputProcessor: job setup ends at 1408979393170

14/08/25 10:09:53 INFO mapreduce.TeradataInputProcessor: job setup time is 15s

 

14/08/25 10:09:53 ERROR tool.ImportTool: Encountered IOException running import job: com.teradata.hadoop.exception.TeradataHadoopSQLException: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 13.10.00.36] [Error 3524] [SQLState 42000] The user does not have CREATE VIEW access to database NTL_PRD_QMTMPTBLS.
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:307)
at com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:102)
at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:317)
at com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:198)
at com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:121)
at com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:112)
at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:375)
at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:317)
at com.teradata.jdbc.jdbc_4.TDStatement.doNonPrepExecute(TDStatement.java:280)
at com.teradata.jdbc.jdbc_4.TDStatement.execute(TDStatement.java:1094)

 

SQOOP is trying to create a view internally for the free form query but the we do not have create view access to the database. Is there any other way to resolve this.... Thanks for your help.

 

Thanks,

Amit