01 2022 档案
摘要:1.导出语句 SELECT ifnull(id,'') ,ifnull(replace(replace(replace(trim(icon),char(13),''),char(10),''),'|',''),'') ,deleted+0 ,ifnull(version,'') ,ifnull(sy
阅读全文
摘要:1.€ [oracle@lenovo sqlload]$ more tb_sqlload_test.ctl Load DATA INFILE '/tmp/tb_sqlload_test.txt' truncate into table tb_sqlload_test FIELDS TERMINATE
阅读全文
摘要:环境:192.168.1.118192.168.1.134 OS:Centos 7 DB:21.9.7 1.安装zookeeper可以安装集群也可以安装单节点 集群的安装步骤请参考:https://www.cnblogs.com/hxlasky/p/14665752.html 我这里安装的是单节点的
阅读全文
摘要:[oracle@lenovo sqlload]$ more data_info.ctl Load DATA INFILE '/tmp/data_info.txt' truncate into table data_info_varchar_sdr FIELDS TERMINATED BY "|" T
阅读全文
摘要:加密压缩cd /tmptar -czvf - ./outputdat | openssl des3 -salt -k Rs34YmiER4 -out /tmp/output.tar 解密解压openssl des3 -d -k Rs34YmiER4 -salt -in /tmp/output.tar
阅读全文
摘要:目的是删除后可以立即创建同样的表名 创建表CREATE TABLE default.rtest7 ON CLUSTER 'mycluster_1'(`id` Int64,`p` Int16)ENGINE = ReplicatedMergeTree('/clickhouse/tables/{shard
阅读全文
摘要:1.停掉systemctl stop clickhouse-server.service 2.删除相应安装包[root@localhost bin]# rpm -qa|grep clickhouseclickhouse-common-static-21.6.6.51-2.x86_64clickhou
阅读全文
摘要:环境:源端--集群环境192.168.1.118192.168.1.134192.168.1.135 目的端--单节点192.168.1.85 1.在源端创建库和表我这里是192.168.1.118上面创建本地表创建库:create database db_test; 创建表:create tabl
阅读全文
摘要:环境:OS:Centos 7版本:21.6.6.51机器:192.168.1.118192.168.1.134192.168.1.135 zookeeper部署 安装步骤请参考:https://www.cnblogs.com/hxlasky/p/14665752.html 单机安装 每台机器安装步骤
阅读全文
摘要:版本:1.2.2 1.下载wget https://github.com/AlexAkulov/clickhouse-backup/releases/download/v0.6.0/clickhouse-backup.tar.gzwget https://github.com/AlexAkulov/
阅读全文
摘要:1.导出/导入(导出文件大小与原始大小一致):clickhouse-client --query="select * from db_test.app_message_80" >/tmp/app_message_80.tsv 查看表大小 SELECT database, table, sum(row
阅读全文