I dont think you can use PutSQL for this. Try ExecuteSQL or you might have to use ExecuteScript processor as other posts suggest: https://community.cloudera.com/t5/Support-Questions/Does-ExecuteSQL-processor-allow-to-execute-stored-procedure/m-p/158922 https://stackoverflow.com/questions/72348844/get-output-of-stored-procedure-using-putsql-in-nifi If that helps please accept solution. Thanks ... View more

Yes it's correct what   elserj said, but inside your crontab job please add . $HOME/.bashrc; for example: 09 15 * * 1 . $HOME/.bashrc; PATH:/compact.sh > /home/user/logfile.log 2>&1 ... View more

If i am having more than one columns as primary key.How shall i proceed. ... View more

Thank you very much for this answer. ... View more

I don't want to add one more column to the actual index columns, but in the INCLUDE() section. Will that also have same effect? ... View more

You need to move your snapshot from exported directory to the directory where hbase looks for snapshots(.hbase-snapshot). so that list_snapshots and other commands(like clone_snapshot ) can work easily hadoop dfs -mv hdfs://NAME_NODE:8020/hbase/.hbase-snapshot/<snapshot_name> hdfs://NAME_NODE:8020/apps/hbase/data/.hbase-snapshot/ hdfs dfs -mv hdfs://NAME_NODE:8020/hbase/archive/data/* hdfs://NAME_NODE:8020/apps/hbase/data/archive/data/ FYI:- to list snapshot directly from remote directory hbase org.apache.hadoop.hbase.snapshot.SnapshotInfo -remote-dir hdfs://NAME_NODE:8020/hbase/ -list-snapshots ... View more

Thank you Matt, ListHDFS was a good hint. I was able to accomplish my task with you inputs. ... View more

Do you mind putting this into a new HCC question? Although the problems may be somewhat similar, you will likely get answers that don't apply to the original question here, so to avoid confusion, I think a new question is the right way to go 🙂 Thanks in advance! ... View more

@Akash S The optimum value for Maximum Timer Driven Thread count will be based on the number of CPU's your system has. Roughly we recommend between 2 and 4 times the number of CPU. So, if your system has 8 CPUs, assuming it isn't bear metal, then your max timer driven threads can be between 16 and 32. If you have a bare metal system, then you will have more room because of hyper-threading, so the values could be between 32 and 64. The Event Driven thread value can stay at 5, NiFi will not need more than that, no matter how many processors there are on the graph. ... View more