JoinRelType
instead.@Deprecated public enum SemiJoinType extends java.lang.Enum<SemiJoinType>
Enum Constant and Description |
---|
ANTI
Deprecated.
Anti-join.
|
INNER
Deprecated.
Inner join.
|
LEFT
Deprecated.
Left-outer join.
|
SEMI
Deprecated.
Semi-join.
|
Modifier and Type | Field and Description |
---|---|
java.lang.String |
lowerName
Deprecated.
Lower-case name.
|
Modifier and Type | Method and Description |
---|---|
static SemiJoinType |
of(JoinRelType joinType)
Deprecated.
|
boolean |
returnsJustFirstInput()
Deprecated.
|
SqlLiteral |
symbol(SqlParserPos pos)
Deprecated.
Creates a parse-tree node representing an occurrence of this
condition type keyword at a particular position in the parsed
text.
|
JoinRelType |
toJoinType()
Deprecated.
|
CorrelateJoinType |
toLinq4j()
Deprecated.
|
static SemiJoinType |
valueOf(java.lang.String name)
Deprecated.
Returns the enum constant of this type with the specified name.
|
static SemiJoinType[] |
values()
Deprecated.
Returns an array containing the constants of this enum type, in
the order they are declared.
|
public static final SemiJoinType INNER
public static final SemiJoinType LEFT
public static final SemiJoinType SEMI
For example, EMP semi-join DEPT
finds all EMP
records
that have a corresponding DEPT
record:
SELECT * FROM EMP WHERE EXISTS (SELECT 1 FROM DEPT WHERE DEPT.DEPTNO = EMP.DEPTNO)
public static final SemiJoinType ANTI
For example, EMP anti-join DEPT
finds all EMP
records
that do not have a corresponding DEPT
record:
SELECT * FROM EMP WHERE NOT EXISTS (SELECT 1 FROM DEPT WHERE DEPT.DEPTNO = EMP.DEPTNO)
public static SemiJoinType[] values()
for (SemiJoinType c : SemiJoinType.values()) System.out.println(c);
public static SemiJoinType valueOf(java.lang.String name)
name
- the name of the enum constant to be returned.java.lang.IllegalArgumentException
- if this enum type has no constant with the specified namejava.lang.NullPointerException
- if the argument is nullpublic SqlLiteral symbol(SqlParserPos pos)
public static SemiJoinType of(JoinRelType joinType)
public JoinRelType toJoinType()
public CorrelateJoinType toLinq4j()
public boolean returnsJustFirstInput()
Copyright © 2012–2019 The Apache Software Foundation. All rights reserved.