@vikrant_kumar24    There are many ways to do this.   I have added a template to my NiFI templates for you.  This way takes a csv Input, splits the lines, extracts two columns, builds an insert statement, and executes that statement (requires database connection pool controller service).   The only real tricky part to this is the regex for mapping the columns in ExtractText Processor.   https://github.com/steven-dfheinz/NiFi-Templates   Once you are able to parse the csv to attributes, adding more attributes for metadata, and adding those details to the insert query should be very easy.    Hope this helps get you started.   Additionally, if you search here, you will find loads of posts with all the other suggested methods for processing csv to sql. ... View more

@Peruvian81 I would delete only enough to get nifi re-started.  Then I would want to go into the flow and look at what has caused it to fill up.   This is of course assuming you have enough space in the drive to begin with.   Next, I would recommend you should address nifi documented steps for disk configuration, and based on your flow, expand the content repository if necessary and if possible.       Last thing to consider:  your flow may just need to terminate large flow files when they are completed at the end of the line.  If these are held in Q, and no longer needed, they are taking up valuable space. ... View more

@AarifAkhter    You need to create permissions within mysql for your ranger user.   An example of this is:   CREATE DATABASE ranger; CREATE USER 'ranger'@'hdp.cloudera.com' IDENTIFIED BY 'ranger'; GRANT ALL PRIVILEGES ON *.* TO 'ranger'@'hdp.cloudera.com' WITH GRANT OPTION; FLUSH PRIVILEGES; where you replace in your hostname for ranger in place of hdp.cloudera.com above:   ip-xxx-xx-xx-xx.ec2.internal   I would also recommend to install using FQDNs (Fully Qualified Domain Names).     Please accept this answer as the solution to close the topic.  ... View more

I would highly recommend to not use special characters in columns names.  Per documentation hive .13 (link) `column?name` should work with Hive,  however, there is no gauruntee that other clients, including SQL Workbench will allow this when the special character can be considered a code like character ($ % & ? " , . etc)     ... View more