Package org.apache.calcite.schema

Enum Schema.TableType

java.lang.Object
java.lang.Enum<Schema.TableType>
org.apache.calcite.schema.Schema.TableType
All Implemented Interfaces:
Serializable, Comparable<Schema.TableType>, Constable
Enclosing interface:
Schema
public static enum Schema.TableType extends Enum<Schema.TableType>
Table type.

  • Enum Constant Details

    • TABLE

      public static final Schema.TableType TABLE
      A regular table.

      Used by DB2, MySQL, PostgreSQL and others.

    • VIEW

      public static final Schema.TableType VIEW
      A relation whose contents are calculated by evaluating a SQL expression.

      Used by DB2, PostgreSQL and others.

    • FOREIGN_TABLE

      public static final Schema.TableType FOREIGN_TABLE
      Foreign table.

      Used by PostgreSQL.

    • MATERIALIZED_VIEW

      public static final Schema.TableType MATERIALIZED_VIEW
      Materialized view.

      Used by PostgreSQL.

    • INDEX

      public static final Schema.TableType INDEX
      Index table.

      Used by Apache Phoenix, PostgreSQL.

    • JOIN

      public static final Schema.TableType JOIN
      Join table.

      Used by Apache Phoenix.

    • SEQUENCE

      public static final Schema.TableType SEQUENCE
      Sequence table.

      Used by Apache Phoenix, Oracle, PostgreSQL and others. In Phoenix, must have a single BIGINT column called "$seq".

    • STAR

      public static final Schema.TableType STAR
      A structure, similar to a view, that is the basis for auto-generated materializations. It is either a single table or a collection of tables that are joined via many-to-one relationships from a central hub table. It is not available for queries, but is just used as an intermediate structure during query planning.

    • STREAM

      public static final Schema.TableType STREAM
      Stream.

    • TYPE

      public static final Schema.TableType TYPE
      Type.

      Used by PostgreSQL.

    • SYSTEM_TABLE

      public static final Schema.TableType SYSTEM_TABLE
      A table maintained by the system. Data dictionary tables, such as the "TABLES" and "COLUMNS" table in the "metamodel" schema, examples of system tables.

      Specified by the JDBC standard and used by DB2, MySQL, Oracle, PostgreSQL and others.

    • SYSTEM_VIEW

      public static final Schema.TableType SYSTEM_VIEW
      System view.

      Used by PostgreSQL, MySQL.

    • SYSTEM_INDEX

      public static final Schema.TableType SYSTEM_INDEX
      System index.

      Used by PostgreSQL.

    • SYSTEM_TOAST_INDEX

      public static final Schema.TableType SYSTEM_TOAST_INDEX
      System TOAST index.

      Used by PostgreSQL.

    • SYSTEM_TOAST_TABLE

      public static final Schema.TableType SYSTEM_TOAST_TABLE
      System TOAST table.

      Used by PostgreSQL.

    • TEMPORARY_INDEX

      public static final Schema.TableType TEMPORARY_INDEX
      Temporary index.

      Used by PostgreSQL.

    • TEMPORARY_SEQUENCE

      public static final Schema.TableType TEMPORARY_SEQUENCE
      Temporary sequence.

      Used by PostgreSQL.

    • TEMPORARY_TABLE

      public static final Schema.TableType TEMPORARY_TABLE
      Temporary table.

      Used by PostgreSQL.

    • TEMPORARY_VIEW

      public static final Schema.TableType TEMPORARY_VIEW
      Temporary view.

      Used by PostgreSQL.

    • LOCAL_TEMPORARY

      public static final Schema.TableType LOCAL_TEMPORARY
      A table that is only visible to one connection.

      Specified by the JDBC standard and used by PostgreSQL, MySQL.

    • SYNONYM

      public static final Schema.TableType SYNONYM
      A synonym.

      Used by DB2, Oracle.

    • ALIAS

      public static final Schema.TableType ALIAS
      An alias.

      Specified by the JDBC standard.

    • GLOBAL_TEMPORARY

      public static final Schema.TableType GLOBAL_TEMPORARY
      A global temporary table.

      Specified by the JDBC standard.

    • ACCEL_ONLY_TABLE

      public static final Schema.TableType ACCEL_ONLY_TABLE
      An accel-only table.

      Used by DB2.

    • AUXILIARY_TABLE

      public static final Schema.TableType AUXILIARY_TABLE
      An auxiliary table.

      Used by DB2.

    • GLOBAL_TEMPORARY_TABLE

      public static final Schema.TableType GLOBAL_TEMPORARY_TABLE
      A global temporary table.

      Used by DB2.

    • HIERARCHY_TABLE

      public static final Schema.TableType HIERARCHY_TABLE
      A hierarchy table.

      Used by DB2.

    • INOPERATIVE_VIEW

      public static final Schema.TableType INOPERATIVE_VIEW
      An inoperative view.

      Used by DB2.

    • MATERIALIZED_QUERY_TABLE

      public static final Schema.TableType MATERIALIZED_QUERY_TABLE
      A materialized query table.

      Used by DB2.

    • NICKNAME

      public static final Schema.TableType NICKNAME
      A nickname.

      Used by DB2.

    • TYPED_TABLE

      public static final Schema.TableType TYPED_TABLE
      A typed table.

      Used by DB2.

    • TYPED_VIEW

      public static final Schema.TableType TYPED_VIEW
      A typed view.

      Used by DB2.

    • TEMPORAL_TABLE

      public static final Schema.TableType TEMPORAL_TABLE
      A temporal table.

      Used by MS SQL, Oracle and others

    • OTHER

      public static final Schema.TableType OTHER
      Table type not known to Calcite.

      If you get one of these, please fix the problem by adding an enum value.

  • Field Details

    • jdbcName

      public final String jdbcName
      The name used in JDBC. For example "SYSTEM TABLE" rather than "SYSTEM_TABLE".

  • Method Details

    • values

      public static Schema.TableType[] 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 Schema.TableType 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