I'm using HDP 2.4. I try to convert json into sql format for this I use "ConvertJSONToSQL processor" but I got driver issue!, can anyone help me to resolve this issue
ConvertJSONToSQL processor properties
NiFi doesn't come with a PostgreSQL driver, you will need to get one and point to its location in the "Database Driver Jar Url" property in the DBCPConnectionPool configuration dialog above. If you already have one and have placed it in NiFi's lib/ directory, this can cause problems and is not recommended. Best practice is to put JDBC drivers in a separate location and refer to that location in the "Database Driver Jar Url" property.
Yes, I create a separate directory in local and import PostgreSQL driver jar into it. After that I point to its location into "Database Driver Jar URL" property, but still I got issue that I mention below.