Hi @ram76, Any reason why the mv is slow? Are they on different mount points? We did see issues around 2-3 minutes delay, but unfortunately that I am not aware of a workaround. You should focus on finding out why the "move" command took this long. In my test, it took 2 minutes to copy: time cp -r /opt/cloudera/parcels/CDH-5.13.3-1.cdh5.13.3.p3573.3750 /opt/cloudera/parcel-cache/5.13.3 real 1m59.830s user 0m0.126s sys 0m5.621s But my "mv' was instant: time mv /opt/cloudera/parcel-cache/5.13.3 /opt/cloudera/parcels/5.13.3 real 0m0.138s user 0m0.000s sys 0m0.002s Can you please share the output of : df -h So we can see the disk break down? Thanks Eric ... View more

@Daddy, This is a known issue in CM when either unpacking or moving of parcel directory is slow. When CM unpacks the parcel file, it performs below steps: 1. untar the parcel file under /opt/cloudera/parcel-cache 2. then "move" the parcel files to /opt/cloudera/parcels If the I/O is slow on the FS that holds directory /opt/cloudera/parcel-cache, the untar command will be slow. If the directories /opt/cloudera/parcel-cache and /opt/cloudera/parcels are mounted on different mount points, then the "move" command will become "copy" and then "delete", so operation will be much slower than the actual "move" which only involves rename. Since CM uses different threads to perform operations, it can happen that the checking happens before the untar operation finishes, hence you hit the issue. Can you please check if above is the issue in your case? So you can perform the same steps I mentioned: 1. manually untar parcel under /opt/cloudera/parcel-cache 2. run "mv" command to move directory from /opt/cloudera/parcel-cache to /opt/cloudera/parcels and time it If either of the above is slow, then you have found your issue. Cheers Eric ... View more

Hi Heri, Glad that it helped and thanks for the info. Cheers Eric ... View more

Hi Heri, As mentioned in the error: if using free form query import (consider adding clause AS if you're using column transformation) You max(id) aggregate function does not have "AS" clause, please change your query to below and try again: select max(id) as max_id from NodeName a where $CONDITIONS Cheers Eric ... View more

Please also share the output of below command on the Ranger host: ls -al /opt/cloudera/parcels/ Just to make sure the CDH version is linked properly. Cheers Eric ... View more

@Dombai_Gabor , Can you please log onto Ranger's host, go to directory /opt/cloudera/parcels/CDH/lib and then run command: grep -rni 'RangerRESTUtils' * Also under directory /opt/cloudera/parcels/CDH/jars and run the same command, just to check if file ranger-plugins-common-2.0.0.7.x.x.x-xxx.jar exist under your CDP installation.   Please share the full output.   Cheers Eric ... View more