[ 
https://issues.apache.org/jira/browse/HIVE-6359?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Navis updated HIVE-6359:
------------------------

    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.

{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.

  was:
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.


> 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
>            Assignee: Navis
>            Priority: Minor
>         Attachments: HIVE-6359.1.patch.txt
>
>
> 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.
> {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)

Reply via email to