This is an automated email from the ASF dual-hosted git repository.
vogievetsky pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/druid.git
The following commit(s) were added to refs/heads/master by this push:
new edc444a4bc fix quickstart (#13126)
edc444a4bc is described below
commit edc444a4bcec710ae8882d3af29106d41fd6a803
Author: Vadim Ogievetsky <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
