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