@TRSS_Cloudera Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.   ... View more

@enirys  You could refer to the following doc for Hive tuning: https://docs.cloudera.com/HDPDocuments/HDP2/HDP-2.6.5/bk_hive-performance-tuning/content/ch_connectivity-admission-control.html#guidelines-hiveserver2-heaps   If you have other services running on the same HS2 node as well, you might want to reduce Hive heap size  or move a service to a different node. Are you expecting too many connections as explained in the above doc, else you might want to bring down HS2 heap size? If you do not see too many connections, but notice high heap usage, you might want to take a heap dump as @asish mentioned, and see if there is memory leak.   Load balancing across HS2 could take place based on how you are accessing Hive. You could use zooKeeper based connection string. ... View more

@reca, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.   ... View more

Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.   ... View more

@dv_conan, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  ... View more

@roshanbi Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  ... View more

@nareshbattula, Has any of the replies helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.  ... View more

@wbivp    I created a community article long ago that details the Ranger based "NiFi Resource Identifier" policy strings you would use in Ranger to provide various levels of authorization within NiFi. https://community.cloudera.com/t5/Community-Articles/NiFi-Ranger-based-policy-descriptions/ta-p/246586 For example, it you want to grant access so that users can access and create components within a PG: /process-groups/<uuid of PG> .  Grant Read and Write for your "group" and/or "user" to allow them to view configurations and added components (processors, controller services, child PGs, etc...) within this PG /data/process-groups/<uuid of PG> Granting Read and Write for your "group" and/or "user" to allow user to view and delete content (flowfiles) queued within connection within this PG. Keep in mind that child PGs will inherit the access granted to the parent PG unless explicit policies have been set on the child PG. Hope this helps, Matt ... View more

English Translation: Question:  How to transform a JSON into multiple flow files? Ex: how to generate through this Json below and generate 4 flow files? [ { "ID_WA_REcipient" : "5599999999999", "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.", "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcv" }, { "ID_WA_REcipient" : "5599999999999", "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.", "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvb" }, { "ID_WA_REcipient" : "5599999999999", "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.", "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvc" }, { "ID_WA_REcipient" : "5599999999999", "DES_MENS_NMO" : "You are receiving the 1st copy of your invoice.", "COD_IDEN_MENS_ENV_NMO" : "xptoqwerzxcvd" }]   Solution You will use the SplitJson processor and in the property "JsonPath Expression" you will put "$" (without quotes). ... View more