hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "caofangkun (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-4307) For partitioned table , if where statement is 'const string equals const string', the query will throw MismatchedTokenException
Date Mon, 08 Apr 2013 06:29:16 GMT

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

caofangkun updated HIVE-4307:
-----------------------------

    Attachment: HIVE-4307-1.patch

https://reviews.apache.org/r/10334/
                
> 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
>         Attachments: HIVE-4307-1.patch
>
>
> 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

Mime
View raw message