Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
0.10.0
-
None
-
None
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))