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

Beeline should escape semi-colon in queries

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.1.0, 1.2.0
    • 1.3.0, 2.0.0
    • Beeline
    • None

    Description

      Beeline should escape the semicolon in queries. for example, the query like followings:
      CREATE TABLE beeline_tb (c1 int, c2 string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n';
      or
      CREATE TABLE beeline_tb (c1 int, c2 string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\;' LINES TERMINATED BY '\n';
      both failed.
      But the 2nd query with semicolon escaped with "\" works in CLI.

      Attachments

        1. HIVE-11100.patch
          6 kB
          Chaoyu Tang

        Issue Links

          is depended upon by

          Bug - A problem which impairs or prevents the functions of the product. HIVE-15820 comment at the head of beeline -e

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. SPARK-12014 Spark SQL query containing semicolon is broken in Beeline (related to HIVE-11100)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. HIVE-9877 Beeline cannot run multiple statements in the same row

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

          Bug - A problem which impairs or prevents the functions of the product. HIVE-12259 Command containing semicolon is broken in Beeline

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. HIVE-12646 beeline and HIVE CLI do not parse ; in quote properly

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. SPARK-12497 thriftServer does not support semicolon in sql

          • Major - Major loss of function.
          • Closed

          Activity

            People

              ctang Chaoyu Tang
              ctang Chaoyu Tang
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: