Uploaded byNaoto MATSUMOTO
ClickHouse column-oriented database Install memo
This document provides instructions for installing and configuring ClickHouse, an open-source column-oriented database management system, on an Ubuntu system. It outlines steps to add the ClickHouse repository, install the ClickHouse server and client packages, start the ClickHouse server service, and use the ClickHouse client to create a sample table and insert data.
More Related Content
Similar to ClickHouse column-oriented database Install memo
![Vibe Coding vs. Spec-Driven Development [Free Meetup]](https://cdn.slidesharecdn.com/ss_thumbnails/vibecodingvsspecdrivendevelopment-251209105622-43f455e7-thumbnail.jpg?width=640&height=640&fit=bounds)
ClickHouse column-oriented database Install memo
- 1. ClickHouse column-oriented database Install memo 2017/10/31SAKURA Internet, Inc. Research Center SR / Naoto MATSUMOTO (C) Copyright 1996-2017 SAKURA Internet Inc
- 2. ClickHouse column-oriented databaseInstall memo 2 # uname -sr; cat /etc/issue Linux 4.10.0-35-generic Ubuntu 17.04 # apt install software-properties-common # apt-key adv --keyserver keyserver.ubuntu.com --recv E0C56BD4 # apt-add-repository "deb http://repo.yandex.ru/clickhouse/trusty stable main" # apt-get update # apt-get install clickhouse-server-common clickhouse-client -y # service clickhouse-server start # clickhouse-client --multiline ClickHouse client version 1.1.54304. Connecting to localhost:9000. Connected to ClickHouse server version 1.1.54304. :) CREATE TABLE ontime ( Year UInt16, Quarter UInt8, Month UInt8, : Div5TailNum String ) ENGINE = MergeTree(FlightDate, (Year, FlightDate), 8192); or # xz -v -c -d < ontime.csv.xz | clickhouse-client --query="INSERT INTO ontime FORMAT CSV"