Glenn Strycker created HIVE-13944:
-------------------------------------

             Summary: 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)

Reply via email to