stored as parquet
option. Using parquet also leads to very significant performance advantages._finalize
' or '_no_finalize
', which are reserved words in function names in Arcadia Data.Analytical views may not contain analytic functions, also known as 'window' functions. However, queries that include window functions may be routed to analytical views that contain the corresponding simple aggregate functions.
For example, a query that contains the window function sum(sales) over ()
can be routed to an analytical view that has a column sum(sales)
.
Queries may contain window functions, such as moving average, percent of group, percentage of previous, and running total.
Arcadia Engine does not support the use of non-deterministic functions, such as rand()
, user()
, pid()
, current_database()
, version()
, and so on, in analytical views.