Error in acquireLock… FAILED: Error in acquiring locks: Locks on the underlying objects cannot be acquired.
Instant Patchy workaround:
SET hive.support.concurrency=false;
Unlock table:
unlock table my_table;
Some other tricks that work – as suggested in cloudera forums – Hue leaves locks on tables sometimes.
HUE_SER=`ls -alrt /var/run/cloudera-scm-agent/process | grep HUE | tail -1 | awk ‘{print $9}’`
HUE_CONF_DIR=/var/run/cloudera-scm-agent/process/${HUE_SER}
ls HUE_CONF_DIR
/opt/cloudera/parcels/CDH/share/hue/build/env/bin/hue close_queries > tmp.log 2>> tmp.log
Search is still On !!