hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roger Hayes <rha...@tripadvisor.com>
Subject Bug in beeline --outputformat=csv2?
Date Fri, 04 Mar 2016 01:15:19 GMT
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://


Mime
View raw message