Hi @itdm_bmi    Please try to add the 2nd jar "hive-contrib-2.1.1-cdh6.1.1.jar"  ... View more

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

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

@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

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

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

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

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