[
https://issues.apache.org/jira/browse/FLINK-9907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16552053#comment-16552053
]
ASF GitHub Bot commented on FLINK-9907:
---------------------------------------
GitHub user xueyumusic opened a pull request:
https://github.com/apache/flink/pull/6382
[FLINK-9907][Table API & SQL] add CRC32 support
## What is the purpose of the change
This PR adds CRC32 checksum compute in table api and sql.It returns the
cyclic redundancy check value of a given string as a 32-bit unsigned value,
null if string is null
The syntax is like `CRC32('test') = 3632233996`
## Brief change log
*expressionDsl and hashExpression Api*
*codegen and HashCalCallGen*
## Verifying this change
This change added tests and can be verified as follows:
- *Added ScalarFunctionsTest*
## Does this pull request potentially affect one of the following parts:
- Dependencies (does it add or upgrade a dependency): (no)
- The public API, i.e., is any changed class annotated with
`@Public(Evolving)`: (no)
- The serializers: (no)
- The runtime per-record code paths (performance sensitive): (no)
- Anything that affects deployment or recovery: JobManager (and its
components), Checkpointing, Yarn/Mesos, ZooKeeper: (no)
- The S3 file system connector: (no)
## Documentation
- Does this pull request introduce a new feature? (yes)
- If yes, how is the feature documented? (not documented yet, patch doc
afterward)
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/xueyumusic/flink crc32
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/flink/pull/6382.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #6382
----
commit 4dddb4ea8298b67af22d66b67c6a38cb596c9447
Author: xueyu <278006819@...>
Date: 2018-07-22T13:23:00Z
crc32 support
----
> add CRC32 checksum in table Api and sql
> ---------------------------------------
>
> Key: FLINK-9907
> URL: https://issues.apache.org/jira/browse/FLINK-9907
> Project: Flink
> Issue Type: New Feature
> Components: Table API & SQL
> Reporter: xueyu
> Priority: Major
> Labels: pull-request-available
>
> CRC32 returns the cyclic redundancy check value of a given string as a 32-bit
> unsigned value, null if string is null. In mysql and hive the syntax like
> select CRC32('test') = 3632233996
> Though it is not a hash function, however the pattern and behavior looks
> similar with hash functions (md5, sha1, sha2 etc..), so I put codegen in
> HashCalcCallGen
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
