[HIVE-4307] For partitioned table , if where statement is 'const string equals const string', the query will throw MismatchedTokenException

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.10.0
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: caofangkun
• Created: 07/Apr/13 08:05
• Updated: 08/Apr/13 09:08

Description

For example:
create table srcpart (key string, value string) partitioned by (ds string, hr string);
hive>explain select * from srcpart where 'test'='test2';
BR.recoverFromMismatchedToken
FAILED: Error in semantic analysis: MetaException(message:Error parsing partition filter : MismatchedTokenException(9!=8))

For views there's a potentially dangerous：
For Example:
create view v_test_table ( id, key, type, dt) as
select id, key ,type dt from
( select id ,key , 'apple' as type , dt
from src_test_table
where dt='20130326′
) t;

The following three query statements will work well:
explain select * from v_test_table where id='123' ;
explain select * from v_test_table where key='123' ;
explain select * from v_test_table where dt='20130326' ;

But the following query will fail :
explain select * from v_test_table where type='orange' ;
BR.recoverFromMismatchedToken
FAILED: Error in semantic analysis: MetaException(message:Error parsing partition filter : MismatchedTokenException(9!=8))