Support Questions

Find answers, ask questions, and share your expertise
Announcements
Now Live: Explore expert insights and technical deep dives on the new Cloudera Community BlogsRead the Announcement

Hue Creates Many Connections to PostgreSQL

avatar
New Member

Hi,

I'm using Hue editor to send queries to PostgreSQL  database.
I have configured interpreter in the following way:

[notebook]

    [[interpreters]]

    [[[postgresql-7af1c4ea51]]]

      name=devops-notification

      interface=sqlalchemy

      options='{"url": "postgresql://${USER}:${PASSWORD}@dbname.eu-central-1.rds.amazonaws.com:5432/notification"}'

It works fine.  But every time I send a quiery, new connection to PostgreSQL instance is established. 
Is there a way to use single database connection per user or just close connections right it returned a result?

 

Thanks  in advance. 
Andrii

1 REPLY 1

avatar
Master Guru

@Andrii I doubt if it's possible. Check the document if this helps:

 

https://docs.gethue.com/administrator/configuration/apps/#jdbc


Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.