Object/Trait

com.crobox.clickhouse.dsl

ColumnOperations

Related Docs: trait ColumnOperations | package dsl

Permalink

object ColumnOperations extends ColumnOperations

Linear Supertypes
Ordering
  1. Alphabetic
  2. By Inheritance
Inherited
  1. ColumnOperations
  2. ColumnOperations
  3. ArithmeticOperations
  4. TypeCastColumnOperations
  5. AggregationFunctionsDsl
  6. LevelModifierDsl
  7. SumDsl
  8. AnyResultDsl
  9. UniqDsl
  10. AggregationFunctionsCombinersDsl
  11. AnyRef
  12. Any
  1. Hide All
  2. Show All
Visibility
  1. Public
  2. All

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. def aggIf[T <: TableColumn[Res], Res](condition: Comparison)(aggregated: AggregateFunction[Res]): CombinedAggregatedFunction[T, Res]

    Permalink
  5. def all(): All

    Permalink
    Definition Classes
    ColumnOperations
  6. def any[T](tableColumn: TableColumn[T]): AnyResult[T]

    Permalink
    Definition Classes
    AnyResultDsl
  7. def anyHeavy[T](tableColumn: TableColumn[T]): AnyResult[T]

    Permalink
    Definition Classes
    AnyResultDsl
  8. def anyLast[T](tableColumn: TableColumn[T]): AnyResult[T]

    Permalink
    Definition Classes
    AnyResultDsl
  9. def array[T <: TableColumn[Seq[Res]], Res](aggregated: AggregateFunction[Res]): CombinedAggregatedFunction[T, Res]

    Permalink
  10. def arrayJoin[V](tableColumn: TableColumn[Seq[V]]): ArrayJoin[V]

    Permalink
    Definition Classes
    ColumnOperations
  11. final def asInstanceOf[T0]: T0

    Permalink
    Definition Classes
    Any
  12. def average[T](tableColumn: TableColumn[T])(implicit arg0: Numeric[T]): Avg[T]

    Permalink
    Definition Classes
    AggregationFunctionsDsl
  13. implicit val booleanNumeric: Numeric[Boolean]

    Permalink
    Definition Classes
    ColumnOperations
  14. def cast(tableColumn: TableColumn[Long], simpleColumnType: SimpleColumnType): Cast[Long]

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

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  16. def columnCase[V](condition: Comparison, value: TableColumn[V]): Case[V]

    Permalink
    Definition Classes
    ColumnOperations
  17. def conditional(column: AnyTableColumn, condition: Boolean): AnyTableColumn

    Permalink
    Definition Classes
    ColumnOperations
  18. def const[V](const: V)(implicit arg0: QueryValue[V]): Const[V]

    Permalink
    Definition Classes
    ColumnOperations
  19. def count(column: TableColumn[_]): Count

    Permalink
    Definition Classes
    AggregationFunctionsDsl
  20. def count(): Count

    Permalink
    Definition Classes
    AggregationFunctionsDsl
  21. def divide[V](left: AnyTableColumn, right: AnyTableColumn): Divide[V]

    Permalink
    Definition Classes
    ArithmeticOperations
  22. final def eq(arg0: AnyRef): Boolean

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

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

    Permalink
    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  25. def forEach[V, T <: TableColumn[Seq[V]], Res](column: T)(forEachFunc: (TableColumn[V]) ⇒ AggregateFunction[Res]): AggregateFunction[Seq[Res]]

    Permalink

    Having a column with type array, it aggregates all the results for that column by running the provided aggregation functions for each vertical slice of the array elements.

    Having a column with type array, it aggregates all the results for that column by running the provided aggregation functions for each vertical slice of the array elements. Therefore, for the query result: \array_col| |[x1, y1, z1, u1] |[x2, y2, z2] |[x3, y3, z3]

    if you run sumForEach(array_col) you will get an array result with the following entries: [sum(x1,x3,x3), sum(y1,y2,y3), sum(z1, z2, z3), sum(u1)]

    Definition Classes
    AggregationFunctionsCombinersDsl
  26. final def getClass(): Class[_]

    Permalink
    Definition Classes
    AnyRef → Any
  27. def groupUniqArray[V](tableColumn: TableColumn[V]): GroupUniqArray[V]

    Permalink
    Definition Classes
    AggregationFunctionsDsl
  28. def hashCode(): Int

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

    Permalink
    Definition Classes
    Any
  30. def lowercase(tableColumn: TableColumn[String]): LowerCaseColumn

    Permalink
    Definition Classes
    ColumnOperations
  31. def max[V](tableColumn: TableColumn[V]): Max[V]

    Permalink
    Definition Classes
    AggregationFunctionsDsl
  32. def median[V](target: TableColumn[V], level: Float = 0.5F): Median[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  33. def medianDeterministic[V, T](target: TableColumn[V], determinator: TableColumn[T], level: Float = 0.5F)(implicit arg0: Numeric[T]): Median[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  34. def medianExact[V](target: TableColumn[V], level: Float = 0.5F): Median[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  35. def medianExactWeighted[V](target: TableColumn[V], weight: TableColumn[Int], level: Float = 0.5F): Median[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  36. def medianTDigest[V](target: TableColumn[V], level: Float = 0.5F): Median[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  37. def medianTiming[V](target: TableColumn[V], level: Float = 0.5F): Median[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  38. def medianTimingWeighted[V](target: TableColumn[V], weight: TableColumn[Int], level: Float = 0.5F): Median[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  39. def merge[T <: TableColumn[StateResult[Res]], Res](aggregated: AggregateFunction[Res]): CombinedAggregatedFunction[T, Res]

    Permalink
  40. def min[V](tableColumn: TableColumn[V]): Min[V]

    Permalink
    Definition Classes
    AggregationFunctionsDsl
  41. def minus[V](left: AnyTableColumn, right: AnyTableColumn): Minus[V]

    Permalink
    Definition Classes
    ArithmeticOperations
  42. def multiply[V](left: AnyTableColumn, right: AnyTableColumn): Multiply[V]

    Permalink
    Definition Classes
    ArithmeticOperations
  43. final def ne(arg0: AnyRef): Boolean

    Permalink
    Definition Classes
    AnyRef
  44. final def notify(): Unit

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

    Permalink
    Definition Classes
    AnyRef
  46. def plus[V](left: AnyTableColumn, right: AnyTableColumn): Plus[V]

    Permalink
    Definition Classes
    ArithmeticOperations
  47. def quantile[V](target: TableColumn[V], level: Float = 0.5F): Quantile[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  48. def quantileDeterministic[V, T](target: TableColumn[V], determinator: TableColumn[T], level: Float = 0.5F)(implicit arg0: Numeric[T]): Quantile[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  49. def quantileExact[V](target: TableColumn[V], level: Float = 0.5F): Quantile[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  50. def quantileExactWeighted[V](target: TableColumn[V], weight: TableColumn[Int], level: Float = 0.5F): Quantile[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  51. def quantileTDigest[V](target: TableColumn[V], level: Float = 0.5F): Quantile[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  52. def quantileTiming[V](target: TableColumn[V], level: Float = 0.5F): Quantile[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  53. def quantileTimingWeighted[V](target: TableColumn[V], weight: TableColumn[Int], level: Float = 0.5F): Quantile[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  54. def quantiles[V](target: TableColumn[V], levels: Float*): Quantiles[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  55. def quantilesDeterministic[V, T](target: TableColumn[V], determinator: TableColumn[T], levels: Float*)(implicit arg0: Numeric[T]): Quantiles[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  56. def quantilesExact[V](target: TableColumn[V], levels: Float*): Quantiles[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  57. def quantilesExactWeighted[V](target: TableColumn[V], weight: TableColumn[Int], levels: Float*): Quantiles[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  58. def quantilesTDigest[V](target: TableColumn[V], levels: Float*): Quantiles[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  59. def quantilesTiming[V](target: TableColumn[V], levels: Float*): Quantiles[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  60. def quantilesTimingWeighted[V](target: TableColumn[V], weight: TableColumn[Int], levels: Float*): Quantiles[V]

    Permalink
    Definition Classes
    LevelModifierDsl
  61. def rawColumn(tableColumn: AnyTableColumn): RawColumn

    Permalink
    Definition Classes
    ColumnOperations
  62. def ref[V](refName: String): RefColumn[V]

    Permalink
    Definition Classes
    ColumnOperations
  63. def reinterpret[V](typeCastColumn: TypeCastColumn[V] with Reinterpretable): Reinterpret[V]

    Permalink
    Definition Classes
    TypeCastColumnOperations
  64. def state[T <: TableColumn[Res], Res](aggregated: AggregateFunction[Res]): CombinedAggregatedFunction[T, StateResult[Res]]

    Permalink
  65. def sum[T](tableColumn: TableColumn[T])(implicit arg0: Numeric[T]): Sum[T]

    Permalink
    Definition Classes
    SumDsl
  66. def sumMap[T, V](key: TableColumn[Seq[T]], value: TableColumn[Seq[V]])(implicit arg0: Numeric[T], arg1: Numeric[V]): SumMap[T, V]

    Permalink
    Definition Classes
    SumDsl
  67. def sumOverflown[T](tableColumn: TableColumn[T])(implicit arg0: Numeric[T]): Sum[T]

    Permalink
    Definition Classes
    SumDsl
  68. def switch[V](defaultValue: TableColumn[V], cases: Case[V]*): Conditional[V]

    Permalink
    Definition Classes
    ColumnOperations
  69. final def synchronized[T0](arg0: ⇒ T0): T0

    Permalink
    Definition Classes
    AnyRef
  70. def timeSeries(tableColumn: TableColumn[Long], interval: MultiInterval): TimeSeries

    Permalink

    This function will push back the timestamp represented by tableColumn to the start of this interval, this happens deterministically.

    This function will push back the timestamp represented by tableColumn to the start of this interval, this happens deterministically.

    Meaning that as long as the duration is the same, your groups will be in the same from/to timestamps

    This is useful for aggregating results by periods of time (group by month, 2 months, days, etc.)

    Definition Classes
    AggregationFunctionsDsl
  71. def toDate(tableColumn: AnyTableColumn): DateRep

    Permalink
    Definition Classes
    TypeCastColumnOperations
  72. def toDateTime(tableColumn: AnyTableColumn): DateTimeRep

    Permalink
    Definition Classes
    TypeCastColumnOperations
  73. def toFixedString(tableColumn: AnyTableColumn, n: Int): FixedString

    Permalink
    Definition Classes
    TypeCastColumnOperations
  74. def toFloat32(tableColumn: AnyTableColumn): Float32

    Permalink
    Definition Classes
    TypeCastColumnOperations
  75. def toFloat32OrZero(tableColumn: AnyTableColumn): Float32

    Permalink
    Definition Classes
    TypeCastColumnOperations
  76. def toFloat64(tableColumn: AnyTableColumn): Float64

    Permalink
    Definition Classes
    TypeCastColumnOperations
  77. def toFloat64OrZero(tableColumn: AnyTableColumn): Float64

    Permalink
    Definition Classes
    TypeCastColumnOperations
  78. def toInt16(tableColumn: AnyTableColumn): Int16

    Permalink
    Definition Classes
    TypeCastColumnOperations
  79. def toInt16OrZero(tableColumn: AnyTableColumn): Int16

    Permalink
    Definition Classes
    TypeCastColumnOperations
  80. def toInt32(tableColumn: AnyTableColumn): Int32

    Permalink
    Definition Classes
    TypeCastColumnOperations
  81. def toInt32OrZero(tableColumn: AnyTableColumn): Int32

    Permalink
    Definition Classes
    TypeCastColumnOperations
  82. def toInt64(tableColumn: AnyTableColumn): Int64

    Permalink
    Definition Classes
    TypeCastColumnOperations
  83. def toInt64OrZero(tableColumn: AnyTableColumn): Int64

    Permalink
    Definition Classes
    TypeCastColumnOperations
  84. def toInt8(tableColumn: AnyTableColumn): Int8

    Permalink
    Definition Classes
    TypeCastColumnOperations
  85. def toInt8OrZero(tableColumn: AnyTableColumn): Int8

    Permalink
    Definition Classes
    TypeCastColumnOperations
  86. def toString(): String

    Permalink
    Definition Classes
    AnyRef → Any
  87. def toStringCutToZero(tableColumn: AnyTableColumn): StringCutToZero

    Permalink
    Definition Classes
    TypeCastColumnOperations
  88. def toStringRep(tableColumn: AnyTableColumn): StringRep

    Permalink
    Definition Classes
    TypeCastColumnOperations
  89. def toUInt16(tableColumn: AnyTableColumn): UInt16

    Permalink
    Definition Classes
    TypeCastColumnOperations
  90. def toUInt16OrZero(tableColumn: AnyTableColumn): UInt16

    Permalink
    Definition Classes
    TypeCastColumnOperations
  91. def toUInt32(tableColumn: AnyTableColumn): UInt32

    Permalink
    Definition Classes
    TypeCastColumnOperations
  92. def toUInt32OrZero(tableColumn: AnyTableColumn): UInt32

    Permalink
    Definition Classes
    TypeCastColumnOperations
  93. def toUInt64(tableColumn: AnyTableColumn): UInt64

    Permalink
    Definition Classes
    TypeCastColumnOperations
  94. def toUInt64OrZero(tableColumn: AnyTableColumn): UInt64

    Permalink
    Definition Classes
    TypeCastColumnOperations
  95. def toUInt8(tableColumn: AnyTableColumn): UInt8

    Permalink
    Definition Classes
    TypeCastColumnOperations
  96. def toUInt8OrZero(tableColumn: AnyTableColumn): UInt8

    Permalink
    Definition Classes
    TypeCastColumnOperations
  97. def tuple[T1, T2](firstColumn: TableColumn[T1], secondColumn: TableColumn[T2]): TupleColumn[(T1, T2)]

    Permalink
    Definition Classes
    ColumnOperations
  98. def uniq(tableColumn: AnyTableColumn): Uniq

    Permalink
    Definition Classes
    UniqDsl
  99. def uniqCombined(tableColumn: AnyTableColumn): Uniq

    Permalink
    Definition Classes
    UniqDsl
  100. def uniqExact(tableColumn: AnyTableColumn): Uniq

    Permalink
    Definition Classes
    UniqDsl
  101. def uniqHLL12(tableColumn: AnyTableColumn): Uniq

    Permalink
    Definition Classes
    UniqDsl
  102. final def wait(): Unit

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

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

    Permalink
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )

Inherited from ColumnOperations

Inherited from ArithmeticOperations

Inherited from TypeCastColumnOperations

Inherited from AggregationFunctionsDsl

Inherited from LevelModifierDsl

Inherited from SumDsl

Inherited from AnyResultDsl

Inherited from UniqDsl

Inherited from AnyRef

Inherited from Any

Ungrouped