Enumeration types in the Query API
P1_X_SMALL
: Max records per second: 5,000,000 records per secondP1_SMALL
: Max records per second: 25,000,000 records per secondP1_MEDIUM
: Max records per second: 100,000,000 records per secondP1_LARGE
: Max records per second: 250,000,000 records per secondP1_X_LARGE
: Max records per second: 500,000,000 records per secondBOOLEAN
: True or false.STRING
: A variable-length string.FLOAT
: A 32-bit signed double-precision floating point number.DOUBLE
: A 64-bit signed double-precision floating point number.INT8
: An 8-bit signed integer, with a minimum value of -2⁷ and a maximum value of 2⁷-1.INT16
: A 16-bit signed integer, with a minimum value of -2¹⁵ and a maximum value of 2¹⁵-1.INT32
: A 32-bit signed integer, with a minimum value of -2³¹ and a maximum value of 2³¹-1.INT64
: A 64-bit signed integer, with a minimum value of -2⁶³ and a maximum value of 2⁶³-1.DATE
: A date without a timestamp. For example, “YYYY-MM-DD”.TIMESTAMP
: A date with a timestamp. For example, “yyy-MM-dd HH:mm:ss”.JSON
: A JavaScript Object Notation (JSON) document.CLICKHOUSE
: A ClickHouse-specific type.ASC
: Sort in ascending order.DESC
: Sort in descending order.THIS
- The current unit of time. For example, if today is June 8, 2022, and
THIS_MONTH
is selected, then data for June 2022 would be returned.
PREVIOUS
- The previous unit of time. For example, if today is June 8, 2022, and
PREVIOUS_MONTH
is selected, then data for May 2022 would be returned. It excludes
the current unit of time.
NEXT
- The next unit of time. For example, if today is June 8, 2022, and
NEXT_MONTH
is selected, then data for July 2022 would be returned. It excludes
the current unit of time.
LAST_N
- The last n
units of time, including the current one. For example, if today
is June 8, 2022 and LAST_N_YEARS
with n
= 3 is selected, then data for 2020, 2021, and
2022 will be returned. It will include the current time period.
THIS_HOUR
: Starts at the zeroth minute of the current hour and continues for 60 minutes.TODAY
: Starts at 12:00:00 AM of the current day and continues for 24 hours.THIS_WEEK
: Starts on Monday, 12:00:00 AM of the current week and continues for seven days.THIS_MONTH
: Starts at 12:00:00 AM on the first day of the current month and continues for the duration of the month.THIS_QUARTER
: Starts at 12:00:00 AM on the first day of the current calendar quarter and continues for the duration of the quarter.THIS_YEAR
: Starts on January 1st, 12:00:00 AM of the current year and continues for the duration of the year.PREVIOUS_HOUR
: Starts at the zeroth minute of the previous hour and continues for 60 minutes.YESTERDAY
: Starts at 12:00:00 AM on the day before the today and continues for 24 hours.PREVIOUS_WEEK
: Starts on Monday, 12:00:00 AM, a week before the current week, and continues for seven days.PREVIOUS_MONTH
: Starts at 12:00:00 AM on the first day of the month before the current month and continues for the duration of the month.PREVIOUS_QUARTER
: Starts at 12:00:00 AM on the first day of the calendar quarter before the current quarter and continues for the duration of the quarter.PREVIOUS_YEAR
: Starts on January 1st, 12:00:00 AM, the year before the current year, and continues for the duration of the year.NEXT_HOUR
: Starts at the zeroth minute of the next hour and continues for 60 minutes.TOMORROW
: ” Starts at 12:00:00 AM, the day after the current day, and continues for 24 hours.NEXT_WEEK
: Starts on Monday, 12:00:00 AM, the week after the current week, and continues for the duration of the week.NEXT_MONTH
: Starts at 12:00:00 AM on the first day of the next month and continues for the duration of the month.NEXT_QUARTER
: Starts at 12:00:00 AM on the first day of the next calendar quarter and continues for the duration of the quarter.NEXT_YEAR
: Starts on January 1st, 12:00:00 AM of the next year and continues for the duration of the year.LAST_N_MINUTES
: Starts at the zeroth second n
- 1 minute(s) before the current minute and continues through the current minute. It includes this minute.LAST_N_HOURS
: Starts at the zeroth minute of the n
- 1 hour(s) before the current hour, and continues through the current hour. It includes this hour.LAST_N_DAYS
: Starts at 12:00:00 AM, n
- 1 day(s) before the current day, and continues through the current day. It includes today.LAST_N_WEEKS
: Starts on Monday, 12:00:00 AM, n
- 1 week(s) before the current week, and continues through the current week. It includes this week.LAST_N_MONTHS
: Starts at 12:00:00 AM on the first day of the month, n
- 1 month(s) before the current month, and continues through the current month. It includes this month.LAST_N_QUARTERS
: Starts at 12:00:00 AM on the first day of the calendar quarter n
- 1 quarter(s) before the current quarter and continues through the current quarter. It includes this quarter.LAST_N_YEARS
: Starts on January 1st, 12:00:00 AM of the year n
- 1 year(s) before the current year and continues through the current year. It includes this year.LAST_15_MINUTES
LAST_30_MINUTES
LAST_HOUR
LAST_4_HOURS
LAST_12_HOURS
LAST_24_HOURS
LAST_7_DAYS
LAST_30_DAYS
LAST_90_DAYS
LAST_3_MONTHS
LAST_6_MONTHS
LAST_YEAR
LAST_2_YEARS
LAST_5_YEARS
DAY
, then the the time series query will return a label and a value for each day.
If there are no records for a given time series granularity, Propel will return the label and a value of “0” so that the time series can be properly visualized.
MINUTE
: Aggregates values by minute intervals.FIVE_MINUTES
: Aggregates values by 5-minute intervals.TEN_MINUTES
: Aggregates values by 10-minute intervals.FIFTEEN_MINUTES
: Aggregates values by 15-minute intervals.HOUR
: Aggregates values by hourly intervals.DAY
: Aggregates values by daily intervals.WEEK
: Aggregates values by weekly intervals.MONTH
: Aggregates values by monthly intervals.YEAR
: Aggregates values by yearly intervals.EQUALS
: Selects values that are equal to the specified value.NOT_EQUALS
: Selects values that are not equal to the specified value.GREATER_THAN
: Selects values that are greater than the specified value.GREATER_THAN_OR_EQUAL_TO
: Selects values that are greater or equal to the specified value.LESS_THAN
: Selects values that are less than the specified value.LESS_THAN_OR_EQUAL_TO
: Selects values that are less or equal to the specified value.IS_NULL
: Selects values that are null. This operator does not accept a value.IS_NOT_NULL
: Selects values that are not null. This operator does not accept a value.LIKE
: Selects values that match the specified pattern.NOT_LIKE
: “Selects values that do not match the specified pattern.COMPLETED
: The Query was completed succesfully.ERROR
: The Query experienced an error.TIMED_OUT
: The Query timed out.METRIC
: Indicates a Metric Query.STATS
: Indicates a Dimension Stats Query.REPORT
: Indicates a Report Query.RECORDS
: Indicates a Record Table Query.RECORDS_BY_UNIQUE_ID
: Indicates records queried by unique ID.SQL
: Indicates a SQL Query.TOP_VALUES
: Indicates a Top Values Query.COUNTER
: Indicates a Metric counter Query.TIME_SERIES
: Indicates a Metric time series Query.LEADERBOARD
: Indicates a Metric leaderboard Query.POSTGRESQL
: Parse as PostgreSQL-compatible SQL.CLICKHOUSE
: Parse as ClickHouse-compatible SQL.