[
https://issues.apache.org/jira/browse/HIVE-28551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17886365#comment-17886365
]
Stamatis Zampetakis commented on HIVE-28551:
--------------------------------------------
The problem can be reproduced on master (commit
6e261a32657d36185654dd05af7215fe33123878) by running
[^results_cache_invalidation3.q]
{noformat}
mvn test -Dtest=TestMiniLlapLocalCliDriver -Dtest.output.overwrite
-Dqfile=results_cache_invalidation3.q -pl itests/qtest -Pitests
{noformat}
> Stale results when executing queries over recreated transactional tables
> ------------------------------------------------------------------------
>
> Key: HIVE-28551
> URL: https://issues.apache.org/jira/browse/HIVE-28551
> Project: Hive
> Issue Type: Bug
> Security Level: Public(Viewable by anyone)
> Components: HiveServer2
> Affects Versions: 4.0.1
> Reporter: Stamatis Zampetakis
> Assignee: Stamatis Zampetakis
> Priority: Major
> Attachments: results_cache_invalidation3.q
>
>
> SQL queries return stale results from the cache when the tables involved in
> the queries are dropped and then recreated with the same name.
> The problem can be reproduced by executing the following sequence of queries.
> {code:sql}
> CREATE TABLE author (fname STRING) STORED AS ORC
> TBLPROPERTIES('transactional'='true');
> INSERT INTO author VALUES ('Victor');
> SELECT fname FROM author;
> DROP TABLE author;
> CREATE TABLE author (fname STRING) STORED AS ORC
> TBLPROPERTIES('transactional'='true');
> INSERT INTO author VALUES ('Alexander');
> SELECT fname FROM author;
> {code}
> The first execution of the SELECT query correctly returns "Victor" as a
> result.
> The second execution of the SELECT query incorrectly returns "Victor" while
> it should return "Alexander".
> The problem manifestates only when the hive.query.results.cache.enabled is
> set to true.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
