This is an automated email from the ASF dual-hosted git repository.
ningk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/beam.git
The following commit(s) were added to refs/heads/master by this push:
new c904971ab21 Fixed a SQL and screenshots in the Beam SQL blog (#17545)
c904971ab21 is described below
commit c904971ab21f04a8eff480c4f483b20ae3ee2fcc
Author: Ning Kang <ningkang0...@gmail.com>
AuthorDate: Wed May 4 13:12:59 2022 -0700
Fixed a SQL and screenshots in the Beam SQL blog (#17545)
Added the missing aggregations for the last example in the blog.
---
.../content/en/blog/beam-sql-with-notebooks.md | 3 ++-
.../images/blog/beam-sql-notebooks/image24.png | Bin 735928 -> 1827405
bytes
.../images/blog/beam-sql-notebooks/image25.png | Bin 91003 -> 259026 bytes
.../images/blog/beam-sql-notebooks/image26.png | Bin 192296 -> 679636 bytes
4 files changed, 2 insertions(+), 1 deletion(-)
diff --git a/website/www/site/content/en/blog/beam-sql-with-notebooks.md
b/website/www/site/content/en/blog/beam-sql-with-notebooks.md
index e6eca08fcf4..872a2a3004d 100644
--- a/website/www/site/content/en/blog/beam-sql-with-notebooks.md
+++ b/website/www/site/content/en/blog/beam-sql-with-notebooks.md
@@ -604,8 +604,9 @@ To run SQL on Dataflow is very simple, you just need to add
the option
```
%%beam_sql -o data_by_state -r DataflowRunner
-SELECT partition_date, state, confirmed_cases, deaths
+SELECT partition_date, state, SUM(confirmed_cases) as confirmed_cases,
SUM(deaths) as deaths
FROM covid_data
+GROUP BY partition_date, state
```
Different from previous `beam_sql` magic executions, you won’t see the result
diff --git a/website/www/site/static/images/blog/beam-sql-notebooks/image24.png
b/website/www/site/static/images/blog/beam-sql-notebooks/image24.png
index 6672a4ba175..83867f5e036 100644
Binary files
a/website/www/site/static/images/blog/beam-sql-notebooks/image24.png and
b/website/www/site/static/images/blog/beam-sql-notebooks/image24.png differ
diff --git a/website/www/site/static/images/blog/beam-sql-notebooks/image25.png
b/website/www/site/static/images/blog/beam-sql-notebooks/image25.png
index 7d1bdf6fdaa..b11bf5ff3ea 100644
Binary files
a/website/www/site/static/images/blog/beam-sql-notebooks/image25.png and
b/website/www/site/static/images/blog/beam-sql-notebooks/image25.png differ
diff --git a/website/www/site/static/images/blog/beam-sql-notebooks/image26.png
b/website/www/site/static/images/blog/beam-sql-notebooks/image26.png
index a8f0184c14e..70744d69ee5 100644
Binary files
a/website/www/site/static/images/blog/beam-sql-notebooks/image26.png and
b/website/www/site/static/images/blog/beam-sql-notebooks/image26.png differ
