gabse 8a Create as 语句执行报错

问题现象

Create as 语句执行报错，报错信息 Truncated incorrect INTEGER value。Sql 如

下：

insert into

prod.test.ds_m_ckp_data_table_13100_tmp2 select GBase 8a MPP Cluster FAQ FAQ

文档版本（2021-04-02） 南大通用数据技术股份有限公司

65

USER_ID,city_code,

AVG(case when statis_ym BETWEEN

IF( LENGTH('202011') =6 ,'202009',

TO_CHAR(ADDDATE(ADD_MONTHS(TO_DATE('20201101' ,'YYYYMMDD'),'0' * 12 + '-

2'),' '),'YYYYMMDD')) AND '202011' then CALL_DURA1 end)

d4c65e05da224918a6b79c5898c57d63_src_2 from view_test2 where user_id

='89560000306665' and city_code='13105' group by

USER_ID,city_code limit 1;

解决方法：

方案 1：关闭_gbase_sis_strict_mode

方案 2：规划 SQL 书写规范，如下

insert into prod.test.ds_m_ckp_data_table_13100_tmp2 select

USER_ID,city_code,AVG(case when statis_ym BETWEEN

IF( LENGTH('202011')

=6 ,'202009',TO_CHAR(ADDDATE(ADD_MONTHS(TO_DATE('20201101' ,'YYYYMMDD')

,'0' * 12 + '-2'),'0'),'YYYYMMDD')) AND '202011' then CALL_DURA1 end)

d4c65e05da224918a6b79c5898c57d63_src_2 from view_test2 where user_id

='89560000306665' and city_code='13105' group by

USER_ID,city_code limit 1;