Commit Graph

297 Commits

Author SHA1 Message Date
Dan Roscigno
8d7d1cf682
Merge branch 'ClickHouse:master' into add-vis-to-cell-towers 2022-11-02 07:58:15 -04:00
Derek Chia
29318a1e13
Update nyc-taxi.md
- Add enum 'UNK' = 5 to `payment_type` to avoid `Unknown element 'UNK' for enum` error when loading trips_*.gz
- Change url table function to s3 table function as described in the earlier paragraph
2022-11-01 18:03:17 +08:00
DanRoscigno
e3a2079ef0 grammar 2022-10-31 09:04:47 -04:00
Dan Roscigno
bb15156b1f
Merge branch 'ClickHouse:master' into add-vis-to-cell-towers 2022-10-28 15:58:30 -04:00
DanRoscigno
030111ac11 add image for UMTS radio 2022-10-28 15:56:48 -04:00
DanRoscigno
be85232610 new images 2022-10-28 14:36:00 -04:00
DanRoscigno
418539cd51 add images 2022-10-28 11:54:44 -04:00
DanRoscigno
1ec10ade5b add link to geo fn, fix index 2022-10-28 09:56:16 -04:00
DanRoscigno
52ca29140e WIP: add Superset deploy instructions 2022-10-21 12:27:20 -04:00
Dan Roscigno
b125fd8718
Update uk-price-paid.md 2022-10-18 09:34:53 -04:00
Dan Roscigno
f4f85a069b
Go live with doc updates (#42053)
* QIP to add overview page

* wip

* New Tutorial and Datasets landing page

* give an example for Cloud

* Update UK Price Paid for Cloud

* Update nyc-taxi.md

* add option for Cloud Load Data button

* Removed the Import Raw Data section

* Update nyc-taxi.md

* update user management and replication docs

* mark self managed

* set doc ordering

* add redirects setting

* Simple fixes to index.md

Co-authored-by: rfraposa <richraposa@gmail.com>
2022-10-04 14:36:59 +03:00
Alexey Milovidov
a92e24fdc1
Update criteo.md 2022-09-30 17:37:51 +03:00
Dalitso Banda
b7d65f7a2d
Update criteo.md
The new spec states that MergeTree does not take any parameters. Updating the doc to reflect this.
2022-09-29 20:17:42 -07:00
DanRoscigno
f2cbe97223 reformat cell tower example doc 2022-09-23 13:28:29 -04:00
DanRoscigno
3073da9ba5 move doc 2022-09-06 18:39:06 -04:00
Alexey Milovidov
1768a82a53 git checkout c4b8137d31 docs/en/getting-started/example-datasets/uk-price-paid.md 2022-09-03 06:45:18 +02:00
DanRoscigno
6efd07cbc8 correct statement 2022-09-01 20:32:06 -04:00
DanRoscigno
662eed214f correct statements 2022-09-01 20:28:25 -04:00
Ivan Blinkov
a947487afe
[docs] fix link markdown 2022-09-01 18:16:13 +03:00
Dan Roscigno
29ac78a92b
Update uk price paid (#40828) 2022-09-01 13:32:33 +02:00
DanRoscigno
c4b8137d31 replace symlinks 2022-08-29 12:19:50 -04:00
DanRoscigno
b50fa8b5a9 replace symlinks 2022-08-28 17:34:50 -04:00
DanRoscigno
5b5fcc56aa add slugs 2022-08-28 10:53:34 -04:00
Alexey Milovidov
441f2feb49 Cleanup usages of allow_experimental_projection_optimization setting, part 1 2022-07-30 23:40:21 +02:00
Dan Roscigno
29ffee8464
typo 2022-07-02 19:24:26 -04:00
Dan Roscigno
e092eff474
Update brown-benchmark.md 2022-06-23 21:46:20 -04:00
DanRoscigno
accc479d88 revert query changes, add setting 2022-06-23 09:54:11 -04:00
DanRoscigno
29bd036013 separated queries, specified UNION DISTINCT 2022-06-22 21:58:43 -04:00
Dan Roscigno
867c3cde59
Update metrica.md
Fix reference, change `What's Next` to `Next Steps`
2022-06-16 10:01:40 -04:00
DanRoscigno
34ce566fa8 removed prepared parts from doc 2022-06-10 10:08:40 -04:00
DanRoscigno
e529007d61 add sample query 2022-06-08 18:15:30 -04:00
DanRoscigno
9c3bcf4db6 add info on where the data dir is 2022-06-08 16:11:20 -04:00
rfraposa
869967de41 Remove H1 anchor tags from docs 2022-06-02 04:55:18 -06:00
Alexey Milovidov
6195429020
Update star-schema.md 2022-05-29 10:01:27 +03:00
Alexey Milovidov
c8935d6e6c
Update star-schema.md 2022-05-29 10:00:34 +03:00
Alexey Milovidov
e22a79eaf2
Update star-schema.md 2022-05-29 09:58:54 +03:00
Alexey Milovidov
be586f7b33
Update ontime.md 2022-05-29 06:43:50 +03:00
Alexey Milovidov
73c89e65e6
Update ontime.md 2022-05-29 06:31:15 +03:00
Alexey Milovidov
7be278c9ff
Update table structure for "ontime" dataset 2022-05-29 06:26:13 +03:00
Alexey Milovidov
39a55991ca Change Playground URL in the docs 2022-05-28 01:18:07 +02:00
Alexey Milovidov
f3e83cb222
Update star-schema.md 2022-05-28 01:51:41 +03:00
Dan Roscigno
f35c893fbe move UK and Taxi datasets up 2022-05-12 14:32:13 -04:00
Alexey Milovidov
5244065cdb
Update metrica.md 2022-05-07 13:04:46 +03:00
Brandon
e718e0a73b
update missing database name for hits_100m_obfuscated
in creare sql, database name for hits_100m_obfuscated is missing
2022-05-07 14:36:06 +08:00
rfraposa
6576fd88c1 EOL fixes 2022-04-19 13:50:45 -06:00
rfraposa
fb08c5b7e1 Merge branch 'master' into docs-staging 2022-04-15 07:25:27 -06:00
rfraposa
d9e6f780db Fixed broken links 2022-04-10 23:01:34 -06:00
rfraposa
4feb622c9f Added /zh docs 2022-04-10 17:08:18 -06:00
rfraposa
8f01fe9c49 Revised /en folder 2022-04-09 07:34:21 -06:00
rfraposa
5250d9ad11 Removed /ja folder, cleaned up /ru markdown 2022-04-09 07:29:05 -06:00
Dan Roscigno
51dc21a55c
add ' 2022-04-08 18:49:47 -04:00
Dan Roscigno
08dfce9a77
Prepared partitions differ from raw data
In both the system exposed at `gh-api.clickhouse.com/play` and in the prepared partitions the field `IATA_CODE_Reporting_Airline` has been renamed as `Carrier`, which breaks many of the queries.

Note: I assume that the raw data uses `IATA_CODE_Reporting_Airline`, but I do not have disk space to test.
2022-04-08 18:45:18 -04:00
Alexey Milovidov
9854b55835
Revert "Format changes for new docs" 2022-04-04 02:05:35 +03:00
rfraposa
c05bf7beb4 Testing new /en folder 2022-03-28 23:09:17 -06:00
rfraposa
ecbdfdea08 Incorporated feedback 2022-03-12 10:04:51 -06:00
rfraposa
5a4466cec7 Update references in docs 2022-03-12 00:24:31 -06:00
Ivan Blinkov
773806ae33
[docs] update nyc-taxi.md (#35217)
* Update nyc-taxi.md

* Update nyc-taxi.md

* Update nyc-taxi.md

* Update nyc-taxi.md
2022-03-11 23:39:05 +03:00
alexey-milovidov
2d7ff774fd
Update ontime.md 2021-11-24 02:48:18 +03:00
alexey-milovidov
d66a742371
Update nyc-taxi.md 2021-11-18 11:25:57 +03:00
alexey-milovidov
9b8f4bcff2
Update nyc-taxi.md 2021-11-07 04:25:26 +03:00
mergify[bot]
8852f933bc
Merge branch 'master' into yandex-to-clickhouse-in-configs 2021-09-29 21:48:43 +00:00
alexey-milovidov
995913e89c
Merge branch 'master' into yandex-to-clickhouse-in-configs 2021-09-28 02:27:36 +03:00
Roman Bug
0427d33d9f
Merge branch 'master' into romanzhukov-DOCSUP-14460-menus-dataset 2021-09-27 23:57:44 +03:00
mergify[bot]
64669a28ce
Merge branch 'master' into yandex-to-clickhouse-in-configs 2021-09-26 22:59:23 +00:00
romanzhukov
a14c5e30c7 Merge branch 'master' into romanzhukov-DOCSUP-14460-menus-dataset 2021-09-26 23:09:48 +03:00
romanzhukov
824a54d218 Links fixed 2021-09-26 17:07:52 +03:00
romanzhukov
ebca69e748 Merge branch 'master' into romanzhukov-DOCSUP-14103-OpenSky-UKProperty
# Conflicts:
#	docs/ru/getting-started/example-datasets/opensky.md
#	docs/ru/getting-started/example-datasets/uk-price-paid.md
2021-09-26 16:44:17 +03:00
alexey-milovidov
b8083929a6
Merge branch 'master' into yandex-to-clickhouse-in-configs 2021-09-23 20:49:40 +03:00
Mark Andreev
155c9773a6
Fix table schema for hits_100m_obfuscated
Add schema for hits_100m_obfuscated (copy from play.clickhouse.com instance)
2021-09-23 14:55:53 +03:00
alexey-milovidov
0b0be96f43
Update github-events.md 2021-09-22 23:56:42 +03:00
Alexey Milovidov
e9e77b4403 .tech -> .com 2021-09-22 03:22:57 +03:00
Ivan Blinkov
f429db1ee9 find . -type f -name '*.md'| xargs -I{} perl -pi -e 's|https://clickhouse.tech|https://clickhouse.com|g' {} 2021-09-19 23:05:54 +03:00
Roman Bug
391983d7ef
Update docs/en/getting-started/example-datasets/menus.md
Co-authored-by: olgarev <56617294+olgarev@users.noreply.github.com>
2021-09-19 16:25:32 +03:00
Roman Bug
bb1a8933a6
Update docs/en/getting-started/example-datasets/menus.md
Co-authored-by: olgarev <56617294+olgarev@users.noreply.github.com>
2021-09-19 16:25:08 +03:00
romanzhukov
4d788cee8c Fix link. 2021-09-16 18:03:35 +03:00
romanzhukov
327c3aa2fa Update translation 2021-09-16 18:01:14 +03:00
romanzhukov
d3e6b9044a Add anchors to all the headings. 2021-09-16 17:02:36 +03:00
romanzhukov
f9d6e6a7f5 Fix index pages. 2021-09-16 16:40:17 +03:00
romanzhukov
09d7d34d50 Fix PR comments. 2021-09-16 16:25:48 +03:00
romanzhukov
2249ed858e Add anchors to all the headings 2021-09-16 15:40:44 +03:00
Roman Bug
cdbbf76d4c
Update docs/en/getting-started/example-datasets/opensky.md
Co-authored-by: olgarev <56617294+olgarev@users.noreply.github.com>
2021-09-15 09:45:56 +03:00
romanzhukov
1be67e00cb Update translation. 2021-09-14 21:03:05 +03:00
romanzhukov
bc8dd77d0f Update menus dataset
- Update menus dataset.
- Add some crosslinks.
2021-09-14 15:36:35 +03:00
romanzhukov
2b6a471a8d Updating ru 2021-09-14 11:20:58 +03:00
romanzhukov
c4cf780850 Add summary section 2021-09-13 21:12:55 +03:00
romanzhukov
9700e2495a Fix errors 2021-09-13 20:52:16 +03:00
romanzhukov
3b5e6ebcd4 Fix link to prj 2021-09-13 20:31:04 +03:00
romanzhukov
3ce302c76c Update UK price paid.
Update UK price paid.
2021-09-13 17:29:51 +03:00
romanzhukov
057312a6f4 Update uk-price-paid.md 2021-09-12 19:58:02 +03:00
romanzhukov
7dc345fefa Update opensky eng/ru
Update opensky eng/ru
2021-09-10 14:06:21 +03:00
romanzhukov
6aaf2d4636 Upload from local PC. 2021-09-10 12:33:43 +03:00
Roman Zhukov
1f8ffce8eb Add touch drafts. 2021-09-06 18:24:59 +00:00
Roman Zhukov
4b46774b4c Add touch drafts. 2021-09-06 18:17:31 +00:00
alexey-milovidov
0aa800122d
Update menus.md 2021-08-20 12:28:23 +03:00
alexey-milovidov
d245eb1705
Merge pull request #27488 from ClickHouse/menus-dataset
Add menus (yummy dataset)
2021-08-09 22:49:22 +03:00
Alexey Milovidov
d584a55de7 Add menus (yummy dataset) 2021-08-09 20:52:41 +03:00
Alexey Milovidov
d64ee0337a Add menus (yummy dataset) 2021-08-09 20:49:38 +03:00
Alexey Milovidov
75eb3e318d Add menus (yummy dataset) 2021-08-09 20:47:52 +03:00
Denny Crane
fef50918ec
Update uk-price-paid.md 2021-08-09 11:17:35 -03:00
Denny Crane
6002b7b42d
Update uk-price-paid.md
added example with a projection
2021-08-09 11:13:19 -03:00
Alexey Milovidov
d159c83fb8 Add OpenSky dataset 2021-08-09 00:02:25 +03:00
Alexey Milovidov
844c0cf0ab Add UK Property Paid data 2021-08-08 22:16:53 +03:00
Alexey Milovidov
0f5d3963bd Add UK Property Paid data 2021-08-08 22:16:11 +03:00
Alexey Milovidov
b368c12400 Add UK Property Paid data 2021-08-08 22:15:18 +03:00
Alexey Milovidov
7631242a3b Add UK Property Paid data 2021-08-08 22:14:01 +03:00
alexey-milovidov
fdc965c579
Update recipes.md 2021-06-26 04:07:25 +03:00
yang
80587a5aa5
Update "Tail_Number" column type in create query
I found the CSV file "Tail_Number" value is like this: N517AE, so it should be the type String
2021-05-29 09:14:20 +08:00
eaxdev
669f6d22bd fix queries 2021-05-02 14:14:40 +03:00
eaxdev
be4d7d8636 actualize doc 2021-05-02 14:14:28 +03:00
ana-uvarova
90aed6bcbb comments edits 2021-04-08 17:24:56 +03:00
AnaUvarova
fd3b446efc
Update docs/en/getting-started/example-datasets/cell-towers.md
Co-authored-by: Anna <42538400+adevyatova@users.noreply.github.com>
2021-04-08 15:56:58 +03:00
AnaUvarova
095556d174
Update docs/en/getting-started/example-datasets/cell-towers.md
Co-authored-by: Anna <42538400+adevyatova@users.noreply.github.com>
2021-04-08 15:56:49 +03:00
AnaUvarova
edce1f5be9
Update docs/en/getting-started/example-datasets/cell-towers.md
Co-authored-by: Anna <42538400+adevyatova@users.noreply.github.com>
2021-04-08 15:56:35 +03:00
ana-uvarova
d9b0a1ce89 pre-final 2021-04-07 16:47:26 +03:00
ana-uvarova
5b3063d157 + edits for EN 2021-04-07 13:33:59 +03:00
ana-uvarova
f328bc3f09 Draft. 2021-04-06 17:37:36 +03:00
Roman Bug
7e88e05f61
Update docs/en/getting-started/example-datasets/recipes.md
Co-authored-by: Alexander Kuzmenkov <36882414+akuzm@users.noreply.github.com>
2021-03-19 12:16:45 +03:00
romanzhukov
7faf6698bb Update ru cake ) 2021-03-13 22:06:56 +03:00
romanzhukov
b316a0b45c Update ru cake ) 2021-03-13 21:44:42 +03:00
alexey-milovidov
9b633ac564
Update ontime.md 2021-02-28 23:27:01 +03:00
Alexey Milovidov
5e3c9a5deb Rename 2021-02-27 17:44:12 +03:00
Alexey Milovidov
2cafd54c17 Add new dataset: Cell Towers 2021-02-27 17:42:31 +03:00
Evgeniia Sudarikova
c285dafb5d edited brown benchmark 2021-02-05 22:20:07 +03:00
Evgeniia Sudarikova
2d0f742fda edited EN docs 2021-01-28 23:16:29 +03:00
alexey-milovidov
f35edecebb
Update ontime.md 2021-01-06 23:27:00 +03:00
alexey-milovidov
af0a359cea
Update metrica.md 2021-01-06 22:53:23 +03:00
alexey-milovidov
058cdcc62c
Update brown-benchmark.md 2021-01-06 22:50:08 +03:00
alexey-milovidov
8e0cbea738
Update brown-benchmark.md 2021-01-06 22:49:48 +03:00
Alexey Milovidov
04d8544151 Add description for Brown Benchmark 2021-01-04 20:30:58 +03:00
alexey-milovidov
850d584d3f
Update index.md 2020-12-21 08:44:08 +03:00
Alexey Milovidov
bb5dd8cb4b Add a link to playground 2020-12-20 14:11:30 +03:00
Alexey Milovidov
618a2b4ad3 Add recipes dataset 2020-12-20 14:02:55 +03:00
Alexey Milovidov
65e38a7a51 Add recipes dataset 2020-12-20 13:59:21 +03:00
Alexey Milovidov
6d87743b0e CDN for datasets 2020-12-13 21:06:27 +03:00
alexey-milovidov
9116eb7aca
Add checksums 2020-12-13 19:35:56 +03:00
alexey-milovidov
d75c7ec30c
Redundancy. 2020-12-13 19:28:45 +03:00
Alexey Milovidov
9a1f64cd15 Add GH dataset description 2020-12-10 02:27:12 +03:00
Alexey Milovidov
2760332a2a Add GH dataset description 2020-12-10 02:26:40 +03:00
alexey-milovidov
7986dbdfc7
Update ontime.md 2020-11-04 14:32:55 +03:00
Roman Bug
9ec78855cd
DOCSUP-2806: Add meta header in RU (#15801)
* DOCSUP-2806: Add meta intro.

* DOCSUP-2806: Update meta intro.

* DOCSUP-2806: Fix meta.

* DOCSUP-2806: Add quotes for meta headers.

* DOCSUP-2806: Remove quotes from meta headers.

* DOCSUP-2806: Add meta headers.

* DOCSUP-2806: Fix quotes in meta headers.

* DOCSUP-2806: Update meta headers.

* DOCSUP-2806: Fix link to nowhere in EN.

* DOCSUP-2806: Fix link (settings to tune)

* DOCSUP-2806: Fix links.

* DOCSUP-2806:Fix links EN

* DOCSUP-2806: Fix build errors.

* DOCSUP-2806: Fix meta intro.

* DOCSUP-2806: Fix toc_priority in examples datasets TOC.

* DOCSUP-2806: Fix items order in toc.

* DOCSUP-2806: Fix order in toc.

* DOCSUP-2806: Fix toc order.

* DOCSUP-2806: Fix order in toc.

* DOCSUP-2806: Fix toc index in create

* DOCSUP-2806: Fix toc order in create.

Co-authored-by: romanzhukov <romanzhukov@yandex-team.ru>
Co-authored-by: alexey-milovidov <milovidov@yandex-team.ru>
2020-10-26 13:29:30 +03:00
Alexey Milovidov
db4db42b65 Fix broken links in docs 2020-10-13 20:23:29 +03:00
alexey-milovidov
8225bc13fe
Fix terrible unbearable data rot. CC @blinkov 2020-07-28 21:42:30 +03:00
Ivan Blinkov
3070989983
[docs] minor refactoring 2020-07-20 18:19:08 +03:00
Ivan Blinkov
7170f3c534
[docs] split aggregate function and system table references (#11742)
* prefer relative links from root

* wip

* split aggregate function reference

* split system tables
2020-06-18 11:24:31 +03:00
alexey-milovidov
7cdf7a0901
Fix terrible data rott @blinkov 2020-05-05 20:44:18 +03:00
alexey-milovidov
f8682a4be4
Update metrica.md 2020-05-05 20:43:01 +03:00
Ivan Blinkov
d91c97d15d
[docs] replace underscores with hyphens (#10606)
* Replace underscores with hyphens

* remove temporary code

* fix style check

* fix collapse
2020-04-30 21:19:18 +03:00