[
https://issues.apache.org/jira/browse/HIVE-13944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15314904#comment-15314904
]
Glenn Strycker commented on HIVE-13944:
---------------------------------------
See also https://www.postgresql.org/docs/current/static/functions-net.html.
This page is probably more useful than the one posted in the description!
> Add type INET to Hive
> ---------------------
>
> Key: HIVE-13944
> URL: https://issues.apache.org/jira/browse/HIVE-13944
> Project: Hive
> Issue Type: Wish
> Reporter: Glenn Strycker
>
> In order to make HiveQL compatible with other popular SQL flavors, systems,
> and platforms (e.g. psql on Greenplum), it would be extremely helpful to be
> able to store IP addresses as an "inet" type rather than string.
> For example, IP addresses can now come in 2 types, IPv4 and IPv6, and each
> can have different levels of truncation. INET types enable queries to filter
> to these families as well as truncate IPs to a desired length or filter out
> IPs truncated below this length.
> See https://www.postgresql.org/docs/current/static/datatype-net-types.html
> for the INET type and related functions.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
