question Re: Beeline's output still shows the header even after setting --showheader=false in Archives of Support Questions (Read Only)

Beeline's output still shows the header even after setting --showheader=false

Alexraj84 — Thu, 19 May 2016 19:56:37 GMT

In my beeline's output I am still able to see the header even after setting --showheader=false. Below is the query that I have execute.

beeline -u jdbc:hive2://10.241.1.85:10000/kaliamoorthya --silent=true --outputformat=csv2 --showheader=false -e 'select dns,tran_session from testtable group by dns,tran_session order by dns;'

Here is the output:

dns,tran_session
012345490,06-05-2016T0258
012365279,06-05-2016T0258
012365478,06-05-2016T0258
012365480,06-05-2016T0258
012365481,06-05-2016T0258
012365482,06-05-2016T0258
012365483,06-05-2016T0258
012365484,06-05-2016T0258
012365485,06-05-2016T0258
012365486,06-05-2016T0258
012365487,06-05-2016T0258
012365489,06-05-2016T0258
012365491,06-05-2016T0258
012365492,06-05-2016T0258
012365493,06-05-2016T0258
012365494,06-05-2016T0258
012365495,06-05-2016T0258
012365496,06-05-2016T0258
012365497,06-05-2016T0258
012365498,06-05-2016T0258
012365499,06-05-2016T0258
012365588,06-05-2016T0258

Any clue what is causing this?

Re: Beeline's output still shows the header even after setting --showheader=false

jyadav — Thu, 19 May 2016 20:03:17 GMT

@Alex Raj

May be you are hitting bug https://issues.apache.org/jira/browse/HIVE-9770.

Re: Beeline's output still shows the header even after setting --showheader=false

Alexraj84 — Thu, 19 May 2016 20:12:49 GMT

Do we have a workaround for this @Jitendra Yadav ?

Re: Beeline's output still shows the header even after setting --showheader=false

jyadav — Thu, 19 May 2016 20:17:06 GMT

@Alex Raj Sorry, I don't see any workaround therefore you probably need to upgrade the hive version to 1.2.