Carter Shanklin created HIVE-6359:
-------------------------------------
Summary: beeline -f fails on scripts with tabs in them.
Key: HIVE-6359
URL: https://issues.apache.org/jira/browse/HIVE-6359
Project: Hive
Issue Type: Bug
Reporter: Carter Shanklin
Priority: Minor
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.
{code}
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
{code}
The same query works fine if I replace tabs with some spaces.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
