Enum CalciteConnectionProperty

All Implemented Interfaces:
Serializable, Comparable<CalciteConnectionProperty>, Constable, org.apache.calcite.avatica.ConnectionProperty

public enum CalciteConnectionProperty extends Enum<CalciteConnectionProperty> implements org.apache.calcite.avatica.ConnectionProperty
Properties that may be specified on the JDBC connect string.
  • Enum Constant Details


      public static final CalciteConnectionProperty APPROXIMATE_DISTINCT_COUNT
      Whether approximate results from COUNT(DISTINCT ...) aggregate functions are acceptable.

      public static final CalciteConnectionProperty APPROXIMATE_TOP_N
      Whether approximate results from "Top N" queries (ORDER BY aggFun DESC LIMIT n) are acceptable.

      public static final CalciteConnectionProperty APPROXIMATE_DECIMAL
      Whether approximate results from aggregate functions on DECIMAL types are acceptable.

      public static final CalciteConnectionProperty NULL_EQUAL_TO_EMPTY
      Whether to treat empty strings as null for Druid Adapter.

      public static final CalciteConnectionProperty AUTO_TEMP
      Whether to store query results in temporary tables.

      public static final CalciteConnectionProperty MATERIALIZATIONS_ENABLED
      Whether Calcite should use materializations.

      public static final CalciteConnectionProperty CREATE_MATERIALIZATIONS
      Whether Calcite should create materializations.

      public static final CalciteConnectionProperty DEFAULT_NULL_COLLATION
      How NULL values should be sorted if neither NULLS FIRST nor NULLS LAST are specified. The default, HIGH, sorts NULL values the same as Oracle.

      public static final CalciteConnectionProperty DRUID_FETCH
      How many rows the Druid adapter should fetch at a time when executing "select" queries.
    • MODEL

      public static final CalciteConnectionProperty MODEL
      URI of the model.
    • LEX

      public static final CalciteConnectionProperty LEX
      Lexical policy.
    • FUN

      public static final CalciteConnectionProperty FUN
      Collection of built-in functions and operators. Valid values include "standard", "bigquery", "mysql", "oracle", "postgresql" and "spatial", and also comma-separated lists, for example "oracle,spatial".

      public static final CalciteConnectionProperty QUOTING
      How identifiers are quoted. If not specified, value from LEX is used.

      public static final CalciteConnectionProperty QUOTED_CASING
      How identifiers are stored if they are quoted. If not specified, value from LEX is used.

      public static final CalciteConnectionProperty UNQUOTED_CASING
      How identifiers are stored if they are not quoted. If not specified, value from LEX is used.

      public static final CalciteConnectionProperty CASE_SENSITIVE
      Whether identifiers are matched case-sensitively. If not specified, value from LEX is used.

      public static final CalciteConnectionProperty PARSER_FACTORY
      Parser factory.

      The name of a class that implements SqlParserImplFactory.


      public static final CalciteConnectionProperty META_TABLE_FACTORY
      MetaTableFactory plugin.

      public static final CalciteConnectionProperty META_COLUMN_FACTORY
      MetaColumnFactory plugin.
    • SCHEMA

      public static final CalciteConnectionProperty SCHEMA
      Name of initial schema.

      public static final CalciteConnectionProperty SCHEMA_FACTORY
      Schema factory.

      The name of a class that implements SchemaFactory.

      Ignored if MODEL is specified.


      public static final CalciteConnectionProperty SCHEMA_TYPE
      Schema type.

      Value may be null, "MAP", "JDBC", or "CUSTOM" (implicit if SCHEMA_FACTORY is specified).

      Ignored if MODEL is specified.

    • SPARK

      public static final CalciteConnectionProperty SPARK
      Specifies whether Spark should be used as the engine for processing that cannot be pushed to the source system. If false (the default), Calcite generates code that implements the Enumerable interface.

      public static final CalciteConnectionProperty TIME_ZONE
      Returns the time zone from the connect string, for example 'gmt-3'. If the time zone is not set then the JVM time zone is returned. Never null.
    • LOCALE

      public static final CalciteConnectionProperty LOCALE
      Returns the locale from the connect string. If the locale is not set, returns the root locale. Never null. Examples of valid locales: 'en', 'en_US', 'de_DE', '_GB', 'en_US_WIN', 'de__POSIX', 'fr__MAC', ''.

      public static final CalciteConnectionProperty FORCE_DECORRELATE
      If the planner should try de-correlating as much as it is possible. If true (the default), Calcite de-correlates the plan.

      public static final CalciteConnectionProperty TYPE_SYSTEM
      Type system. The name of a class that implements RelDataTypeSystem and has a public default constructor or an INSTANCE constant.

      public static final CalciteConnectionProperty CONFORMANCE
      SQL conformance level.

      Controls the semantics of ISO standard SQL features that are implemented in non-standard ways in some other systems.

      For example, the SUBSTRING(string FROM start [FOR length]) operator treats negative start values as 1, but BigQuery's implementation regards negative starts as counting from the end. If conformance=BIG_QUERY we will use BigQuery's behavior.

      This property only affects ISO standard SQL features. For example, the SUBSTR function is non-standard, so is controlled by the fun property. If you set fun=oracle you will get SUBSTR with Oracle's semantics; if you set fun=postgres you will get SUBSTR with PostgreSQL's (slightly different) semantics.


      public static final CalciteConnectionProperty TYPE_COERCION
      Whether to make implicit type coercion when type mismatch for validation, default true.

      public static final CalciteConnectionProperty LENIENT_OPERATOR_LOOKUP
      Whether to make create implicit functions if functions do not exist in the operator table, default false.

      public static final CalciteConnectionProperty TOPDOWN_OPT
      Whether to enable top-down optimization in Volcano planner.
  • Field Details

  • Method Details

    • values

      public static CalciteConnectionProperty[] values()
      Returns an array containing the constants of this enum type, in the order they are declared.
      an array containing the constants of this enum type, in the order they are declared
    • valueOf

      public static CalciteConnectionProperty 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.)
      name - the name of the enum constant to be returned.
      the enum constant with the specified name
      IllegalArgumentException - if this enum type has no constant with the specified name
      NullPointerException - if the argument is null
    • camelName

      public String camelName()
      Specified by:
      camelName in interface org.apache.calcite.avatica.ConnectionProperty
    • defaultValue

      public @Nullable Object defaultValue()
      Specified by:
      defaultValue in interface org.apache.calcite.avatica.ConnectionProperty
    • type

      public org.apache.calcite.avatica.ConnectionProperty.Type type()
      Specified by:
      type in interface org.apache.calcite.avatica.ConnectionProperty
    • valueClass

      public @Nullable Class valueClass()
      Specified by:
      valueClass in interface org.apache.calcite.avatica.ConnectionProperty
    • required

      public boolean required()
      Specified by:
      required in interface org.apache.calcite.avatica.ConnectionProperty
    • wrap

      public org.apache.calcite.avatica.ConnectionConfigImpl.PropEnv wrap(Properties properties)
      Specified by:
      wrap in interface org.apache.calcite.avatica.ConnectionProperty