sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amit Kumar <dutta.ami...@gmail.com>
Subject Fwd: Issue with SQOOP Internally creating View in the Teradata database while running the Free Form Query
Date Mon, 25 Aug 2014 16:01:32 GMT
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

Mime
View raw message