thank you!
On Fri, Jul 24, 2015 at 3:23 PM, Jim Scott <jsc...@maprtech.com> wrote: > let me clarify... > > If you were grouping by household, you may want to group on the left side. > If it is stored in a single valued field, then you would have to manipulate > the value in some way to get the portion you want to group by. Thusly, > storing it in two parts would be optimal for the use case. > > On Fri, Jul 24, 2015 at 9:44 AM, Stefán Baxter <ste...@activitystream.com> > wrote: > > > Well, that is only true if you dont have a BigInteger to hold it :) > > > > see: > > > > > https://java-ipv6.googlecode.com/svn/artifacts/0.14/doc/apidocs/com/googlecode/ipv6/IPv6Address.html > > > > Regards, > > -Stefan > > > > On Fri, Jul 24, 2015 at 2:39 PM, Jim Scott <jsc...@maprtech.com> wrote: > > > > > an IPv6 address is actually two longs. Depending on the type of > analysis > > > you are doing you may prefer to store them that way. > > > > > > e.g. the range on the left side is a home / location and the range on > the > > > right side are sub values (devices within the home). > > > > > > Depending on your use case you may want to store them separately. > > > > > > Other than that tidbit, I cannot speak to Drill's capability to > leverage > > > said data. > > > > > > On Fri, Jul 24, 2015 at 4:20 AM, Stefán Baxter < > > ste...@activitystream.com> > > > wrote: > > > > > > > Hi, > > > > > > > > Has anyone here opinion/ideas on how ipv6 addresses might be stored > > > > efficiently in Parquet via Drill. > > > > > > > > The Java BigInteger class handles the 128 variant but the > BigIntHolder > > in > > > > Drill relies on a Long. Storing it in two longs is not optimal and it > > > would > > > > surprise me if the variable binary field can do range queries. > > > > > > > > all input is welcome :). > > > > > > > > This minuscule UDF project (https://github.com/acmeguy/asdrill) now > > also > > > > includes a IPv4 conversion (One may exist already) . > > > > > > > > Regards, > > > > -Stefan > > > > > > > > > > > > > > > > -- > > > *Jim Scott* > > > Director, Enterprise Strategy & Architecture > > > +1 (347) 746-9281 > > > > > > <http://www.mapr.com/> > > > [image: MapR Technologies] <http://www.mapr.com> > > > > > > Now Available - Free Hadoop On-Demand Training > > > < > > > > > > http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available > > > > > > > > > > > > > -- > *Jim Scott* > Director, Enterprise Strategy & Architecture > +1 (347) 746-9281 > > <http://www.mapr.com/> > [image: MapR Technologies] <http://www.mapr.com> > > Now Available - Free Hadoop On-Demand Training > < > http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available > > >
