Re: Missing column headers from S3 file

[Punit Shetty]

Yes, running the CTAS command on hive CLI does print the headers once the
query execution is completed.

I think this feature is yet to be implemented: https://issues.
apache.org/jira/browse/HIVE-12860

On Thu, Mar 9, 2017 at 9:50 AM, Punit Shetty 
wrote:

> Yes, running the CTAS command on hive CLI does print the headers once the
> query execution is completed.
>
> I think this feature is yet to be implemented: https://issues.
> apache.org/jira/browse/HIVE-12860
>
>
> On Wed, Mar 8, 2017 at 5:51 PM, Pushkar.Gujar 
> wrote:
>
>> apologies,
>>
>> my command was
>>
>> hive -e "set hive.cli.print.header=true; *select * from abc*" >>
>> output.txt
>>
>>
>> Thank you,
>> *Pushkar Gujar*
>>
>>
>> On Wed, Mar 8, 2017 at 8:49 PM, Pushkar.Gujar 
>> wrote:
>>
>>> 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 
>>> 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

>>>
>>>
>>
>

Re: Missing column headers from S3 file

[Pushkar.Gujar]

apologies,

my command was

hive -e "set hive.cli.print.header=true; *select * from abc*" >> output.txt


Thank you,
*Pushkar Gujar*


On Wed, Mar 8, 2017 at 8:49 PM, Pushkar.Gujar 
wrote:

> 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 
> 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
>>
>
>

Re: Missing column headers from S3 file

[Pushkar.Gujar]

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 
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
>

Missing column headers from S3 file

[Punit Shetty]

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