подскажите плз, что может быть не так.
пытаюсь создать таблицу ReplacingMergeTree с первичным ключом отличным, от ключа сортировки. но получаю ошибку Syntax error: failed at position 3479:
Expected one of: token, AND, OR, BETWEEN, IS, LIKE, NOT LIKE, IN, NOT IN, GLOBAL IN, GLOBAL NOT IN, Arrow, QuestionMark, SAMPLE BY, SETTINGS, INTO OUTFILE, FORMAT
позиция 3479 - буковка P в слове PRIMARY
CREATE TABLE views ON CLUSTER reports ( C_CONTEXT Nullable(UInt32), C_DISPOSITION Nullable(UInt32), C_DURATION Nullable(Int16), C_ID FixedString(16), C_TYPE Nullable(UInt32), C_UNIQUE Nullable(UInt8), C_WAITING Nullable(Int16), DU_ID FixedString(16), E_ACTION Nullable(String), E_CATEGORY Nullable(String), E_ID FixedString(16), E_LABEL Nullable(String), NON_INTERACTION Nullable(UInt8), PROJECT_ID FixedString(16), S_AD_GROUP_ID Nullable(UInt64), S_BROWSER_NAME UInt32, S_BROWSER_VERSION_1 UInt8, S_BROWSER_VERSION_2 UInt16, S_BROWSER_VERSION_3 UInt32, S_BROWSER_VERSION_4 UInt16, S_CAMPAIGN_ID Nullable(UInt64), S_DATE Date, S_DATETIME DateTime, S_DEVICE_OS UInt32, S_DEVICE_RESOLUTION_X UInt16, S_DEVICE_RESOLUTION_Y UInt16, S_DEVICE_TYPE Enum8('Tablet' = 1, 'Mobile' = 2, 'Computer' = 3), S_ET_DATETIME Nullable(DateTime), S_FIRST_VISIT Date, S_FORWARD Nullable(String), S_FROM Nullable(String), S_GEO_CITY String, S_GEO_COUNTRY String, S_ID FixedString(16), S_KEYWORD_ID Nullable(UInt64), S_POOL_ID Nullable(UInt32), S_TO Nullable(String), S_UTM_CAMPAIGN String, S_UTM_CONTENT String, S_UTM_MEDIUM String, S_UTM_SOURCE String, S_UTM_TERM String, U_ID FixedString(16), VERSION UInt16, V_ET_DATETIME Nullable(DateTime), V_AD_ID Nullable(UInt32), V_DATETIME Nullable(DateTime), V_DURATION Int32, V_EXIT_URL String, V_GCLID Nullable(String), V_ID FixedString(16), V_LANDING_URL String, V_SPENDING_CAMPAIGN Nullable(String), V_SPENDING_CLICKS Nullable(UInt32), V_SPENDING_CONVERSIONS Nullable(Float64), V_SPENDING_COST_AED Nullable(Float64), V_SPENDING_COST_AMD Nullable(Float64), V_SPENDING_COST_ARS Nullable(Float64), V_SPENDING_COST_AUD Nullable(Float64), V_SPENDING_COST_BGN Nullable(Float64), V_SPENDING_COST_BRL Nullable(Float64), V_SPENDING_COST_BTC Nullable(Float64), V_SPENDING_COST_BYN Nullable(Float64), V_SPENDING_COST_CAD Nullable(Float64), V_SPENDING_COST_CHF Nullable(Float64), V_SPENDING_COST_CNY Nullable(Float64), V_SPENDING_COST_CZK Nullable(Float64), V_SPENDING_COST_DKK Nullable(Float64), V_SPENDING_COST_EUR Nullable(Float64), V_SPENDING_COST_GBP Nullable(Float64), V_SPENDING_COST_HRK Nullable(Float64), V_SPENDING_COST_ILS Nullable(Float64), V_SPENDING_COST_INR Nullable(Float64), V_SPENDING_COST_ISK Nullable(Float64), V_SPENDING_COST_JPY Nullable(Float64), V_SPENDING_COST_KGS Nullable(Float64), V_SPENDING_COST_KZT Nullable(Float64), V_SPENDING_COST_MDL Nullable(Float64), V_SPENDING_COST_MXN Nullable(Float64), V_SPENDING_COST_NZD Nullable(Float64), V_SPENDING_COST_RON Nullable(Float64), V_SPENDING_COST_RSD Nullable(Float64), V_SPENDING_COST_RUB Nullable(Float64), V_SPENDING_COST_SAR Nullable(Float64), V_SPENDING_COST_SGD Nullable(Float64), V_SPENDING_COST_THB Nullable(Float64), V_SPENDING_COST_TJS Nullable(Float64), V_SPENDING_COST_TRY Nullable(Float64), V_SPENDING_COST_UAH Nullable(Float64), V_SPENDING_COST_USD Nullable(Float64), V_SPENDING_COST_UZS Nullable(Float64), V_SPENDING_COST_VND Nullable(Float64), V_SPENDING_COST_XAG Nullable(Float64), V_SPENDING_COST_XAU Nullable(Float64), V_SPENDING_COST_XPT Nullable(Float64), V_SPENDING_COST_ZAR Nullable(Float64), V_SPENDING_CURRENCY Nullable(String), V_SPENDING_GROUP Nullable(String), V_SPENDING_IMPRESSIONS Nullable(UInt32), V_SPENDING_KEYWORD Nullable(String), V_TITLE String, V_URL String ) ENGINE = ReplacingMergeTree('/clickhouse/tables/{node}/reports/views', '{replica}', VERSION) PARTITION BY toYYYYMM(S_DATE) ORDER BY (C_ID, E_ID, PROJECT_ID, S_DATETIME, S_ID, U_ID, V_ID, DU_ID) PRIMARY KEY (PROJECT_ID, S_DATETIME) SETTINGS index_granularity = 8192
что с ним может быть не так ?
