Problem refreshing materialized view

luigui — Wed, 19 May 2021 17:47:52 GMT

Hi,

I'm having trouble refreshing a materialized view as it doesn't update properly. I'm going to show an example.

Base table "test_table" with 2 rows:

create table test_table as select 1 as c union select 2 as c

Then I create a materialized view from "test_table":

create materialized view test_mv as select * from test_table

If I query test_mv, it show 2 rows, it's ok. But if I truncate the original table, and then rebuild the materialized view, the query over the materialized view keeps showing 2 rows!

truncate table test_table; alter materialized view test_mv rebuild; select * from test_mv; -- <-- This query returns 2 rows!!

Any ideas on what's happening? I'm running hive version 3.1.0.3.1.0.0-78

Thanks!

Re: Problem refreshing materialized view

MBohlmann — Wed, 24 Nov 2021 15:12:01 GMT

I came across the same issue when we truncated tables. Hive version 3.1.0.3.1.4.0-315

Cheers.

Re: Problem refreshing materialized view

asish — Thu, 25 Nov 2021 15:36:55 GMT

@luigui @MBohlmann I believe you are hitting https://issues.apache.org/jira/browse/HIVE-22260

question Problem refreshing materialized view in Support Questions

Problem refreshing materialized view

Re: Problem refreshing materialized view

Re: Problem refreshing materialized view