print table headers only in Hive

Viewed 3074

Is it possible to print headers in Hive without the table name prefix?

I did: set hive.cli.print.header=true;

and then: select * from brands limit 3;

the result was:

brands.id  brands.name brands.tag      brands.value
7     Brand      50      DeLorme
0     Brand      50      U-Line
27    Brand      50      Elcon

And what really wanted to get is:

id    name       tag      value
7     Brand      50      DeLorme
0     Brand      50      U-Line
27    Brand      50      Elcon

"brands" is a table that I created and not a main DB table.

Thanks for your help,
Nina

1 Answers
Related