Open alberttwong opened 6 months ago
mysql> select tracking_log from information_schema.load_tracking_logs where job_id=11119
-> ;
ERROR 2013 (HY000): Lost connection to MySQL server during query
No connection. Trying to reconnect...
Connection id: 24
Current database: *** NONE ***
+-------------------------------------------------------------+
| tracking_log |
+-------------------------------------------------------------+
| Error: NULL value in non-nullable column 'id'. Row: [NULL]
|
+-------------------------------------------------------------+
1 row in set (0.05 sec)
based on https://docs.starrocks.io/docs/2.5/sql-reference/sql-statements/data-definition/CREATE_TABLE/, default should be able to have null values in column.
@lllong33 how about this issue?
@alberttwong I don't know SR internals, it doesn't seem to be a dbt parse issue.
drop table if exists `testing`.`my_first_dbt_model__dbt_tmp`;
create table `testing`.`my_first_dbt_model__dbt_tmp` PROPERTIES ( "replication_num" = "1") as
-- select cast(null as int) as id -- work
-- union all
select null as id -- work
union all
select 1 as id
-- union all
-- select cast(null as int) as id -- not work: id must is not null
-- union all
-- select null as id -- not work: id must is not null
Stuck at step 5. https://docs.getdbt.com/guides/manual-install?step=5