[HIVE-6359] beeline -f fails on scripts with tabs in them.

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Assignee: Navis Ryu
• Reporter: Carter Shanklin
• Created: 03/Feb/14 18:13
• Updated: 12/Mar/14 09:20
• Resolved: 10/Mar/14 14:35

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.

Issue Links

• relates to: HIVE-4268 Beeline should support the -f option
• links to: review board