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
