@jass pls give a try with below settings. 1) Go to CM > Tez > Actions > "Upload Tez tar file to HDFS". 2) Go to CM >> Click on Hive on Tez service >> click on configuration >> Search for the Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml setting. a) In the Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml setting, click + b) In Name enter the property "hive.server2.tez.initialize.default.sessions" and in value enter "false" c) Save the changes. 3) Once both the steps are performed, restart the stale services. 4) Hive services should be up now.   ... View more

@drgenious can you share more details on the query executed and log details to check further? this error can happen for multiple reasons like data type, memory etc. it does not show the real reason. attach the trace along with other details requested.   ... View more

@Ane can you give a try by explicitly mentioning target database before calling CTAS.  use <target_database> ... View more

issue is more generic. have we have complete stacktrace to see the root cause? ... View more

let table hwctest has 2 columns as below, +--------------------------+------------+----------+ | col_name | data_type | comment | +--------------------------+------------+----------+ | col1 | string | | | col2 | string | | | dt | date | | | | NULL | NULL | | # Partition Information | NULL | NULL | | # col_name | data_type | comment | | dt | date | | +--------------------------+------------+----------+ getting column name from metadata and stored in temp var, beeline -u "jdbcurl" --showHeader=false --outputformat=csv2 -e "SELECT COLUMN_NAME FROM sys.COLUMNS_V2 c JOIN sys.TBLS a ON c.CD_ID=a.TBL_ID where a.TBL_NAME='hwctest'" | tr "\n" "," > tmp a=$(cat tmp)  Passing col names as variable, beeline -u "jdbcurl" --hivevar colName=${a%?} ..... 0: jdbc:hive2://c2757-node3.coelab.cloudera.c> select case when array_contains(split('${colName}',','),'col1') then 1 else 0 . . . . . . . . . . . . . . . . . . . . . . .> end as type ..... INFO : Executing command(queryId=hive_20220218082727_46d036f4-7667-485a-a2c9-c5be158292d4): select case when array_contains(split('col1,col2',','),'col1') then 1 else 0 end as type +-------+ | type | +-------+ | 1 | +-------+ replace the value col1 in your case. ... View more

can we have complete error stack trace or hs2 logs and version details for reference? ... View more

In general, ambari will create that znode by default. we dont need to create manually. logs shows that issue with sasl. we can still create znode manually after logging into zookeeper cli. [root@c2757-node3 ~]# /opt/cloudera/parcels/CDH-7.1.6-1.cdh7.1.6.p0.10506313/lib/zookeeper/bin/zkCli.sh -server c2757-node3.coelab.cloudera.com:2181 /usr/java/jdk1.8.0_232-cloudera/bin/java Connecting to c2757-node3.coelab.cloudera.com:2181 Welcome to ZooKeeper! JLine support is enabled WATCHER:: WatchedEvent state:SyncConnected type:None path:null [zk: c2757-node3.coelab.cloudera.com:2181(CONNECTED) 0] ls / [confstore, hbase, hiveserver2, kafka, rmstore, solr-infra, zookeeper] [zk: c2757-node3.coelab.cloudera.com:2181(CONNECTED) 1] ls /hiveserver2 [serverUri=c2757-node3.coelab.cloudera.com:10000;version=3.1.3000.7.1.6.0-297;sequence=0000000024] [zk: c2757-node3.coelab.cloudera.com:2181(CONNECTED) 7] create /sample Created /sample [zk: c2757-node3.coelab.cloudera.com:2181(CONNECTED) 8] ls / [confstore, hbase, hiveserver2, kafka, rmstore, sample, solr-infra, zookeeper] ... View more