QUA_PARTITION_HINT

Loads partitioning information. Should be used as a constraint of a table.

Syntax

QUA_PARTITION_HINT ( mode, definition_json )

Arguments

mode

Is a string literal which defines a mode of partitioning.

definition_json

Specifies a definition provided as JSON string literal. The definition_json has to be in line with mode.

Return types

The result is a type of bit but the result value can't be consumed in any way.

Example

CREATE TABLE BigTable (
  user_id     bigint,
  firstname   nvarchar(50),
  lastname    nvarchar(50),
  nationality nvarchar(50),
  constraint CHK_table_partition_hint check ( lyft_partition_hint ('create_table_columns', '{ "columns": ["nationality"]}') = 1 )
);