Re: Max with retract aggregate function does not support type: ''CHAR''.
Hi Yuval,
yes this is rather a bug. If we support VARCHAR here we should also
support CHAR. Feel free to open an issue.
Regards,
Timo
On 03.02.21 11:46, Yuval Itzchakov wrote:
I can understand that in some sense it's nonsensical to MAX on a CHAR,
since Blink will only determine a CHAR when there's a constant in the
SQL, but I was surprised that it didn't work with just an identity
implementation.
On Wed, Feb 3, 2021 at 12:33 PM Till Rohrmann <mailto:trohrm...@apache.org>> wrote:
Thanks for reaching out to the Flink community Yuval. I am pulling
in Timo and Jark who might be able to answer this question. From
what I can tell, it looks a bit like an oversight because VARCHAR is
also supported.
Cheers,
Till
On Tue, Feb 2, 2021 at 6:12 PM Yuval Itzchakov mailto:yuva...@gmail.com>> wrote:
Hi,
I'm trying to use MAX on a field that is statically known from
another table (let's ignore why for a moment). While running the
SQL query, I receive an error:
Max with retract aggregate function does not support type: ''CHAR''.
Looking at the code for creating the max function:
image.png
It does seem like all primitives are supported. Is there a
particular reason why a CHAR would not be supported? Is this an
oversight?
--
Best Regards,
Yuval Itzchakov.
--
Best Regards,
Yuval Itzchakov.
Re: Max with retract aggregate function does not support type: ''CHAR''.
I can understand that in some sense it's nonsensical to MAX on a CHAR, since Blink will only determine a CHAR when there's a constant in the SQL, but I was surprised that it didn't work with just an identity implementation. On Wed, Feb 3, 2021 at 12:33 PM Till Rohrmann wrote: > Thanks for reaching out to the Flink community Yuval. I am pulling in Timo > and Jark who might be able to answer this question. From what I can tell, > it looks a bit like an oversight because VARCHAR is also supported. > > Cheers, > Till > > On Tue, Feb 2, 2021 at 6:12 PM Yuval Itzchakov wrote: > >> Hi, >> I'm trying to use MAX on a field that is statically known from another >> table (let's ignore why for a moment). While running the SQL query, I >> receive an error: >> >> Max with retract aggregate function does not support type: ''CHAR''. >> >> Looking at the code for creating the max function: >> >> [image: image.png] >> >> It does seem like all primitives are supported. Is there a particular >> reason why a CHAR would not be supported? Is this an oversight? >> -- >> Best Regards, >> Yuval Itzchakov. >> > -- Best Regards, Yuval Itzchakov.
Re: Max with retract aggregate function does not support type: ''CHAR''.
Thanks for reaching out to the Flink community Yuval. I am pulling in Timo and Jark who might be able to answer this question. From what I can tell, it looks a bit like an oversight because VARCHAR is also supported. Cheers, Till On Tue, Feb 2, 2021 at 6:12 PM Yuval Itzchakov wrote: > Hi, > I'm trying to use MAX on a field that is statically known from another > table (let's ignore why for a moment). While running the SQL query, I > receive an error: > > Max with retract aggregate function does not support type: ''CHAR''. > > Looking at the code for creating the max function: > > [image: image.png] > > It does seem like all primitives are supported. Is there a particular > reason why a CHAR would not be supported? Is this an oversight? > -- > Best Regards, > Yuval Itzchakov. >
Max with retract aggregate function does not support type: ''CHAR''.
Hi, I'm trying to use MAX on a field that is statically known from another table (let's ignore why for a moment). While running the SQL query, I receive an error: Max with retract aggregate function does not support type: ''CHAR''. Looking at the code for creating the max function: [image: image.png] It does seem like all primitives are supported. Is there a particular reason why a CHAR would not be supported? Is this an oversight? -- Best Regards, Yuval Itzchakov.
