invalidQuery: Syntax error: Unexpected identifier "String" at

[clemishow]

Bug Report

I'm trying to make this query work, but I'm getting an error message.
invalidQuery: Syntax error: Unexpected identifier "String" at [4:36]

#standardSQL
SELECT
 TIMESTAMP(PARSE_DATE('%Y%m%d', _TABLE_SUFFIX)) AS time,
  CAST (param.value.string_valueAS String ) AS metric,
  count(*) AS nb
FROM `neocity.analytics.events_*`, UNNEST(event_params) as param
WHERE
  event_name = 'screen_view' AND
  param.value.string_value != 'null'
GROUP BY 1,2 
ORDER BY 1,2 LIMIT 686

Expected Behavior

CAST (param.value.string_valueAS String ) AS metric,

Put a space between value and AS

Actual Behavior

Error message

Specifications

• Version: efbcbb838b
• Platform: AWS Docker
• Grafana Version: 7.0.5

[Tamirk]

Hi @clemishow can you let us know which version of our plugin you are using

[clemishow]

1.0.6

[Tamirk]

Ok, We are waiting for 2.0.0 to be officially published, Once publish please test your issue with the latest version and if you still face an issue we'll fix this

[spark2ignite]

@tamir Klein <tamir@doit-intl.com> I don't see anything on 2.0 that fixes this issue. Vadim Solovey | GM // DoiT International

…

On Thu, Jul 16, 2020 at 6:36 PM Tamir Klein ***@***.***> wrote: Ok, We are waiting for 2.0.0 to be officially published, Once publish please test your issue with the latest version and if you still face an issue we'll fix this — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#257 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABLWF7YATFTV6JVA2C67MBTR34M6RANCNFSM4O4JJLRQ> .

[Tamirk]

@clemishow We see an error in your SQL (missing space) can you replace this line

CAST (param.value.string_valueAS String ) AS metric,

With this
CAST (param.value.string_value AS String ) AS metric,

Note: I added a space between param.value.string_value and the AS keyword

[clemishow]

The error comes from Query Builder which doesn't put the space