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)

Reply via email to