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 >