Hi Xiaoxiang, Do I really need to create a model in order to get the incremental data from Hive into Kylin?
Can I query the incremental data of a pure dim/fact table without a model? Thank you very much On Fri, Nov 17, 2023 at 9:05 AM Xiaoxiang Yu <x...@apache.org> wrote: > 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 > >> >
