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.

SAP Repication server for Oracle to HIVe

Highlighted

SAP Repication server for Oracle to HIVe

Hello,

We are trying to implement heterogeneous SAP Replication server between Oracle as source and SAP HANA as destination.

Reference Link-

https://blogs.sap.com/2015/12/23/setup-configure-and-replicate-from-sap-adaptive-server-enterprise-t...

While Creating connection between SAP Replication to HIVE, we are getting below error -

	I. 2018/06/06 16:41:14. SQM starting: 143:0 HIVESB.RRAHDP
I. 2018/06/06 16:41:15. Message from server: Message: 0, State 0, Severity 5 -- '[ statement ][ HIVESB ] HiveStatement::Execute Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.Exception: HTTP 400 Error: PUBLIC is Not Fo.
I. 2018/06/06 16:41:16. Message from server: Message: 0, State 0, Severity 5 -- '[ statement ][ HIVESB ] HiveStatement::Execute Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Indexes unsupported for Tez execution engine'.
I. 2018/06/06 16:41:16. Message from server: Message: 0, State 0, Severity 5 -- '[ statement ][ HIVESB ] HiveStatement::Execute Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.Exception: HTTP 400 Error: PUBLIC is Not Fo.
I. 2018/06/06 16:41:17. Message from server: Message: 0, State 0, Severity 5 -- '[ statement ][ HIVESB ] HiveStatement::Execute Error while compiling statement: FAILED: ParseException line 1:202 Failed to recognize predicate 'percent'. Failed rule: 'identifier' in column specification'.
I. 2018/06/06 16:41:17. The DSI thread for database 'HIVESB.RRAHDP' is started. 
I. 2018/06/06 16:41:17. Message from server: Message: 0, State 0, Severity 5 -- '[ statement ][ HIVESB ] HiveStatement::ExecuteCmdList Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [sybase] does not have [READ] privilege on [file:/data/srs/rs_hive_rec_0.
E. 2018/06/06 16:41:17. ERROR #5046 DSI(143 HIVESB.RRAHDP) - eneric/dsi/dsioqid.c(2058)
When executing the rs_get_lastcommit function in database 'HIVESB.RRAHDP', received data server errors. See logged data server errors for more information.
I. 2018/06/06 16:41:17. The DSI thread for database 'HIVESB.RRAHDP' is shutdown.

Please help
4 REPLIES 4
Highlighted

Re: SAP Repication server for Oracle to HIVe

Mentor

@Anirudh D

There error is due to "FAILED: HiveAccessControlException Permission denied: user [sybase] does not have [READ] privilege on [file:/data/srs/rs_hive_rec_0."

Can you give the permission on this file probably by creating rw ACL for srs

Before enabling ACL on HDP you MUST set the following HDFS -> Configs -> Advanced -> hdfs-site.xml property to true and restart the stale configs

dfs.namenode.acls.enabled=true 

Also, make sure there is a local user mapping to sysbase

$ hdfs dfs -setfacl -m sysbase:hdfs:rw- /data/srs 

After setting the ACL above retry

please revert

Highlighted

Re: SAP Repication server for Oracle to HIVe

Mentor

@Anirudh D

Any updates? If you found this answer addressed your question, please take a moment to log in and click the "accept" link on the answer.

Re: SAP Repication server for Oracle to HIVe

@Geoffrey Shelton Okot

Sorry for the late reply. It did not work.

Highlighted

Re: SAP Repication server for Oracle to HIVe

Mentor

@Anirudh D

So what is the new error message? Any new logs to share ?

Don't have an account?
Coming from Hortonworks? Activate your account here