clickhouse日常使用场景

1、查询当前所在数据库

select currentDatabase() FORMAT TabSeparatedWithNamesAndTypes

2、查询参数表

select concat('select count(*) from ',database,'.',name,' union all ')
from system.tables
where database in ('test_1', 'test_2', 'test_3')
  and match(create_table_query, '154.62.93' )
  and  engine in ('View','Dictionary','MaterializedView','Join','Join','MySQL');

3、查寻字段默认值

defaultValueOfArgumentType

select * from system.functions
where name like '%defa%';