Member since
02-09-2021
109
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
661 | 07-27-2023 11:39 PM |
07-27-2023
11:39 PM
Hi @itdm_bmi After adding the jar , Instead of ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.MultiDelimitSerde' Please try ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe'
... View more
07-27-2023
01:41 AM
Hi @itdm_bmi Please try to add the 2nd jar "hive-contrib-2.1.1-cdh6.1.1.jar"
... View more
07-27-2023
01:16 AM
Hi @itdm_bmi Can you share the output of ls -l /opt/cloudera/parcels/CDH/jars| grep -i contrib Also, may i know what exact add command you executed ?
... View more
07-19-2023
10:19 PM
Hi @hanumanth The MSCK will run slow for the first time as it has to go through all the partitions and update HMS. You can recommend users to maintain around 10k partitions to avoid slowness/hung in HMS
... View more
07-13-2023
08:48 PM
@hanumanth If its an external table, dropping it will not delete the data from HDFS and when you recreate it, the MSCK again has to go through all the 36k partitions and scan them, this may overload the HMS for time being and can cause slowness.
... View more
06-27-2023
10:24 PM
Hi Hanu, if the MSCK is hanging for a particular table, then there must be some problem on that table, What do you see in HS2 or HMS logs when the command is hung ? Are you seeing any error in logs or ? Can you share the thread which is running MSCK ? Check what that thread is doing, it will give an idea where the problem is coming from.
... View more
09-27-2022
06:25 AM
May i know if the table was created from the data that was exported in some other format like 'txt' format or something ? if this is true then, starting from CDP 7.x versions, the default file format is parquet. So, when the table is imported, it will be created in parquet format, but its original files will in 'txt' format.
... View more
09-27-2022
06:14 AM
Can you make sure that Hiveserver2 is installed under Hive_on_Tez and not under Hive ? Most probably the tez libraries are not defined under hive configurations 1- try adding this property "tez.lib.uris" in Hive on Tez and Hive services - Cloudera Manager -> Hive on Tez -> Configurations -> "Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml" tez.lib.uris=/user/tez/<version>/tez.tar.gz ## Where (/user/tez/<version>/tez.tar.gz) is an HDFS location. - Cloudera Manager -> Hive -> Configurations -> "Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml" tez.lib.uris=/user/tez/<version>/tez.tar.gz Also make sure tez client is installed on all the edge nodes and the file exists on HDFS 2 - If you don't find the file on HDFS do the following - Cloudera Manager -> Tez -> Actions -> "Upload Tez tar file to HDFS"
... View more
04-06-2021
02:50 AM
Hello Michael, In your insert query are you referring to table like "databasename.tablename"?, if yes, then first try to execute "use databasename" And then execute the query.
... View more