Hello @Tushar17, Have you checked the logs  /var/log/cloudera-manager-installer/8.start-cloudera-scm-server.log ? Can you please share any stack trace you see in the logs?   ... View more

Hello @baabdullah ,   The error indicates that your DataNode is down. Could you please confirm if that's the scenario?    Error: could only be written to 0 of the 1 minReplication nodes. There are 0 datanode(s) running and 0 node(s) are excluded in this operation. Could you please check the data node logs to identify the exact issue? Maybe you need to check the heap size (one of the many possible reasons).    Hope this helps, Tarun Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs-up button. ... View more

Hello @prakodi, Thanks for your response!   You do have the option to select a single database in the general tab while creating hive replication policies. In the Replicate All parameter you can mention the single database.   Refer to this article:  https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/replication-manager/topics/rm-dc-configuring-replication-of-hiveimpala-data.html   Hope this helps, Tarun   Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs-up button. ... View more

Hello @prakodi ,   You can use Hive Replication to migrate the schema from one cluster to another https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/replication-manager/topics/rm-dc-hiveimpala-replication.html   Hope this helps, Tarun   Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs-up button. ... View more

Hello @VeHa,   I hope you are doing great!   Could you please let me know how you have added the value for "metastore.storage.schema.reader.impl" in hive-site.xml? Is it done as below? CM » Hive » Configuration » Safety Valve -Advanced Configuration for Hive-Site.xml Property: metastore.storage.schema.reader.impl Value: org.apache.hadoop.hive.metastore.SerDeStorageSchemaReader  Let me know if this helps.   Cheers! ... View more

Hello @sseoju , You may get the required information in Impala as shown below: [node1:21000] default> CREATE EXTERNAL TABLE IF NOT EXISTS test_table > ( > `id` string comment 'id', > `name` string comment 'name', > `area` struct<`country`: string comment "test country", `address`:string comment 'test address'> comment 'test struct' > ); Query: CREATE EXTERNAL TABLE IF NOT EXISTS test_table ( `id` string comment 'id', `name` string comment 'name', `area` struct<`country`: string comment "test country", `address`:string comment 'test address'> comment 'test struct' ) +-------------------------+ | summary | +-------------------------+ | Table has been created. | +-------------------------+ Fetched 1 row(s) in 0.26s [node1:21000] default> desc test_table; Query: describe test_table +------+------------------------------------------+-------------+ | name | type | comment | +------+------------------------------------------+-------------+ | id | string | id | | name | string | name | | area | struct< | test struct | | | country:string comment 'test country', | | | | address:string comment 'test address' | | | | > | | +------+------------------------------------------+-------------+ Fetched 3 row(s) in 0.28s This is also mentioned here https://impala.apache.org/docs/build/html/topics/impala_describe.html Let me know if this helps. Cheers! ... View more