ClickHouse / ClickHouse/ClickHouse

A system.table_settings is wanted

Open
#65,817 2 comments 1 reaction 0 assignees View on GitHub
comp-system-table external feature
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

I want to write:
```sql
SELECT name,value FROM system.table_settings WHERE database='db' AND table='the_table' AND name='parts_to_throw_insert'
```

Instead of
```sql
WITH
'parts_to_throw_insert' AS name,
regexpExtract(create_table_query, 'SETTINGS .+', 0) AS settings_str,
arrayMap(x -> splitByString(' = ', x), extractAll(settings_str, '([a-z_]+ = [^ ,]+)')) AS settings
SELECT
arrayFirst(s -> s[1] = name, settings)[2] AS value
FROM system.tables
WHERE (database = 'db') AND (table = 'the_table')

```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.