About flowerbirds

GangWar · ‎07-12-2021

@sur I believe you have to Set below properties before executing create table statement. SET hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; SET hive.support.concurrency=true; This seems a very known behaviour and I did a simple Googling and found the solutions on several places. Below are the references. https://stackoverflow.com/questions/42669171/semanticexception-error-10265-while-running-simple-hive-select-query-on-a-tran https://dbmstutorials.com/hive/hive-errors.html https://knowledge.informatica.com/s/article/526538?language=en_USv Hope this helps.

GangWar · ‎07-12-2021

@flowerbirds For CM server DB you can try something like below: In db.properties: com.cloudera.cmf.db.type = mysql com.cloudera.cmf.orm.hibernate.connection.url=jdbc:mysql://<db_host>/scm?useSSL=true com.cloudera.cmf.orm.hibernate.connection.username=scm com.cloudera.cmf.orm.hibernate.connection.password=cloudera In /etc/default/cloudera-scm-server add the following to export CMF_JAVA_OPTS: -Djavax.net.ssl.trustStore=/opt/cloudera/security/jks/truststore.jks Restart the Cloudera Manager server. NOTE: Just remember in some case we set ssl=true&sslmode=require so if the normal method means com.cloudera.cmf.orm.hibernate.connection.url=jdbc:mysql://<db_host>/scm?useSSL=true failed please try the `ssl=true&sslmode=require as well and see.

Online	Offline
Last Visited	‎07-28-2021 10:02 PM

Member Since	‎05-22-2021 08:56 AM
Last Visited	‎07-28-2021 10:02 PM
Posts	6

Cloudera Community

Re: ACID table transactions fails

Re: CM 5.16.2 scm prepare database error with mysq...