-Re: Best format to use
Nitin Pawar 2013-04-09, 16:56
there is another important point to look as well
what kind of queries are you planning to run? there are different types of
formats which suit to different needs.
like when you are doing something related to couple of columns only then
you may choose RCFile (newer ORCFile Format)
when you got to read few records together then may be sequence files are
there are others as wel
On Tue, Apr 9, 2013 at 10:21 PM, Mark <[EMAIL PROTECTED]> wrote:
> Actually, compressed sequence files may not work with Pig or Hive then
> On Apr 9, 2013, at 9:50 AM, Mark <[EMAIL PROTECTED]> wrote:
> > Forgetting Impala, what format would be best to use with daily logs?
> > Block-compressed sequence files?
> > On Apr 8, 2013, at 8:12 PM, Harsh J <[EMAIL PROTECTED]> wrote:
> >> Hey Mark,
> >> Gzip codec creates extension .gzip, not .deflate (which is
> >> DeflateCodec). You may want to re-check your settings.
> >> Impala questions are best resolved at its current user and developer
> >> community at
> >> Impala does currently support LZO (and also Indexed LZO) compressed
> >> text files however, so you may want to try that as its splittable
> >> (compared to Gzip ones).
> >> On Tue, Apr 9, 2013 at 5:18 AM, Mark <[EMAIL PROTECTED]> wrote:
> >>> Trying to determine what the best format to use for storing daily
> logs. We recently switch from snappy (.snappy) to gzip (.deflate) but I'm
> wondering if there is something better? Our main clients for these daily
> logs are pig and hive using an external table. We were thinking about
> testing out impala but we see that it doesn't work with compressed text
> files. Any suggestions?
> >>> Thanks
> >> --
> >> Harsh J