自由格式报表预览报错

数据集用的是自助数据集，没有写SQL，数据详情也能正常查看，将字段放入自由报表中也没问题，但是一预览就提示SQL报错，什么问题啊

太阳福音 发表于 2022-12-12 15:20
数据库是hive，不支持这个日期时间格式转化吗
SQL语句：
SELECT br_acc_cod as long_col_0, br_acc_des as ...

您参考一下这个https://blog.csdn.net/zcc_789/article/details/118496829

这里看一下语句是否有异常

yhdata_ruby 发表于 2022-12-12 14:41
这里看一下语句是否有异常

数据库是hive，不支持这个日期时间格式转化吗
SQL语句：
SELECT br_acc_cod as long_col_0, br_acc_des as long_col_1, account_id as long_col_2, is_post as long_col_3, ats_received_amount as long_col_4
        , ats_pay_amount as long_col_5, ats_balance as long_col_6, sap_dr_amount as long_col_7, sap_cr_amount as long_col_8, sap_balance as long_col_9
        , receives_diff as long_col_10, pay_diff as long_col_11, balance_diff as long_col_12, insert_time as ETL_TIME, part_dt as PART_DT
        , from_unixtime(unix_timestamp(CONCAT(substring(part_dt, 1, int(4)), '-', substring(part_dt, int(5), int(2)), '-', CASE
        WHEN length(part_dt) > 2 THEN substring(part_dt, length(part_dt) - int(2) + 1)
        ELSE part_dt
END), 'yyyy-MM-dd'), 'yyyy-MM-dd HH:mm:ss') as long_col_13
FROM bisi_dm.dmk_fin_accrual_difference_ats_d