StarRocks / dbt-starrocks

dbt-starrocks contains all of the code enabling dbt to work with StarRocks
10 stars 4 forks source link

StarRocksColumn(Column) does not support complex type #42

Closed mcgray closed 2 months ago

mcgray commented 2 months ago

StarRocksColumn(Column) has no from_description overridden which means types like "array" is going to be incorrectly parsed in simply "array" as "" is going to be considered numeric precision or string length from default implementation. Could be useful to limit just for "(" for reading type from description.

Example:

  1. Create table
  2. Try to alter table
    {{
    config(
        materialized='incremental',
        on_schema_change='append_new_columns'
    )
    }}
    select
    cast(NULL as int) as `atp_int`,
    cast(NULL as array<string>) as `atp_arr_string`
    where false