The default location for server logs is /var/log/clickhouse-server/. The server is ready to handle client connections
once it logs the Readyforconnections message.
Once the clickhouse-server is up and running, we can use clickhouse-client to connect to the server and run some
test queries like SELECT"Hello,world!";.
Quick tips for clickhouse-client
Interactive mode:
clickhouse-client
clickhouse-client--host=...--port=...--user=...--password=...
Enable multiline queries:
clickhouse-client-m
clickhouse-client--multiline
Run queries in batch-mode:
clickhouse-client--query='SELECT1'
echo'SELECT1'|clickhouse-client
clickhouse-client<<<'SELECT1'
Insert data from a file in specified format:
clickhouse-client--query='INSERTINTOtableVALUES'<data.txt
clickhouse-client--query='INSERTINTOtableFORMATTabSeparated'<data.tsv
Import Sample Dataset
Now it’s time to fill our ClickHouse server with some sample data. In this tutorial, we’ll use the anonymized data of
Yandex.Metrica, the first service that runs ClickHouse in production way before it became open-source (more on that in
history section). There are multiple ways to import Yandex.Metrica dataset, and for the sake of the tutorial, we’ll go with the
most realistic one.
Download and Extract Table Data
curlhttps://clickhouse-datasets.s3.yandex.net/hits/tsv/hits_v1.tsv.xz|unxz--threads=`nproc`>
hits_v1.tsv
curlhttps://clickhouse-datasets.s3.yandex.net/visits/tsv/visits_v1.tsv.xz|unxz--threads=`nproc`
>visits_v1.tsv
The extracted files are about 10GB in size.
Create Tables
As in most databases management systems, ClickHouse logically groups tables into “databases”. There’s a default
database, but we’ll create a new one named tutorial:
clickhouse-client--query"CREATEDATABASEIFNOTEXISTStutorial"
Syntax for creating tables is way more complicated compared to databases (see reference. In general CREATETABLE
statement has to specify three key things:
1. Name of table to create.
剩余597页未读，继续阅读
玩转曼哈顿
- 粉丝: 71
- 资源: 4
我的内容管理
展开
最新资源
- 贵州煤矿矿井水分类与处理策略：悬浮物、酸性与非酸性
- 醛固酮增多症肾上腺静脉采样对比：ACTH后LR-CAV的最优评估
- 开源云连接传感器监控平台：农业土壤湿度远程监测
- 母婴用品企业年度生产计划线性规划优化模型：实证与应用
- 井下智能变电站：Rogowski线圈电流检测系统的研发与性能验证
- 霍州矿区煤巷稳定性分析及支护策略
- ARM嵌入式系统远程软件更新方案：基于TFTP协议
- 煤炭选煤中汞分布规律与洗选脱汞效果
- 提升码垛机器人性能：拉格朗日动力学模型与滑模模糊控制的应用
- 增强现实技术提升学前手写教学：设计与开发案例
- 不规则工作面沉陷三角剖分算法提升与应用
- 卡尔曼滤波在瞬变电磁干扰压制中的应用研究
- 煤矿安全能力研究：理论与系统构建
- LonWorks总线技术在斜巷运输车辆定位与跑车防护中的应用
- 神东煤炭集团高效煤粉锅炉系统：节能环保新实践
- Ti/SnO2+Sb2Ox/PbO2电极分形维数与电催化性能研究
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
