Hi, I am trying to build an adapter for avro files, analogous to the csv example. While scalar types work fine, I am having trouble getting an unnest query to run. The example I found in the code is something like this:
select a.*, b.* from table1 as a, unnest(a.items) as b; Two questions: 1) I always got the error message: "table A not found". It seems that the corresponding test is currently set to ignore, and if ran it yields the same error org.apache.calcite.test.JdbcTest.testUnnestArrayColumn() 2) As a way to proceed further i now check for select * from unnest(schema1.table1.items) but this also gives a table not found error message. It seems that the org.apache.calcite.sql.validate.SqlValidatorImpl always looks for schemas and tables with a "CATALOG" prefix and never finds the table / schema. This might be related to my knowledge of the overall architecture, but i am following the csv examples. Any help would be appreciated! Johannes
