You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Roger Hayes <rh...@tripadvisor.com> on 2016/03/04 02:15:19 UTC

Bug in beeline --outputformat=csv2?

Dear Hive folks--

Here's the output I get from beeline with the outputformat option. It doesn't look right to me -- the text values ought to be surrounded by a delimiter since the values contain ','. And it's not clear why the quote characters are escaped, since the values are not quoted.

Is this a legit bug?  If so, shall I file a JIRA, or will you do so & send me a link?

- Thanks,
 Roger Hayes

$ beeline -u jdbc:hive2://  -e 'select * from csv_bug'
scan complete in 2ms
Connecting to jdbc:hive2://
Connected to: Apache Hive (version 1.1.0-cdh5.4.4)
Driver: Hive JDBC (version 1.1.0-cdh5.4.4)
Transaction isolation: TRANSACTION_REPEATABLE_READ
OK
+-------------+---------------------------------------------+--+
| csv_bug.id  |                  csv_bug.t                  |
+-------------+---------------------------------------------+--+
| 1           | words,with,commas,between                   |
| 2           | words\'with\'quotes\'between                |
| 3           | and with \"mixed\" \'quotes\', plus commas  |
+-------------+---------------------------------------------+--+
3 rows selected (0.984 seconds)
Beeline version 1.1.0-cdh5.4.4 by Apache Hive
Closing: 0: jdbc:hive2://

$ beeline -u jdbc:hive2://  --outputformat=csv2 -e 'select * from csv_bug'
scan complete in 2ms
Connecting to jdbc:hive2://
Connected to: Apache Hive (version 1.1.0-cdh5.4.4)
Driver: Hive JDBC (version 1.1.0-cdh5.4.4)
Transaction isolation: TRANSACTION_REPEATABLE_READ
OK
csv_bug.id,csv_bug.t
1,words,with,commas,between
2,words\'with\'quotes\'between
3,and with \"mixed\" \'quotes\', plus commas
3 rows selected (0.957 seconds)
Beeline version 1.1.0-cdh5.4.4 by Apache Hive
Closing: 0: jdbc:hive2://