Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

NiFi -- Help

Highlighted

NiFi -- Help

Explorer

Can anyone help in solving the following error

I am trying to import data from mysql to hive

help-1.pdf

3 REPLIES 3
Highlighted

Re: NiFi -- Help

Super Guru

Can you share your configuration of QueryDatabaseTable and its DBCP Controller Service? Also you should be able to find more information about those bulletins/errors in logs/nifi-app.log, please paste in the relevant stack trace as it will help determine the issue you're having.

Re: NiFi -- Help

Explorer
Highlighted

Re: NiFi -- Help

Hey @Nikhil Vemula!
I'm not sure about your error, but are you able to connect to the mysql from your Nifi host?

telnet <mysql> port

And could you share your configs from querydatabse processor and see if there's more detail on nifi's log.
PS: Did you set any DBCPConnectionPool at the controller service?

Hope this helps!

Don't have an account?
Coming from Hortonworks? Activate your account here