Open dev4mobile opened 13 hours ago
DROP TABLE IF EXISTS default.output_http_safe_access;
CREATE TABLE IF NOT EXISTS default.output_http_safe_access(`msgType` String, `version` String, `deviceType` String, `sourceid` LowCardinality(String), `sid` String, `referrer` String, `updateTime` String) ENGINE = URL(
'http://127.0.0.1:10098/api/data',
'JSONEachRow',
headers('Content-Type'='application/json;charset=UTF-8')
);
DROP TABLE IF EXISTS default.output_http_safe_access_mv;
CREATE MATERIALIZED VIEW IF NOT EXISTS default.output_http_safe_access_mv TO default.output_http_safe_access AS SELECT 'DeviceInfoPushReq' AS `msgType`, '1.0.0' AS `version`, 'H5' AS `deviceType`, host AS `sourceid`, sid, refer AS `referrer`, toString(toUnixTimestamp(ts)) as `updateTime` FROM default.access_local WHERE id is not null AND org != 'no_res' AND empty(req_risk) AND id != '';
why when I insert data failed from source table, the material view table can be updated