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

Make double quote optional in tsv/csv/dsv output

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.2.0
    • None
    • 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.2.patch
          9 kB
          Ferdinand Xu
        3. HIVE-9788.1.patch
          10 kB
          Ferdinand Xu

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-14679 csv2/tsv2 output format disables quoting by default and it's difficult to enable

          • Major - Major loss of function.
          • Open
          relates to

          New Feature - A new feature of the product, which has yet to be developed. HIVE-7390 Make single quote character optional and configurable in BeeLine CSV/TSV output

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: