Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] MV creation issue when using window.start as a paramater. #1819

Closed
ps48 opened this issue May 4, 2024 · 0 comments
Closed

[BUG] MV creation issue when using window.start as a paramater. #1819

ps48 opened this issue May 4, 2024 · 0 comments
Assignees
Labels
bug Something isn't working

Comments

@ps48
Copy link
Member

ps48 commented May 4, 2024

What is the bug?
Create acceleration flyout fails to create an acceleration when window.start is used as a paramater in the MV aggregations.

How can one reproduce the bug?
Steps to reproduce the behavior:

  1. Go to create acceleration flyout
  2. Click on create acceleration with MV and add window.start as a paramater
  3. Scroll down to see the generated query
  4. Click on create acceleration

Work around
Today users have a work around to this, that they can edit in workbench and remove the backticks for window.start command in MV

FROM:
CREATE MATERIALIZED VIEW myglue.default.mv_1
AS SELECT
   count(`@timestamp`) AS `counter1`, 
   `window.start`
FROM myglue.default.reddyvam
GROUP BY TUMBLE (`@timestamp`, '1 minute')
 WITH (
index_settings = '{"number_of_shards":1,"number_of_replicas":1}',
auto_refresh = true,
refresh_interval = '15 minutes',
watermark_delay = '1 minute',
checkpoint_location = 's3://ckpt'
)

TO:
CREATE MATERIALIZED VIEW myglue.default.mv_1
AS SELECT
   count(`@timestamp`) AS `counter1`, 
   window.start
FROM myglue.default.reddyvam
GROUP BY TUMBLE (`@timestamp`, '1 minute')
 WITH (
index_settings = '{"number_of_shards":1,"number_of_replicas":1}',
auto_refresh = true,
refresh_interval = '15 minutes',
watermark_delay = '1 minute',
checkpoint_location = 's3://ckpt'
)

What is the expected behavior?
The expected behavior is that the MV creation succeeds and window.start is quoted properly.

What is your host/environment?

  • OS: Linux
  • Version: 2.13
  • Plugins: dashboards-observability

Do you have any screenshots?
Screenshot 2024-05-03 at 11 53 34 PM

Do you have any additional context?
Add any other context about the problem.

@ps48 ps48 added bug Something isn't working untriaged and removed untriaged labels May 4, 2024
@ps48 ps48 self-assigned this May 4, 2024
@ps48 ps48 removed the untriaged label May 4, 2024
@ps48 ps48 closed this as completed May 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant