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 <[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]
