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

beeline -f fails on scripts with tabs between column type and comment

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.2.0
    • Fix Version/s: 2.1.0
    • Component/s: Beeline
    • Labels:
      None

      Description

      This issue was supposed to be resolved by https://issues.apache.org/jira/browse/HIVE-6359

      However when invoking
      create table test (id int<tab>COMMENT 'test');
      the following error appears

      beeline -f test.sql -u"jdbc:hive2://localhost:10000/default;principal=hive/FQDN@US-WEST-2.COMPUTE.INTERNAL"
      scan complete in 4ms
      Connecting to jdbc:hive2://localhost:10000/default;principal=hiveFQDN@US-WEST-2.COMPUTE.INTERNAL
      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
      0: jdbc:hive2://localhost:10000/default> create table test (id intCOMMENT 'test');
      Error: Error while compiling statement: FAILED: ParseException line 1:22 cannot recognize input near 'intCOMMENT' ''test'' ')' in column type (state=42000,code=40000)

      There is no problem when <tab> is between the columns e.g.
      create table test (id int COMMENT 'test',<tab>id2 string COMMENT 'test2');

        Attachments

          Activity

            People

            • Assignee:
              aihuaxu Aihua Xu
              Reporter:
              krisss Krzysztof Adamski
            • Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: