hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Glenn Strycker (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-13944) Add type INET to Hive
Date Fri, 03 Jun 2016 21:57:59 GMT

    [ 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)

Mime
View raw message