Liu created FLINK-38988:
---------------------------
Summary: Support INET_ATON and INET_NTOA functions for IP address
conversion
Key: FLINK-38988
URL: https://issues.apache.org/jira/browse/FLINK-38988
Project: Flink
Issue Type: Improvement
Components: Table SQL / API
Reporter: Liu
## Motivation
IP address conversion between string and numeric formats is a common
requirement in data analysis scenarios, especially for:
- Log analysis and processing
- Network security analysis
- User behavior tracking and analytics
Currently, Flink SQL does not provide built-in functions for IP address
conversion. Users have to implement UDFs to achieve this functionality, which
increases development overhead and reduces portability.
## Proposal
Add two built-in scalar functions following MySQL's naming convention:
### 1. INET_ATON(ip_string)
Converts an IPv4 address string to its numeric representation (BIGINT).
### 2. INET_NTOA(ip_number)
Converts a numeric IP address representation back to its string format.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)