ClickHouse / ClickHouse/ClickHouse
A system.table_settings is wanted
Open
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
Assessment
This issue has not been assessed yet.