nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Burgess <>
Subject Re: SelectHiveQL HiveConnectionPool issues
Date Mon, 09 May 2016 16:09:58 GMT
Your URL has a scheme of "mysql", try replacing with "hive2", and also
maybe explicitly setting the port:


If that doesn't work, can you see if there is an error/stack trace in


On Mon, May 9, 2016 at 12:04 PM, Mike Harding <> wrote:
> Hi All,
> I'm trying to test out the new SelectHiveQL processor but I'm struggling to
> get the HiveConnectionPool configured correctly as I keep getting 'error
> getting hive connection'.
> I'm setting the database URL to my db 'default' as
> jdbc:mysql://<hostname_of_node_with_hiveserver2>/default
> Nifi is installed on a different node in my cluster so I have set the
> hive-site.xml to point to /etc/spark/
> I currently have Hive Authorization = None and HIveServer2 authentication =
> none but I still specify a user name used to create the db without a
> password.
> Would appreciate it if someone could share how they have things configured.
> Thanks,
> Mike

View raw message