[
https://issues.apache.org/jira/browse/HIVE-6359?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13931482#comment-13931482
]
Thejas M Nair commented on HIVE-6359:
-------------------------------------
Yes, I think we can put a note for the -f option about this bug in 0.12 and
earlier, as this is not something that is easy to debug, and people could have
tabs in their script files.
> 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
> Fix For: 0.13.0
>
> Attachments: HIVE-6359.1.patch.txt, HIVE-6359.2.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.2#6252)
