Package org.apache.calcite.sql

Enum JoinType

  • All Implemented Interfaces:
    java.io.Serializable, java.lang.Comparable<JoinType>
    public enum JoinType
extends java.lang.Enum<JoinType>
    Enumerates the types of join.

    • Enum Constant Summary

      Enum Constants 
      Enum Constant Description
      COMMA
      Comma join: the good old-fashioned SQL FROM clause, where table expressions are specified with commas between them, and join conditions are specified in the WHERE clause.
      CROSS
      Cross join (also known as Cartesian product).
      FULL
      Full outer join.
      INNER
      Inner join.
      LEFT
      Left outer join.
      LEFT_SEMI_JOIN
      Left semi join.
      RIGHT
      Right outer join.

    • Field Summary

      Fields 
      Modifier and Type Field Description
      java.lang.String lowerName
      Lower-case name.

    • Constructor Summary

      Constructors 
      Modifier Constructor Description
      private JoinType()  

    • Method Summary

      All Methods Static Methods Instance Methods Concrete Methods 
      Modifier and Type Method Description
      boolean generatesNullsOnLeft()
      Returns whether a join of this type may generate NULL values on the left-hand side.
      boolean generatesNullsOnRight()
      Returns whether a join of this type may generate NULL values on the right-hand side.
      SqlLiteral symbol​(SqlParserPos pos)
      Creates a parse-tree node representing an occurrence of this condition type keyword at a particular position in the parsed text.
      static JoinType valueOf​(java.lang.String name)
      Returns the enum constant of this type with the specified name.
      static JoinType[] 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, equals, finalize, getDeclaringClass, hashCode, name, ordinal, toString, valueOf

      • Methods inherited from class java.lang.Object

        getClass, notify, notifyAll, wait, wait, wait

    • Enum Constant Detail

      • INNER

        public static final JoinType INNER
        Inner join.

      • FULL

        public static final JoinType FULL
        Full outer join.

      • CROSS

        public static final JoinType CROSS
        Cross join (also known as Cartesian product).

      • LEFT

        public static final JoinType LEFT
        Left outer join.

      • RIGHT

        public static final JoinType RIGHT
        Right outer join.

      • LEFT_SEMI_JOIN

        public static final JoinType LEFT_SEMI_JOIN
        Left semi join.

        Not used by Calcite; only in Babel's Hive dialect.

      • COMMA

        public static final JoinType COMMA
        Comma join: the good old-fashioned SQL FROM clause, where table expressions are specified with commas between them, and join conditions are specified in the WHERE clause.

    • Field Detail

      • lowerName

        public final java.lang.String lowerName
        Lower-case name.

    • Constructor Detail

      • JoinType

        private JoinType()

    • Method Detail

      • values

        public static JoinType[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows: 
        for (JoinType c : JoinType.values())
    System.out.println(c);
        Returns:
        an array containing the constants of this enum type, in the order they are declared

      • valueOf

        public static JoinType valueOf​(java.lang.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:
        java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
        java.lang.NullPointerException - if the argument is null

      • generatesNullsOnLeft

        public boolean generatesNullsOnLeft()
        Returns whether a join of this type may generate NULL values on the left-hand side.

      • generatesNullsOnRight

        public boolean generatesNullsOnRight()
        Returns whether a join of this type may generate NULL values on the right-hand side.

      • symbol

        public SqlLiteral symbol​(SqlParserPos pos)
        Creates a parse-tree node representing an occurrence of this condition type keyword at a particular position in the parsed text.