Help for Fixing TpcdsLatticeSuggesterTest in calcite

2022-04-29 Thread wangcheng (AK)
Hi, I'm planning to use the lattice suggester in Calcite with TPC-DS, but the TpcdsLatticeSuggesterTest in Calcite fails in the 1st query. I run the TpcdsLatticeSuggesterTest with Disabled annotation removed. The error is shown below: Can't unwrap class org.apache.calcite.sql.SqlDialect from

Re: Column 'x' not found in any table

2022-04-29 Thread Julian Hyde
'x' is a table alias, not a column alias. There are some very limited circumstances in which a table alias applied to a table with an anonymous column causes the anonymous column to be renamed. Evidently those circumstances apply to case 1 but not case 2. On Fri, Apr 29, 2022 at 8:51 AM Dmitry

Column 'x' not found in any table

2022-04-29 Thread Dmitry Sysolyatin
Hi! Maybe someone knows what can be the cause of the following issue: I tried to execute two queries: val query1 = "SELECT x FROM unnest(array[1]) x" val query2 = "SELECT x FROM unnest(array(select 1)) x" The first one works, but the second one throws an exception: Column 'x' not found in any

[jira] [Created] (CALCITE-5125) "||" operator can be used for array concatenation

2022-04-29 Thread Dmitry Sysolyatin (Jira)
Dmitry Sysolyatin created CALCITE-5125: -- Summary: "||" operator can be used for array concatenation Key: CALCITE-5125 URL: https://issues.apache.org/jira/browse/CALCITE-5125 Project: Calcite