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: <SNT152-W55D7F9EE103FA9D783FBF392750@phx.gbl>
References: <SNT152-W55D7F9EE103FA9D783FBF392750@phx.gbl>
Date: Sun, 15 May 2016 00:15:00 +0100
Message-ID: <CAJ3fcbCtGkpNAqHv5dVJg9bCUqAYNC1dpMsznPNmMTGX9AaBjQ@mail.gmail.com>
Subject: Re: Query Failing while querying on ORC Format
From: Mich Talebzadeh <mich.talebzadeh@gmail.com>
To: user <user@hive.apache.org>
Content-Type: multipart/alternative; boundary=001a1149d2be7f99f30532d58f58
archived-at: Sat, 14 May 2016 23:15:17 -0000

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

check this thread.

alter table add columns aternatives or hive refresh

that night help

HTH

Dr Mich Talebzadeh


LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*


http://talebzadehmich.wordpress.com


On 14 May 2016 at 23:29, Mahender Sarangam <mahender.bigdata@outlook.com>
wrote:

> Hi,
> We are dumping our data into ORC Partition Bucketed table. We have loaded
> almost 6 months data and here month is Partition by column. Now we have
> modified ORC partition bucketed table schema. We have added 2 more columns
> to the ORC table. Now whenever we are running select statement for older
> month which has no columns( even though these columns are not part in
> select clause, (projection column) ), it is throwing exception.
>
> There is JIRA bug for this kind of requirement has already been raised.
> https://issues.apache.org/jira/browse/HIVE-11981
>
> Can any one please tell me know alternative workaround for reading old
> previous columns of ORC partition table.
>
> Thanks
>

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

<div dir=3D"ltr"><div>check this thread.</div><div><br></div><div>alter tab=
le <span>add</span> <span>columns</span> aternatives or hive refresh</div><=
div><br></div><div>that night help</div><div><br></div><div>HTH</div></div>=
<div class=3D"gmail_extra"><br clear=3D"all"><div><div class=3D"gmail_signa=
ture"><div dir=3D"ltr"><font color=3D"#000000" face=3D"Times New Roman" siz=
e=3D"3">

</font><p style=3D"margin:0cm 0cm 0pt"><font color=3D"#000000" face=3D"Cali=
bri" size=3D"3">Dr Mich Talebzadeh</font></p><font color=3D"#000000" face=
=3D"Times New Roman" size=3D"3">

</font><p style=3D"margin:0cm 0cm 0pt"><font color=3D"#000000" face=3D"Cali=
bri" size=3D"3">=C2=A0</font></p><font color=3D"#000000" face=3D"Times New =
Roman" size=3D"3">

</font><p style=3D"margin:0cm 0cm 0pt"><span style=3D"font-family:&quot;Ari=
al&quot;,sans-serif"><font color=3D"#000000" size=3D"3">LinkedIn </font></s=
pan><i><span style=3D"font-family:&quot;Arial&quot;,sans-serif;font-size:10=
pt"><font color=3D"#000000">=C2=A0</font><a href=3D"https://www.linkedin.co=
m/profile/view?id=3DAAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw" target=3D"_bla=
nk"><font color=3D"#0000ff">https://www.linkedin.com/profile/view?id=3DAAEA=
AAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw</font></a></span></i></p><font color=3D=
"#000000" face=3D"Times New Roman" size=3D"3">

</font><p style=3D"margin:0cm 0cm 0pt"><font color=3D"#000000" face=3D"Cali=
bri" size=3D"3">=C2=A0</font></p><font color=3D"#000000" face=3D"Times New =
Roman" size=3D"3">

</font><p style=3D"margin:0cm 0cm 0pt;text-align:justify"><span style=3D"fo=
nt-family:&quot;Arial&quot;,sans-serif;font-size:10pt"><a href=3D"http://ta=
lebzadehmich.wordpress.com/" target=3D"_blank"><font color=3D"#0000ff">http=
://talebzadehmich.wordpress.com</font></a></span></p><font color=3D"#000000=
" face=3D"Times New Roman" size=3D"3">

</font><p style=3D"margin:0cm 0cm 0pt"><span style=3D"font-family:&quot;Ari=
al&quot;,sans-serif;font-size:9pt"><font color=3D"#000000">=C2=A0</font></s=
pan></p><font color=3D"#000000" face=3D"Times New Roman" size=3D"3">

</font></div></div></div>
<br><div class=3D"gmail_quote">On 14 May 2016 at 23:29, Mahender Sarangam <=
span dir=3D"ltr">&lt;<a href=3D"mailto:mahender.bigdata@outlook.com" target=
=3D"_blank">mahender.bigdata@outlook.com</a>&gt;</span> wrote:<br><blockquo=
te class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc so=
lid;padding-left:1ex">


<div><div dir=3D"ltr">Hi,<br>We are dumping our data into ORC=C2=A0Partitio=
n Bucketed table. We have loaded almost 6 months=C2=A0data and here month i=
s Partition by column. Now we have modified=C2=A0ORC partition bucketed=C2=
=A0table schema. We have added=C2=A02 more columns to the=C2=A0ORC table. N=
ow whenever we are running=C2=A0select statement for older month which has =
no columns( even though these columns are not part in select clause, (proje=
ction column)=C2=A0), it is throwing exception.<br>=C2=A0<br>There is JIRA =
bug for this kind of requirement has already been raised.<br><a href=3D"htt=
ps://issues.apache.org/jira/browse/HIVE-11981" target=3D"_blank">https://is=
sues.apache.org/jira/browse/HIVE-11981</a><br>=C2=A0<br>Can any one please =
tell me know alternative workaround for reading old previous columns of ORC=
 partition table.<br>=C2=A0<br>Thanks<br> 		 	   		  </div></div>
</blockquote></div><br></div>

--001a1149d2be7f99f30532d58f58--