How to reflect last hour data into Hive and Kylin Insights query window

2023-11-16 Thread Nam Đỗ Duy
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

[jira] [Created] (KYLIN-5721) The input parameters of some date functions support string format

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5721: --- Summary: The input parameters of some date functions support string format Key: KYLIN-5721 URL: https://issues.apache.org/jira/browse/KYLIN-5721 Project: Kylin

[jira] [Created] (KYLIN-5718) Support automatic merging of V3 dictionary files

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5718: --- Summary: Support automatic merging of V3 dictionary files Key: KYLIN-5718 URL: https://issues.apache.org/jira/browse/KYLIN-5718 Project: Kylin Issue Type:

[jira] [Created] (KYLIN-5717) The to_date function is not aligned with SparkSQL. When converting to a time format such as yyyyMMdd, the result of the query hitting the snapshot is incorrect

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5717: --- Summary: The to_date function is not aligned with SparkSQL. When converting to a time format such as MMdd, the result of the query hitting the snapshot is incorrect Key: KYLIN-5717

[jira] [Created] (KYLIN-5720) the query node returns to the login page after clicking on the model page

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5720: --- Summary: the query node returns to the login page after clicking on the model page Key: KYLIN-5720 URL: https://issues.apache.org/jira/browse/KYLIN-5720 Project: Kylin

[jira] [Created] (KYLIN-5719) Occasional initialization failure of the V3 global dictionary file, resulting in failure of build jobs

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5719: --- Summary: Occasional initialization failure of the V3 global dictionary file, resulting in failure of build jobs Key: KYLIN-5719 URL:

[jira] [Created] (KYLIN-5722) Optimize KylinConfExt

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5722: --- Summary: Optimize KylinConfExt Key: KYLIN-5722 URL: https://issues.apache.org/jira/browse/KYLIN-5722 Project: Kylin Issue Type: Improvement Affects

[jira] [Created] (KYLIN-5723) Optimize Calcite plan to convert spark logical plan

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5723: --- Summary: Optimize Calcite plan to convert spark logical plan Key: KYLIN-5723 URL: https://issues.apache.org/jira/browse/KYLIN-5723 Project: Kylin Issue Type:

[jira] [Created] (KYLIN-5724) Support local debug & glue hive client cache

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5724: --- Summary: Support local debug & glue hive client cache Key: KYLIN-5724 URL: https://issues.apache.org/jira/browse/KYLIN-5724 Project: Kylin Issue Type:

[jira] [Created] (KYLIN-5725) After turning on the email alert configuration, the operation task prompts an unknown error, and the query underpressing also reports an error.

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5725: --- Summary: After turning on the email alert configuration, the operation task prompts an unknown error, and the query underpressing also reports an error. Key: KYLIN-5725 URL:

[jira] [Created] (KYLIN-5726) Remove unnecessary execution goal for deploy plugin

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5726: --- Summary: Remove unnecessary execution goal for deploy plugin Key: KYLIN-5726 URL: https://issues.apache.org/jira/browse/KYLIN-5726 Project: Kylin Issue Type:

[jira] [Created] (KYLIN-5727) update spark version to 3.2.0-kylin-4.6.11.0

2023-11-16 Thread Hongrong Cao (Jira)
Hongrong Cao created KYLIN-5727: --- Summary: update spark version to 3.2.0-kylin-4.6.11.0 Key: KYLIN-5727 URL: https://issues.apache.org/jira/browse/KYLIN-5727 Project: Kylin Issue Type:

Re: How to reflect last hour data into Hive and Kylin Insights query window

2023-11-16 Thread Xiaoxiang Yu
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

Re: How to reflect last hour data into Hive and Kylin Insights query window

2023-11-16 Thread Nam Đỗ Duy
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,