an we know why are you using GET command to update the entity ?  is it typo ? ... View more

Just got the article access. By the way this issue occurs in mysql even not a galera cluster types. even i make the same Mariadb as master / slave, the same issue occurs, so this is not the problem with galera cluster, is for sure. ... View more

Found another Cloudera KB, where it says: To resolve this issue we have to set this property hadoop.security.authorization to false under hive safety valve as this will be used only by Hive without impacting the storage, since it cannot be set to false at storage layer as it is needed for storage. STEPS TO SET THE PROPERTY: CM < Hive on tez < Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml  Name: hadoop.security.authorization Value: false ... View more

Because I ran into this thread when looking how to solve this error and because we found a solution, I thought it might still serve some people if I share what solution we found. We needed HWC to profile Hive managed + transactional tables from Ataccama (data quality solution). And we found someone who successfully got spark-submit working. We checked their settings and changed the spark-submit as follows: COMMAND="$SPARK_HOME/bin/$SPARK_SUBMIT \             --files $MYDIR/$LOG4J_FILE_NAME $SPARK_DRIVER_JAVA_OPTS $SPARK_DRIVER_OPTS \         --jars {{ hwc_jar_path }} \         --conf spark.security.credentials.hiveserver2.enabled=false \         --conf "spark.sql.hive.hiveserver2.jdbc.url.principal=hive/_HOST@{{ ad_realm }}" \             --conf spark.dynamicAllocation.enable=false \             --conf spark.hadoop.metastore.catalog.default=hive \             --conf spark.yarn.maxAppAttempts=1 \             --conf spark.sql.legacy.parquet.int96RebaseModeInRead=CORRECTED \             --conf spark.sql.legacy.parquet.int96RebaseModeInWrite=CORRECTED \             --conf spark.sql.legacy.parquet.datetimeRebaseModeInRead=CORRECTED \             --conf spark.sql.legacy.timeParserPolicy=LEGACY \             --conf spark.sql.legacy.typeCoercion.datetimeToString.enabled=true \             --conf spark.sql.parquet.int96TimestampConversion=true \             --conf spark.sql.extensions=com.hortonworks.spark.sql.rule.Extensions \             --conf spark.sql.extensions=com.qubole.spark.hiveacid.HiveAcidAutoConvertExtension \             --conf spark.kryo.registrator=com.qubole.spark.hiveacid.util.HiveAcidKyroRegistrator \             --conf spark.sql.sources.commitProtocolClass=org.apache.spark.sql.execution.datasources.SQLHadoopMapReduceCommitProtocol \             --conf spark.datasource.hive.warehouse.read.mode=DIRECT_READER_V2 \         --class $CLASS $JARS $MYLIB $PROPF $LAUNCH $*"; exec $COMMAND Probably the difference was in the spark.hadoop.metastore.catalog.default=hive setting. In the above example are some Ansible variables: hwc_jar_path: "/opt/cloudera/parcels/CDH-7.1.7-1.cdh7.1.7.p1000.24102687/jars/hive-warehouse-connector-assembly-1.0.0.7.1.7.1000-141.jar" ad_realm is our LDAP realm. Hope it helps anyone.   ... View more

Hello, did you ever find a solution? I am running into the same error. Even tried mssql-12.2.0 and mssql-8.2.2.  ... View more

@bhagi Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future.  ... View more

Congratulations on resolving the issue @shiva239. Can you please mark the appropriate reply as the solution to make it easier for others to find the answer in the future?  mark as solution button     ... View more

the 'date' column in our table is indeed of the TIMESTAMP data type. ... View more