LowCardinality(String), postcode2 LowCardinality(String), type Enum8('terraced' = 1, 'semi-detached'..., postcode2, addr1, addr2);
导入数据
INSERT INTO uk_price_paid WITH splitByChar(' ', postcode) AS p SELECT...toUInt32(price_string) AS price, parseDateTimeBestEffortUS(time) AS date, p[1] AS postcode1, p[2] AS...postcode2, transform(a, ['T', 'S', 'D', 'F', 'O'], ['terraced', 'semi-detached', 'detached', 'flat',...,
parseDateTimeBestEffortUS(time) AS date,
p[1] AS postcode1,
p[2] AS postcode2,
transform(a, [‘T