You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@flink.apache.org by "Jark Wu (Jira)" <ji...@apache.org> on 2021/01/14 12:26:00 UTC

[jira] [Commented] (FLINK-20970) DECIMAL(10, 0) can not be GROUP BY key.

    [ https://issues.apache.org/jira/browse/FLINK-20970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17264860#comment-17264860 ] 

Jark Wu commented on FLINK-20970:
---------------------------------

Hi [~ana4], could you share the full example including the source DDL? This mostly because of the wrong type defined in the source. 
Besides, did you try this on the 1.12.0? This might not happen in the new version. 

> DECIMAL(10, 0) can not be GROUP BY key.
> ---------------------------------------
>
>                 Key: FLINK-20970
>                 URL: https://issues.apache.org/jira/browse/FLINK-20970
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Runtime
>    Affects Versions: 1.10.1
>            Reporter: Wong Mulan
>            Priority: Major
>         Attachments: image-2021-01-14-17-06-28-648.png
>
>
> If value which type is not DECIMAL(38, 18) is GROUP BY key, the result will be -1.
> So, only DECIMAL(38, 18) can be GROUP BY key?
> Whatever the value is, it will be return -1.
>  !image-2021-01-14-17-06-28-648.png|thumbnail! 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)