Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-9788

Make double quote optional in tsv/csv/dsv output

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.2.0
    • Component/s: None
    • Labels:
    • Release Note:
      Hide
      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)
      Show
      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)

      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.

        Attachments

        1. HIVE-9788.patch
          8 kB
          Ferdinand Xu
        2. HIVE-9788.1.patch
          10 kB
          Ferdinand Xu
        3. HIVE-9788.2.patch
          9 kB
          Ferdinand Xu

          Issue Links

            Activity

              People

              • Assignee:
                Ferd Ferdinand Xu
                Reporter:
                brocknoland Brock Noland
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: