Back to Clickhouse

direct dictionary layout

docs/en/sql-reference/statements/create/dictionary/layouts/direct.md

26.4.1.1-new760 B
Original Source

import Tabs from '@theme/Tabs'; import TabItem from '@theme/TabItem';

direct {#direct}

The dictionary is not stored in memory and directly goes to the source during the processing of a request.

The dictionary key has the UInt64 type.

All types of sources, except local files, are supported.

Configuration example:

<Tabs> <TabItem value="ddl" label="DDL" default>
sql
LAYOUT(DIRECT())
</TabItem> <TabItem value="xml" label="Configuration file">
xml
<layout>
  <direct />
</layout>
</TabItem> </Tabs>

complex_key_direct {#complex_key_direct}

This type of storage is for use with composite keys. Similar to direct.