Skip to end of metadataGo to start of metadata

1. Dbeaver Hive Keytab
2. Dbeaver Hive Jdbc
3. Dbeaver Hive Zookeeper
4. Dbeaver Hive Ssl

The current JDBC interface for Hive only supports running queries and fetching results. Only a small subset of the metadata calls are supported.

Dbeaver Hive Keytab

To see how the JDBC interface can be used, see sample code.

DBeaver连接Hive 一、配置hiveserver2的用户名和密码. DBeaver is certainly an ultimate Universal client which incorporates RDBMS and NoSQL Databases. The GUI is very useful and easy to manipulate all kind of DB queries.DBeaver is remarkably fast and stable. It loads quickly and responds instantaneously. Especially, It is the only client tool for Apache Cassandra NoSQL Database in market.

Integration with Pentaho

1. Download pentaho report designer from the pentaho website.

2. Overwrite report-designer.sh with the code provided below. Slack canada.

3. Build and start the hive server with instructions from HiveServer.
4. Compile and run the Hive JDBC client code to load some data (I haven't figured out how to do this in report designer yet). See sample code for loading the data.

5. Run the report designer (note step 2).

6. Select 'Report Design Wizard'.
7. Select a template - say 'fall template' - next.
8. Create a new data source - JDBC (custom), Generic database.

9. Provide Hive JDBC parameters. Give the connection a name 'hive'.

10. Click on 'Test'. The test should succeed.
11. Edit the query: select 'Sample Query', click edit query, click on the connection 'hive'. Create a new query. Write a query on the table testHiveDriverTable, for example, select * from testHiveDriverTable. Click next.
12. Layout Step: Add PageOfPages to Group Items By. Add key and value as Selected Items. Click next. And Finish.
13. Change the Report header to 'hive-pentaho-report'. Change the type of the header to 'html'.
14. Run the report and generate pdf. You should get something like the report attached here.

Integration with SQuirrel SQL Client

1. Download, install and start the SQuirrel SQL Client from the SQuirrel SQL website.
2. Select 'Drivers -> New Driver..' to register the Hive JDBC driver.

   1. Enter the driver name and example URL: Fl studio 9 freehome.

3. Select 'Extra Class Path -> Add' to add the following jars from your local Hive and Hadoop distribution.

4. Select 'List Drivers'. This will cause SQuirrel to parse your jars for JDBC drivers and might take a few seconds. From the 'Class Name' input box select the Hive driver:

5. Click 'OK' to complete the driver registration.
6. Select 'Aliases -> Add Alias..' to create a connection alias to your Hive server.
   1. Give the connection alias a name in the 'Name' input box.
   2. Select the Hive driver from the 'Driver' drop-down.
   3. Modify the example URL as needed to point to your Hive server.
   4. Leave 'User Name' and 'Password' blank and click 'OK' to save the connection alias.
7. To connect to the Hive server, double-click the Hive alias and click 'Connect'.

When the connection is established you will see errors in the log console and might get a warning that the driver is not JDBC 3.0 compatible. These alerts are due to yet-to-be-implemented parts of the JDBC metadata API and can safely be ignored. To test the connection enter SHOW TABLES in the console and click the run icon.

Also note that when a query is running, support for the 'Cancel' button is not yet available.

Tested and verified for MS Windows, Linux and Mac OS X.

Install:

Windows installer – run installer executable. It will automatically upgrade version (if needed).
MacOS DMG – just run it and drag-n-drop DBeaver into Applications.
Debian package – run sudo dpkg -i dbeaver-<version>.deb. Then execute “dbeaver &”.
RPM package – run sudo rpm -ivh dbeaver-<version>.rpm. Then execute “dbeaver &”. Note: to upgrade use “-Uvh” parameter.
ZIP archive – extract archive and run “dbeaver” executable. Do not extract archive over previous version (remove previous version before install).

Upgrade – don’t be afraid to remove previous DBeaver version – your settings won’t be lost. All settings are kept in the separate folder (DBeaverData in user home)

Java notes:
DBeaver requires Java 11 or higher. Since version 7.3.1 all distributions include OpenJDK 11 bundle.
If you want to use you own locally installed Java you may delete folder “jre” in the DBeaver installation folder.

Dbeaver Hive Jdbc

Debian repository:

Dbeaver Hive Zookeeper

Ubuntu PPA:
You can use PPA repository to easily install/upgrade DBeaver on Debian Linuxes. Mostly it is the same as regular Debian repo but it is hosted on Launchpad.

Early Access:

You may get latest build (EA version) of DBeaver. Usually it contains all major bug fixes found in current stable version. Just choose the archive corresponding to your OS and hardware from the following folder: EA version downloads.

Source code:

Archive:

All recent DBeaver versions are available in the archive.

CloudBeaver

Dbeaver Hive Ssl

DBeaver is desktop application.
If you are looking for a web-based database management system – please check another of our products: CloudBeaver.

It is also open-source and free.