GROUP BY
- group by one or more dimension columns along with aggregations on one or more metric columnsWHERE
SUM
, MIN
, MAX
, COUNT
, AVG
etcWHERE
APPEND
and optional if the push type is REFRESH
.GROUP BY
WHERE
BOOLEAN
, TIMESTAMP
, JSON
are added after release 0.7.1
. In release 0.7.1
and older releases, BOOLEAN
is equivalent to STRING.
BIG_DECIMAL
is added after release 0.10.0
.DATETIME
datatype support, you need to input time in either STRING, LONG, or INT format. However, Pinot needs to convert the date into an understandable format such as epoch timestamp to do operations.timeSize:timeUnit:timeFormat:pattern
.EPOCH
format, this value is not used and can be set to 1 or any other integer.\HOURS
, MINUTES
etc. If your date is not in EPOCH
format, this value is not used and can be set to MILLISECONDS
or any other unit.\EPOCH
or SIMPLE_DATE_FORMAT
. If it is SIMPLE_DATE_FORMAT
, the pattern string is also specified. \SIMPLE_DATE_FORMAT
. The pattern should be specified using the java SimpleDateFormat representation. e.g. 2020-08-21 can be represented as yyyy-MM-dd
.\1:MILLISECONDS:EPOCH
- used when timestamp is in the epoch milliseconds and stored in LONG
format1:HOURS:EPOCH
- used when timestamp is in the epoch hours and stored in LONG
or INT
format1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd
- when the date is in STRING
format and has the pattern year-month-date. e.g. 2020-08-211:HOURS:SIMPLE_DATE_FORMAT:EEE MMM dd HH:mm:ss ZZZ yyyy
- when date is in STRING
format. e.g. Mon Aug 24 12:36:50 America/Los_Angeles 2019