Hive - Replication issue through Cloudera Manager

Sayed016 — Tue, 21 Apr 2026 07:57:28 GMT

Hello Team,

We are setting the Hive replication through Cloudera Manager. The replication policy looks as follows.

Note that we also enabled the snapshot on the source cluster for the path - /warehouse

However, when we press save policy then we get the below notification.

We looked into the Cloudera Manager logs and we can see the below error. Can you please help us to get the correct configuration to resolve the issue?

2022-04-19 15:51:07,848 ERROR scm-web-1686:com.cloudera.server.web.cmf.WebController: getHiveWarehouseSnapshotsEnabled javax.ws.rs.NotAuthorizedException: HTTP 401 Unauthorized at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.apache.cxf.jaxrs.client.AbstractClient.convertToWebApplicationException(AbstractClient.java:507) at org.apache.cxf.jaxrs.client.ClientProxyImpl.checkResponse(ClientProxyImpl.java:324) at org.apache.cxf.jaxrs.client.ClientProxyImpl.handleResponse(ClientProxyImpl.java:878) at org.apache.cxf.jaxrs.client.ClientProxyImpl.doChainedInvocation(ClientProxyImpl.java:791) .... .... .... .... at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683) at java.lang.Thread.run(Thread.java:750) 2022-04-19 15:51:07,849 ERROR scm-web-1686:com.cloudera.server.web.common.JsonResponse: JsonResponse created with throwable: javax.ws.rs.NotAuthorizedException: HTTP 401 Unauthorized at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at org.apache.cxf.jaxrs.client.AbstractClient.convertToWebApplicationException(AbstractClient.java:507) at org.apache.cxf.jaxrs.client.ClientProxyImpl.checkResponse(ClientProxyImpl.java:324) at org.apache.cxf.jaxrs.client.ClientProxyImpl.handleResponse(ClientProxyImpl.java:878) at org.apache.cxf.jaxrs.client.ClientProxyImpl.doChainedInvocation(ClientProxyImpl.java:791)

Re: Hive - Replication issue through Cloudera Manager

Bharati — Tue, 19 Apr 2022 18:03:37 GMT

@Sayed016 Thank you for your question.

From the error stack of CM logs, it looks like it tries to copy the system database and information_schema.

You need to exclude the system database and information_schema

Add the following exclusion on a Hive replication: Databases: (?!information_schema|sys\b).+ Tables: [\w].+

Re: Hive - Replication issue through Cloudera Manager

Sayed016 — Tue, 19 Apr 2022 23:06:40 GMT

@Bharati Thank you! This worked. However, could you please share which logs had shown that it was trying to copy the system database and information_schema?

question Re: Hive - Replication issue through Cloudera Manager in Support Questions

Hive - Replication issue through Cloudera Manager

Re: Hive - Replication issue through Cloudera Manager

Re: Hive - Replication issue through Cloudera Manager