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.

Sign up for GitHub

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

Jump to bottom

no generate select 2.1 #284

Closed
igor9292 opened this issue Sep 1, 2020 · 4 comments · Fixed by #285 or grafana/grafana-plugin-repository#803
Closed

no generate select 2.1 #284

igor9292 opened this issue Sep 1, 2020 · 4 comments · Fixed by #285 or grafana/grafana-plugin-repository#803
Assignees
@Slach

Comments

@igor9292
Copy link

igor9292 commented Sep 1, 2020

systax error: failed at position 1(line 1, col)
no generate select

$columns(
substring(concat(JobName as JobName,' # ' , Metrics.MetricName as Metric), 1, 50) as JobSource,
sum(Metrics.Value) as Kafka_lag_max)
FROM $table
ARRAY JOIN Metrics
@Slach
Copy link
Collaborator

Slach commented Sep 2, 2020

@igor9292 thanks for reporting, I confirm, ARRAY JOIN doesn't parse properly cause the parser to expect ON|USING keyword after JOIN Metrics ...

could you suggest
do you have one $table
which contains Metrics field Nested structure?

@Slach Slach self-assigned this Sep 2, 2020
@Slach Slach mentioned this issue Sep 2, 2020
Merged
@Slach Slach closed this as completed in #285 Sep 2, 2020
@Slach
Copy link
Collaborator

Slach commented Sep 2, 2020

@igor9292 could you check your query with the latest master version and share results and reopen this issue if still reproduce?

@igor9292
Copy link
Author

igor9292 commented Oct 5, 2020

it's work

@Slach
Copy link
Collaborator

Slach commented Oct 6, 2020

nice to hear it ;)

Slach added a commit to Altinity/grafana-plugin-repository that referenced this issue Nov 30, 2020
@Slach
ClickHouse Database datasource plugin update to 2.2.0
398c50c 
# 2.2.0 (2020-11-30)
## Enhancement:

* add region support to annotation query, try to fix wrong column orders for table format, fix Altinity/clickhouse-grafana#303
* add plugin sign process, fix Altinity/clickhouse-grafana#212
* add `DateTime64` support, fix Altinity/clickhouse-grafana#292
* add `linux\arm64` backend plugin build
* improve ARRAY JOIN parsing, fix Altinity/clickhouse-grafana#284
* improve `docker-compose.yaml` add ability to redefine `GRAFANA_VERSION` and `CLICKHOUSE_VERSION` via environment variables `latest` by default

## Fixes:
* add `*.js.map` and `*.js` from src and spec folder to .gitignore
* don't apply adhoc filters twice when used $adhoc macros, fix Altinity/clickhouse-grafana#282
* fix corner case for table format with wrong columns order between meta and data response section, fix Altinity/clickhouse-grafana#281
* add trickster to docker-compose environment
* actualize links in README.md

Signed-off-by: Eugene Klimov <eklimov@altinity.com>
@Slach Slach mentioned this issue Nov 30, 2020
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Slach Slach

Labels
None yet
Projects
None yet
Milestone
No milestone
2 participants
@Slach @igor9292