For work, I use Datagrip since the license is provided. ![]() SQL development tools like DbVisualizer, SQuirreL SQL and DataGrip are popular options for database development. Personally, I mostly use PostgreSQL in my personal projects so this is just perfect and so much better than pgAdmin. Although these tools don't offer native Hive support they can be easily configured to connect to Hive using JDBC. This article, in combination with a project I created ( While connecting these tools to clusters without kerberos is relatively straightforward, the process of connecting them to kerberized clusters can be complex and error prone. Hive JDBC Uber Jar), aim to simplify and standardize this process. WHAT IS DBVISUALIZER USED FOR FULLĪ full description of these tasks is out of scope for this article, but at a high level, make sure that: There are a few key things that must be properly configured before attempting to connect to a kerberized cluster. Kinit with an appropriate principal and launch DbVisualizer You can successfully kinit from your workstation against the realm specified in your nf file.You have a valid kerberos principal that can access the appropriate services your cluster.The nf file on your workstation matches the one on your cluster.DbVisualizer and/or DataGrip have been successfully installed on your workstation.You have downloaded the latest release of my Hive JDBC Uber Jar and placed it somewhere sensible. Open DbVisualizer preferences ("DbVisualizer" > "Preferences") and add the following properties. DbVisualizer will need to be restarted after applying these changes. For the "Driver File Paths" you are pointing to the Open the Diver Manager dialog ("Tools" > "Driver Manager.") and hit the "Create a new driver" icon.įill in the information as seen below. Hive-jdbc-uber-x.jar that you just downloaded.Ĭreate a new connection ("Database" > "Create Database Connection") and fill out the details based on your cluster as seen below. Please note that you must append the "principal" to the "database" parameter for kerberized connections. Hit the "Connect" button to test the connection.You should see something like the following in the "Connection Message" text area if the connection is successful. It is the universal database tool for developers, DBAs and analysts. On the other hand, DbVisualizer is detailed as ' Database tool for developers, DBAs and analysts '. A cross-platform IDE that is aimed at DBAs and developers working with SQL databases. ![]() You are now ready to execute your first query against Hive using DbVisualizer!. Developers describe DataGrip as ' A database IDE for professional SQL developers '.Kinit with an appropriate principal and launch DataGrip Under "File" > "Data Sources.", create a new Driver. Make sure you load the hive-jdbc-uber-x.jar that you just downloaded.Ĭreate a new "Project Data Source" using the new Driver. Then add the following flags to "VM Options" on the "Advanced" tab. After creating the "Project Data Source", test the connection.You are now ready to execute your first query against Hive using DataGrip!.This extends the product support to cover the full license period and also includes the following. You can extend and enhance your support by adding Premium support to your license. It's just that a paid app like DataGrip just does everything better. DbVisualizer Pro comes bundled free of charge with our Basic support, which entitles you to email support for the first 60 days after license issue. You can get your feet wet and manage multiple different RDBMS' at once without much trouble. The "Database" tab actually identified several object types that DBeaver simply didn't such as warehouses, roles, and functionsĭBeaver is great for what it is. ![]() (Snowflake Specific) Better Database support - DataGrip for Snowflake has much better language and object support. Also, pushing and pulling via DG is far nicerīetter UI - Datagrip might be heavier on resources (RAM), but it's a much better experience for me as someone who comes from the Microsoft stack (where I use SSMS, VS/VSCode) with customization and overall look-and-feelīetter project support - This one isn't really much of a difference, but I like the way that DG handles project switching over DBeaver Here's a short list of reasons I switched (in no particular order)īetter GIT integration - Every time I update DBeaver, I have to reinstall my extensions. At that point I REALLY noticed the differences. Once I found out the DataGrip had support for it, I gave it a shot. Reverse engineering / Data Model visualization. Ability to export / import data to multiple formats. Create, alter or drop objects on any data source. I had a handful of reasons, but the primary reason why I used DBeaver to begin with was Snowflake support. Ability to connect to MANY different database engines on a single IDE.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |