从分段中插入我的ODS，在我的日期列时会出现错误，我该更改代码？

发布于 2025-02-14 01:17:11 字数 673 浏览 0 评论 0原文

我已经将数据加载到了舞台上，该分段整体上都顺利进行，但是现在，当试图将数据插入到ODS中时，我的SQL错误。除温度_tmp和stecitation_tmp外，所有表都没有错误移动，该表具有to_date函数。

我最终遇到了这个错误：

无法用格式'yyyymmdd'
分析日期'

我对为什么会发生这种情况感到不知所措，我尝试了try_t try_to_to_date，因为<<<<代码> SEXITION_TMP 表具有加载数据的标题。

查询：

INSERT INTO precipitation(date_t, precipitation, precipitation_normal)
    SELECT 
        TO_DATE(date_tmp,'YYYYMMDD'), 
        CAST(precipitation_tmp AS FLOAT), 
        CAST(precipitation_normal AS FLOAT) 
    FROM 
        "UDACITYPROJECT"."STAGING".precipitation_tmp;

这是针对学校项目的。

原文

I've loaded my data into staging, which went smoothly across the board, but now when trying to insert my data from staging into the ods my sql errors out. All tables moved without error with the exception of temperature_tmp and precipitation_tmp, which have the TO_DATE function.

I end up getting this error:

Can't parse 'date' as date with format 'YYYYMMDD'

I'm at a loss as to why this is happening, I tried TRY_TO_DATE and that threw a different error because the first row of the precipitation_tmp table has the headers from loading the data.

Query:

INSERT INTO precipitation(date_t, precipitation, precipitation_normal)
    SELECT 
        TO_DATE(date_tmp,'YYYYMMDD'), 
        CAST(precipitation_tmp AS FLOAT), 
        CAST(precipitation_normal AS FLOAT) 
    FROM 
        "UDACITYPROJECT"."STAGING".precipitation_tmp;

This is for a school project.

分享到QQ

分享到微博