You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by vo...@apache.org on 2022/09/22 03:50:28 UTC
[druid] 01/03: fix quickstart (#13126)
This is an automated email from the ASF dual-hosted git repository.
vogievetsky pushed a commit to branch 24.0.0
in repository https://gitbox.apache.org/repos/asf/druid.git
commit d792c28bb757c5627d546dd66db49355bc12f8b0
Author: Vadim Ogievetsky <va...@ogievetsky.com>
AuthorDate: Tue Sep 20 17:44:21 2022 -0700
fix quickstart (#13126)
---
docs/assets/tutorial-query-01.png | Bin 81402 -> 48774 bytes
docs/assets/tutorial-query-02.png | Bin 155423 -> 86083 bytes
docs/assets/tutorial-query-03.png | Bin 197392 -> 120017 bytes
docs/assets/tutorial-query-035.png | Bin 256043 -> 0 bytes
docs/assets/tutorial-query-04.png | Bin 250861 -> 135419 bytes
docs/assets/tutorial-query-05.png | Bin 51855 -> 153221 bytes
docs/assets/tutorial-query-06.png | Bin 208088 -> 138730 bytes
docs/assets/tutorial-query-07.png | Bin 260071 -> 149016 bytes
docs/assets/tutorial-query-08.png | Bin 297253 -> 0 bytes
docs/assets/tutorial-quickstart-04.png | Bin 144088 -> 129369 bytes
docs/assets/tutorial-quickstart-05.png | Bin 84116 -> 110367 bytes
docs/tutorials/index.md | 9 +++++----
docs/tutorials/tutorial-query.md | 20 ++++++++------------
13 files changed, 13 insertions(+), 16 deletions(-)
diff --git a/docs/assets/tutorial-query-01.png b/docs/assets/tutorial-query-01.png
index 371d35dec2..c8455f6420 100644
Binary files a/docs/assets/tutorial-query-01.png and b/docs/assets/tutorial-query-01.png differ
diff --git a/docs/assets/tutorial-query-02.png b/docs/assets/tutorial-query-02.png
index f459bd6996..852d5fde24 100644
Binary files a/docs/assets/tutorial-query-02.png and b/docs/assets/tutorial-query-02.png differ
diff --git a/docs/assets/tutorial-query-03.png b/docs/assets/tutorial-query-03.png
index 29443edb26..725d373b6f 100644
Binary files a/docs/assets/tutorial-query-03.png and b/docs/assets/tutorial-query-03.png differ
diff --git a/docs/assets/tutorial-query-035.png b/docs/assets/tutorial-query-035.png
deleted file mode 100644
index f22db18f19..0000000000
Binary files a/docs/assets/tutorial-query-035.png and /dev/null differ
diff --git a/docs/assets/tutorial-query-04.png b/docs/assets/tutorial-query-04.png
index 9cfef34ccd..8715cde1b2 100644
Binary files a/docs/assets/tutorial-query-04.png and b/docs/assets/tutorial-query-04.png differ
diff --git a/docs/assets/tutorial-query-05.png b/docs/assets/tutorial-query-05.png
index 2fc59ceb33..a56a0ed5aa 100644
Binary files a/docs/assets/tutorial-query-05.png and b/docs/assets/tutorial-query-05.png differ
diff --git a/docs/assets/tutorial-query-06.png b/docs/assets/tutorial-query-06.png
index 705605607a..d17ae10cba 100644
Binary files a/docs/assets/tutorial-query-06.png and b/docs/assets/tutorial-query-06.png differ
diff --git a/docs/assets/tutorial-query-07.png b/docs/assets/tutorial-query-07.png
index 5997ba2f76..ddcda873cd 100644
Binary files a/docs/assets/tutorial-query-07.png and b/docs/assets/tutorial-query-07.png differ
diff --git a/docs/assets/tutorial-query-08.png b/docs/assets/tutorial-query-08.png
deleted file mode 100644
index 32aa5d48a7..0000000000
Binary files a/docs/assets/tutorial-query-08.png and /dev/null differ
diff --git a/docs/assets/tutorial-quickstart-04.png b/docs/assets/tutorial-quickstart-04.png
index 431d8b97c8..e847ef550c 100644
Binary files a/docs/assets/tutorial-quickstart-04.png and b/docs/assets/tutorial-quickstart-04.png differ
diff --git a/docs/assets/tutorial-quickstart-05.png b/docs/assets/tutorial-quickstart-05.png
index 6178289fdc..da3ed0dfa6 100644
Binary files a/docs/assets/tutorial-quickstart-05.png and b/docs/assets/tutorial-quickstart-05.png differ
diff --git a/docs/tutorials/index.md b/docs/tutorials/index.md
index 68d4475324..7d3d2ab68e 100644
--- a/docs/tutorials/index.md
+++ b/docs/tutorials/index.md
@@ -184,8 +184,9 @@ Follow these steps to load the sample Wikipedia dataset:
```
</details>
-6. Optionally, click **Preview** to see the general shape of the data before you ingest it.
-7. Click **Run** to execute the query. The task may take a minute or two to complete. When done, the task displays its duration and the number of rows inserted into the table. The view is set to automatically refresh, so you don't need to refresh the browser to see the status change.
+6. Optionally, click **Preview** to see the general shape of the data before you ingest it.
+7. Edit the first line of the query and change the default destination datasource name from `wikiticker-2015-09-12-sampled` to `wikipedia`.
+8. Click **Run** to execute the query. The task may take a minute or two to complete. When done, the task displays its duration and the number of rows inserted into the table. The view is set to automatically refresh, so you don't need to refresh the browser to see the status change.
@@ -201,7 +202,7 @@ In the **Query** view, run the following query to produce a list of top channels
SELECT
channel,
COUNT(*)
-FROM "wikiticker-2015-09-12-sampled"
+FROM "wikipedia"
GROUP BY channel
ORDER BY COUNT(*) DESC
```
@@ -214,7 +215,7 @@ Congratulations! You've gone from downloading Druid to querying data with the MS
See the following topics for more information:
-* [Druid SQL overview](../querying/sql.md) to learn about how to query the data you just ingested.
+* [Druid SQL overview](../querying/sql.md) or the [Query tutorial](./tutorial-query.md) to learn about how to query the data you just ingested.
* [Ingestion overview](../ingestion/index.md) to explore options for ingesting more data.
* [Tutorial: Load files using SQL](./tutorial-msq-extern.md) to learn how to generate a SQL query that loads external data into a Druid datasource.
* [Tutorial: Load data with native batch ingestion](tutorial-batch-native.md) to load and query data with Druid's native batch ingestion feature.
diff --git a/docs/tutorials/tutorial-query.md b/docs/tutorials/tutorial-query.md
index 94f0e85d33..cd91e4101f 100644
--- a/docs/tutorials/tutorial-query.md
+++ b/docs/tutorials/tutorial-query.md
@@ -64,21 +64,17 @@ create a query for the page dimension.
returns no data, since by default the query filters for data from the last day, while our data is considerably
older than that. Let's remove the filter.
-5. In the datasource tree, click `__time` and **Remove Filter**.
-
- 
-
-6. Click **Run** to run the query.
+5. Click **Run** to run the query.
You should now see two columns of data, a page name and the count:
- 
+ 
Notice that the results are limited in the console to about a hundred, by default, due to the **Smart query limit**
feature. This helps users avoid inadvertently running queries that return an excessive amount of data, possibly
overwhelming their system.
-7. Let's edit the query directly and take a look at a few more query building features in the editor.
+6. Let's edit the query directly and take a look at a few more query building features in the editor.
Click in the query edit pane and make the following changes:
1. Add a line after the first column, `"page"` and Start typing the name of a new column, `"countryName"`. Notice that the autocomplete menu suggests column names, functions, keywords, and more. Choose "countryName" and
@@ -108,7 +104,7 @@ returns the number of edits for the page. Make the same column name change in th
is null. Let's
show only rows with a `countryName` value.
-8. Click the countryName dimension in the left pane and choose the first filtering option. It's not exactly what we want, but
+7. Click the `countryName` dimension in the left pane and choose the first filtering option. It's not exactly what we want, but
we'll edit it by hand. The new WHERE clause should appear in your query.
8. Modify the WHERE clause to exclude results that do not have a value for countryName:
@@ -118,7 +114,7 @@ we'll edit it by hand. The new WHERE clause should appear in your query.
```
Run the query again. You should now see the top edits by country:
- 
+ 
9. Under the covers, every Druid SQL query is translated into a query in the JSON-based _Druid native query_ format before it runs
on data nodes. You can view the native query for this query by clicking `...` and **Explain SQL Query**.
@@ -126,7 +122,7 @@ we'll edit it by hand. The new WHERE clause should appear in your query.
While you can use Druid SQL for most purposes, familiarity with native query is useful for composing complex queries and for troubleshooting
performance issues. For more information, see [Native queries](../querying/querying.md).
- 
+ 
> Another way to view the explain plan is by adding EXPLAIN PLAN FOR to the front of your query, as follows:
>
@@ -163,7 +159,7 @@ FROM wikipedia WHERE TIME_IN_INTERVAL("__time", '2015-09-12/2015-09-13')
GROUP BY 1
```
-
+
### General group by
@@ -174,7 +170,7 @@ GROUP BY channel, page
ORDER BY SUM(added) DESC
```
-
+
## Other ways to invoke SQL queries
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org