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)