Table supports multiple data models #4
Comments
motto1314
referenced
this issue
in motto1314/dbt-starrocks
May 12, 2022
Table supports selecting one from Duplicate Key/Unique Key/Primary Key Table supports set ENGINE Table supports set keys Table supports set DISTRIBUTED BY Table supports set PROPERTIES Table supports set PARTITION BY Notice: 'Create table as' can only set engine='OLAP' and table_type='DUPLICATE'
motto1314
referenced
this issue
in motto1314/dbt-starrocks
May 13, 2022
Table supports selecting one from Duplicate Key/Unique Key/Primary Key Table supports set ENGINE Table supports set keys Table supports set DISTRIBUTED BY Table supports set PROPERTIES Table supports set PARTITION BY Notice: 'Create table as' can only set engine='OLAP' and table_type='DUPLICATE'
imay
pushed a commit
that referenced
this issue
May 13, 2022
#4 1. Table supports selecting one from `Duplicate Key`/`Unique Key`/`Primary Key` 2. Table supports set `ENGINE` 3. Table supports set `keys` 4. Table supports set `DISTRIBUTED BY` 5. Table supports set `PROPERTIES` 6. Table supports set `PARTITION BY` ### Notice: 1. `Create table as` can only set engine='OLAP' and table_type='DUPLICATE' 2. distributed_by is must ### Test: test_dbt_empty: empty test_dbt_base: base `[ERROR: distributed_by is must ]` test_dbt_ephemeral: ephemeral `[ERROR: not support with ]` test_dbt_incremental: incremental `[ERROR: distributed_by is must ]` test_dbt_snapshot_strategy_timestamp: snapshot_strategy_timestamp `[ERROR: not support with ]` test_dbt_snapshot_strategy_check_cols: snapshot_strategy_check_cols `[ERROR: not support with ]` test_dbt_data_test: data_test test_dbt_schema_test: schema_test `[ERROR: distributed_by is must ]` test_dbt_ephemeral_data_tests: data_test_ephemeral_models `[ERROR: not support with ]` # example: ## dbt seed properties(whatever_you_want.yml): ### Minimum configuration: ``` config: distributed_by: ['id'] ``` ### Complete configuration: ``` config: engine: 'OLAP' keys: ['id', 'name', 'some_date'] table_type: 'PRIMARY' //PRIMARY or DUPLICATE or UNIQUE distributed_by: ['id'] buckets: 3 //default 10 partition_by: ['some_date'] partition_by_init: ["PARTITION p1 VALUES [('1971-01-01 00:00:00'), ('1991-01-01 00:00:00')),PARTITION p1972 VALUES [('1991-01-01 00:00:00'), ('1999-01-01 00:00:00'))"] properties: {"replication_num":"1", "in_memory": "true"} ``` ## dbt run config(table/incremental): ### Minimum configuration: ``` {{ config(materialized=var("materialized_var", "table"), distributed_by=['id'])}} {{ config(materialized='incremental', distributed_by=['id']) }} ``` ### Complete configuration: ``` {{ config(materialized='table', engine='OLAP', buckets=32, distributed_by=['id'], properties={"in_memory": "true"}) }} {{ config(materialized='incremental', engine='OLAP', buckets=32, distributed_by=['id'], properties={"in_memory": "true"}) }} ```
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Duplicate Key/Unique Key/Primary KeyENGINEkeysDISTRIBUTED BYPROPERTIESPARTITION BYThe text was updated successfully, but these errors were encountered: