How to print hive beeline output without header and non tabular form

sande picture sande · Apr 24, 2017 · Viewed 10.9k times · Source

I want to print this output

+------------------------------------------------+--+
|                    tab_name                    |
+------------------------------------------------+--+
| table1                                         |
| table2                                         |
| table3                                         |
| wt                                             |
| wa                                             |
| wal                                            |
+------------------------------------------------+--+

AS without header and without table format in beeline

table1
table2 table3 wt
wa
wal

Answer

David דודו Markovitz picture David דודו Markovitz · Apr 24, 2017

From the shell

beeline --showHeader=false --outputformat=tsv2 -e "select ..."

Within beeline

!set showheader false
!set outputformat tsv2    
select ...;