[
https://issues.apache.org/jira/browse/BEAM-10461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17213297#comment-17213297
]
Jigyasa gROVER commented on BEAM-10461:
---------------------------------------
Hey Folks,
I am in a similar boat as well where I am dynamically trying to create multiple
temporary tables and then joining them for my final query in Beam and end up
facing identical issue of {{*BadRequest: 400 Syntax error: Unexpected keyword
CREATE at [1:16]*}}. Any updates on whether we'd be having this support in the
future? TIA :)
> ReadFromBigQuery read with script (temporary functions)
> -------------------------------------------------------
>
> Key: BEAM-10461
> URL: https://issues.apache.org/jira/browse/BEAM-10461
> Project: Beam
> Issue Type: Improvement
> Components: io-py-gcp
> Reporter: Gerard Casas Saez
> Priority: P3
>
> AS a user I have a custom function that I use for querying a table. As such,
> I would like to build a Query on a beam pipeline with the function inlined
> there. However it seems that currently Beam readers do not accept this as I
> get:
> ```
> {
> "error": {
> "code": 400,
> "message": "configuration.query.destinationTable cannot be set for
> scripts",
> "errors": [
> {
> "message": "configuration.query.destinationTable cannot be set for
> scripts",
> "domain": "global",
> "reason": "invalid"
> }
> ],
> "status": "INVALID_ARGUMENT"
> }
> }
> ```
> Wondering if anyone has a recommendation on how to add support for this?
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
