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: <CAAye89BkJ6XwX=AU4vKmU71xCOOw74d+=jma_Mwb3=9be_d12A@mail.gmail.com>
References: <CAAye89BkJ6XwX=AU4vKmU71xCOOw74d+=jma_Mwb3=9be_d12A@mail.gmail.com>
From: "Pushkar.Gujar" <pushkarvgujar@gmail.com>
Date: Wed, 8 Mar 2017 20:49:50 -0500
Message-ID: <CAGT5kx8Mdk-Ng75OWzsm0Q5iqpq9OrvGu0ym672ery0OJxDJmg@mail.gmail.com>
Subject: Re: Missing column headers from S3 file
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=001a113ad44823d308054a427796
archived-at: Thu, 09 Mar 2017 01:50:22 -0000

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

if you were running CTAS command from hive CLI, you might have noticed that
headers get printed in CLI once the query execution is completed. I think
the property hive.cli.print.header is there to only print headers only in
cli.

Not sure about S3, but I tried below which worked perfectly

hive -e "set hive.cli.print.header=true; create table....." >> output.txt


Thank you,
*Pushkar Gujar*


On Wed, Mar 8, 2017 at 6:47 PM, Punit Shetty <punitshetty30@gmail.com>
wrote:

> Hi,
>
> I'm trying to get the column headers into a S3 file.
>
> When I run this on the hive command line:
> set hive.cli.print.header=true;
> select * from abc;
>
> Things work fine, I'm able to see the column headers with the table data
> on the console.
>
> But my query is, when I try something like this:
> set hive.cli.print.header=true;
> CREATE TABLE test123 ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES
> TERMINATED BY '\n' STORED AS TEXTFILE LOCATION 's3://somelocation' AS
> select * abc;
>
> The column headers are missing from the S3 file.
>
> Is this the expected behaviour or am I missing something?
>
> Thanks,
> Punit
>

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

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:georgia,=
serif;font-size:small;color:#000000">if you were running CTAS command from =
hive CLI, you might have noticed that headers get printed in CLI once the q=
uery execution is completed. I think the property hive.cli.print.header is =
there to only print headers only in cli.</div><div class=3D"gmail_default" =
style=3D"font-family:georgia,serif;font-size:small;color:#000000"><br></div=
><div class=3D"gmail_default" style=3D"font-family:georgia,serif;font-size:=
small;color:#000000">Not sure about S3, but I tried below which worked perf=
ectly=C2=A0</div><div class=3D"gmail_default" style=3D"font-family:georgia,=
serif;font-size:small;color:#000000"><br></div><div class=3D"gmail_default"=
 style=3D"font-family:georgia,serif;font-size:small;color:#000000">hive -e =
&quot;set hive.cli.print.header=3Dtrue; create table.....&quot; &gt;&gt; ou=
tput.txt</div><div class=3D"gmail_extra"><br clear=3D"all"><div><div class=
=3D"gmail_signature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><d=
iv><div dir=3D"ltr"><div><b><font face=3D"georgia, serif"><br></font></b></=
div><div><font face=3D"georgia, serif">Thank you,</font></div><div><font fa=
ce=3D"georgia, serif"><b><font size=3D"4">Pushkar Gujar</font></b><br></fon=
t></div><div><br></div></div></div></div></div></div>
<br><div class=3D"gmail_quote">On Wed, Mar 8, 2017 at 6:47 PM, Punit Shetty=
 <span dir=3D"ltr">&lt;<a href=3D"mailto:punitshetty30@gmail.com" target=3D=
"_blank">punitshetty30@gmail.com</a>&gt;</span> wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex"><div dir=3D"ltr"><span style=3D"font-size:12.8px">Hi,</span><=
div style=3D"font-size:12.8px"><br></div><div style=3D"font-size:12.8px">I&=
#39;m trying to get the column headers into a S3 file.</div><div style=3D"f=
ont-size:12.8px"><br></div><div style=3D"font-size:12.8px">When I run this =
on the hive command line:</div><div style=3D"font-size:12.8px">set hive.cli=
.print.header=3Dtrue;</div><div style=3D"font-size:12.8px">select * from ab=
c;</div><div style=3D"font-size:12.8px"><br></div><div style=3D"font-size:1=
2.8px">Things work fine, I&#39;m able to see the column headers with the ta=
ble data on the console.</div><div style=3D"font-size:12.8px"><br></div><di=
v style=3D"font-size:12.8px">But my query is, when I try something like thi=
s:</div><div style=3D"font-size:12.8px"><div>set hive.cli.print.header=3Dtr=
ue;</div><div>CREATE TABLE test123 ROW FORMAT DELIMITED FIELDS TERMINATED B=
Y &#39;\t&#39; LINES TERMINATED BY &#39;\n&#39; STORED AS TEXTFILE LOCATION=
 &#39;s3://somelocation&#39; AS</div><div>select * abc;</div></div><div sty=
le=3D"font-size:12.8px"><br></div><div style=3D"font-size:12.8px">The colum=
n headers are missing from the S3 file.</div><div style=3D"font-size:12.8px=
"><br></div><div style=3D"font-size:12.8px">Is this the expected behaviour =
or am I missing something?</div><div style=3D"font-size:12.8px"><br></div><=
div style=3D"font-size:12.8px">Thanks,</div><div style=3D"font-size:12.8px"=
>Punit</div></div>
</blockquote></div><br></div></div>

--001a113ad44823d308054a427796--