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)