volumes:
- '../../../resources/modules/clickhouse.metabase-driver.jar:/plugins/clickhouse.jar'
- './.docker/clickhouse/single_node_tls/certificates/ca.crt:/certs/ca.crt'
- '~/.aws/credentials:/aws/credentials'
CREATE EXTERNAL TABLE clv.surrgate_index_outcomes(
surrogate_key string,
surrogate_value double,
outcome_name string,
outcome_lookup_days int
)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- здесь используеться схема PUB3318 для сохранения view. Вам нужно заменить на имя своей схемы, которую вы получите при регистрации https://www.exasol.com/test-it-now/ | |
-- шаг 0. Что у нас с основнвми таблицами | |
OPEN SCHEMA RETAIL; | |
SELECT COUNT(*) FROM SALES | |
; | |
--322 186 828 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- мониторим параллельную сессию | |
FLUSH STATISTICS; | |
SELECT * | |
FROM EXA_USER_PROFILE_LAST_DAY | |
WHERE | |
SESSION_ID = 1692059709381345282 AND COMMAND_NAME = 'SELECT' -- меняем на ид сессиии, котороая выполняет запросы | |
PREFERRING HIGH STMT_ID |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 0. Создадим таблицу для экспериментов | |
CREATE TABLE sales AS | |
SELECT | |
t.ticket_no | |
, passenger_id | |
, passenger_name | |
, fare_conditions | |
, amount | |
FROM | |
ticket_flights AS tf |