Object

io.snappydata

QueryHint

Related Doc: package snappydata

Permalink

object QueryHint extends Enumeration

SQL query hints as interpreted by the SnappyData SQL parser. The format mirrors closely the format used by Hive,Oracle query hints with a comment followed immediately by a '+' and then "key(value)" for the hint. Example:

SELECT * /*+ hint(value) */ FROM t1

Linear Supertypes
Enumeration, Serializable, Serializable, AnyRef, Any
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. QueryHint
  2. Enumeration
  3. Serializable
  4. Serializable
  5. AnyRef
  6. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

Type Members

  1. type Type = Value

    Permalink
  2. class Val extends Value with Serializable

    Permalink
    Attributes
    protected
    Definition Classes
    Enumeration
    Annotations
    @SerialVersionUID()
  3. abstract class Value extends Ordered[Value] with Serializable

    Permalink
    Definition Classes
    Enumeration
    Annotations
    @SerialVersionUID()
  4. class ValueSet extends AbstractSet[Value] with SortedSet[Value] with SortedSetLike[Value, ValueSet] with Serializable

    Permalink
    Definition Classes
    Enumeration

Value Members

  1. final def !=(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  2. final def ##(): Int

    Permalink
    Definition Classes
    AnyRef → Any
  3. final def ==(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  4. val ColumnsAsClob: Value

    Permalink

    Query hint for SQL queries to serialize STRING type as CLOB rather than as VARCHAR.

    Query hint for SQL queries to serialize STRING type as CLOB rather than as VARCHAR.

    Possible values are valid column names in the tables/schema. Multiple column names to be comma separated. One can also provide '*' for serializing all the STRING columns as CLOB.

    Example:
    SELECT id, name, addr, medical_history FROM t1 --+ columnsAsClob(addr) SELECT id, name, addr, medical_history FROM t1 --+ columnsAsClob(*)

  5. val ComplexTypeAsJson: Value

    Permalink

    Query hint for SQL queries to serialize complex types (ARRAY, MAP, STRUCT) as CLOBs in JSON format for routed JDBC/ODBC queries (default) to display better in external tools else if set to false/0 then display as serialized blobs.

    Query hint for SQL queries to serialize complex types (ARRAY, MAP, STRUCT) as CLOBs in JSON format for routed JDBC/ODBC queries (default) to display better in external tools else if set to false/0 then display as serialized blobs.

    Possible values are 'false/0' or 'true/1' (default is true)

    Example:
    SELECT * FROM t1 --+ complexTypeAsJson(0)

  6. val Index: Value

    Permalink

    Query hint followed by table to override optimizer choice of index per table.

    Query hint followed by table to override optimizer choice of index per table.

    Possible values are valid indexes defined on the table.

    Example:
    SELECT * FROM t1 /*+ index(xxx) */, t2 --+ withIndex(yyy)

  7. val JoinOrder: Value

    Permalink

    Query hint after FROM clause to indicate following tables have join order fixed and optimizer shouldn't try to re-order joined tables.

    Query hint after FROM clause to indicate following tables have join order fixed and optimizer shouldn't try to re-order joined tables.

    Possible comma separated values are io.snappydata.JOS.

    Example:
    SELECT * FROM /*+ joinOrder(fixed) */ t1, t2

  8. val JoinType: Value

    Permalink

    Query hint to force a join type for the current join.

    Query hint to force a join type for the current join. This should appear after the required table/plan in FROM where the specific join type has to be forced. Note that this will enable the specific join type only if it is possible for that table in the join and silently ignore otherwise.

    Possible values are Constant.JOIN_TYPE_BROADCAST, Constant.JOIN_TYPE_HASH, Constant.JOIN_TYPE_SORT.

    Example:
    SELECT * FROM t1 /*+ joinType(broadcast) -- broadcast t1 */, t2 where ...

  9. final def Value(i: Int, name: String): Value

    Permalink
    Attributes
    protected
    Definition Classes
    Enumeration
  10. final def Value(name: String): Value

    Permalink
    Attributes
    protected
    Definition Classes
    Enumeration
  11. final def Value(i: Int): Value

    Permalink
    Attributes
    protected
    Definition Classes
    Enumeration
  12. final def Value: Value

    Permalink
    Attributes
    protected
    Definition Classes
    Enumeration
  13. final def apply(x: Int): Value

    Permalink
    Definition Classes
    Enumeration
  14. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any
  15. def clone(): AnyRef

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  16. final def eq(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  17. def equals(arg0: Any): Boolean

    Permalink
    Definition Classes
    AnyRef → Any
  18. def finalize(): Unit

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  19. final def getClass(): Class[_]

    Permalink
    Definition Classes
    AnyRef → Any
  20. def hashCode(): Int

    Permalink
    Definition Classes
    AnyRef → Any
  21. final def isInstanceOf[T0]: Boolean

    Permalink
    Definition Classes
    Any
  22. final def maxId: Int

    Permalink
    Definition Classes
    Enumeration
  23. final def ne(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  24. var nextId: Int

    Permalink
    Attributes
    protected
    Definition Classes
    Enumeration
  25. var nextName: Iterator[String]

    Permalink
    Attributes
    protected
    Definition Classes
    Enumeration
  26. final def notify(): Unit

    Permalink
    Definition Classes
    AnyRef
  27. final def notifyAll(): Unit

    Permalink
    Definition Classes
    AnyRef
  28. def readResolve(): AnyRef

    Permalink
    Attributes
    protected
    Definition Classes
    Enumeration
  29. final def synchronized[T0](arg0: ⇒ T0): T0

    Permalink
    Definition Classes
    AnyRef
  30. implicit def toStr(h: Type): String

    Permalink
  31. def toString(): String

    Permalink
    Definition Classes
    Enumeration → AnyRef → Any
  32. def values: ValueSet

    Permalink
    Definition Classes
    Enumeration
  33. final def wait(): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  34. final def wait(arg0: Long, arg1: Int): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  35. final def wait(arg0: Long): Unit

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  36. final def withName(s: String): Value

    Permalink
    Definition Classes
    Enumeration

Inherited from Enumeration

Inherited from Serializable

Inherited from Serializable

Inherited from AnyRef

Inherited from Any

Ungrouped