PQL47 (PQL Function Library - CPM 4.7)

The hard upper limit of rows per table is 2.1 billion rows (exactly 2³¹-1). The recommended upper limit of rows for a table is 800 million.

Table names and table IDs have to be unique. Within a table the column names and IDs have to be unique. Please also note that table and column names are case-insensitive. Information about supported table and column names can be found here.

The hard upper limit of distinct activities in an activity table is 32,767 (2¹⁵-1). Nevertheless, we recommend to not exceed the number of 1,000 distinct activities per activity table for visualization reasons.

The DATE type represents timestamps that can range from year 1400 (including) to the year 10000 (excluding) on millisecond precision. Values outside this range will be mapped to NULL. A detailed description of the DATE type can be found here.

The implementation of floating point numbers follows the IEEE Standard for Floating-Point Arithmetic (IEEE 754) with a 64 bit precision. Further information can be found here.

The INT type represents integers with 64 bits which supports a range from -9223372036854775808 (-2⁶³) to 9223372036854775807 (2⁶³-1). Further information on the INT type can be found here.

The STRING type allows to handle sequences of characters, typically text. STRING constants have to be quoted with single quotes ('...'). Single quotes within a STRING constant have to be escaped with a backslash (\'). A literal backslash within a STRING constant also have to be escaped with a backslash (\\). Unicode characters are supported in all functions which support the STRING type, unless specifically noted in the documentation for the given function. A more detailed description of STRING can be found here.