Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
MIME-Version: 1.0
Date: Fri, 8 Apr 2016 17:53:50 -0700
Message-ID: 
 <CAMP4i_N34uxX7+49_-zEWAvkMis52YpKyEjP_7PV9DQ9Y2fJUQ@mail.gmail.com>
Subject: ORC file sort order ..
From: Gautam <gautamkowshik@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=001a113eae1ab2c50f053002be76

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

Hey,

           This might be too obvious a question but I haven't found a way
to validate ordering in an ORC file. I need each file to be ordered by a
column, Is there a sure shot way of ensuring the sort order in an ORC file
is as I expect it?

The closest i'v come to is using the hive --orcfiledump --rowindex <col_id>
which prints that columns min/max values in the index. But that is still
not saying if the data within the stripes is sorted.

Cheers,
-Gautam.

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

<div dir=3D"ltr"><div class=3D"gmail_signature">Hey,</div><div class=3D"gma=
il_signature"><br></div><div class=3D"gmail_signature">=C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0This might be too obvious a question but I haven&#39;t=
 found a way to validate ordering in an ORC file. I need each file to be or=
dered by a column, Is there a sure shot way of ensuring the sort order in a=
n ORC file is as I expect it?</div><div class=3D"gmail_signature"><br></div=
><div class=3D"gmail_signature">The closest i&#39;v come to is using the hi=
ve --orcfiledump --rowindex &lt;col_id&gt; which prints that columns min/ma=
x values in the index. But that is still not saying if the data within the =
stripes is sorted.</div><div class=3D"gmail_signature"><br></div><div class=
=3D"gmail_signature">Cheers,</div><div class=3D"gmail_signature">-Gautam.</=
div>
</div>

--001a113eae1ab2c50f053002be76--