SAP Repication server for Oracle to HIVe

[#1]

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

[#2]

@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

[#3]

@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.

[#4]

@Geoffrey Shelton Okot

Sorry for the late reply. It did not work.

[#5]

@Anirudh D

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