Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAPukpS_ayiS-FWYKJvEVNT+N1sk+OSGV5nnk61oXbdFTK=Ak2g@mail.gmail.com>
References: 
 <CAPukpS_ayiS-FWYKJvEVNT+N1sk+OSGV5nnk61oXbdFTK=Ak2g@mail.gmail.com>
Date: Tue, 10 Nov 2015 21:13:56 -0800
Message-ID: 
 <CAPukpS_VbTB54d8c2XRBH84D2d6gScNGiUGDBPB3e48h=mquBQ@mail.gmail.com>
Subject: Re: Compare Query Execution duration between ORC and SequenceFile
From: reveen joe <impdocs2008@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=001a11356642aca3f105243ce4c0

--001a11356642aca3f105243ce4c0
Content-Type: text/plain; charset=UTF-8

> Hi,
>
> I understand that data retrieval against an ORC table can be much faster
> than a SequenceFile table when a *subset of columns* are selected.
>
> I am assuming Query Execution duration would be faster even when *all the
> columns* in a given a partition are selected but not very sure about
> this.
>
> Would you clarify if you have experimented projecting all the columns in a
> given partition from an ORC file and how did it compare against
> SequenceFile table?
>
> Thank you!
>

--001a11356642aca3f105243ce4c0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra"><div class=3D"gmail_quote"><br>=
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi,=C2=A0<div><br></div><di=
v>I understand that data retrieval against an ORC table can be much faster =
than a SequenceFile table when a <u>subset of columns</u> are selected.=C2=
=A0</div><div><br></div><div>I am assuming Query Execution duration would b=
e faster even when <u>all the columns</u> in a given a partition are select=
ed but not very sure about this.=C2=A0</div><div><br></div><div>Would you c=
larify if you have experimented projecting all the columns in a given parti=
tion from an ORC file and how did it compare against SequenceFile table?=C2=
=A0</div><div><br></div><div>Thank you!=C2=A0</div></div>
</blockquote></div><br></div></div>

--001a11356642aca3f105243ce4c0--