Привет всем, а что не так с версией 19.9.2? Раньше

код работал, а с этой версией посылает с кодом 62:
e1a9bd3e9cfa :) CREATE TABLE IF NOT EXISTS replica_2.csSensi(Unit String,Index String,Scenario String,Tenor String,Tenor1 String,Tenor2 String,UnderlyingType String,Book String,Value Float64,InstName String,InstUnderlying String,Observable String,Observable1 String,Observable2 String,ObservableType String,Observable1Type String,Observable2Type String,ObservableContract String,Underlying String,Id String,Type String,RiskType String,Pillar String,InstrumentType String,InstrumentId String,ParamName String,StrikeStickiness String,SkewStrikeStickiness String,IdL String,IdR String,Maturity String,Code String,AltCode String,Currency String,EquityCurrency String,AssetCategory String,Expiry String,EndDate String,ExpiryDate String,SettleDate String,FixingDate String,ErrorMessage String,IrSwapLeg String,Date Date,commit Int64,factor Int8) ENGINE = ReplicatedMergeTree('/clickhouse/tables/02/csSensi', '172.29.170.24') PARTITION BY Date ORDER BY (commit,Book, InstrumentId) SETTINGS index_granularity = 8192

CREATE TABLE IF NOT EXISTS replica_2.csSensi
(
Unit String,
Index String,
Scenario String,
Tenor String,
Tenor1 String,
Tenor2 String,
UnderlyingType String,
Book String,
Value Float64,
InstName String,
InstUnderlying String,
Observable String,
Observable1 String,
Observable2 String,
ObservableType String,
Observable1Type String,
Observable2Type String,
ObservableContract String,
Underlying String,
Id String,
Type String,
RiskType String,
Pillar String,
InstrumentType String,
InstrumentId String,
ParamName String,
StrikeStickiness String,
SkewStrikeStickiness String,
IdL String,
IdR String,
Maturity String,
Code String,
AltCode String,
Currency String,
EquityCurrency String,
AssetCategory String,
Expiry String,
EndDate String,
ExpiryDate String,
SettleDate String,
FixingDate String,
ErrorMessage String,
IrSwapLeg String,
Date Date,
commit Int64,
factor Int8
)
ENGINE = ReplicatedMergeTree('/clickhouse/tables/02/csSensi', '172.29.170.24')
PARTITION BY Date
ORDER BY (commit, Book, InstrumentId)
SETTINGS index_granularity = 8192

Received exception from server (version 19.9.2):
Code: 62. DB::Exception: Received from 172.29.170.24:9001. DB::Exception: Syntax error: failed at position 70: ,Scenario String,Tenor String,Tenor1 String,Tenor2 String,UnderlyingType String,Book String,Value Float64,InstName String,InstUnderlying String,Observable Strin. Expected one of: list, delimited by binary operators, list, delimited by operator of variable arity, expression with prefix unary operator, string concatenation expression, expression with ternary operator, NOT, CASE, LEFT, RIGHT, asterisk, number, CAST, NULL, function, case, logical-NOT expression, logical-AND expression, logical-OR expression, array, token, parenthesized expression, SELECT subquery, identifier, compound identifier, qualified asterisk, CAST expression, SUBSTRING expression, TRIM expression, LEFT expression, RIGHT expression, EXTRACT expression, DATE_ADD expression, DATE_DIFF expression, string literal, literal, element of expression, SUBSTRING, EXTRACT, DATEADD, DATE_ADD, TIMESTAMPADD, TIMESTAMP_ADD, DATESUB, DATE_SUB, TIMESTAMPSUB, TIMESTAMP_SUB, INTERVAL, LTRIM, RTRIM, TRIM, DATEDIFF, DATE_DIFF, TIMESTAMPDIFF, TIMESTAMP_DIFF, list of elements, tuple element expression, array element expression, unary minus expression, multiplicative expression, INTERVAL operator expression, additive expression, BETWEEN expression, comparison expression, nullity checking, lambda expression, OpeningRoundBracket, Arrow.

0 rows in set. Elapsed: 0.014 sec.

Index скорее всего зарезервированное слово