Dbeaver Hive

Posted : admin On 1/29/2022

You can find installation instructions here

DBeaver与HIVE工欲善其事必先利其器安装DBeaver准备工作还没结束-改配置HIVEHadoop连接HIVE工欲善其事必先利其器你好! 这是你第一次使用 Markdown编辑器 所展示的欢迎页。如果你想学习如何使用Markdown编辑器, 可以仔细阅读这篇文章,了解一下Markdown的基本语法知识。.

You can find the latest drivers on the Cloudera website

  1. Bellow are the steps you can use to connect your DBeaver client to a remote database server via SSH. Note that you only need to do these steps once. The connection configurations will be saved and you can re-use them by right-click + connect. This guide is created using DBeaver version 6.3. Method 1: DBeaver via SSH with plain password 1.
  2. Nov 04, 2020 The table in the hive is consists of multiple columns and records. The table we create in any database will be stored in the sub-directory of that database. The default location where the database is stored on HDFS is /user/hive/warehouse. The way of creating tables in the hive is very much similar to the way we create tables in SQL.
  3. Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.

mkdir ~/.dbeaver-drivers/cloudera-hive/

  1. Navigate to Database > Driver Manager > New
  2. Add all the files from ~/.dbeaver-drivers/cloudera-hive/
  3. Driver name: Hive-Cloudera (for labeling only)
  4. Class name: com.cloudera.hive.jdbc41.HS2Driver (at the time of this writing)
  5. Default port: 10000
  6. URL template: jdbc:hive2://{host}:{port}/{database};AuthMech=1;KrbRealm=FOO.BAR;KrbHostFQDN={server}; KrbServiceName=hive;KrbAuthType=2
    • Note you need to change FOO.BAR to match your krb5.conf settings
  1. In the menu bar Navigate to Database > New Connection
  2. Select Hive-Cloudera
  3. Fill in the appropriate values for host & database (I set database to default)
  4. Set server to be your KrbHostFQDN
  5. Leave your user name & password blank
  6. Test connection
  7. Press next, next, & change the name of this connection as you see fit
  8. Press finish
Hive

Congrats you’ve successfully connected to hive using kerberos authentication!

Dbeaver Hive Learning

If you are receiving [Cloudera][HiveJDBCDriver](500168) Error creating login context using ticket cache: Unable to obtain Principal Name for authentication make sure to check the following

  1. Ensure that you have the latest cryptography libraries installed
    • Java 9 includes these libraries by default
  2. That you’ve configured your /etc/krb5.conf successfully
    • If you’ve done this correctly you should be able to run kinit in terminal and create a ticket without issue
  3. For Windows adding the following lines to your dbeaver.ini may be necessary as well

    • -Djava.security.krb5.conf=c:kerberoskrb5.ini
      • note: this is the windows equivalent of /etc/krb5.conf
    • -Djava.security.auth.login.config=c:kerberosjaas.conf

      • success has also been reported with the following jaas.conf file & keytab usage

Dbeaver Hive Log

  • Dark theme support was improved (Windows 10 and GTk)
  • Data viewer:
    • Copy As: format configuration editor was added
    • Extra configuration for filter dialog (performance)
    • Sort by column as fixed (for small fetch sizes)
    • Case-insensitive filters support was added
    • Plaintext view now support top/bottom dividers
    • Data editor was fixed (when column name conflicts with alias name)
    • Duplicate row(s) command was fixed for multiple selected rows
    • Edit sub-menu was returned to the context menu
    • Columns auto-size configuration was added
    • Dictionary viewer was fixed (for read-only connections)
    • Current/selected row highlighting support was added (configurable)
  • Metadata search now supports search in comments
  • GIS/Spatial:
    • Map position preserve after tiles change
    • Support of geometries with Z and M coordinates was added
    • Postgis: DDL for 3D geometry columns was fixed
    • Presto + MySQL geometry type support was added
    • BigQuery now supports spatial data viewer
    • Binary geo json support was improved
    • Geometry export was fixed (SRID parameter)
    • Tiles definition editor was fixed (multi-line definitions + formatting)
  • SQL editor:
    • Auto-completion for objects names with spaces inside was fixed
    • Database objects hyperlinks rendering was fixed
  • SQL Server: MFA (multi-factor authentication) support was added
  • PostgreSQL: array data types read was fixed
  • Oracle: indexes were added to table DDL
  • Vertica: LIMIT clause support was improved
  • Athena: extra AWS regions added to connection dialog
  • Sybase IQ: server version detection was improved
  • SAP ASE: user function loading was fixed
  • Informix: cross-database metadata read was fixed
  • We migrated to Eclipse 2021-03 platform