@amey84   Yes.  Although yum install still provides the bundled postgres, you can choose to install it or another database separately.  During ambari-server setup you choose Y here:   Enter advanced database configuration [y/n] (n)? y   The following links will be helpful here for more info about ambari + postgres:   https://docs.cloudera.com/HDPDocuments/Ambari-2.6.1.5/bk_ambari-administration/content/using_ambari_with_postgresql.html   If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.   Thanks, Steven ... View more

@Kaur   it appears like your nifi node does not have enough system ram to allow you to use 2g and 4g settings.   I suggest increasing the node specification to at least 8gb or 16 gb of system ram and test boostrap config with 2g 4g or 4g 8g respectively.    If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.   Thanks, Steven ... View more

Great article! Is Registry also keeping track of the user that committed the changes? If yes, does this also work in the case that NiFi is configured to use OIDC instead of client certificates? (i.e. different usernames in NiFi than in Registry) ... View more

The solution you are looking for is:  ReplaceText:   https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.12.0/org.apache.nifi.processors.standard.ReplaceText/   You can find loads of examples here in the forum with this search:   https://community.cloudera.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&q=replaceText     If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.   Thanks, Steven ... View more

From what I've investigated, it may be due to the version of the mysql-connector-java. The class com.mysql.jdbc.jdbc2.optional.MysqlDataSource is present in version 5 and the one that I have installed is the 8. I tried installing explicitly the version 5 but I got different errors. What I've done and got it working is changing that class to the one available in version 8, which is com.mysql.cj.jdbc.MysqlXADataSource.   For Schema Registry you have to modify 2 files: /var/lib/ambari-server/resources/mpacks/hdf-ambari-mpack-3.4.1.1-4/common-services/REGISTRY/0.3.0/package/scripts/params.py /var/lib/ambari-agent/cache/common-services/REGISTRY/0.3.0/package/scripts/params.py There change the variable registry_storage_java_class to the value com.mysql.cj.jdbc.MysqlXADataSource Note: the variable should appear twice.   The same for Streaming Analytics, you have to modify 2 files. This time: /var/lib/ambari-server/resources/mpacks/hdf-ambari-mpack-3.4.1.1-4/common-services/STREAMLINE/0.5.0/package/scripts/params.py /var/lib/ambari-agent/cache/common-services/STREAMLINE/0.5.0/package/scripts/params.py There change the variable streamline_storage_java_class also to the value com.mysql.cj.jdbc.MysqlXADataSource   You should then be able to start the services. I just solved this, so I'm not aware if any other errors will show up by using these services. ... View more

Hi steven. Thanks for the quick response. I'm running this HDP cluster in SUSE 12 SP2.  This node has 32 GB RAM and using just 4.  Free RAM is 27 GB. Yarn Configuration is like this: ResourceManager Java heap size = 2048 NodeManager Java heap size = 1024 AppTimelineServer Java heap size = 8072   ulimit used by RM process is: core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 128615 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 32768 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 65536 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited --- From RM log file: 2020-09-29 17:15:00,825 INFO scheduler.AbstractYarnScheduler (AbstractYarnScheduler.java:getMinimumAllocation(1367)) - Minimum allocation = <memory:1024, vCores:1> 2020-09-29 17:15:00,825 INFO scheduler.AbstractYarnScheduler (AbstractYarnScheduler.java:getMaximumAllocation(1379)) - Maximum allocation = <memory:24576, vCores:3   No matter how much memory is assigned to RM, it always fails with this Jana OoM. What may be a recommended Java Memory configuration for Yarn components?        ... View more

@aniket5003 NiFi can be added to ambari using one of the HDF Management packs.  Depending on your relationship with Cloudera, you may need to use your account to get after the NiFi 1.12.1 management pack.  I do know other versions are out on the open internet (1.9 and below), but newest versions will require a cloudera username and password to access repos and artifacts.   Once you have a management pack added to ambari,  you should be able to install nifi and other HDF components in an HDP cluster.   Additionally you can get 1.12.1 from nifi.apache.org and install outside of ambari interface if you need something quick.   If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.   Thanks, Steven ... View more

@Elf  IMO anything is possible with ambari.  That said, out of the box, maybe it would not appear to be possible without some advanced ambari admin skills.      I took a look at the link you provided and that is an example of how to spin up a single machine with many of the services you may already have in your ambari cluster.     To install griffin in an ambari cluster you would need to pick a node, install griffin, missing requirements (services/components not in your cluster), and thoughtfully modify the configuration to use the existing services from the ambari cluster.  For example,  feed griffin you configuration locations for hadoop, hdfs, hive, etc and NOT use the specific directions to install those parts based on sample documentation.   If you do decide to go down this path, please update here with your progress or create new Questions with specific errors you may have.   ... View more

@ujay Of course.   The link referenced xml is a template file.  Click through and get the raw xml code and save to a file.  From here you import the template:   Then in the upper navigation grab the template icon and drag to the nifi canvas:       It should automatically choose the last template uploaded:   Once the template is on the canvas click through into the process group created:   You will need to do some work in Controller Services so check out the notes in the Red Box.  The flow is an example of how to generate many flow files and detect duplicates.  Be sure to do some research on the processor (google search) to understand how others have resolved working with the processor as your begin to integrate this into your own flow.    This community is also a great research tool too:     ... View more

@praneet Adding the value to the processor (+) is a suitable method.  You just need to make sure you get the right string in that field.  It's blocked out, but appears not just the actual token but prepended with "Bearer".  Try just the token string.   One thing I like to do for any API, before I start to work on invokeHttp configuration, is to use Postman to help me identify all of the required settings to test connection to an API.  Once this is complete, I can definitively ensure that nifi invokeHttp is sending the same request.     If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.     Thanks, Steven ... View more

@Manoj90 In addition o @PVVK point, you need to be careful with routing relationships back on the originating processor.  During development I like to use a output port that I call End of Line or EOL1, EOL2, EOL3 as I need more in larger flows.   This is to evaluate if something goes to fail, retry, etc.  Later once I am certain the flow is working as I need, I either auto terminate these routes, or I route them out of my processor group to an Event Notification system.     It looks like this:   Using an output port to hold un needed routes during testing     If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.     Thanks, Steven ... View more

@mansu You need to make sure the file and locations have the correct permissions for the nifi user.  For example in linux:   chown -R nifi:nifi /path/to/files     If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.     Thanks, Steven ... View more

@vikrant_kumar24    Based on what you describe you are either exceeding the capabilities of the outbound network connection from nifi, or the receiving end API.  I suspect the latter but its hard to tell without seeing the number of nodes and processor scheduling settings. You can try to slow down the execution of invokeHttp to confirm.  If it is set to 0 sec it can create a lot of connections to the endpoint.  Try 5,10,15 seconds and re-evaluate.    Also If you have more than 1 one nifi node, it can create a great deal of concurrent connections.        If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.     Thanks, Steven ... View more

@surajnag This is a great question.  Here are some of my ideas which I have used in development and production nifi flows.   During development route all flow exceptions to an output port.  I call these EOL, or End of Line and increment them with #s, like EOL1, EOL2, EOL3.  I use these to hold failure, retry, original, no-retry, etc type outbound connections during testing.  As I move to production, some of these may be auto terminated, and some may remain. In production, I route ALL major points of failure which are not auto terminated to an output port called ERROR.  In my flows I sometimes have multiple ERROR output ports for difference purposes.   Depending on the use case, the error is sent to some type of event notification.  For Example:  send an email, or post to a slack channel.  In other cases these are routed to a process group that is in a stopped/disabled state.  Based on the error, I may make some change in the flow, and then enable/start the flow to create a method to REPLAY that flowfile. In reference to successful end of flow, I may just auto terminate, as I want to assume the flow is always on, and everything has succeeded if it is not routed as above in #1 or #2.  In other cases the bottom or end of the flow is also routed to some type of Event Notification.  However, be careful here, as you could create tons of notifications depending on your flow. I hope some of these ideas are helpful.     If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.     Thanks, Steven ... View more

Hi Steven, I am able to upload file to /user/hive/warehouse/ods.db/hive_test/ or /user/hive/warehouse/ods.db/hive_test but Hue still unable to import the data. The same syntax was successfully run on linux prompt, so I really confuse why it doesn't work from Hue.   regards, wenfeng ... View more

@alex15   I suspect the issue you have is that nifi use is not able to execute the script. Make sure the user ownership of the file is correct, also confirm read/write permissions.  In unix/linux these are chown and chmod.        If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.     Thanks, Steven ... View more

@stevenmatison  can you explain about how to add a driver in sqoop command, please  ... View more

@lukolas The example you provide sees to be REGEX not expression language.  You would need to test some kind of expression language in that Topic Name(s) property.   Another suggestion would be to have a file, or for example generateflowfile, which contains a list of topics.  Then split/extract that list into attributes, then send that attribute to the topic name.     Having a ton of topics going to single processors can become a bottleneck which creates tons of downstream flowfiles from each topic.  So be careful with tuning and concurrency in reference to number and topics and messages per topic.   If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.     Thanks, Steven @ DFHZ ... View more