docker_clickhouse_with_experimental_allow_extended_storage_definition_syntax.sh

cd ~/ClickHouse/docker/server

docker build --no-cache -t clickhouse:with_ext_storage_syntax .
docker run --name ch1 -d clickhouse:with_ext_storage_syntax
docker exec -it --user root ch1 clickhouse client

Dockerfile

FROM ubuntu:16.04

ARG repository="deb https://repo.yandex.ru/clickhouse/xenial/ dists/stable/main/binary-amd64/"
ARG version=\*

RUN apt-get update && \
    apt-get install -y apt-transport-https tzdata && \
    mkdir -p /etc/apt/sources.list.d && \
    echo $repository | tee /etc/apt/sources.list.d/clickhouse.list && \
    apt-get update && \
    apt-get install --allow-unauthenticated -y clickhouse-server-common=$version clickhouse-server-base=$version && \
    rm -rf /var/lib/apt/lists/* /var/cache/debconf && \
    apt-get clean

RUN sed -i 's,<listen_host>127.0.0.1</listen_host>,<listen_host>0.0.0.0</listen_host>,' /etc/clickhouse-server/config.xml && \
    sed -i 's,<listen_host>::1</listen_host>,,' /etc/clickhouse-server/config.xml
RUN chown -R clickhouse /etc/clickhouse-server/

RUN mkdir -p /etc/clickhouse-server/users.d/
RUN chown -R clickhouse /etc/clickhouse-server/users.d/
RUN echo '<yandex><profiles><default><experimental_allow_extended_storage_definition_syntax>1</experimental_allow_extended_storage_definition_syntax></default></profiles></yandex>' > /etc/clickhouse-server/users.d/experimental_allow_extended_storage_definition_syntax.xml


USER clickhouse
EXPOSE 9000 8123 9009
VOLUME /var/lib/clickhouse

ENV CLICKHOUSE_CONFIG /etc/clickhouse-server/config.xml

ENTRYPOINT exec /usr/bin/clickhouse-server --config=${CLICKHOUSE_CONFIG}

output.txt

ClickHouse client version 1.1.54318.
Connecting to localhost:9000.
Connected to ClickHouse server version 1.1.54318.

:) SELECT * FROM system.settings WHERE name LIKE '%syntax%'

SELECT *
FROM system.settings 
WHERE name LIKE '%syntax%'

┌─name──────────────────────────────────────────────────┬─value─┬─changed─┐
│ experimental_allow_extended_storage_definition_syntax │ 1     │       1 │
└───────────────────────────────────────────────────────┴───────┴─────────┘

1 rows in set. Elapsed: 0.002 sec. 

:) CREATE TABLE ext_definition_merge_tree (p String, k String, d String) ENGINE = MergeTree PARTITION BY p ORDER BY k

CREATE TABLE ext_definition_merge_tree
(
    p String, 
    k String, 
    d String
)
ENGINE = MergeTree
PARTITION BY p
ORDER BY k

Ok.

0 rows in set. Elapsed: 0.004 sec. 

:) SELECT hostName()

SELECT hostName()

┌─hostName()───┐
│ a18318b68b77 │
└──────────────┘

1 rows in set. Elapsed: 0.001 sec. 

:)