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

beeline -f fails on scripts with tabs in them.

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • None
    • 0.13.0
    • None
    • None

    Description

      NO PRECOMMIT TESTS

      On a recent trunk build I used beeline -f on a script with tabs in it.

      Beeline rather unhelpfully attempts to perform tab expansion on the tabs and the query fails. Here's a screendump.

      Connecting to jdbc:hive2://mymachine:10000/mydb
      Connected to: Apache Hive (version 0.13.0-SNAPSHOT)
      Driver: Hive JDBC (version 0.13.0-SNAPSHOT)
      Transaction isolation: TRANSACTION_REPEATABLE_READ
      Beeline version 0.13.0-SNAPSHOT by Apache Hive
      0: jdbc:hive2://mymachine:10000/mydb> select  i_brand_id as brand_id, i_brand as brand,
      . . . . . . . . . . . . . . . . . . . . . . .>  
      Display all 560 possibilities? (y or n) 
      . . . . . . . . . . . . . . . . . . . . . . .>  ager_id=36
      . . . . . . . . . . . . . . . . . . . . . . .>  
      Display all 560 possibilities? (y or n) 
      . . . . . . . . . . . . . . . . . . . . . . .>  d d_moy=12
      . . . . . . . . . . . . . . . . . . . . . . .>  
      Display all 560 possibilities? (y or n) 
      . . . . . . . . . . . . . . . . . . . . . . .>  d d_year=2001
      . . . . . . . . . . . . . . . . . . . . . . .>         and ss_sold_date between '2001-12-01' and '2001-12-31'
      . . . . . . . . . . . . . . . . . . . . . . .>  group by i_brand, i_brand_id
      . . . . . . . . . . . . . . . . . . . . . . .>  order by ext_price desc, brand_id
      . . . . . . . . . . . . . . . . . . . . . . .> limit 100 ;
      Error: Error while compiling statement: FAILED: ParseException line 1:65 missing FROM at 'd_moy' near 'd' in from source (state=42000,code=40000)
      Closing: org.apache.hive.jdbc.HiveConnection
      

      The same query works fine if I replace tabs with some spaces.

      Attachments

        1. HIVE-6359.1.patch.txt
          1 kB
          Navis Ryu
        2. HIVE-6359.2.patch.txt
          0.6 kB
          Navis Ryu

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            navis Navis Ryu Assign to me
            cartershanklin Carter Shanklin
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment