Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of adeelmahmood@gmail.com
 designates 74.125.82.174 as permitted sender)
MIME-Version: 1.0
Date: Mon, 14 Apr 2014 22:41:16 -0400
Message-ID: 
 <CAH1YrM7HxvPpNY6-zmdmar9-jXic63mrHo6AnNtueq6XhZW7DA@mail.gmail.com>
Subject: Reading query columns in ExecuteWithHookContext
From: Adeel Qureshi <adeelmahmood@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=f46d044401baf2ac1904f70bbb68

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

I am trying to read the columns from hive queries being executed by
implementing the ExecuteWithHookContext hook. This works fine by extracting
ColumnAccessInfo information from HiveContext (which is passed in)
.getQueryPlan().getColumnAccessInfo(). This provides access to
a TableToColumnAccessMap which has all the columns from the query in it
along with user information. So this works fine.

However when I run same queries on partition tables the list of columns
returned by TableToColumnAccessMap are not correct. It includes the
partition columns but ends up excluding some of the non-partioned columns.
So for a 5 column table with last 2 being partitioned columns it would
return 1 non-partioned and 2 partioned columns and simply ignore the other
two partitioned columns. Any ideas on what that might be the case or any
other ways on getting a handle on columns of a query being run.

Thanks
Adeel

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

<div dir=3D"ltr">I am trying to read the columns from hive queries being ex=
ecuted by implementing the=C2=A0ExecuteWithHookContext hook. This works fin=
e by extracting ColumnAccessInfo information from HiveContext (which is pas=
sed in) .getQueryPlan().getColumnAccessInfo(). This provides access to a=C2=
=A0TableToColumnAccessMap which has all the columns from the query in it al=
ong with user information. So this works fine.<div>
<br></div><div>However when I run same queries on partition tables the list=
 of columns returned by=C2=A0TableToColumnAccessMap are not correct. It inc=
ludes the partition columns but ends up excluding some of the non-partioned=
 columns. So for a 5 column table with last 2 being partitioned columns it =
would return 1 non-partioned and 2 partioned columns and simply ignore the =
other two partitioned columns. Any ideas on what that might be the case or =
any other ways on getting a handle on columns of a query being run.</div>
<div><br></div><div>Thanks</div><div>Adeel</div></div>

--f46d044401baf2ac1904f70bbb68--