I am not really sure. But I think it is the Query cache make your query result unchanged.
The config entry is kylin.query.cache-enabled , is turn on by default. This doc links is https://kylin.apache.org/5.0/docs/configuration/query_cache -- Best wishes to you ! From ：Xiaoxiang Yu At 2023-11-17 09:48:55, "Nam Đỗ Duy" <na...@vnpay.vn.INVALID> wrote: >Hello Team, hello Xiaoxiang, can you please help me with this urgent >issue... > >(this is public email group so in general I neglect your specific name from >greeting of first email in the threads, but in fact most of time Xiaoxiang >actively answers my issues, thank you very much) > >On Thu, Nov 16, 2023 at 2:59 PM Nam Đỗ Duy <na...@vnpay.vn> wrote: > >> Dear Dev Team, please kindly advise this scenario >> >> 1. I have a fact table and I use Kylin insights window to query it and get >> 5 million rows. >> >> 2. Then I use following command to load X rows (last hour data) from >> parquet into Hive table >> >> LOAD DATA LOCAL INPATH >> '/opt/LastHour/factUserEventDF_2023_11_16.parquet/14' INTO TABLE >> factUserEvent; >> >> 3. Then I open Kylin insights window to query it but it still returned >> previous number (5 million rows) not adding the last hour data of X rows >> which I previously loaded from parquet into hive in step 2) >> >> Can you advise the way to make table refresh and updated? >> >> Thank you very much >>
