GBase8A 报错： The query includes syntax that is not supported by the Express engine.

1.如果遇到：ERROR 1733 (HY000): (GBA-01EX-700) The query includes syntax that is not supported by the Express engine. 
Either restructure the query with supported syntax, 
or enable the GBase Query Path in the configuration file to execute the query with reduced performance.

2.修改参数： 

set  _gbase_query_path= 1; 

然后再执行即可。

根据参数手册，建议修改会话级参数。set  _gbase_query_path= 1; 

example: 

表结构： 

CREATE TABLE dep_dpsit_acct_bal_info_test (
 PRDT_NO varchar(10) DEFAULT NULL,
 PRDT_NM varchar(10) DEFAULT NULL,
 CUST_TPCD varchar(10) DEFAULT NULL,
 OPACT_ORGNO varchar(10) DEFAULT NULL,
 YACM_BAL decimal(26,6) DEFAULT NULL,
 ACCT_BAL decimal(26,6) DEFAULT NULL,
 DDW_ETL_DT date DEFAULT NULL,
 KEY idx_PRDT_NO (PRDT_NO) USING HASH GLOBAL,
 KEY idx_PRDT_NM (PRDT_NM) USING HASH GLOBAL,
 KEY idx_CUST_TPCD (CUST_TPCD) USING HASH GLOBAL,
 KEY idx_OPACT_ORGNO (OPACT_ORGNO) USING HASH GLOBAL
) DISTRIBUTED BY('PRDT_NO', 'OPACT_ORGNO','PRDT_NM','CUST_TPCD');
 

--测试语句： 

SET @i = 0;

INSERT INTO dep_dpsit_acct_bal_info_test (PRDT_NO, PRDT_NM, CUST_TPCD, OPACT_ORGNO, YACM_BAL, ACCT_BAL, DDW_ETL_DT)
SELECT 
   CONCAT('PRD', LPAD(FLOOR(RAND() * 10000), 4, '0')),  -- 随机生成产品编号
   CONCAT('产品', LPAD(FLOOR(RAND() * 100), 2, '0')),  -- 随机生成产品名称
   CONCAT('CUST', LPAD(FLOOR(RAND() * 500), 3, '0')),  -- 随机生成客户类型代码
   CONCAT('ORG', LPAD(FLOOR(RAND() * 100), 2, '0')),   -- 随机生成组织编号
   ROUND(RAND() * 10000, 2),                             -- 随机生成余额
   ROUND(RAND() * 10000, 2),                             -- 随机生成账户余额
   DATE_SUB(CURDATE(), INTERVAL FLOOR(RAND() * 365) DAY) -- 随机生成日期
FROM (SELECT @i:=@i+1 AS num FROM information_schema.tables LIMIT 10000) AS tmp;