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