My best bet will be string data type itself with partitioning to aid partial search. Please do consider the fact that ipv6 address is more complicated than ipv4 in terms of searching .
Regards Dev On 28 Jun 2016 9:35 pm, "Igor Kuzmenko" <f1she...@gmail.com> wrote: > Currently I'm using ORC transactional tables, and i need to store a lot of > data containing IP addresses. > With IPv4 it can be a Integer (4 bytes exacty), but what about IPv6? > Obiously it should be space efficient and easy to search for exact match. > As extra feature it would be good to do fast search with mask (10.120.*.*) >
