| create_temp_table | If true, a unique temporary table name will
be generated in the sys_temp schema and used
in place of input parameter
projection_name. If persist is false
(or unspecified), then this is always allowed
even if the caller does not have permission
to create tables. The generated name is
returned in qualified_projection_name. The default value is false. The supported values are: |
| collection_name | [DEPRECATED--please specify the containing
schema for the projection as part of input
parameter projection_name and use
Create Schema
to create the schema if non-existent] Name
of a schema for the projection. If the schema
is non-existent, it will be automatically
created. The default value is ''. |
| expression | An optional filter
expression
to be applied to the source table prior to
the projection. The default value is ''. |
| is_replicated | If true then the projection will be
replicated even if the source table is not. The default value is false. The supported values are: |
| offset | The number of initial results to skip (this
can be useful for paging through the
results). The default value is 0. |
| limit | The number of records to keep. The default value is -9999. |
| order_by | Comma-separated list of the columns to be
sorted by; e.g. 'timestamp asc, x desc'. The
columns specified must be present in input
parameter column_names. If any alias is
given for any column name, the alias must be
used, rather than the original column name. The default value is ''. |
| chunk_size | Indicates the number of records per chunk to
be used for this projection. |
| chunk_column_max_memory | Indicates the target maximum data size for
each column in a chunk to be used for this
projection. |
| chunk_max_memory | Indicates the target maximum data size for
all columns in a chunk to be used for this
projection. |
| create_indexes | Comma-separated list of columns on which to
create indexes on the projection. The
columns specified must be present in input
parameter column_names. If any alias is
given for any column name, the alias must be
used, rather than the original column name. |
| ttl | Sets the TTL of the
projection specified in input parameter
projection_name. |
| shard_key | Comma-separated list of the columns to be
sharded on; e.g. 'column1, column2'. The
columns specified must be present in input
parameter column_names. If any alias is
given for any column name, the alias must be
used, rather than the original column name. The default value is ''. |
| persist | If true, then the projection specified in
input parameter projection_name will be
persisted and will not expire unless a ttl
is specified. If false, then the
projection will be an in-memory table and
will expire unless a ttl is specified
otherwise. The default value is false. The supported values are: |
| preserve_dict_encoding | If true, then columns that were dict
encoded in the source table will be dict
encoded in the projection. The default value is true. The supported values are: |
| retain_partitions | Determines whether the created projection
will retain the partitioning scheme from the
source table. The default value is false. The supported values are: |
| partition_type | Partitioning
scheme to use. |
| partition_keys | Comma-separated list of partition keys, which
are the columns or column expressions by
which records will be assigned to partitions
defined by partition_definitions. |
| partition_definitions | Comma-separated list of partition
definitions, whose format depends on the
choice of partition_type. See
range partitioning,
interval partitioning,
list partitioning,
hash partitioning,
or
series partitioning
for example formats. |
| is_automatic_partition | If true, a new partition will be created
for values which don't fall into an existing
partition. Currently only supported for
list partitions. The default value is false. The supported values are: |
| view_id | ID of view of which this projection is a
member. The default value is ''. |
| strategy_definition | The
tier strategy
for the table and its columns. |
| compression_codec | The default
compression codec
for the projection's columns. |
| join_window_functions | If set, window functions which require a
reshard will be computed separately and
joined back together, if the width of the
projection is greater than the
join_window_functions_threshold. The default value is true. |
| join_window_functions_threshold | If the projection is greater than this width
(in bytes), then window functions which
require a reshard will be computed separately
and joined back together. The default value is ''. |
| qualify_filter | An optional filter
expression
applied to the projection after window
function evaluation, equivalent to a SQL
QUALIFY clause. May reference window
function aliases as well as any other column
in the projection. Rows for which the
expression evaluates to false (or NULL) are
removed from the projection. The default value is ''. |
