达梦数据迁移到clickhouse Published on Apr 6, 2024 in 随笔 with 0 comment 先在clickhouse建表和库 ```sql CREATE TABLE "xxx" ( "USER_ID" String, "DOOR_INDEX_CODE" String, "DOOR_NAME" String, "IN_OUT_TYPE" String, "ORG_INDEX_CODE" String, "ORG_INDEX_NAME" String, "ACADEMY" String, "BIRTHPLACE" String, "CENSUS_REGISTER" String, "CERT_NO" String, "COMPANY_UNIT" String, "DORMITOR" String, "EDUCATION" String, "EMAIL" String, "HOUSE_HOLD_REL" String, "SFTYPE" String, "MOBILE" String, "NATION" String, "ORGID" String, "PERSON_ID" String, "PERSON_NAME" String, "SEX" String, "CERTTYPE" String, "EVENT_TIME" String, "CARD_NO" String, "IS_MEN" String, "JOB_NO" String, "DEV_INDEX_CODE" String, "DEV_NAME" String, "DOOR_REGION_INDEX_CODE" String, "PIC_URI" String, "ORG_NAME" String, "EVENT_TYPE" String, "RECEIVE_TIME" String, "CREATE_TIME" String, "CREATE_USER" String, "UPDATE_TIME" String, "UPDATE_USER" String, "ID" String, "IS_DELETE" String DEFAULT '0', "ORG_ID" String, "EVENT_ID" String DEFAULT '' ) ENGINE = MergeTree() PRIMARY KEY ("ID") ``` clickhouse-client 导入 ```sql INSERT INTO qwuser.B_T_PEOPLE_INOUT_LOGS FROM INFILE '/root/sql/sql.sql' FORMAT MySQLDump ``` 本文由 admin 创作,采用 知识共享署名4.0 国际许可协议进行许可。本站文章除注明转载/出处外,均为本站原创或翻译,转载前请务必署名。