[
https://issues.apache.org/jira/browse/HIVE-21702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16835141#comment-16835141
]
Rajkumar Singh commented on HIVE-21702:
---------------------------------------
[~brenagwynn] look like incompatibility within HMS client and server, what
version of HMS you are running here, what the value set for
hive.metastore.rawstore.impl? what error/exception do you see in HMS logs.
> Queries with filter on a partition column fail when using standalone metastore
> ------------------------------------------------------------------------------
>
> Key: HIVE-21702
> URL: https://issues.apache.org/jira/browse/HIVE-21702
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2, Standalone Metastore
> Affects Versions: 3.1.0
> Environment: HDP 3.1 on AWS (Hive 3.1.0)
> Standalone metastore on an EC2 instance (using
> hive-standalone-metastore-3.1.0.3.1.0.0-78.jar)
> Reporter: Igor Bezuglyi
> Priority: Major
> Attachments: hiveserver_ex.log, table_data_a.csv
>
>
> Queries with filter on a partition column fail when using standalone metastore
> Example (Hiveserver2 is pointing to a standalone metastore instance)
> {{create table test_a_src (id integer, value varchar(255), run_id
> varchar(14)) }}{{row format delimited fields terminated by ','}}{{stored as
> textfile;}}
> {{create table test_a (id integer, value varchar(255)) }}{{partitioned by
> (run_id varchar(14))}}{{row format delimited fields terminated by
> ','}}{{stored as textfile;}}
> {{<Upload a csv file to test_a_src data directory - test file is
> }}{{attached>}}
> {{insert into test_a select * from test_a_src;}}
> {{select id from test_a where run_id = '20190502123500';}}
> {{Error: Error while compiling statement: FAILED: SemanticException
> MetaException(message:java.lang.UnsupportedOperationException)
> (state=42000,code=40000)}}
> The same queries work fine when using the embedded metastore. Filters on any
> other column work fine as well. The problem is with partition columns.
> An excerpt from hiveserver2.log is attached.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
