Dbeaver Presto

Posted on |



Presto ODBC Driver supports open-source Presto Server versions 0.240 and earlier, Teradata Presto Server versions 0.208-t and Presto Foundation server 341 and earlier; Presto JDBC Driver supports open-source Presto Server versions 0.240 and earlier, Teradata Presto Server versions 0.208-t and earlier, and Presto Foundation Server 341 and earlier.

  1. Dbeaver Prestonwood
  2. Dbeaver Prestosql
  3. Dbeaver Preston
  • .SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc. DBeaver Community Edition is free and open source (ASL) product.
  • Sequelize is a promise-based Node.js ORM for Postgres, MySQL, SQLite and Microsoft SQL Server. It features solid transaction support, relations, read replication and more. TiDB (The pronunciation is.

Trino’s open source distributed SQL engine runs fast analyticqueries against various data sources ranging in size from gigabytes topetabytes. Starburst brings that SQL engine to even more data sources,with more robust features. Because Starburst’s SQL is ANSI-compliant andsupports most of the SQL language features you depend on, you can hit the groundrunning.

Business intelligence users and data scientists can continue to use theirfavorite client tools such as Tableau, Qlik and ApacheSuperset to access and analyze virtually any data source, or multiple datasources in a single query.

The basics #

We know you want to jump right in, and we know you already have awesomeanalytics skills. It’s just a matter of harnessing the power ofStarburst products to take your analytics even further. With that inmind, you can browse our latest reference materials to learn just how familiarStarburst SQL is:

Dbeaver Prestonwood

Catalogs #

One key difference worth highlighting is the concept of catalogs. Each of yourdata sources is defined as a catalog in Starburst, and that catalog inturn contains schemas. Using a SQL client such as our CLI, you can discover whatcatalogs are available:

From there, you can use the familiar SHOW SCHEMAS command to drill furtherdown.

Dbeaver

Fully-qualified table names #

Table names are fully qualified when they include the catalog name:

This becomes critical when creating federated queries.

General SQL features #

Just in case you’d like a review, here’s a walkthrough of some basic SQLfeatures in Starburst from one of our founders, David Phillips:

Dbeaver Presto Topics:
  • CASE and searched CASE expressions
  • IF expressions
  • TRY expressions
  • Lambda expressions
Click on the links to read more on that topic in our reference manual.

Running time: ~8 min.

Advanced SQL #

Ready to move past the basics? For your convenience, we’ve divided the AdvancedSQL for Starburst video training course up into topic sections, andprovided links to the relevant parts of our documentation below.

Advanced aggregation techniques #

Dbeaver Prestosql

Topics:
  • count() with DISTINCT
  • Approximations, including counting and percentiles
  • max_by() values
  • Pivoting with count_if() and FILTER
  • Complex aggregations

Running time: ~28 min.

Preston

Window functions #

Topics:
  • Ranking and numbering without ordering
  • Bucketing and percentage ranking
  • Accessing leading and training rows with lead() and lag()
  • Accessing first, last and Nth values
  • ROWS vs RANGE using array_agg()
  • Using aggregations in window functions

Running time: ~25 min.

Array and map functions #

Many data stores allow to to create arrays, but it isn’t always easy.Starburst allows you to easily create arrays and maps with your data.Creating arrays with your data is easy:

SQL array indexes are 1-based. Learn more about how to use and manipulate themin this in-depth video.

Topics:
  • Accessing array and map elements with element_at()
  • Sorting arrays with array_sort()
  • matching elements with any_match(), all_match() and none_match()
  • Filtering elements
  • Transforming elements
  • Converting arrays to strings
  • Computing array products
  • Creating maps from keys and values and an array of entry rows

Running time: ~19 min.

Using JSON #

Topics:
  • The JSON data type
  • Extraction using json_extract() and json_extract_scalar()
  • Formatting as JSON

Running time: ~14 min.

Skip
  • Using SQL in Starburst
    • The basics
    • Advanced SQL

The CData JDBC Driver for Presto implements JDBC standards that enable third-party tools to interoperate, from wizards in IDEs to business intelligence tools. This article shows how to connect to Presto data with wizards in DBeaver and browse data in the DBeaver GUI.

Create a JDBC Data Source for Presto Data

Follow the steps below to load the driver JAR in DBeaver.

  1. Open the DBeaver application and, in the Databases menu, select the Driver Manager option. Click New to open the Create New Driver form.
  2. In the Driver Name box, enter a user-friendly name for the driver.
  3. To add the .jar, click Add File.
  4. In the create new driver dialog that appears, select the cdata.jdbc.presto.jar file, located in the lib subfolder of the installation directory.
  5. Click the Find Class button and select the PrestoDriver class from the results. This will automatically fill the Class Name field at the top of the form. The class name for the driver is cdata.jdbc.presto.PrestoDriver.
  6. Add jdbc:presto: in the URL Template field.

Dbeaver Preston

Create a Connection to Presto Data

Follow the steps below to add credentials and other required connection properties.

  1. In the Databases menu, click New Connection.
  2. In the Create new connection wizard that results, select the driver.
  3. On the next page of the wizard, click the driver properties tab.

  4. Enter values for authentication credentials and other properties required to connect to Presto.

    Set the Server and Port connection properties to connect, in addition to any authentication properties that may be required.

    To enable TLS/SSL, set UseSSL to true.

    Authenticating with LDAP

    In order to authenticate with LDAP, set the following connection properties:

    • AuthScheme: Set this to LDAP.
    • User: The username being authenticated with in LDAP.
    • Password: The password associated with the User you are authenticating against LDAP with.

    Authenticating with Kerberos

    In order to authenticate with KERBEROS, set the following connection properties:

    • AuthScheme: Set this to KERBEROS.
    • KerberosKDC: The Kerberos Key Distribution Center (KDC) service used to authenticate the user.
    • KerberosRealm: The Kerberos Realm used to authenticate the user with.
    • KerberosSPN: The Service Principal Name for the Kerberos Domain Controller.
    • KerberosKeytabFile: The Keytab file containing your pairs of Kerberos principals and encrypted keys.
    • User: The user who is authenticating to Kerberos.
    • Password: The password used to authenticate to Kerberos.

    Built-in Connection String Designer

    For assistance in constructing the JDBC URL, use the connection string designer built into the Presto JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.

    java -jar cdata.jdbc.presto.jar

    Fill in the connection properties and copy the connection string to the clipboard.

    Below is a typical connection string:

    jdbc:presto:Server=127.0.0.1;Port=8080;

Query Presto Data

You can now query information from the tables exposed by the connection: Right-click a Table and then click Edit Table. The data is available on the Data tab.