[HIVE-9788] Make double quote optional in tsv/csv/dsv output

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Labels: TODOC1.2

Release Note

beeline --disableQuotingForSV=true --verbose=true -u jdbc:hive2://localhost:10000
issuing: !connect jdbc:hive2://localhost:10000 '' ''
Connecting to jdbc:hive2://localhost:10000
Connected to: Apache Hive (version 1.2.0-SNAPSHOT)
Driver: Hive JDBC (version 1.2.0-SNAPSHOT)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.2.0-SNAPSHOT by Apache Hive
0: jdbc:hive2://localhost:10000> !outputformat csv2
0: jdbc:hive2://localhost:10000> select * from test;
Getting log thread is interrupted, since query is done!
test.a,test.b
28,"aa"
37,a"b
2 rows selected (1.421 seconds)

• Assignee: Ferdinand Xu
• Reporter: Brock Noland
• Created: 25/Feb/15 19:53
• Updated: 26/Jan/19 04:26
• Resolved: 05/Mar/15 14:28

Description

_强调文本_Similar to HIVE-7390 some customers would like the double quotes to be optional. So if the data is "A" then the output from beeline should be "A" which is the same as the Hive CLI.

Issue Links

• is related to: HIVE-14679 csv2/tsv2 output format disables quoting by default and it's difficult to enable
• relates to: HIVE-7390 Make single quote character optional and configurable in BeeLine CSV/TSV output