Member since
01-27-2021
9
Posts
3
Kudos Received
2
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
650 | 04-27-2022 11:44 PM | |
1168 | 03-03-2022 10:42 PM |
04-28-2022
04:21 AM
1 Kudo
@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
04-27-2022
11:44 PM
@Meepoljd yes. these calls were made, to get, metadata information from backend db (mysql, postgres) for each request comes in to hms for query processing.
... View more
04-06-2022
01:12 AM
1 Kudo
@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
03-22-2022
10:40 AM
@Ane can you give a try by explicitly mentioning target database before calling CTAS. use <target_database>
... View more
03-03-2022
10:42 PM
1 Kudo
hive user does not have access to dir /user/sathyam.kunda/dev/data/raw/multiplan/mpi_fnxnegotiator.db/negotiationteam. drwxr-xr-x shows that other group users has only read and execute access but not write. pls check the permissions.
... View more
02-21-2022
04:06 AM
issue is more generic. have we have complete stacktrace to see the root cause?
... View more
02-18-2022
01:16 AM
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
02-17-2022
11:32 PM
can we have complete error stack trace or hs2 logs and version details for reference?
... View more
02-09-2022
04:55 AM
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