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://