You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
analytics/priv/data_migrations/NumericIDs/sql/create-dict-from-static-fil...

10 lines
284 B
Plaintext

CREATE DICTIONARY domains_lookup (
`id` UInt64,
`site_id` UInt64,
`domain` String,
`partition` String
) PRIMARY KEY domain
SOURCE(HTTP(URL '<%= @dict_url %>' CREDENTIALS(user 'user' password '<%= @dict_password %>') FORMAT 'CSVWithNames'))
LIFETIME(3600)
LAYOUT(COMPLEX_KEY_HASHED())