SQL File Won't connect to Generic Data Source
I cannot connect a SQL File to the console for Hive DB connection. The only difference I can tell between the Hive DB Console and my PostGre DB Console is the Hive DB console is based on a Generic JDBC connection.
This is very frustrating as I use the SQL Files to keep my queries organized (and read them for non-datagrip use cases).
The console files have to live in some deep DataGrip owned directory so it's no good for keeping queries organized and accessible.
What am I doing wrong that I cannot select the "ThriftServer" DataSource as the console to connect to from my SQL file?
The attached screen shot should display the "ThriftServer" as a valid data source in my Database explore window, but it is missing as an option in the "Choose Console" window from the SQL File.
Thanks!
Please sign in to leave a comment.
Hi,
What DataGrip version do you use? Try to use latest DataGrip 2017.2 EAP or DataGrip 2017.1.4 where "Attach Console" action could be found more intuitive.
As a workaround, you can change attached file dialect to generic or invoke Execute action from File tree.
Thank you.
I'm using : DataGrip 2017.1.4 - Build #DB-171.4694.3, built on May 16, 2017
So I actually had the "dialect" for Hive connection as PostGre. I changed it MySQL and now the Hive console pops up.
So the dialect of the SQL File dictates which Consoles you can connect to? Good to know, Thanks!!
Would love if you add support for Hive-QL