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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 1.2.0
    • 2.1.0
    • Beeline
    • 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

        1. HIVE-11828.patch
          2 kB
          Aihua Xu

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: