StarRocks / dbt-starrocks

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

support complex type when add column #43

Closed Astralidea closed 2 months ago

Astralidea commented 2 months ago

Now dbt uses the following sql to detect the type

    select
        column_name,
        data_type,
        character_maximum_length,
        numeric_precision,
        numeric_scale
    from INFORMATION_SCHEMA.columns
    where table_name = '$table'
      and table_schema = '$db'
    order by ordinal_position

But starrocks does not return detailed type information Therefore, dbt considers using desc syntax to supplement detailed type information for complex types. This will partial repair fix #41 #42