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

[caofangkun (JIRA)]

caofangkun created HIVE-4307:
--------------------------------

             Summary: For partitioned table , if where statement is 'const 
string equals const string', the query will throw MismatchedTokenException
                 Key: HIVE-4307
                 URL: https://issues.apache.org/jira/browse/HIVE-4307
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 0.10.0
            Reporter: caofangkun
            Priority: Minor


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))

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira