SmiMi commented on issue #45873:
URL: https://github.com/apache/doris/issues/45873#issuecomment-2575052739
> You can find some useful information in the target directory, such as what
the doris adapter compiled your modify sql into.
Yes, I have found out why. dbt-doris extension does not compile
columns.description into the final sql file. Because it's using `CREATE TABLE
AS SELECT` statement 。For example, the finalsql is as follows:
```SQL
create table `bigdata`.`dim_test_after__dbt_tmp`
COMMENT 'aaaa'
as
select
cast(`customer_code` as varchar) as `customer_code`,
cast(`id` as varchar) as `id`,
cast(`customer_name` as varchar) as `customer_name`
from (
with middle_steo as (
select 1)
select customer_code, id,customer_name from dim_customer
) `_table_colume_type_name`
;
```
And this grammar does not support adding column comment。
So I have modified the dbt-doris extension, just add this SQL at the end of
final sql:
```SQL
ALTER TABLE `bigdata`.`dim_test_after__dbt_tmp` MODIFY COLUMN
`customer_code` COMMENT 'test',
MODIFY COLUMN `id` COMMENT 'test',
MODIFY COLUMN `customer_name` COMMENT 'test'
;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
