, column 44: Table 'PCOLLECTION' not found
From: Andrew Pilloud
Date: Tuesday, May 11, 2021 at 10:38 PM
To: Tao Li
Cc: "user@beam.apache.org" , Yuan Feng
Subject: Re: A problem with calcite sql
If the type was just a nested row this shoul
t;
> *From: *Andrew Pilloud
> *Date: *Tuesday, May 11, 2021 at 11:51 AM
> *To: *Tao Li
> *Cc: *"user@beam.apache.org" , Yuan Feng <
> yua...@zillowgroup.com>
> *Subject: *Re: A problem with calcite sql
>
>
>
> SELECT CAST('CAST(id AS VARCHAR)'
umn 'market_transactionManagement_transactionManagers.email' not found in
any table
So what would be the right syntax? Thanks!
From: Andrew Pilloud
Date: Tuesday, May 11, 2021 at 11:51 AM
To: Tao Li
Cc: "user@beam.apache.org" , Yuan Feng
Subject: Re: A problem with calcite sql
s.java:911)
>
> at
> org.apache.beam.sdk.schemas.utils.AvroUtils.toAvroField(AvroUtils.java:306)
>
> at
> org.apache.beam.sdk.schemas.utils.AvroUtils.toAvroSchema(AvroUtils.java:341)
>
> at
> org.apache.beam.sdk.schemas.utils.AvroUti
.AvroUtils.toAvroSchema(AvroUtils.java:341)
at
org.apache.beam.sdk.schemas.utils.AvroUtils.toAvroSchema(AvroUtils.java:348)
From: Andrew Pilloud
Reply-To: "user@beam.apache.org"
Date: Monday, May 10, 2021 at 7:46 PM
To: user
Cc: Yuan Feng
Subject: Re: A problem with calcite sql
For the first one
> at
> org.apache.beam.sdk.schemas.utils.AvroUtils.toAvroSchema(AvroUtils.java:341)
>
> at
> org.apache.beam.sdk.schemas.utils.AvroUtils.toAvroSchema(AvroUtils.java:348)
>
>
>
>
>
> *From: *Tao Li
> *Reply-To: *"user@beam.apache.or
n Feng
Subject: Re: A problem with calcite sql
Never mind. Looks like “user” is a reserved name.
From: Tao Li
Reply-To: "user@beam.apache.org"
Date: Monday, May 10, 2021 at 7:10 PM
To: "user@beam.apache.org"
Cc: Yuan Feng
Subject: A problem with calcite sql
Hi Beam communit
Never mind. Looks like “user” is a reserved name.
From: Tao Li
Reply-To: "user@beam.apache.org"
Date: Monday, May 10, 2021 at 7:10 PM
To: "user@beam.apache.org"
Cc: Yuan Feng
Subject: A problem with calcite sql
Hi Beam community,
I am seeing a weird issue by using
Hi Beam community,
I am seeing a weird issue by using calcite sql. I don’t understand why it’s
complaining my query is not valid. Once I removed “user AS user”, it worked
fine. Please advise. Thanks.
Exception in thread "main"
org.apache.beam.sdk.extensions.sql.impl.ParseException: Unable to p
