clickhouse select结果创建表，insert 现有表

winsanity

于 2021-11-23 09:57:52 发布

阅读量4.6k

点赞数 1

分类专栏： clickhouse 文章标签： database

本文链接：https://blog.csdn.net/winsanity/article/details/121486747

版权

clickhouse 专栏收录该内容

5 篇文章

订阅专栏

clickhouse查询结果创建表，insert 现有表

1、查询结果insert 现有表

INSERT INTO company_weibo_old 
(ID, CID, COMPANY_NAME, NAME, ICO, INFO, TAGS, COUNT, FANS, FOLLOW_COUNT, SOURCE_URL, CREATE_TIME, UPDATE_TIME, DELETED, ROW_TYPE, CHULI_DATE)
 SELECT id, cid, company_name, name, ico, info, tags, count, fans, follow_count, source_url, create_time, update_time, deleted, row_type, chuli_date
FROM company_weibo where chuli_date = '2021-11-16 00:00:00'

2、查询结果创建新表

create table company_weibo_new 
engine=MergeTree() 
order by id 
as
( SELECT id, cid, company_name, name, ico, info, tags, count, fans, follow_count, source_url, create_time, update_time, deleted, row_type, chuli_date
FROM economic_brain_temp.company_weibo where chuli_date = '2021-11-16 00:00:00')