[
https://issues.apache.org/jira/browse/HIVE-21702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16835551#comment-16835551
]
Igor Bezuglyi commented on HIVE-21702:
--------------------------------------
hive.metastore.rawstore.impl is not set. HMS version is 3.1.0. Here's the
contents of META_INF/manifest.mf:
Manifest-Version: 1.0
Implementation-Title: Hive Standalone Metastore
Implementation-Version: 3.1.0.3.1.0.0-78
Archiver-Version: Plexus Archiver
Built-By: jenkins
Specification-Vendor: The Apache Software Foundation
Specification-Title: Hive Standalone Metastore
Implementation-Vendor-Id: org.apache.hive
Implementation-Vendor: The Apache Software Foundation
Created-By: Apache Maven 3.3.9
Build-Jdk: 1.8.0_91
Specification-Version: 0.0
Implementation-URL: [https://www.apache.org/hive-standalone-metastore/]
Java version is the same on both machines:
openjdk version "1.8.0_212"
OpenJDK Runtime Environment (build 1.8.0_212-b04)
OpenJDK 64-Bit Server VM (build 25.212-b04, mixed mode)
> 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)
