Re: BeamSql query failure on complex data structures

2020-12-16 Thread Robin Qiu
5, 2020 at 5:13 PM Andrew Pilloud > wrote: > >> Are these issues you are aware of? >> >> -- Forwarded message - >> From: Aspen Barnes >> Date: Tue, Dec 15, 2020 at 12:42 PM >> Subject: BeamSql query failure on complex data structures >&g

Re: BeamSql query failure on complex data structures

2020-12-15 Thread Kyle Weaver
Hi Aspen, if the issue has been fixed on Calcite's side, it is waiting for an overdue upgrade of the Calcite version Beam uses (tracked by [1]). Currently Beam depends on Calcite 1.20, and it looks like that issue was fixed in Calcite 1.21 [2]. [1] https://issues.apache.org/jira/browse/BEAM-9379

Re: BeamSql query failure on complex data structures

2020-12-15 Thread Ahmet Altay
+Andrew Pilloud +Robin Qiu On Tue, Dec 15, 2020 at 12:42 PM Aspen Barnes wrote: > Hello, I have recently encountered an issue with BeamSql queries against > complex data structures. See > https://issues.apache.org/jira/browse/BEAM-11140 for info. Essentially, > the query code generation is

BeamSql query failure on complex data structures

2020-12-15 Thread Aspen Barnes
Hello, I have recently encountered an issue with BeamSql queries against complex data structures. See https://issues.apache.org/jira/browse/BEAM-11140 for info. Essentially, the query code generation is failing past a certain depth, which is not hard to achieve with subqueries and nested data