Package org.apache.calcite.sql

Enum SqlDialect.DatabaseProduct

java.lang.Object

java.lang.Enum<SqlDialect.DatabaseProduct>

org.apache.calcite.sql.SqlDialect.DatabaseProduct

All Implemented Interfaces:

Serializable, Comparable<SqlDialect.DatabaseProduct>, Constable

Enclosing class:

SqlDialect

public static enum SqlDialect.DatabaseProduct
extends Enum<SqlDialect.DatabaseProduct>

Rough list of flavors of database.

These values cannot help you distinguish between features that exist in different versions or ports of a database, but they are sufficient to drive a switch statement if behavior is broadly different between say, MySQL and Oracle.

If possible, you should not refer to particular database at all; write extend the dialect to describe the particular capability, for example, whether the database allows expressions to appear in the GROUP BY clause.

Nested Class Summary

Nested classes/interfaces inherited from class java.lang.Enum

Enum.EnumDesc<E extends Enum<E>>

Enum Constant Summary

Enum Constants

Enum Constant	Description
ACCESS
BIG_QUERY
CALCITE
CLICKHOUSE
DB2
DERBY
EXASOL
FIREBIRD
FIREBOLT
H2
HIVE
HSQLDB
INFOBRIGHT
INFORMIX
INGRES
INTERBASE
JETHRO
LUCIDDB
MSSQL
MYSQL
NEOVIEW
NETEZZA
ORACLE
PARACCEL	Paraccel, now called Actian Matrix.
PHOENIX
POSTGRESQL
PRESTO
REDSHIFT
SNOWFLAKE
SPARK
SQLSTREAM
STARROCKS
SYBASE
TERADATA
UNKNOWN	Placeholder for the unknown database.
VERTICA

Method Summary

Modifier and Type	Method	Description
SqlDialect	getDialect()	Returns a dummy dialect for this database.
static SqlDialect.DatabaseProduct	valueOf(String name)	Returns the enum constant of this type with the specified name.
static SqlDialect.DatabaseProduct[]	values()	Returns an array containing the constants of this enum type, in the order they are declared.

Methods inherited from class java.lang.Enum

clone, compareTo, describeConstable, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Enum Constant Details

ACCESS

public static final SqlDialect.DatabaseProduct ACCESS

BIG_QUERY

public static final SqlDialect.DatabaseProduct BIG_QUERY

CALCITE

public static final SqlDialect.DatabaseProduct CALCITE

CLICKHOUSE

public static final SqlDialect.DatabaseProduct CLICKHOUSE

MSSQL

public static final SqlDialect.DatabaseProduct MSSQL

MYSQL

public static final SqlDialect.DatabaseProduct MYSQL

ORACLE

public static final SqlDialect.DatabaseProduct ORACLE

DERBY

public static final SqlDialect.DatabaseProduct DERBY

DB2

public static final SqlDialect.DatabaseProduct DB2

EXASOL

public static final SqlDialect.DatabaseProduct EXASOL

FIREBIRD

public static final SqlDialect.DatabaseProduct FIREBIRD

FIREBOLT

public static final SqlDialect.DatabaseProduct FIREBOLT

H2

public static final SqlDialect.DatabaseProduct H2

HIVE

public static final SqlDialect.DatabaseProduct HIVE

INFORMIX

public static final SqlDialect.DatabaseProduct INFORMIX

INGRES

public static final SqlDialect.DatabaseProduct INGRES

JETHRO

public static final SqlDialect.DatabaseProduct JETHRO

LUCIDDB

public static final SqlDialect.DatabaseProduct LUCIDDB

INTERBASE

public static final SqlDialect.DatabaseProduct INTERBASE

PHOENIX

public static final SqlDialect.DatabaseProduct PHOENIX

POSTGRESQL

public static final SqlDialect.DatabaseProduct POSTGRESQL

PRESTO

public static final SqlDialect.DatabaseProduct PRESTO

NETEZZA

public static final SqlDialect.DatabaseProduct NETEZZA

INFOBRIGHT

public static final SqlDialect.DatabaseProduct INFOBRIGHT

NEOVIEW

public static final SqlDialect.DatabaseProduct NEOVIEW

SYBASE

public static final SqlDialect.DatabaseProduct SYBASE

TERADATA

public static final SqlDialect.DatabaseProduct TERADATA

HSQLDB

public static final SqlDialect.DatabaseProduct HSQLDB

VERTICA

public static final SqlDialect.DatabaseProduct VERTICA

SQLSTREAM

public static final SqlDialect.DatabaseProduct SQLSTREAM

SPARK

public static final SqlDialect.DatabaseProduct SPARK

STARROCKS

public static final SqlDialect.DatabaseProduct STARROCKS

PARACCEL

public static final SqlDialect.DatabaseProduct PARACCEL

Paraccel, now called Actian Matrix. Redshift is based on this, so presumably the dialect capabilities are similar.

REDSHIFT

public static final SqlDialect.DatabaseProduct REDSHIFT

SNOWFLAKE

public static final SqlDialect.DatabaseProduct SNOWFLAKE

UNKNOWN

public static final SqlDialect.DatabaseProduct UNKNOWN

Placeholder for the unknown database.

Its dialect is useful for generating generic SQL. If you need to do something database-specific like quoting identifiers, don't rely on this dialect to do what you want.

Method Details

values

public static SqlDialect.DatabaseProduct[] values()

Returns an array containing the constants of this enum type, in the order they are declared.

Returns:

an array containing the constants of this enum type, in the order they are declared

valueOf

public static SqlDialect.DatabaseProduct valueOf(String name)

Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)

Parameters:

name - the name of the enum constant to be returned.

Returns:

the enum constant with the specified name

Throws:

IllegalArgumentException - if this enum type has no constant with the specified name

NullPointerException - if the argument is null

getDialect

public SqlDialect getDialect()

Returns a dummy dialect for this database.

Since databases have many versions and flavors, this dummy dialect is at best an approximation. If you want exact information, better to use a dialect created from an actual connection's metadata (see SqlDialectFactory.create(java.sql.DatabaseMetaData)).

Returns:

Dialect representing lowest-common-denominator behavior for all versions of this database