ClickHouse · Forge

          content="ClickHouse is an open source column-oriented database management system that allows generating analytical data reports in real time using SQL queries."/>

15

<meta property="og:type" content="website"/>

16

<meta property="og:url" content="https://clickhouse.yandex"/>

17

<meta property="og:image" content="https://clickhouse.yandex/images/logo.png"/>

18

19

<meta property="twitter:title" content="ClickHouse DBMS"/>

20

21

<meta name="description"

22

          content="ClickHouse is an open source distributed column-oriented database management system that allows generating analytical data reports in real time using SQL queries. Сreated by Yandex ClickHouse manages extremely large volumes of data in a stable and sustainable manner."/>

23

<meta name="keywords"

24

          content="ClickHouse, DBMS, OLAP, relational, analytics, analytical, big data, open-source, SQL, web-analytics" />

25

26

<link href="index.css" media="all" rel="stylesheet" />

</head>

<body>

<div id="navbar">

<div id="navbar-inner">

31

<div id="top-menu" class="desktop-only">

32

<a class="menu_item" href="#quick-start">Quick Start</a>

33

<a class="menu_item" href="#performance">Performance</a>

34

<a class="menu_item" href="docs/en/">Documentation</a>

35

<a class="menu_item" href="blog/en/">Blog</a>

36

<a class="menu_item" href="#contacts">Contacts</a>

37

</div>

38

39

<a id="logo" href="#">

40

<h1 id="main-title">

41

<svg id="title-logo" xmlns="http://www.w3.org/2000/svg" width="48" height="44" viewBox="0 0 9 8">

42

<path class="red" d="M0,7 h1 v1 h-1 z"></path>

43

<path class="orange" d="M0,0 h1 v7 h-1 z"></path>

44

<path class="orange" d="M2,0 h1 v8 h-1 z"></path>

45

<path class="orange" d="M4,0 h1 v8 h-1 z"></path>

46

<path class="orange" d="M6,0 h1 v8 h-1 z"></path>

47

<path class="orange" d="M8,3.25 h1 v1.5 h-1 z"></path>

</svg>

ClickHouse

</h1>

</a>

</div>

</div>

<div id="hero">

<div class="page">

<div class="block-70">

59

<p id="short-description">ClickHouse is an <span class="orange">open source</span> column-oriented

60

database management system

61

capable of <span class="orange">real time</span> generation of analytical data reports using <span

62

class="orange">SQL</span> queries.</p>

63

<a id="call_to_action" href="#quick-start">

Quick Start

</a>

</div>

<div class="block-30">

68

<ul id="index_ul" class="dashed">

69

<li>

70

<a class="index_item" href="#blazing-fast">Blazing Fast</a>

71

</li>

72

<li>

73

<a class="index_item" href="#linearly-scalable">Linearly Scalable</a>

74

</li>

75

<li>

76

<a class="index_item" href="#hardware-efficient">Hardware Efficient</a>

77

</li>

78

<li>

79

<a class="index_item" href="#fault-tolerant">Fault Tolerant</a>

80

</li>

81

<li>

82

<a class="index_item" href="#key-features">Feature Rich</a>

83

</li>

84

<li>

85

<a class="index_item" href="#highly-reliable">Highly Reliable</a>

86

</li>

87

<li>

88

<a class="index_item" href="#simple-and-handy">Simple and Handy</a>

</li>

</ul>

</div>

<div class="clear"></div>

93

</div>

94

</div>

95

<div id="announcement" class="colored-block">

<div class="page">

</div>

</div>

<div class="page">

<h2 id="slogan">ClickHouse. Just makes you think faster.</h2>

101

102

<div class="block-70">

103

<ul class="dashed">

104

<li>Run more queries in the same amount of time</li>

105

<li>Test more hypotheses</li>

106

<li>Slice and dice your data in many more new ways</li>

107

<li>Look at your data from new angles</li>

108

<li>Discover new dimensions</li>

109

</ul>

110

</div>

111

<div class="block-30">

112

<svg id="placeholder" class="desktop-only" viewBox="0 0 76 76" xmlns="http://www.w3.org/2000/svg">

113

<defs>

114

<rect id="path-1" x="0" y="16" width="60" height="60" rx="1"></rect>

115

                <mask id="mask-2" maskContentUnits="userSpaceOnUse" maskUnits="objectBoundingBox" x="0" y="0" width="60" height="60" fill="white">

116

<use xlink:href="#path-1"></use>

117

</mask>

118

<rect id="path-3" x="16" y="0" width="60" height="60" rx="1"></rect>

119

                <mask id="mask-4" maskContentUnits="userSpaceOnUse" maskUnits="objectBoundingBox" x="0" y="0" width="60" height="60" fill="white">

120

<use xlink:href="#path-3"></use>

121

</mask>

122

<rect id="path-5" x="0" y="8" width="20" height="20" rx="1"></rect>

123

                <mask id="mask-6" maskContentUnits="userSpaceOnUse" maskUnits="objectBoundingBox" x="0" y="0" width="20" height="20" fill="white">

124

<use xlink:href="#path-5"></use>

125

</mask>

126

<rect id="path-7" x="8" y="0" width="20" height="20" rx="1"></rect>

127

                <mask id="mask-8" maskContentUnits="userSpaceOnUse" maskUnits="objectBoundingBox" x="0" y="0" width="20" height="20" fill="white">

128

<use xlink:href="#path-7"></use>

129

</mask>

130

</defs>

131

<g id="Page-1" stroke="none" stroke-width="1" fill="none" fill-rule="evenodd" stroke-linecap="round">

132

<g id="Clickhouse_2" transform="translate(-558.000000, -1293.000000)">

133

<g id="Group-11" transform="translate(558.000000, 1293.000000)">

134

<use stroke="#FFCC00" mask="url(#mask-2)" stroke-width="4" xlink:href="#path-1"></use>

135

<use stroke="#FFCC00" mask="url(#mask-4)" stroke-width="4" xlink:href="#path-3"></use>

136

                        <path d="M0.989013672,17.017334 L16.8210449,1.16748047" stroke="#FFCC00" stroke-width="2"></path>

137

                        <path d="M59.0788574,74.9973145 L74.7983398,59.2650146" stroke="#FFCC00" stroke-width="2"></path>

138

                        <path d="M59.1091309,17.1687012 L74.9368896,1.10351562" stroke="#FFCC00" stroke-width="2"></path>

139

                        <path d="M1.07910156,17.2504883 L26.0395508,33.4033203" stroke="#FFCC00" stroke-width="2"></path>

140

                        <path d="M17.2602539,1.18457031 L34.0175781,25.1796875" stroke="#FFCC00" stroke-width="2"></path>

141

<path d="M51.2958984,25.4736328 L58.8277588,17" stroke="#FFCC00" stroke-width="2"></path>

142

                        <path d="M1.01904297,50.942627 L25.9216309,75.064209" stroke="#FFCC00" stroke-width="2" transform="translate(13.470337, 63.003418) scale(-1, 1) translate(-13.470337, -63.003418) "></path>

143

<path d="M44.1804199,51.300293 L58.9638672,75.010498" stroke="#FFCC00" stroke-width="2"></path>

144

                        <path d="M52.0131836,43.1345215 L75.0227051,58.9299316" stroke="#FFCC00" stroke-width="2"></path>

145

<g id="Group-3" transform="translate(25.000000, 24.000000)" stroke="#444444">

146

<use mask="url(#mask-6)" stroke-width="4" xlink:href="#path-5"></use>

147

<use mask="url(#mask-8)" stroke-width="4" xlink:href="#path-7"></use>

148

                            <path d="M19.2587891,1.08825684 L26.7729492,8.8046875" stroke-width="2" transform="translate(23.015869, 4.946472) scale(-1, 1) translate(-23.015869, -4.946472) "></path>

149

                            <path d="M1.05773926,1.04125977 L8.82080078,8.9654541" stroke-width="2" transform="translate(4.939270, 5.003357) scale(-1, 1) translate(-4.939270, -5.003357) "></path>

150

                            <path d="M1.12487793,18.887207 L9.26220703,26.8897705" stroke-width="2" transform="translate(5.193542, 22.888489) scale(-1, 1) translate(-5.193542, -22.888489) "></path>

151

                            <path d="M19.038208,19.1968994 L26.9085693,26.9760742" stroke-width="2" transform="translate(22.973389, 23.086487) scale(-1, 1) translate(-22.973389, -23.086487) "></path>

</g>

</g>

</g>

</g>

</svg>

</div>

<div class="clear"></div>

160

161

162

<h2 id="blazing-fast">Blazing Fast</h2>

163

164

<p>ClickHouse's performance <a href="benchmark.html">exceeds</a> comparable column-oriented DBMS currently available

165

on the market. It processes hundreds of millions to more than a billion rows and tens of gigabytes of data

166

per single server per second.</p>

167

168

<p>ClickHouse uses all available hardware to its full potential to process each query as fast as possible. The peak

169

processing performance for a single query <span class="grey">(after decompression, only used columns)</span>

170

stands at more than 2 terabytes per second.</p>

171

</div>

172

<div id="performance" class="colored-block">

173

<div class="page">

174

<h2>ClickHouse works 100-1,000x faster than traditional approaches</h2>

175

        <p>In contrast to common data management methods, where vast amounts of raw data in its native format are available as

176

a "data lake" for any given query,

177

ClickHouse offers instant results in most cases: the data is processed faster than it takes

178

to create a query. Follow the link below to see detailed benchmarks by Yandex of ClickHouse in comparison

179

            with other database management systems. Also there are some links on third-party benchmarks in the following section.</p>

180

<a id="benchmark_learn_more" href="benchmark.html">

181

Learn more

182

</a>

183

<div class="clear"></div>

</div>

</div>

<div class="page">

<h2 id="independent-benchmarks">Independent Benchmarks</h2>

190

191

<ul class="dashed">

192

<li><a href="https://www.percona.com/blog/2017/02/13/clickhouse-new-opensource-columnar-database/"

193

rel="external nofollow" target="_blank">ClickHouse: New Open Source Columnar Database</a> by Percona</li>

194

        <li><a href="https://www.percona.com/blog/2017/03/17/column-store-database-benchmarks-mariadb-columnstore-vs-clickhouse-vs-apache-spark/"

195

title="MariaDB ColumnStore vs. Clickhouse vs. Apache Spark"

196

rel="external nofollow" target="_blank">Column Store Database Benchmarks</a> by Percona</li>

197

<li><a href="http://tech.marksblogg.com/billion-nyc-taxi-clickhouse.html"

198

               rel="external nofollow" target="_blank">1.1 Billion Taxi Rides on ClickHouse & an Intel Core i5</a> by Mark Litwintschik</li>

199

<li><a href="https://tech.marksblogg.com/billion-nyc-taxi-rides-clickhouse-cluster.html"

200

               rel="external nofollow" target="_blank">1.1 Billion Taxi Rides: 108-core ClickHouse Cluster</a> by Mark Litwintschik</li>

201

<li><a href="https://www.altinity.com/blog/2017/6/20/clickhouse-vs-redshift"

202

rel="external nofollow" target="_blank">ClickHouse vs Amazon RedShift Benchmark</a> by Altinity</li>

203

<li><a href="https://carto.com/blog/inside/geospatial-processing-with-clickhouse"

204

rel="external nofollow" target="_blank">Geospatial processing with Clickhouse</a> by Carto</li>

205

        <li><a href="https://translate.yandex.com/translate?url=http%3A%2F%2Fwww.clickhouse.com.cn%2Ftopic%2F5a72e8ab9d28dfde2ddc5ea2F&amp;lang=zh-en"

206

               rel="external nofollow" target="_blank">ClickHouse and Vertica comparison</a> by zhtsh <span class="grey">(machine translation from Chinese)</span></li>

207

        <li><a href="https://translate.yandex.com/translate?url=http%3A%2F%2Fverynull.com%2F2016%2F08%2F22%2Finfinidb%E4%B8%8Eclickhouse%E5%AF%B9%E6%AF%94%2F&amp;lang=zh-en"

208

               rel="external nofollow" target="_blank">ClickHouse and InfiniDB comparison</a> by RamboLau <span class="grey">(machine translation from Chinese)</span></li>

209

</ul>

210

211

<h2 id="linearly-scalable">Linearly Scalable</h2>

212

213

<p>ClickHouse allows companies to add servers to their clusters when necessary without investing time or money into

214

any additional DBMS modification. The system has been successfully serving

215

<a href="https://metrica.yandex.com/" rel="external nofollow">Yandex.Metrica</a>,

216

while the count of servers in it's main production cluster have grown from 60 to 394 in two years,

217

which are by the way located in six geographically distributed datacenters.</p>

218

219

<p>ClickHouse scales well both vertically and horizontally. ClickHouse is easily adaptable to perform either on

220

cluster with hundreds of nodes, or on a single server or even on a tiny virtual machine. Currently there are

221

installations with more than two trillion rows per single node,

222

as well as installations with 100Tb of storage per single node.</p>

223

224

225

<h2 id="hardware-efficient">Hardware Efficient</h2>

226

227

<p>ClickHouse processes typical analytical queries two to three orders of magnitude faster than traditional

228

row-oriented systems with the same available I/O throughput. The system's columnar storage format allows fitting

229

more hot data in RAM, which leads to a shorter response times.</p>

230

231

    <p>ClickHouse allows to minimize the number of seeks for range queries, which increases efficiency of using rotational

232

disk drives, as it maintains locality of reference for continually stored data.</p>

233

234

<p>ClickHouse is CPU efficient because of it's vectorized query execution involving relevant processor instructions

235

and runtime code generation.</p>

236

237

<p>By minimizing data transfers for most types of queries, ClickHouse enables companies to manage their data and

238

create reports without using specialized networks that are aimed at high-performance computing.</p>

239

240

<h2 id="fault-tolerant">Fault Tolerant</h2>

241

242

<p>ClickHouse supports multi-master asynchronous replication and can be deployed across multiple datacenters.

243

Downtime of a single node or the whole datacenter won't affect the system's availability for both reads and

244

writes.

245

Distributed reads are automatically balanced to live replicas to avoid increasing latency. Replicated data

246

are synchronized automatically or semi-automatically after server downtime.</p>

</div>

</div>

<div id="grey-block" class="colored-block">

251

<div class="page">

252

253

<h2 id="key-features">Key Features</h2>

254

255

<div class="block-50">

256

<ul class="dashed">

257

<li>True column-oriented storage</li>

258

<li>Vectorized query execution</li>

259

<li>Data compression</li>

260

<li>Parallel and distributed query execution</li>

261

<li>Real time query processing</li>

262

<li>Real time data ingestion</li>

263

<li>On-disk locality of reference</li>

264

<li>Cross-datacenter replication</li>

265

<li>High availability</li>

266

<li>SQL support</li>

</ul>

</div>

<div class="block-50">

271

<ul class="dashed">

272

<li>Local and distributed joins</li>

273

<li>Pluggable external dimension tables</li>

274

<li>Arrays and nested data types</li>

275

<li>Approximate query processing</li>

276

<li>Probabilistic data structures</li>

277

<li>Full support of IPv6</li>

278

<li>Features for web analytics</li>

279

<li>State-of-the-art algorithms</li>

280

<li>Detailed documentation</li>

281

<li>Clean documented code</li>

</ul>

</div>

<div class="clear"></div>

</div>

</div>

<div class="page">

<h2 id="feature-rich">Feature Rich</h2>

291

292

<p>ClickHouse features a user-friendly SQL query dialect with a number of built-in analytics capabilities.

293

For example, it includes probabilistic data

294

structures for fast and memory-efficient calculation of cardinalities and quantiles. There are functions for

295

working dates, times and time zones, as well as some specialized ones like addressing URLs and IPs

296

(both IPv4 and IPv6) and many more.</p>

297

298

    <p>Data organizing options available in ClickHouse, such as arrays, array joins, tuples and nested data structures, are

299

extremely efficient for managing denormalized data.</p>

300

301

<p>Using ClickHouse allows joining both distributed data and co-located data, as the system supports local joins and

302

distributed joins. It also offers an opportunity to use external dictionaries, dimension tables loaded from

303

an external source, for seamless joins with simple syntax.</p>

304

305

<p>ClickHouse supports approximate query processing – you can get results as fast as you want, which is

306

indispensable when dealing with terabytes and petabytes of data.</p>

307

308

<p>The system's conditional aggregate functions, calculation of totals and extremes, allow getting results with a

309

single query without having to run a number of them.</p>

310

311

<h2 id="success-stories">Success Stories</h2>

312

313

<ul class="dashed">

314

<li><a href="docs/en/introduction/ya_metrika_task/">Yandex.Metrica</a></li>

315

<li><a href="https://blog.cloudflare.com/http-analytics-for-6m-requests-per-second-using-clickhouse/"

316

               rel="external nofollow" target="_blank">HTTP Analytics</a> and <a href="https://blog.cloudflare.com/how-cloudflare-analyzes-1m-dns-queries-per-second/"

317

rel="external nofollow" target="_blank">DNS Analytics</a> at CloudFlare</li>

318

<li><a href="https://www.slideshare.net/glebus/using-clickhouse-for-experimentation-104247173"

319

rel="external nofollow" target="_blank">ClickHouse for Experimentation</a> at Spotify</li>

320

<li><a href="https://blog.qrator.net/en/clickhouse-ddos-mitigation_37/"

321

rel="external nofollow" target="_blank">ClickHouse DB in DDoS mitigation</a> at Qrator</li>

322

        <li><a href="https://translate.yandex.com/translate?url=https%3A%2F%2Fhabrahabr.ru%2Fpost%2F322620%2F&amp;lang=ru-en"

323

               rel="external nofollow" target="_blank">Migrating to Yandex ClickHouse</a> by LifeStreet <span class="grey">(machine translation from Russian)</span></li>

324

        <li><a href="https://translate.yandex.com/translate?url=http%3A%2F%2Fsouslecapot.net%2F2018%2F11%2F21%2Fpatrick-chatain-vp-engineering-chez-contentsquare-penser-davantage-amelioration-continue-que-revolution-constante%2F&lang=fr-en"

325

               rel="external nofollow" target="_blank">ClickHouse at ContentSquare</a> <span class="grey">(machine translation from French)</span></li>

326

        <li><a href="https://translate.yandex.com/translate?url=https%3A%2F%2Fhabrahabr.ru%2Fcompany%2Fsmi2%2Fblog%2F314558%2F&amp;lang=ru-en"

327

               rel="external nofollow" target="_blank">How to start ClickHouse up and win the jackpot</a> by SMI2 <span class="grey">(machine translation from Russian)</span></li>

328

        <li><a href="https://translate.yandex.com/translate?url=http%3A%2F%2Fwww.jianshu.com%2Fp%2F4c86a2478cca&amp;lang=zh-en"

329

            rel="external nofollow" target="_blank">First place at Analysys OLAP algorithm contest</a> <span class="grey">(machine translation from Chinese)</span></li>

330

        <li><a href="https://translate.yandex.com/translate?url=https%3A%2F%2Ftech.geniee.co.jp%2Fentry%2F2017%2F07%2F20%2F160100"

331

            rel="external nofollow" target="_blank">Speeding up Report API</a> at Geniee <span class="grey">(machine translation from Japanese)</span></li>

332

<li><a href="https://www.yandex.com/company/press_center/press_releases/2012/2012-04-10/"

333

rel="external nofollow" target="_blank">LHCb experiment</a> by CERN</li>

334

</ul>

335

336

<h2>When to use ClickHouse</h2>

337

338

<p>For analytics over stream of clean, well structured and immutable events or logs.

339

It is recommended to put each such stream into a single wide fact table with pre-joined dimensions.

340

</p>

341

<p>Some examples of viable applications:</p>

342

343

<ul class="dashed">

344

<li>Web and App analytics</li>

345

<li>Advertising networks and RTB</li>

346

<li>Telecommunications</li>

347

<li>E-commerce and finance</li>

348

<li>Information security</li>

349

<li>Monitoring and telemetry</li>

350

<li>Time series</li>

351

<li>Business intelligence</li>

352

<li>Online games</li>

353

<li>Internet of Things</li>

354

</ul>

355

356

<h2>When <span class="red">NOT</span> to use ClickHouse</h2>

357

358

<ul class="dashed">

359

<li>Transactional workloads (OLTP)</li>

360

<li>Key-value access with high request rate</li>

361

<li>Blob or document storage</li>

362

<li>Over-normalized data</li>

363

</ul>

364

365

<h2 id="highly-reliable">Highly Reliable</h2>

366

367

<p>ClickHouse has been managing petabytes of data serving a number of highload mass audience services of

368

<a href="https://www.yandex.com/company/"

369

rel="external nofollow">Yandex</a>, Russia's

370

leading search provider and one of largest European IT companies.

371

Since 2012, ClickHouse has been providing robust database management for the company's <a

372

href="https://metrica.yandex.com/" rel="external nofollow">web analytics service</a>, comparison

373

e-commerce platform, public email service, online advertising platform, business intelligence tools

374

and infrastructure monitoring.</p>

375

376

<p>ClickHouse can be configured as purely distributed system located on independent nodes,

377

without any single points of failure.</p>

378

379

<p>Software and hardware failures or misconfigurations do not result in loss of data. Instead of deleting "broken"

380

data, ClickHouse saves it or asks you what to do before a startup. All data is checksummed before every

381

        read or write to disk or network. It&nbsp;is virtually impossible to delete data by accident as there are safeguards

382

even for human errors.</p>

383

384

<p>ClickHouse offers flexible limits on query complexity and resource usage, which can be fine-tuned with settings.

385

It is possible to simultaneously serve both a number of high priority low-latency requests and some

386

long-running queries with background priority.</p>

387

388

<h2 id="simple-and-handy">Simple and Handy</h2>

389

<p>ClickHouse streamlines all your data processing. It's easy to use: ingest all your structured data into the

390

system, and it is instantly available for reports. New columns for new properties or dimensions can be

391

easily added to the system at any time without slowing it down.</p>

392

393

<p>ClickHouse is simple and works out-of-the-box. As well as performing on hundreds of node clusters, this system

394

can be easily installed on a single server or even a virtual machine. No development experience or code-writing

395

skills are required to install ClickHouse.</p>

396

397

<h2 id="quick-start">Quick Start</h2>

398

399

<p>System requirements: Linux, x86_64 with SSE 4.2.</p>

400

401

    <p>Install packages for <span class="distributive_selected" id="repo_deb">Ubuntu/Debian</span> or <span class="distributive_not_selected" id="repo_rpm">CentOS/RedHat</span>:</p>

402

403

<code id="packages-install">

404

<pre id="instruction_deb">

405

sudo apt-get install dirmngr

406

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv E0C56BD4

407

408

echo "deb http://repo.yandex.ru/clickhouse/deb/stable/ main/" | sudo tee /etc/apt/sources.list.d/clickhouse.list

409

sudo apt-get update

410

411

sudo apt-get install -y clickhouse-server clickhouse-client

412

413

sudo service clickhouse-server start

414

clickhouse-client

415

</pre>

416

<pre id="instruction_rpm" style="display: none;">

417

sudo yum install yum-utils

418

sudo rpm --import https://repo.yandex.ru/clickhouse/CLICKHOUSE-KEY.GPG

419

sudo yum-config-manager --add-repo https://repo.yandex.ru/clickhouse/rpm/stable/x86_64

420

sudo yum install clickhouse-server clickhouse-client

421

422

sudo /etc/init.d/clickhouse-server start

clickhouse-client

</pre>

</code>

<p>For other operating systems the easiest way to get started is using

428

<a href="https://hub.docker.com/r/yandex/clickhouse-server/" rel="external nofollow"

429

target="_blank">

430

            official Docker images of ClickHouse</a>, this is not the only <a href="https://clickhouse.yandex/docs/en/getting_started/">option</a> though.

431

Alternatively, you can easily get a running ClickHouse instance or cluster at

432

        <a href="https://cloud.yandex.com/services/managed-clickhouse?utm_source=referrals&utm_medium=clickhouseofficialsite&utm_campaign=link1" rel="external nofollow" target="_blank">

433

Yandex Managed Service for ClickHouse</a>.

434

</p>

435

436

    <p>After you got connected to your ClickHouse server, you can proceed to <strong><a href="tutorial.html">tutorial</a></strong> or <strong><a href="docs/en/">full

437

documentation</a></strong>.</p>

438

439

<h2 id="contacts">Contacts</h2>

440

<ul class="dashed">

441

<li>Subscribe to the <a href="https://clickhouse.yandex/blog/en" target="_blank">official ClickHouse blog</a>

442

and its <a href="https://clickhouse.yandex/blog/ru" target="_blank">counterpart in Russian</a>.</li>

443

<li>Ask any questions on <a href="https://stackoverflow.com/questions/tagged/clickhouse"

444

rel="external nofollow" target="_blank">Stack Overflow</a> or

445

<a href="https://groups.google.com/group/clickhouse"

446

rel="external nofollow" target="_blank">Google Group</a>.

447

</li>

448

<li>Join Telegram chat to discuss with real users in <a

449

href="https://telegram.me/clickhouse_en"

450

rel="external nofollow" target="_blank">English</a> or in

451

<a href="https://telegram.me/clickhouse_ru"

452

rel="external nofollow" target="_blank">Russian</a>.</li>

453

<li>Watch video content on <a href="https://www.youtube.com/c/ClickHouseDB"

454

rel="external nofollow" target="_blank">YouTube channel</a>.</li>

455

<li>Follow official <a

456

href="https://twitter.com/ClickHouseDB"

457

rel="external nofollow" target="_blank">Twitter account</a>.</li>

458

<li>Open <a href="https://github.com/ClickHouse/ClickHouse/issues/new/choose"

459

                    rel="external nofollow" target="_blank">GitHub issue</a> if you have a bug report or feature request.</li>

460

<li>Or email Yandex ClickHouse team directly at

461

<a id="feedback_email" href="">turn on JavaScript to see email address</a>.

462

            You can also <a href="https://forms.yandex.com/surveys/meet-yandex-clickhouse-team/" target="_blank" rel="external nofollow">fill this form</a> to meet us in person.</li>

463

</ul>

464

465

    <p>Friendly reminder: check out the documentation in <a href="docs/en/">English</a>, <a href="docs/ru/">Russian</a>, <a href="docs/zh/">Chinese</a> or <a href="docs/fa/">Farsi</a> first &mdash; maybe your question is already covered.

466

</p>

467

468

<h2>Like ClickHouse?</h2>

469

    <p>Help to spread the word about it via <a rel="external nofollow" target="_blank" href="https://www.facebook.com/sharer.php?u=https://clickhouse.yandex">Facebook</a>,

470

        <a rel="external nofollow" target="_blank" href="https://twitter.com/intent/tweet?url=https://clickhouse.yandex">Twitter</a> and

471

        <a rel="external nofollow" target="_blank" href="https://www.linkedin.com/shareArticle?url=https://clickhouse.yandex">LinkedIn</a>!</p>

472

473

    <p>Also hosting ClickHouse Meetups is very appreciated, <a href="https://forms.yandex.com/surveys/meet-yandex-clickhouse-team/" target="_blank" rel="external nofollow">fill this form</a>

474

if you are interested and we'll get in touch.

475

        Short reports about previous meetups are <a href="https://clickhouse.yandex/blog/en?tag=meetup" target="_blank">published in official ClickHouse blog</a>.</p>

476

477

<p class="warranty"><a href="https://github.com/ClickHouse/ClickHouse/blob/master/LICENSE"

478

rel="external nofollow" target="_blank">

479

        ClickHouse source code is published under Apache 2.0 License.</a> Software is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY

480

KIND, either express or implied.</p>

</div>

<a id="github_link"

487

href="https://github.com/ClickHouse/ClickHouse"

488

rel="external nofollow"

489

target="_blank"

490

><div id="github">Fork me on GitHub</div></a>

491

492

<script type="text/javascript" src="https://yastatic.net/jquery/3.1.1/jquery.min.js"></script>

493

<script type="text/javascript">

494

$(document).ready(function () {

495

$.get('https://raw.githubusercontent.com/ClickHouse/ClickHouse/master/README.md', function(e) {

496

var skip = true;

497

var lines = e.split('\n');

498

var result = [];

499

$.each(lines, function(idx) {

500

var line = lines[idx];

501

if (skip) {

502

if (line.includes('Upcoming Events')) {

skip = false;

}

} else {

if (!line) { return; };

507

line = line.split('](');

508

var tail = line[1].split(') ');

509

result.push(

510

'<a class="announcement-link" rel="external nofollow" target="_blank" href="' +

511

tail[0] + '">' + line[0].replace('* [', '').replace('ClickHouse Meetup in ', '') +

512

'</a> ' + tail[1].slice(0, -1)

);

}

});

if (result.length) {

517

if (result.length == 1) {

518

result = 'Upcoming Meetup: ' + result[0];

519

} else {

520

result = 'Upcoming Meetups: ' + result.join(', ');

521

var offset = result.lastIndexOf(', ');

522

result = result.slice(0, offset) + result.slice(offset).replace(', ', ' and ');

523

}

524

$('#announcement>.page').html(result);

525

}

526

});

527

var name = $('#main-title').text().trim().toLowerCase();

528

var feedback_address = name + '-feedback' + '@yandex-team.com';

529

var feedback_email = $('#feedback_email');

530

feedback_email.attr('href', 'mailto:' + feedback_address);

531

feedback_email.html(feedback_address);

532

533

$("a[href^='#']").on('click', function (e) {

534

e.preventDefault();

535

var selector = $(e.target).attr('href');

var offset = 0;

if (selector) {

offset = $(selector).offset().top - $('#logo').height() * 1.5;

540

}

541

$('html, body').animate({

542

scrollTop: offset

543

}, 500);

544

            window.history.replaceState('', document.title, window.location.href.replace(location.hash, '') + this.hash);

545

});

546

547

var hostParts = window.location.host.split('.');

548

if (hostParts.length > 2 && hostParts[0] != 'test') {

549

window.location.host = hostParts[0] + '.' + hostParts[1];

550

}

551

552

var available_distributives = ['deb', 'rpm'];

553

var selected_distributive = 'deb';

554

555

function refresh_distributives() {

556

available_distributives.forEach(function (name) {

557

if (name == selected_distributive) {

558

$('#repo_' + name).attr("class", "distributive_selected");

559

$('#instruction_' + name).show();

560

} else {

561

$('#repo_' + name).attr("class", "distributive_not_selected");

562

$('#instruction_' + name).hide();

}

});

};

refresh_distributives();

568

569

available_distributives.forEach(function (name) {

570

$('#repo_' + name).on('click', function () {

571

selected_distributive = name;

572

refresh_distributives();

});

});

});

</script>

579

<script type="text/javascript">

580

(function (d, w, c) {

581

(w[c] = w[c] || []).push(function() {

582

try {

583

w.yaCounter18343495 = new Ya.Metrika2({

id:18343495,

clickmap:true,

trackLinks:true,

accurateTrackBounce:true,

webvisor:true

});

} catch(e) { }

});

var n = d.getElementsByTagName("script")[0],

594

s = d.createElement("script"),

595

f = function () { n.parentNode.insertBefore(s, n); };

596

s.type = "text/javascript";

597

s.async = true;

598

s.src = "https://mc.yandex.ru/metrika/tag.js";

599

600

if (w.opera == "[object Opera]") {

601

d.addEventListener("DOMContentLoaded", f, false);

602

} else { f(); }

603

})(document, window, "yandex_metrika_callbacks2");

604

</script>

605

<noscript>

606

<div><img src="https://mc.yandex.ru/watch/18343495" style="position:absolute; left:-9999px;" alt=""/></div>

607

</noscript>

608

609

</body>

610

</html>

cloudflare/ClickHouse

Branches

Tags

Clone

website/index.html