Hello folks, I have to perform Update statement on hive table which has only 1 row. However it takes 17 seconds to perform the job. I was wondering what causes this long execution process. I noticed that the run DAG operation took 11.72 seconds to finish. Is this a normal execution time? I am using Hive 18.104.22.168.1.0.0-78. Thank you in advance!
For the first time when we are running Update statement..etc TEZ will initialize the session if the session is already running and the Execution time seems to be Okay.
If you run another Update statement then the time should be less than 11 sec i believe, also the execution time depends on how many records exists in the table(if we have millions records without partition then update statement will perform full table scan and eventually execution time will be higher).
Also it would be good to check do u have any resource constrain in the cluster.
In case if you are updating bulk records then refer to merge strategy.