mardi 4 août 2015

Hive - How to remove column header from result set

I am trying to fix one issue which has created after hive query execution.

A new table named 'stock_data' which is holding stock price , stock symbol and all other details.

I had a tsv file ( tab separated file ) and used 'load data local inpath' command to load database table.

tsv file having column header like 'stock_name','stock_symbol' ....

Now, when I wanted to display stock symbol and with number of counts using below query :-

select stock_symbol,count(*) from stocks group by stock_symbol;

Output is loading column header

XOM 500
XRX 500
XTO 496
YPF 500
YUM 500
YZC 478
ZAP 494
ZF  494
stock_symbol    1

Time taken: 20.576 seconds, Fetched: 1735 row(s)

My question is :-

How to hide or remove 'stock_symbol 1' ( Last line ) from my result set ?

I tried to use below command before run :-

set hive.cli.print.header=false;

Did not work for me ...

Could anyone help me for the same ..

Thanks ..

Aucun commentaire:

Enregistrer un commentaire