使用jdbc创建物化视图的时候,报错Encountered: BUILD

Viewed 9

mysql-connector-j版本为8.3.0
doris版本为2.1.9
使用jdbc创建物化视图时报错,我怎么能直接创建或者让他不报错
物化视图创建语句

CREATE MATERIALIZED VIEW bw_xxfp_zxx_view BUILD IMMEDIATE
REFRESH AUTO ON SCHEDULE EVERY 1 DAY STARTS {0}03:30:00{1}
DUPLICATE KEY(tenantId, orgId, invoiceDate)
COMMENT '销项发票主信息异步物化视图'
PARTITION BY (DATE_TRUNC(invoiceDate, 'month'))
DISTRIBUTED BY HASH(id) BUCKETS 32
PROPERTIES ('replication_num' = '1')
AS
SELECT
    zxx.ZH_BM AS tenantId,
    zxx.ZZ_BM AS orgId,
    date_trunc(zxx.KPRQ, 'day') as invoiceDate,
    jg.ZZ_MC AS orgName,
    zxx.ID AS id,
    zxx.FPLX AS invoiceCategory,
    zxx.FPHM AS invoiceNo,
    zxx.FPDM AS invoiceCode,
    zxx.FPLX_DM AS invoiceTypeCode,
    zxx.SSWZZFP AS paperInvoiceFlag,
    CONCAT(COALESCE(zxx.FPLX_DM, ''), COALESCE(zxx.SSWZZFP, '')) AS invoiceTypeCodePlus,
    zxx.GMFMC AS buyerName,
    zxx.GMFNSRSBH AS buyerTaxNo,
    CASE WHEN zxx.GMFZRRBS = '' OR zxx.GMFZRRBS IS NULL THEN 'N' ELSE zxx.GMFZRRBS END AS buyerNaturalPerson,
    CASE WHEN zxx.GMFZRRBS != 'Y' OR zxx.GMFZRRBS IS NULL THEN SUBSTRING(zxx.GMFNSRSBH, 3, 2) ELSE NULL END AS buyerLocation,
    zxx.XSFMC AS sellerName,
    zxx.XSFNSRSBH AS sellerTaxNo,
    CASE WHEN zxx.XSFZRRBS = '' OR zxx.XSFZRRBS IS NULL THEN 'N' ELSE zxx.XSFZRRBS END AS sellerNaturalPerson,
    zxx.FPZT AS invoiceStatus,
    zxx.KPLX AS invoiceType,
    zxx.HCZT AS redDashedStatus,
    CASE
        WHEN zxx.FPZT = '00' AND zxx.KPLX = '0' AND (zxx.HCZT NOT IN ('1','2') OR zxx.HCZT IS NULL OR zxx.HCZT = '')  THEN '000'
        WHEN zxx.FPZT = '00' AND zxx.KPLX = '1' THEN '001'
        WHEN zxx.FPZT = '03' AND zxx.KPLX = '0' THEN '030'
        WHEN zxx.FPZT = '03' AND zxx.KPLX = '1' THEN '031'
        WHEN zxx.FPZT = '00' AND zxx.KPLX = '0' AND zxx.HCZT = '1' THEN '005'
        WHEN zxx.FPZT = '00' AND zxx.KPLX = '0' AND zxx.HCZT = '2' THEN '004'
        ELSE NULL
END AS invoiceStatusPlus,
    zxx.KPR AS drawer,
    CASE
        WHEN zxx.LYBZ = '04' AND json_extract(zxx.BYZD, '$.flowOrderSource') = '0' THEN '040'
        WHEN zxx.LYBZ = '04' AND json_extract(zxx.BYZD, '$.flowOrderSource') = '1' THEN '041'
        ELSE zxx.LYBZ
END AS sourceMark,
    CASE
        WHEN zxx.SPECIFICNO = '00' OR zxx.SPECIFICNO IS NULL OR zxx.SPECIFICNO = '' THEN NULL
        WHEN zxx.FPLX = '0' THEN CONCAT('0', zxx.SPECIFICNO)
        ELSE zxx.SPECIFICNO
END AS specificNo,
    zxx.HJJE AS goodsTotalPrice,
    zxx.HJSE AS goodsTotalTax,
    zxx.HJJE + zxx.HJSE AS goodsTotalPriceTax,
    CASE WHEN zxx.FPZT = '00' AND zxx.KPLX = '0' THEN 1 ELSE 0 END AS blueInvoiceCount,
    CASE WHEN zxx.FPZT = '00' AND zxx.KPLX = '0' THEN IFNULL(zxx.HJJE, 0) ELSE 0 END AS blueInvoiceTotalPrice,
    CASE WHEN zxx.FPZT = '00' AND zxx.KPLX = '0' THEN IFNULL(zxx.HJSE, 0) ELSE 0 END AS blueInvoiceTotalTax,
    CASE WHEN zxx.FPZT = '00' AND zxx.KPLX = '0' THEN IFNULL(zxx.HJJE, 0) + IFNULL(zxx.HJSE, 0) ELSE 0 END AS blueInvoiceTotalPriceTax,
    CASE WHEN zxx.FPZT = '00' AND zxx.KPLX = '1' THEN 1 ELSE 0 END AS redInvoiceCount,
    CASE WHEN zxx.FPZT = '00' AND zxx.KPLX = '1' THEN IFNULL(zxx.HJJE, 0) ELSE 0 END AS redInvoiceTotalPrice,
    CASE WHEN zxx.FPZT = '00' AND zxx.KPLX = '1' THEN IFNULL(zxx.HJSE, 0) ELSE 0 END AS redInvoiceTotalTax,
    CASE WHEN zxx.FPZT = '00' AND zxx.KPLX = '1' THEN IFNULL(zxx.HJJE, 0) + IFNULL(zxx.HJSE, 0) ELSE 0 END AS redInvoiceTotalPriceTax,
    CASE WHEN zxx.FPZT = '03' THEN 1 ELSE 0 END AS invalidInvoiceCount,
    CASE WHEN zxx.FPZT = '03' THEN IFNULL(zxx.HJJE, 0) ELSE 0 END AS invalidInvoiceTotalPrice,
    CASE WHEN zxx.FPZT = '03' THEN IFNULL(zxx.HJSE, 0) ELSE 0 END AS invalidInvoiceTotalTax,
    CASE WHEN zxx.FPZT = '03' THEN IFNULL(zxx.HJJE, 0) + IFNULL(zxx.HJSE, 0) ELSE 0 END AS invalidInvoiceTotalPriceTax
FROM
    bw_xxfp_zxx AS zxx
LEFT JOIN
    bw_jg_xx AS jg ON zxx.ZZ_BM = jg.ZZ_BM;

java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 1:
CREATE MATERIALIZED VIEW bw_xxfp_zxx_view BUILD IMMEDIATE
^
Encountered: BUILD
Expected

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1344)
at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2090)
at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1253)
1 Answers

这个是语法有问题呀,检查下语法的,刷新粒度这里这种写法不支持,换种写法试试的
image.png