The prefetch (fetch value) option of jdbc can improve your perfomance a lot. You can add this options as dynamic option in the connection pool. My performance improves with a factor 20 when I raised it to 2000. JDBC uses a default value 10 when you don't specify a value. ... View more

The workaround described in this article works: https://community.hortonworks.com/content/supportkb/158121/errorcannot-create-poolableconnectionfactory-row-s.html ... View more

For connecting Nifi with Hive and Cloudera and Kerberos you can use JDBC. Configure a DBCPConnectionPool as follows: Database Connection URL: <host>:10000;AuthMech=1;KrbRealm=<kerberos realm>;KrbHostFQDN=_HOST;KrbServiceName=hive Database Driver Class Name: com.cloudera.hive.jdbc41.HS2Driver Database Driver Location: Location Cloudera JDBC jar files After that you can use PutSQL, GetSQL en ConvertJSONtoSQL Add comment Share ... View more