[jira] [Created] (KYLIN-5976) libch.so: cannot allocate memory in static TLS block

2024-10-03 Thread Alexander (Jira)
Alexander created KYLIN-5976:


 Summary: libch.so: cannot allocate memory in static TLS block
 Key: KYLIN-5976
 URL: https://issues.apache.org/jira/browse/KYLIN-5976
 Project: Kylin
  Issue Type: Bug
  Components: Release
Affects Versions: 5.0.0
Reporter: Alexander
 Attachments: check-env.out

Build Kylin with Gluten key - "-withGluten"

Ensure that build sucessfully added gluten to package
{code:java}
// so
~/apache-kylin-5.0.0-r5-with-gluten-bin/server/libch.so

// libs
~/apache-kylin-5.0.0-r5-with-gluten-bin/lib/gluten/
celeborn-client-spark-3-shaded_2.12-0.5.1.jar
delta-core_2.12-2.3.0.jar
delta-storage-2.3.0.jar
gluten-celeborn-clickhouse-1.2.0-SNAPSHOT-jar-with-dependencies.jar
gluten.jar
protobuf-java-3.23.4.jar 

//GLUTEN_VERSION
1.2.0-kylin-240730{code}
Try to start Kylin instance without any changes in gluten properties. Use 
default properties.

Got error in "Checking Spark Availability" step.
{code:java}
Checking Spark Availability
...[FAIL]
 {code}
Error description in check-env.out file:
{code:java}
[459715] 2024-10-03T20:53:13,051 INFO  [main] gluten.GlutenDriverPlugin : 
Gluten build info:
==
Backend: ClickHouse
Backend Branch: rebase_ch/20240730
Backend Revision: f69def8b6a8
Backend Revision Time: UNKNOWN
GCC Version: 
Gluten Branch: HEAD
Gluten Build Time: 2024-09-04T08:14:52Z
Gluten Repo URL: https://github.com/Kyligence/gluten-ext.git
Gluten Revision: 14934a23ad23034c72229b3ea2a974787f1c3608
Gluten Revision Time: 2024-07-31 11:18:34 +0800
Gluten Version: 1.2.0-kylin-240730
Hadoop Version: 2.7.4
Java Version: 1.8
Scala Version: 2.12.15
Spark Version: 3.3.0-kylin-4.6.27.0-SNAPSHOT
==
[459715] 2024-10-03T20:53:13,338 INFO  [main] vectorized.JniLibLoader : Read 
real path /home/kylin/apache-kylin-5.0.0-r5-with-gluten-bin/server/libch.so for 
libPath /home/kylin/apache-kylin-5.0.0-r5-with-gluten-bin/server/libch.so
Exception in thread "main" java.lang.UnsatisfiedLinkError: 
/home/kylin/apache-kylin-5.0.0-r5-with-gluten-bin/server/libch.so: 
/home/kylin/apache-kylin-5.0.0-r5-with-gluten-bin/server/libch.so: cannot 
allocate memory in static TLS block
    at java.lang.ClassLoader$NativeLibrary.load(Native Method)
    at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1941)
    at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1824)
    at java.lang.Runtime.load0(Runtime.java:809)
    at java.lang.System.load(System.java:1086)
    at 
org.apache.gluten.vectorized.JniLibLoader.loadFromPath0(JniLibLoader.java:103)
    at 
org.apache.gluten.vectorized.JniLibLoader.loadFromPath(JniLibLoader.java:117)
    at 
org.apache.gluten.backendsapi.clickhouse.CHListenerApi.initialize(CHListenerApi.scala:70)
    at 
org.apache.gluten.backendsapi.clickhouse.CHListenerApi.onDriverStart(CHListenerApi.scala:45)
    at org.apache.gluten.GlutenDriverPlugin.init(GlutenPlugin.scala:75)
    at 
org.apache.spark.internal.plugin.DriverPluginContainer.$anonfun$driverPlugins$1(PluginContainer.scala:53)
    at 
scala.collection.TraversableLike.$anonfun$flatMap$1(TraversableLike.scala:293)
    at scala.collection.mutable.ResizableArray.foreach(ResizableArray.scala:62)
    at scala.collection.mutable.ResizableArray.foreach$(ResizableArray.scala:55)
    at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:49)
    at scala.collection.TraversableLike.flatMap(TraversableLike.scala:293)
    at scala.collection.TraversableLike.flatMap$(TraversableLike.scala:290)
    at scala.collection.AbstractTraversable.flatMap(Traversable.scala:108)
    at 
org.apache.spark.internal.plugin.DriverPluginContainer.(PluginContainer.scala:46)
    at 
org.apache.spark.internal.plugin.PluginContainer$.apply(PluginContainer.scala:210)
    at 
org.apache.spark.internal.plugin.PluginContainer$.apply(PluginContainer.scala:193)
    at org.apache.spark.SparkContext.(SparkContext.scala:560)
    at 
org.apache.spark.api.java.JavaSparkContext.(JavaSparkContext.scala:58)
    at 
org.apache.kylin.tool.setup.KapSparkTaskTestCLI.main(KapSparkTaskTestCLI.java:44)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at 
org.apache.spark.deploy.JavaMainApplication.start(SparkApplication.scala:52)
    at 
org.apache.spark.deploy.SparkSubmit.org$apache$spark$deploy$SparkSubmit$$runMain(SparkSubmit.scala:977)
    at org.apache.spark.deploy.SparkSubmit.doRunMain$1(SparkSubmit.scala:180)
    at org.apache.spark.deploy.SparkSubmit.submit(SparkSubmit.scala:203)
    at org.apache.spa

[jira] [Closed] (KYLIN-5729) Supports email notification when jobs are finished or discarded

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5729.
-

> Supports email notification when jobs are finished or discarded
> ---
>
> Key: KYLIN-5729
> URL: https://issues.apache.org/jira/browse/KYLIN-5729
> Project: Kylin
>  Issue Type: Bug
>Reporter: Laura Xia
>Assignee: Laura Xia
>Priority: Major
> Fix For: 5.0.0
>
> Attachments: image-2023-12-01-15-43-47-377.png
>
>
> !image-2023-12-01-15-43-47-377.png!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5852) Support priority for job scheduler

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5852.
-

> Support priority for job scheduler
> --
>
> Key: KYLIN-5852
> URL: https://issues.apache.org/jira/browse/KYLIN-5852
> Project: Kylin
>  Issue Type: Improvement
>  Components: Job Engine
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>
> There are two steps need to handle high priority jobs: 1) write the ready 
> task into the job_lock table on the dataloading master node; 2) read the task 
> from the job_lock table to execute it on the dataloading slave node. The 
> priority of tasks is correctly managed by the master node; however, this 
> property is not serialized into the job_lock table, so the slave node cannot 
> order the tasks correctly.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5683) There is a pagination problem when table data is in integer columns

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5683.
-

> There is a pagination problem when table data is in integer columns
> ---
>
> Key: KYLIN-5683
> URL: https://issues.apache.org/jira/browse/KYLIN-5683
> Project: Kylin
>  Issue Type: Bug
>Reporter: Laura Xia
>Assignee: Laura Xia
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5819) optimize the warning message on the dialog for editing computed column

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5819?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5819.
-

> optimize the warning message on the dialog for editing computed column
> --
>
> Key: KYLIN-5819
> URL: https://issues.apache.org/jira/browse/KYLIN-5819
> Project: Kylin
>  Issue Type: Improvement
>Reporter: chunyan.huang
>Assignee: chunyan.huang
>Priority: Minor
> Fix For: 5.0.0
>
> Attachments: image-2024-04-11-09-20-21-371.png, 
> image-2024-04-11-11-34-29-089.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5919) Re-design SubtractBitmap function

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5919.
-

> Re-design SubtractBitmap function
> -
>
> Key: KYLIN-5919
> URL: https://issues.apache.org/jira/browse/KYLIN-5919
> Project: Kylin
>  Issue Type: Improvement
>  Components: Job Engine, Query Engine
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5934) Model validation failed for computedColumn contains escaping slash

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5934.
-

> Model validation failed for computedColumn contains escaping slash
> --
>
> Key: KYLIN-5934
> URL: https://issues.apache.org/jira/browse/KYLIN-5934
> Project: Kylin
>  Issue Type: Bug
>  Components: Modeling
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5712) The database, table, column name in the model creation API are case-sensitive, resulting in an error when calling the API

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5712.
-

> The database, table, column name in the model creation API are 
> case-sensitive, resulting in an error when calling the API
> -
>
> Key: KYLIN-5712
> URL: https://issues.apache.org/jira/browse/KYLIN-5712
> Project: Kylin
>  Issue Type: Bug
>Affects Versions: 5.0-beta
>Reporter: Hongrong Cao
>Assignee: Hongrong Cao
>Priority: Minor
> Fix For: 5.0.0
>
> Attachments: image-2023-11-20-22-04-48-100.png, 
> image-2023-11-20-22-05-41-142.png
>
>
> The API call parameters are as follows
> {quote}{
>   "project": "kylin_learn",
>   "fact_table": "SSB.LINEORDER",
>   "alias": "test_model_02",
>   "management_type": "MODEL_BASED",
>   "simplified_measures": [
>     {
>       "name": "COUNT_ALL",
>       "expression": "COUNT",
>       "parameter_value": [
>         {
>           "type": "constant",
>           "value": 1
>         }
>       ],
>       "return_type": ""
>     }
>   ],
>   "simplified_dimensions": [
>     {
>       "column": "LINEORDER.LO_ORDERKEY",
>       "name": "LO_ORDERKEY",
>       "status": "DIMENSION"
>     },
>     {
>       "column": "LINEORDER.LO_CUSTKEY",
>       "name": "LO_CUSTKEY",
>       "status": "DIMENSION"
>     },
>     {
>       "column": "LINEORDER.LO_ORDERDATE",
>       "name": "LO_ORDERDATE",
>       "status": "DIMENSION"
>     },
>     {
>       "column": "LINEORDER.LO_ORDERPRIOTITY",
>       "name": "LO_ORDERPRIOTITY",
>       "status": "DIMENSION"
>     },
>     {
>       "column": "LINEORDER.V_REVENUE",
>       "name": "V_REVENUE",
>       "status": "DIMENSION"
>     },
>     {
>       "column": "DATES.D_YEAR",
>       "name": "D_YEAR",
>       "status": "DIMENSION"
>     },
>     {
>       "column": "CUSTOMER.c_name",
>       "name": "c_name",
>       "status": "DIMENSION"
>     },
>     {
>       "column": "CUSTOMER.C_PHONE",
>       "name": "C_PHONE",
>       "status": "DIMENSION"
>     }
>   ],
>   "join_tables": []
> }
> {quote}
> normal result as follows
> !image-2023-11-20-22-04-48-100.png|width=749,height=817!
>  
> The exceptions are as follows 
> !image-2023-11-20-22-05-41-142.png|width=907,height=802!
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5816) when turn on the V3 global dictionary and concurrently build Segments, the count query result may be incorrect

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5816.
-

> when turn on the V3 global dictionary and concurrently build Segments, the 
> count query result may be incorrect
> --
>
> Key: KYLIN-5816
> URL: https://issues.apache.org/jira/browse/KYLIN-5816
> Project: Kylin
>  Issue Type: Improvement
>  Components: Others
>Affects Versions: 5.0-beta
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> when turn on the V3 global dictionary and concurrently build Segments, the 
> count query result may be incorrect. 
> *Dev Design*
> add Distributed locks for global dictionary build



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5771) Query cannot be interrupted during Segment pruning phase

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5771.
-

> Query cannot be interrupted during Segment pruning phase
> 
>
> Key: KYLIN-5771
> URL: https://issues.apache.org/jira/browse/KYLIN-5771
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>
> When SQL is in the planning stage and pruning segment optimization is 
> performed, it may cause the query to cross the expected 300s and trigger the 
> timeout cancellation logic due to the existence of a large number of 
> segments, and a large number of filter expressions for simplification issues.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5766) Normalize query cache key

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5766?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5766.
-

> Normalize query cache key
> -
>
> Key: KYLIN-5766
> URL: https://issues.apache.org/jira/browse/KYLIN-5766
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5938) Fix swagger can not disable

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5938.
-

> Fix swagger can not disable
> ---
>
> Key: KYLIN-5938
> URL: https://issues.apache.org/jira/browse/KYLIN-5938
> Project: Kylin
>  Issue Type: Bug
>  Components: Others
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5873) Check segment overlap before return models

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5873.
-

> Check segment overlap before return models
> --
>
> Key: KYLIN-5873
> URL: https://issues.apache.org/jira/browse/KYLIN-5873
> Project: Kylin
>  Issue Type: Bug
>  Components: Modeling
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Minor
> Fix For: 5.0.0
>
> Attachments: 8849.1.png, 8849.2.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5926) Turn off OptimizeOneRowJoin for query

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5926?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5926.
-

> Turn off OptimizeOneRowJoin for query
> -
>
> Key: KYLIN-5926
> URL: https://issues.apache.org/jira/browse/KYLIN-5926
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5698) A dimension table field with an alias is used for measure, but the field is not added to the Kylin5 model dimension, and the field type cannot be obtained when creating a

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5698?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5698.
-

> A dimension table field with an alias is used for measure, but the field is 
> not added to the Kylin5 model dimension, and the field type cannot be 
> obtained when creating a tableindex
> -
>
> Key: KYLIN-5698
> URL: https://issues.apache.org/jira/browse/KYLIN-5698
> Project: Kylin
>  Issue Type: Bug
>  Components: Modeling
>Affects Versions: 5.0-beta
>Reporter: Yaguang Jia
>Assignee: Yaguang Jia
>Priority: Minor
> Fix For: 5.0.0
>
>
> *Dev Design*
> /kylin/api/models?model_name= In the response of this api, add the return 
> value to the type in the selected_columns list, and return the field type of 
> the column.
>  
> 
>  
> *Dev Design*
> /kylin/api/models?model_name= 
> 这个api的response里,在selected_columns列表里type加上返回值,返回列的字段类型。



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5876) Avoid infinite match in OlapProjectMergeRule caused by simplify projects

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5876.
-

> Avoid infinite match in OlapProjectMergeRule caused by simplify projects
> 
>
> Key: KYLIN-5876
> URL: https://issues.apache.org/jira/browse/KYLIN-5876
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>
> tdvt test compared to version kylin-5.0-alpha a new failed sql has been 
> added, the query reports an error
> {code:sql}
> SELECT (CASE WHEN "t2"."__measure__2" = 0 THEN NULL ELSE 
> CAST("t0"."__measure__0" AS DOUBLE PRECISION) / "t2"."__measure__2" END) AS 
> "TEMP(Test)(3502400386)(0)"
> FROM (
>   SELECT SUM("CALCS"."NUM1") AS "__measure__0"
>   FROM "TDVT"."CALCS" "CALCS"
>   HAVING (COUNT(1) > 0)
> ) "t0"
>   CROSS JOIN (
>   SELECT AVG("t1"."__measure__0") AS "__measure__2"
>   FROM (
> SELECT SUM("CALCS"."NUM1") AS "__measure__0"
> FROM "TDVT"."CALCS" "CALCS"
> GROUP BY "CALCS"."STR1"
>   ) "t1"
>   HAVING (COUNT(1) > 0)
> ) "t2"
> LIMIT 500
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5822) support history table adds left-closed and right-closed time interval

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5822.
-

> support history table adds left-closed and right-closed time interval
> -
>
> Key: KYLIN-5822
> URL: https://issues.apache.org/jira/browse/KYLIN-5822
> Project: Kylin
>  Issue Type: Bug
>Reporter: chunyan.huang
>Assignee: chunyan.huang
>Priority: Minor
> Fix For: 5.0.0
>
> Attachments: image-2024-04-11-11-32-26-396.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5879) use dataset iterator api to reduce driver memory use

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5879.
-

> use dataset iterator api to reduce driver memory use
> 
>
> Key: KYLIN-5879
> URL: https://issues.apache.org/jira/browse/KYLIN-5879
> Project: Kylin
>  Issue Type: New Feature
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>
> Full Scenario OLAP Service/Data Unification Service Outlet
> * The query result set should not reasonably have a Limit limit.
> * Scenarios answered by hierarchical storage/detailed indexing can support 
> large-scale data exporting
> * scenarios answered by query down, querying through JDBC provided by KE, the 
> performance is not significantly lower than using JDBC provided by the data 
> source directly, such as querying Hive JDBC directly.
> * the amount of data returned does not set a limit on the number of data 
> entries / or data size, because customer data is growing, the analysis of the 
> scene is not fixed.
> * customer behavior using data in a uniform manner, the current asynchronous 
> query in the data use scenarios have limitations.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5883) Enable aggregate pushDown

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5883?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5883.
-

> Enable aggregate pushDown
> -
>
> Key: KYLIN-5883
> URL: https://issues.apache.org/jira/browse/KYLIN-5883
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


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

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5720.
-

> 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
>  Issue Type: Bug
>Affects Versions: 5.0-beta
>Reporter: Hongrong Cao
>Assignee: Hongrong Cao
>Priority: Major
> Fix For: 5.0.0
>
> Attachments: image-2023-11-16-17-09-47-295.png
>
>
> Reproduction method: configure two nodes, an all/job + a query node,
> visit the query node and click on the model page will flashback!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5906) Upgrade Spark version

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5906.
-

> Upgrade Spark version
> -
>
> Key: KYLIN-5906
> URL: https://issues.apache.org/jira/browse/KYLIN-5906
> Project: Kylin
>  Issue Type: Bug
>  Components: Job Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5937) Pushdown select star case sensitive

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5937.
-

> Pushdown select star case sensitive
> ---
>
> Key: KYLIN-5937
> URL: https://issues.apache.org/jira/browse/KYLIN-5937
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5969) Package gluten dependencies into spark

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5969?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5969.
-

> Package gluten dependencies into spark
> --
>
> Key: KYLIN-5969
> URL: https://issues.apache.org/jira/browse/KYLIN-5969
> Project: Kylin
>  Issue Type: Improvement
>Reporter: zhong.zhu
>Assignee: zhong.zhu
>Priority: Major
> Fix For: 5.0.0
>
>
> After execute ./sbin/download-spark-user.sh, gluten relevant dependencies 
> will also be packaged into downloaded spark



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


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

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5725.
-

> 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: https://issues.apache.org/jira/browse/KYLIN-5725
> Project: Kylin
>  Issue Type: Bug
>Affects Versions: 5.0-beta
>Reporter: Hongrong Cao
>Assignee: sibing.zhang
>Priority: Critical
> Fix For: 5.0.0
>
> Attachments: image-2023-11-17-15-03-23-989.png, 
> image-2023-11-17-15-05-29-264.png
>
>
> Steps to Reproduce
> 1:Configure to enable email alerts
> 2:Create a model and initiate a build task.
> 3:In the task list operation task restart, pause, terminate
> 4:Query sql, expect query downpressure
> Actual result
> 3:Operation error report
> 4:Query error



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5765) Optimization of registering udf operators

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5765.
-

> Optimization of registering udf operators
> -
>
> Key: KYLIN-5765
> URL: https://issues.apache.org/jira/browse/KYLIN-5765
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
> Attachments: 42118-2.png, 42118.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5813) improve query history page filter item and model list page button text

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5813.
-

> improve query history page filter item and model list page button text
> --
>
> Key: KYLIN-5813
> URL: https://issues.apache.org/jira/browse/KYLIN-5813
> Project: Kylin
>  Issue Type: Improvement
>Reporter: chunyan.huang
>Assignee: chunyan.huang
>Priority: Major
> Fix For: 5.0.0
>
> Attachments: image-2024-04-09-09-38-42-450.png, 
> image-2024-04-09-09-39-13-571.png, image-2024-04-09-09-39-40-593.png, 
> image-2024-04-09-09-44-16-515.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5917) Optimize segment pruning after upgrading calcite 1.30

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5917.
-

> Optimize segment pruning after upgrading calcite 1.30
> -
>
> Key: KYLIN-5917
> URL: https://issues.apache.org/jira/browse/KYLIN-5917
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5898) Converted subQuery with alias cannot query

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5898.
-

> Converted subQuery with alias cannot query
> --
>
> Key: KYLIN-5898
> URL: https://issues.apache.org/jira/browse/KYLIN-5898
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (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

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5717.
-

> 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
> URL: https://issues.apache.org/jira/browse/KYLIN-5717
> Project: Kylin
>  Issue Type: Bug
>Affects Versions: 5.0-beta
>Reporter: Hongrong Cao
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>
> 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;



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5893) Support getting job list by type for api

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5893.
-

> Support getting job list by type for api
> 
>
> Key: KYLIN-5893
> URL: https://issues.apache.org/jira/browse/KYLIN-5893
> Project: Kylin
>  Issue Type: New Feature
>  Components: Job Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5911) Add index based on project for queryHistory table

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5911.
-

> Add index based on project for queryHistory table
> -
>
> Key: KYLIN-5911
> URL: https://issues.apache.org/jira/browse/KYLIN-5911
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5940) File size estimation is inaccurate

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5940?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5940.
-

> File size estimation is inaccurate
> --
>
> Key: KYLIN-5940
> URL: https://issues.apache.org/jira/browse/KYLIN-5940
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5803) Add FileSegment and smart cache

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5803.
-

> Add FileSegment and smart cache
> ---
>
> Key: KYLIN-5803
> URL: https://issues.apache.org/jira/browse/KYLIN-5803
> Project: Kylin
>  Issue Type: New Feature
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> add FileSegment



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5839) Block agg-push-down for non-equal-join

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5839?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5839.
-

> Block agg-push-down for non-equal-join
> --
>
> Key: KYLIN-5839
> URL: https://issues.apache.org/jira/browse/KYLIN-5839
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> The related non-equiv-join sql is as follows. If you want a corresponding 
> equal-join sql, just remove the condition content `or (t2.fcol_10 is null and 
> t5.fcol_17 is null)`. 
> {code:java}
> select t2.fcol_7 fcol_7, count(distinct t2.fcol_6) fcol_6
> from (select t1.company_code fcol_6, t1.type_name fcol_7,
>   case when t1.created_date = t0.fcol_1 then 'TRUE'
>   else 'FALSE' end fcol_10
>   from ( select company_code, created_date, type_name
> from "DEFAULT"."TEST_AGG_PUSH_DOWN" ) t1
> join ( select company_code, max(created_date) fcol_1
>from "DEFAULT"."TEST_AGG_PUSH_DOWN"
>group by company_code
> ) t0 on t1.company_code = t0.company_code
> ) t2 join ( select 'TRUE' fcol_17 ) t5
> on  t2.fcol_10 = t5.fcol_17 or (t2.fcol_10 is null and t5.fcol_17 is null)
> group by t2.fcol_7{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5767) Calculating total rows abnormal when jdbc datasource is connnected

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5767?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5767.
-

> Calculating total rows abnormal when jdbc datasource is connnected
> --
>
> Key: KYLIN-5767
> URL: https://issues.apache.org/jira/browse/KYLIN-5767
> Project: Kylin
>  Issue Type: Bug
>  Components: Job Engine
>Affects Versions: 5.0-beta
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>
> {{When the JDBC data source is connected, the snapshot management function is 
> enabled and the dimension table is not sampled, optimize the build logic to 
> ensure that the job can be executed normally when the dimension table data 
> volume is large}}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5885) Optimize segment pruning

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5885?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5885.
-

> Optimize segment pruning
> 
>
> Key: KYLIN-5885
> URL: https://issues.apache.org/jira/browse/KYLIN-5885
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Priority: Minor
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5697) Mirror: Kylin5 request response optimization

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5697?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5697.
-

> Mirror: Kylin5 request response optimization
> 
>
> Key: KYLIN-5697
> URL: https://issues.apache.org/jira/browse/KYLIN-5697
> Project: Kylin
>  Issue Type: Improvement
>  Components: REST Service
>Affects Versions: 5.0-beta
>Reporter: Yaguang Jia
>Assignee: Yaguang Jia
>Priority: Minor
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5812) add rules combination to scalar subquery join

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5812?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5812.
-

> add rules combination to scalar subquery join
> -
>
> Key: KYLIN-5812
> URL: https://issues.apache.org/jira/browse/KYLIN-5812
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> add rules combination to scalar subquery join



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5973) Enable Streaming for Kylin5

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5973.
-

> Enable Streaming for Kylin5
> ---
>
> Key: KYLIN-5973
> URL: https://issues.apache.org/jira/browse/KYLIN-5973
> Project: Kylin
>  Issue Type: Bug
>  Components: Real-time Streaming
>Affects Versions: 5.0-beta
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> KE5 Streaming job not avabile



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5939) Only system admin can access sparder UI

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5939.
-

> Only system admin can access sparder UI
> ---
>
> Key: KYLIN-5939
> URL: https://issues.apache.org/jira/browse/KYLIN-5939
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5945) metadata refactor

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5945.
-

> metadata refactor
> -
>
> Key: KYLIN-5945
> URL: https://issues.apache.org/jira/browse/KYLIN-5945
> Project: Kylin
>  Issue Type: New Feature
>  Components: Metadata
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: Zhiting Guo
>Priority: Major
> Fix For: 5.0.0
>
> Attachments: 1.PNG, 2.PNG, 3.png, 4.png, Metadata deep dive (en).pdf, 
> metadata (3).pdf
>
>
> Kylin's metadata has some architectural issues, such as: 
> 1. The metadata adopts a key-value structure. The JSON block contains a lot 
> of content, which will grow with the growth of customer business, resulting 
> in excessive network IO when updating metadata.
> 2. The design of epoch and project lock ensures that transactions within the 
> project are executed serially, resulting in single-point bottlenecks and 
> concurrency problems.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


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

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5718.
-

> Support automatic merging of V3 dictionary files
> 
>
> Key: KYLIN-5718
> URL: https://issues.apache.org/jira/browse/KYLIN-5718
> Project: Kylin
>  Issue Type: Improvement
>Affects Versions: 5.0-beta
>Reporter: Hongrong Cao
>Assignee: Yaguang Jia
>Priority: Blocker
> Fix For: 5.0.0
>
> Attachments: image-2023-11-20-21-54-43-547.png
>
>
> As the number of build tasks increases, the V3 dictionary generates more and 
> more files, and build performance becomes slower and slower.
> !image-2023-11-20-21-54-43-547.png!
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5955) Kylin Package support gluten

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5955?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5955.
-

> Kylin Package support gluten
> 
>
> Key: KYLIN-5955
> URL: https://issues.apache.org/jira/browse/KYLIN-5955
> Project: Kylin
>  Issue Type: New Feature
>Reporter: zhong.zhu
>Assignee: zhong.zhu
>Priority: Major
> Fix For: 5.0.0
>
>
> h3. update release script with gluten
> - add gluten relevant dependencies
> {code:bash}
> ./build/release/release.sh -withGluten
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5888) Support _ymdint_between function

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5888.
-

> Support _ymdint_between function
> 
>
> Key: KYLIN-5888
> URL: https://issues.apache.org/jira/browse/KYLIN-5888
> Project: Kylin
>  Issue Type: New Feature
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5824) refine handel error for export models

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5824.
-

> refine handel error for export models
> -
>
> Key: KYLIN-5824
> URL: https://issues.apache.org/jira/browse/KYLIN-5824
> Project: Kylin
>  Issue Type: Bug
>Reporter: chunyan.huang
>Assignee: chunyan.huang
>Priority: Minor
> Fix For: 5.0.0
>
>
> The system reports error when the number of models exceeds 256



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5962) Realization type is wrong when hitting snapshot or internalTable

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5962.
-

> Realization type is wrong when hitting snapshot or internalTable
> 
>
> Key: KYLIN-5962
> URL: https://issues.apache.org/jira/browse/KYLIN-5962
> Project: Kylin
>  Issue Type: Bug
>  Components: Others, Query Engine
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5894) Temporary writable db config support for hive transactional table building

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5894.
-

> Temporary writable db config support for hive transactional table building
> --
>
> Key: KYLIN-5894
> URL: https://issues.apache.org/jira/browse/KYLIN-5894
> Project: Kylin
>  Issue Type: New Feature
>  Components: Job Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5814) query cache support redis sentinel mode

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5814.
-

> query cache support redis sentinel mode
> ---
>
> Key: KYLIN-5814
> URL: https://issues.apache.org/jira/browse/KYLIN-5814
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> query cache support redis sentinel mode



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5764) Sum expression supports if condition

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5764.
-

> Sum expression supports if condition
> 
>
> Key: KYLIN-5764
> URL: https://issues.apache.org/jira/browse/KYLIN-5764
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5946) Integration with gluten

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5946?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5946.
-

> Integration with gluten
> ---
>
> Key: KYLIN-5946
> URL: https://issues.apache.org/jira/browse/KYLIN-5946
> Project: Kylin
>  Issue Type: New Feature
>  Components: Job Engine, Query Engine
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: Zhichao  Zhang
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5695) Code refactoring : Filter condition -> rewrite

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5695.
-

> Code refactoring :  Filter condition -> rewrite
> ---
>
> Key: KYLIN-5695
> URL: https://issues.apache.org/jira/browse/KYLIN-5695
> Project: Kylin
>  Issue Type: Improvement
>  Components: Modeling
>Affects Versions: 5.0-beta
>Reporter: Yaguang Jia
>Assignee: Yaguang Jia
>Priority: Minor
> Fix For: 5.0.0
>
>
> h2. Dev Design
> Rewrite the Filter condition functionality for models:
> 1. When it is found that the field definition of a model does not comply with 
> the two-phase definition, a KylinException is generated with necessary error 
> information.
> 2. When it is found that the filter condition of an imported model does not 
> meet the definition of the model (including case sensitivity issues), a 
> KylinException is generated with necessary error information.
>  
> 
> h1. Dev Design
> 对模型的Filter condition的rewrite功能重写:
>  # 当发现模型的字段定义不符合两段式定义时,产生KylinException,并附带必要的错误信息;
>  # 当发现导入的模型的filter condition,不满足模型的定义时(包括大小写匹配问题),产生KylinException,并附带必要的错误信息;



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5830) When the query connects two or more tables, the query results are inconsistent whether the order by field is in the select field or not

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5830.
-

> When the query connects two or more tables, the query results are 
> inconsistent whether the order by field is in the select field or not
> ---
>
> Key: KYLIN-5830
> URL: https://issues.apache.org/jira/browse/KYLIN-5830
> Project: Kylin
>  Issue Type: New Feature
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> Q1:
> {code:java}
> select CUSTOMER.C_PHONE
> -- ,LO_PARTKEY
> from SSB.CUSTOMER left join SSB.LINEORDER on 
> CUSTOMER.C_CUSTKEY=LINEORDER.LO_CUSTKEY
> order by LINEORDER.LO_PARTKEY NULLS LAST
> LIMIT 500{code}
> Calcite Plan:
> {code:java}
> KapProjectRel(C_PHONE=[$6], ctx=[])
>   KapLimitRel(ctx=[], fetch=[500])
> KapSortRel(sort0=[$12], dir0=[ASC], ctx=[])
>   KapJoinRel(condition=[=($0, $11)], joinType=[left], ctx=[])
> KapTableScan(table=[[SSB, CUSTOMER]], ctx=[1@NDataflow [test]], 
> fields=[[0, 1, 2, 3, 4, 5, 6, 7, 8]])
> KapTableScan(table=[[SSB, LINEORDER]], ctx=[2@NDataflow [test1]], 
> fields=[[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17]]){code}
> Q2:
> {code:java}
> select CUSTOMER.C_PHONE
> ,LO_PARTKEY
> from SSB.CUSTOMER left join SSB.LINEORDER on 
> CUSTOMER.C_CUSTKEY=LINEORDER.LO_CUSTKEY
> order by LINEORDER.LO_PARTKEY NULLS LAST
> LIMIT 500{code}
> Calcite Plan
> {code:java}
> KapLimitRel(ctx=[], fetch=[500])
>   KapSortRel(sort0=[$1], dir0=[ASC], ctx=[])
> KapProjectRel(C_PHONE=[$6], LO_PARTKEY=[$12], ctx=[])
>   KapJoinRel(condition=[=($0, $11)], joinType=[left], ctx=[])
> KapTableScan(table=[[SSB, CUSTOMER]], ctx=[1@NDataflow [test]], 
> fields=[[0, 1, 2, 3, 4, 5, 6, 7, 8]])
> KapTableScan(table=[[SSB, LINEORDER]], ctx=[2@NDataflow [test1]], 
> fields=[[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17]])
> {code}
> In SortRel, the columns used are not pushed down to the sub OlapContext. To 
> fix this issue, need to add the columns to the sub OlapContext.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5890) The available queue capacity size is inaccurate

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5890.
-

> The available queue capacity size is inaccurate
> ---
>
> Key: KYLIN-5890
> URL: https://issues.apache.org/jira/browse/KYLIN-5890
> Project: Kylin
>  Issue Type: Bug
>  Components: Job Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5828) During multi-jobs concurrent building, the flat table may use inconsistent global dictionaries, resulting in incorrect count distinct query results.

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5828?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5828.
-

> During multi-jobs concurrent building, the flat table may use inconsistent 
> global dictionaries, resulting in incorrect count distinct query results.
> 
>
> Key: KYLIN-5828
> URL: https://issues.apache.org/jira/browse/KYLIN-5828
> Project: Kylin
>  Issue Type: Bug
>  Components: Storage - Parquet
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> *Root Cause*
> When multiple tasks are concurrently building and using the same global 
> dictionary, the consistency of the dictionary version used in the flat table 
> encoding process is not guaranteed. At the same time, another task expands 
> the dictionary, causing some flat table partitions to mistakenly use the new 
> version of the dictionary partition file. Due to the inconsistent data 
> distribution, the correct dictionary content cannot be obtained, resulting in 
> a flat table encoding column of 0 and ultimately causing an abnormal count 
> distinct value.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5840) Upgrade org.xerial.snappy:snappy-java to version 1.1.10.4

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5840.
-

> Upgrade org.xerial.snappy:snappy-java to version 1.1.10.4
> -
>
> Key: KYLIN-5840
> URL: https://issues.apache.org/jira/browse/KYLIN-5840
> Project: Kylin
>  Issue Type: Improvement
>  Components: Others
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> Upgrade org.xerial.snappy:snappy-java to version 1.1.10.4



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5842) When an async query hits the cache, it is unable to download the results.

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5842.
-

> When an async query hits the cache, it is unable to download the results.
> -
>
> Key: KYLIN-5842
> URL: https://issues.apache.org/jira/browse/KYLIN-5842
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> When an asynchronous query hits the cache, it is unable to download the 
> results.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5823) improve text recognition dialog of add batch dimensions

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5823?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5823.
-

> improve text recognition dialog of add batch dimensions
> ---
>
> Key: KYLIN-5823
> URL: https://issues.apache.org/jira/browse/KYLIN-5823
> Project: Kylin
>  Issue Type: Improvement
>Reporter: chunyan.huang
>Assignee: chunyan.huang
>Priority: Minor
> Fix For: 5.0.0
>
> Attachments: image-2024-04-11-11-42-40-903.png, 
> image-2024-04-11-11-43-11-768.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5928) Update ScalarSubqueryJoinRule to adapt calcite 1.30

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5928.
-

> Update ScalarSubqueryJoinRule to adapt calcite 1.30
> ---
>
> Key: KYLIN-5928
> URL: https://issues.apache.org/jira/browse/KYLIN-5928
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5865) Supports OlapFilterJoinRule.FILTER_ON_JOIN

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5865.
-

> Supports OlapFilterJoinRule.FILTER_ON_JOIN
> --
>
> Key: KYLIN-5865
> URL: https://issues.apache.org/jira/browse/KYLIN-5865
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
> Attachments: 8813.1.png, 8813.2.png, 8813.3.png, 8813.4.png
>
>
> The following SQL hit index problem, casually add a filter condition will 
> lead to repair failure, resulting in the query hit aggregation + detail, the 
> expectation is to hit the aggregate index.
>  !8813.1.png! 
>  !8813.2.png! 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5957) Fix download-async-profiler.sh

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5957?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5957.
-

> Fix download-async-profiler.sh
> --
>
> Key: KYLIN-5957
> URL: https://issues.apache.org/jira/browse/KYLIN-5957
> Project: Kylin
>  Issue Type: Bug
>  Components: Others
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>
> missing `musl` related profilers



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5881) Import models from other project should consider merging ruleBasedIndex

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5881.
-

> Import models from other project should consider merging ruleBasedIndex
> ---
>
> Key: KYLIN-5881
> URL: https://issues.apache.org/jira/browse/KYLIN-5881
> Project: Kylin
>  Issue Type: Bug
>  Components: Modeling
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5817) After sending the query, the number of scanRows and scanBytes in response are inaccurate

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5817.
-

> After sending the query, the number of scanRows and scanBytes in response are 
> inaccurate
> 
>
> Key: KYLIN-5817
> URL: https://issues.apache.org/jira/browse/KYLIN-5817
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-beta
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> h3. Background
> When KE calls the query interface, it is found that the scan row count 
> {{scanRows}} and scan byte count {{scanBytes}} in the response are not 
> accurate.
> h3. Root Cause
> The query interface internally calls the 
> {{collectAdaptiveSparkPlanExecMetrics}} method of {{{}QueryMetricUtils{}}}. 
> When iterating through {{{}exec.children.foreach{}}}, if the {{child}} is a 
> {{{}SparkPlan{}}}, each time the results of the new {{child}} overwrite the 
> {{newScanRow}} and {{newScanBytes}} variables without adding them up.
> h3. Dev Design
> To address the issue, replace the assignment operator {{=}} with the compound 
> addition assignment operator {{+=}} to ensure that the results are properly 
> accumulated. This change will allow for the correct aggregation of scan row 
> count and scan byte count in each iteration.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5688) After a system admin user without data permission is added to a user group with data permission for a project, the system admin still has no data permission for this proje

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5688.
-

> After a system admin user without data permission is added to a user group 
> with data permission for a project, the system admin still has no data 
> permission for this project
> -
>
> Key: KYLIN-5688
> URL: https://issues.apache.org/jira/browse/KYLIN-5688
> Project: Kylin
>  Issue Type: Bug
>  Components: Security
>Affects Versions: 5.0-alpha
>Reporter: Yaguang Jia
>Assignee: Zhiting Guo
>Priority: Minor
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5853) Optimize job_info and job_lock tables

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5853.
-

> Optimize job_info and job_lock tables
> -
>
> Key: KYLIN-5853
> URL: https://issues.apache.org/jira/browse/KYLIN-5853
> Project: Kylin
>  Issue Type: Improvement
>  Components: Job Engine
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>
> Optimize job_info and job_lock tables



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5880) Dynamically adjust parquet conf when reading and writing layout files

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5880?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5880.
-

> Dynamically adjust parquet conf when reading and writing layout files
> -
>
> Key: KYLIN-5880
> URL: https://issues.apache.org/jira/browse/KYLIN-5880
> Project: Kylin
>  Issue Type: New Feature
>  Components: Job Engine, Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


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

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5726?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5726.
-

> Remove unnecessary execution goal for deploy plugin
> ---
>
> Key: KYLIN-5726
> URL: https://issues.apache.org/jira/browse/KYLIN-5726
> Project: Kylin
>  Issue Type: Improvement
>Affects Versions: 5.0-beta
>Reporter: Hongrong Cao
>Assignee: Hongrong Cao
>Priority: Minor
> Fix For: 5.0.0
>
>
> Duplicate deploy behavior in pom.xml and kylin/pom.xml



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5854) In a read/write cluster, snapshots are automatically refreshed to maintain the original behavior

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5854.
-

> In a read/write cluster, snapshots are automatically refreshed to maintain 
> the original behavior
> 
>
> Key: KYLIN-5854
> URL: https://issues.apache.org/jira/browse/KYLIN-5854
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>
> In a read/write cluster, snapshots are automatically refreshed to maintain 
> the original behavior



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5877) Upgrade table schema of recommendation

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5877.
-

> Upgrade table schema of recommendation
> --
>
> Key: KYLIN-5877
> URL: https://issues.apache.org/jira/browse/KYLIN-5877
> Project: Kylin
>  Issue Type: Improvement
>  Components: Modeling
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Minor
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5869) Column ACL missing alias while reusing with-items

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5869.
-

> Column ACL missing alias while reusing with-items
> -
>
> Key: KYLIN-5869
> URL: https://issues.apache.org/jira/browse/KYLIN-5869
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5708) The time range of logs included in the job diagnostic package is incomplete

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5708.
-

> The time range of logs included in the job diagnostic package is incomplete
> ---
>
> Key: KYLIN-5708
> URL: https://issues.apache.org/jira/browse/KYLIN-5708
> Project: Kylin
>  Issue Type: Bug
>Affects Versions: 5.0-beta
>Reporter: Hongrong Cao
>Assignee: longfeiJiang
>Priority: Minor
> Fix For: 5.0.0
>
> Attachments: image-2023-11-16-10-27-44-668.png
>
>
> task started executing at 13:40, and the start time of schedule.log and 
> kylin.log are both at 13:49, with no previous logs.
> {quote}2022-09-21T13:54:52,089 INFO [main] diag : Extract kylin log from 
> 2022-09-21T13:49:00 to 2022-09-21T13:52:33 .
> {quote}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5821) fix model edit page pfk flag bug and enhance model canvas window position

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5821.
-

> fix model edit page pfk flag bug and enhance model canvas window position
> -
>
> Key: KYLIN-5821
> URL: https://issues.apache.org/jira/browse/KYLIN-5821
> Project: Kylin
>  Issue Type: Bug
>Reporter: chunyan.huang
>Assignee: chunyan.huang
>Priority: Minor
> Fix For: 5.0.0
>
> Attachments: image-2024-04-11-09-33-26-053.png, 
> image-2024-04-11-09-35-55-932.png, image-2024-04-11-09-36-29-178.png, 
> image-2024-04-11-11-31-27-283.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5931) Query with many hints cannot work

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5931.
-

> Query with many hints cannot work
> -
>
> Key: KYLIN-5931
> URL: https://issues.apache.org/jira/browse/KYLIN-5931
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5747) Calcite constant folding, adding strings to numbers, results not as expected when multiple plus signs are used together

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5747.
-

> Calcite constant folding, adding strings to numbers, results not as expected 
> when multiple plus signs are used together
> ---
>
> Key: KYLIN-5747
> URL: https://issues.apache.org/jira/browse/KYLIN-5747
> Project: Kylin
>  Issue Type: Bug
>Affects Versions: 5.0-beta
>Reporter: zhong.zhu
>Assignee: zhong.zhu
>Priority: Critical
> Fix For: 5.0.0
>
>
> Phenomenon:
> When more than one plus sign is used in a row and the parameters on both 
> sides of the plus sign are constants, the result is not as expected
> '1' + 3 + 3 → 7 (correct)
> '1' + 3 + '3' → 4.03 (wrong result)
> '1' + '3' + 'a' → error
> When multiple plus signs are used in a row, and the arguments on both sides 
> of the plus sign are constants, and the first plus sign results in null, the 
> use of plus signs in a row is not supported.
> e.g. 'q' + 1 + 1 -> error



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5841) Upgrade org.apache.avro:avro to version 1.11.3

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5841?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5841.
-

> Upgrade org.apache.avro:avro to version 1.11.3
> --
>
> Key: KYLIN-5841
> URL: https://issues.apache.org/jira/browse/KYLIN-5841
> Project: Kylin
>  Issue Type: Improvement
>  Components: Others
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> Upgrade org.apache.avro:avro to version 1.11.3



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5912) Dictionary encoded incorrect

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5912.
-

> Dictionary encoded incorrect
> 
>
> Key: KYLIN-5912
> URL: https://issues.apache.org/jira/browse/KYLIN-5912
> Project: Kylin
>  Issue Type: Bug
>  Components: Job Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5682) ER graph optimizes performance

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5682?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5682.
-

> ER graph optimizes performance
> --
>
> Key: KYLIN-5682
> URL: https://issues.apache.org/jira/browse/KYLIN-5682
> Project: Kylin
>  Issue Type: Improvement
>Reporter: Laura Xia
>Assignee: Laura Xia
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5829) Add a tool for generating sql from dumped metadata

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5829?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5829.
-

> Add a tool for generating sql from dumped metadata
> --
>
> Key: KYLIN-5829
> URL: https://issues.apache.org/jira/browse/KYLIN-5829
> Project: Kylin
>  Issue Type: New Feature
>  Components: Metadata
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> Add a tool for generating sql from dumped metadata
> The usage of the command is {{./bin/creata-table.sh 
> \{absolute_table_directory}}}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5974) internal table detail page partition column read error

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5974.
-

> internal table detail page partition column read error
> --
>
> Key: KYLIN-5974
> URL: https://issues.apache.org/jira/browse/KYLIN-5974
> Project: Kylin
>  Issue Type: Improvement
>  Components: Website
>Reporter: huangsheng
>Assignee: huangsheng
>Priority: Trivial
> Fix For: 5.0.0
>
> Attachments: 截屏2024-09-14 17.28.16.png, 截屏2024-09-14 17.28.54.png, 
> 截屏2024-09-14 17.28.59.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5882) Collect expandedFilterConditions to avoid segment pruning failure

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5882.
-

> Collect expandedFilterConditions to avoid segment pruning failure
> -
>
> Key: KYLIN-5882
> URL: https://issues.apache.org/jira/browse/KYLIN-5882
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5738) Query support using '+' to concatenate strings

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5738?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5738.
-

> Query support using '+' to concatenate strings
> --
>
> Key: KYLIN-5738
> URL: https://issues.apache.org/jira/browse/KYLIN-5738
> Project: Kylin
>  Issue Type: Bug
>Affects Versions: 5.0-beta
>Reporter: zhong.zhu
>Assignee: zhong.zhu
>Priority: Critical
> Fix For: 5.0.0
>
> Attachments: image-2023-12-11-11-19-24-736.png, 
> image-2023-12-11-11-24-05-314.png
>
>
> Many queries of the client's mobile reports are SQL queries with + 
> concatenated strings. The client does not agree with the SQL transformation 
> of the front-end reports and hopes that KYLIN 4.X is forward compatible with 
> this function.
> For example:
> Both the company and first_deptname fields are of type varchar(4096)
> Case one:
> SELECT company + '-' + first_deptname FROM Table name
>  
> _KYLIN 4 Query Result with Exception:_
> _Conversion to relational algebra failed to preserve datatypes:_
> _validated type:_
> _RecordType(CHAR(1) CHARACTER SET "UTF-16LE" COLLATE "UTF-16LE$en_US$primary" 
> NOT NULL EXPR$0) NOT NULL_
> _converted type:_
> _RecordType(CHAR(3) CHARACTER SET "UTF-16LE" COLLATE "UTF-16LE$en_US$primary" 
> NOT NULL EXPR$0) NOT NULL_
> _rel:_
> _LogicalSort(fetch=[500])_
> _LogicalProject(EXPR$0=[||(||('A', '_'), 'B')])
> KapTableScan(table=[[APP, A02_HR_ORGANIZATION_TALENT_CHAIN]], ctx=[], fields=
>  
> In KYLIN 3.x, the query result is right: company-deptname



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5910) Enhancement of query log

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5910?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5910.
-

> Enhancement of query log
> 
>
> Key: KYLIN-5910
> URL: https://issues.apache.org/jira/browse/KYLIN-5910
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5875) Enhance the simplification method of filter condition for segment pruning

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5875.
-

> Enhance the simplification method of filter condition for segment pruning
> -
>
> Key: KYLIN-5875
> URL: https://issues.apache.org/jira/browse/KYLIN-5875
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5958) Support storage v3 for website

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5958.
-

> Support storage v3 for website
> --
>
> Key: KYLIN-5958
> URL: https://issues.apache.org/jira/browse/KYLIN-5958
> Project: Kylin
>  Issue Type: New Feature
>  Components: Web , Website
>Affects Versions: 5.0-beta
>Reporter: huangsheng
>Assignee: huangsheng
>Priority: Blocker
> Fix For: 5.0.0
>
> Attachments: 截屏2024-09-02 16.36.39.png, 截屏2024-09-02 16.36.54.png
>
>
> Support storage v3 for website



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5932) Support info of stackTrace interception

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5932.
-

> Support info of stackTrace interception
> ---
>
> Key: KYLIN-5932
> URL: https://issues.apache.org/jira/browse/KYLIN-5932
> Project: Kylin
>  Issue Type: Improvement
>  Components: Others
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5809) Add discarded field for LayoutRecDetailResponse

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5809.
-

> Add discarded field for LayoutRecDetailResponse
> ---
>
> Key: KYLIN-5809
> URL: https://issues.apache.org/jira/browse/KYLIN-5809
> Project: Kylin
>  Issue Type: Bug
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> Add discarded field for LayoutRecDetailResponse



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5874) Change 'max concurrent limit' to project level config

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5874.
-

> Change 'max concurrent limit' to project level config
> -
>
> Key: KYLIN-5874
> URL: https://issues.apache.org/jira/browse/KYLIN-5874
> Project: Kylin
>  Issue Type: Improvement
>  Components: Job Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5804) Add clickhouse deps as default profile

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5804.
-

> Add clickhouse deps as default profile
> --
>
> Key: KYLIN-5804
> URL: https://issues.apache.org/jira/browse/KYLIN-5804
> Project: Kylin
>  Issue Type: Bug
>Reporter: Zhimin Wu
>Assignee: Zhimin Wu
>Priority: Major
> Fix For: 5.0.0
>
>
> Add clickhouse deps as default profile



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5867) add return job id for table sample

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5867.
-

> add return job id for table sample
> --
>
> Key: KYLIN-5867
> URL: https://issues.apache.org/jira/browse/KYLIN-5867
> Project: Kylin
>  Issue Type: Improvement
>  Components: Job Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>
> The sampling job should return jobId to judge whether this job is completed. 
> For example:
> {code:json}
> {
> "code":"000",
> "data":"e3aa809b-5e73-42a5-a1e1-649d53b16e2c",
> "msg":""
> } {code}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5856) Merge contents of KAPRels and OLAPRels into OlapRels

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5856.
-

> Merge contents of KAPRels and OLAPRels into OlapRels
> 
>
> Key: KYLIN-5856
> URL: https://issues.apache.org/jira/browse/KYLIN-5856
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5899) Optimization of job table and transaction

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5899?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5899.
-

> Optimization of job table and transaction
> -
>
> Key: KYLIN-5899
> URL: https://issues.apache.org/jira/browse/KYLIN-5899
> Project: Kylin
>  Issue Type: Improvement
>  Components: Job Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


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

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5719.
-

> Occasional initialization failure of the V3 global dictionary file, resulting 
> in failure of build jobs
> --
>
> Key: KYLIN-5719
> URL: https://issues.apache.org/jira/browse/KYLIN-5719
> Project: Kylin
>  Issue Type: Improvement
>Affects Versions: 5.0-beta
>Reporter: Hongrong Cao
>Assignee: Yaguang Jia
>Priority: Major
> Fix For: 5.0.0
>
>
> As in the title.
> Hopefully the occasional failure to initialize the dictionary file won't 
> affect the build task



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5730) Query dry-run for better modeling

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5730.
-

> Query dry-run for better modeling
> -
>
> Key: KYLIN-5730
> URL: https://issues.apache.org/jira/browse/KYLIN-5730
> Project: Kylin
>  Issue Type: Improvement
>Affects Versions: 5.0-beta
>Reporter: Xiaoxiang Yu
>Assignee: Xiaoxiang Yu
>Priority: Major
> Fix For: 5.0.0
>
> Attachments: KYLIN-5730-01.png, KYLIN-5730-02.png, KYLIN-5730-03.png
>
>
> h2. Background
> When user enable this feature, the query insight page will display helpful 
> message
> for user to understand why model is not match and what to do in next step.
>  
> Following messages will display some query analytics, including at least:
>  # RelNode Tree
>  # OLAPContext and matched Model for each context
>  # Spark Physical Plan
> Configuration entry is 'kylin.query.dryrun-enabled', at project level.
> h2. How to use
>  # enable this in project configuration
>  # send a query in Insight page
>  # read Dry-run message and fix something and retry
>  
> h4. Dry-run message sample:
>  # {{Last Exception :}}
> {{{}  No realization found for {id = 0, model = not matched, fact table = 
> TPCH_CN.LINEITEM{
> {{  Incapable message : MODEL_UNMATCHED_JOIN, MODEL_UNMATCHED_JOIN, 
> MODEL_UNMATCHED_JOIN, MODEL_UNMATCHED_JOIN, MODEL_UNMATCHED_JOIN, 
> MODEL_UNMATCHED_JOIN, MODEL_UNMATCHED_JOIN, MODEL_UNMATCHED_JOIN, }}
>  # {{OLAPContext(s) and matched model(s) :}}
> {{ Ctx=0 is not matched by any model/snapshot, recommend :}}
> {{ {}}
> {{   "Fact Table" : "TPCH_CN.LINEITEM",}}
> {{   "Dimension Tables" : [ "TPCH_CN.REGION", "TPCH_CN.ORDERS", 
> "TPCH_CN.SUPPLIER", "TPCH_CN.PART", "TPCH_CN.CUSTOMER", "TPCH_CN.NATION"],}}
> {{   "Query Columns" : [ "TPCH_CN.NATION.N_NAME", 
> "TPCH_CN.ORDERS.O_ORDERDATE", "TPCH_CN.REGION.R_NAME", "TPCH_CN.PART.P_TYPE", 
> "TPCH_CN.LINEITEM.DISC_PRICE"],}}
> {{   "Dimension(Group by)" : [ "TPCH_CN.ORDERS.O_ORDERDATE"],}}
> {{   "Dimension(Filter cond)" : [ "TPCH_CN.ORDERS.O_ORDERDATE", 
> "TPCH_CN.REGION.R_NAME", "TPCH_CN.PART.P_TYPE"],}}
> {{   "Measure" : [ "SUM(UNKNOWN_ALIAS.$F1)", 
> "SUM(T_1_4CD6601C.DISC_PRICE)"],}}
> {{   "Join" : "}}
> {{Fact: [T_1_4CD6601C:LINEITEM]}}
> {{  Dim: [T_1_4CD6601C:LINEITEM] INNER JOIN [T_2_716C1DB8:PART] ON 
> [L_PARTKEY] = [P_PARTKEY]}}
> {{  Dim: [T_1_4CD6601C:LINEITEM] INNER JOIN [T_3_6D21031C:SUPPLIER] ON 
> [L_SUPPKEY] = [S_SUPPKEY]}}
> {{    Dim: [T_3_6D21031C:SUPPLIER] INNER JOIN [T_7_4F00CD31:NATION] ON 
> [S_NATIONKEY] = [N_NATIONKEY]}}
> {{  Dim: [T_1_4CD6601C:LINEITEM] INNER JOIN [T_4_5CEAD9DF:ORDERS] ON 
> [L_ORDERKEY] = [O_ORDERKEY]}}
> {{    Dim: [T_4_5CEAD9DF:ORDERS] INNER JOIN [T_5_54B979E7:CUSTOMER] ON 
> [O_CUSTKEY] = [C_CUSTKEY]}}
> {{      Dim: [T_5_54B979E7:CUSTOMER] INNER JOIN [T_6_42081A08:NATION] ON 
> [C_NATIONKEY] = [N_NATIONKEY]}}
> {{        Dim: [T_6_42081A08:NATION] INNER JOIN [T_8_B14C00A:REGION] ON 
> [N_REGIONKEY] = [R_REGIONKEY]",}}
> {{   "Index Id" : 0,}}
> {{   "Query Column / Index Column" : "5 / 0",}}
> {{   "Index Columns" : []}}
> {{{} }{{
>  # {{RelNode(with ctx id) :}}
> {{  OLAPToEnumerableConverter}}
> {{  LimitRel(ctx=[0@null], fetch=[500])}}
> {{    SortRel(sort0=[$0], dir0=[ASC-nulls-first], ctx=[0@null])}}
> {{      ProjectRel(O_YEAR=[$0], MKT_SHARE=[/($1, $2)], ctx=[0@null])}}
> {{        AggregateRel(group-set=[[0]], groups=[null], agg#0=[SUM($1)], 
> agg#1=[SUM($2)], ctx=[0@null])}}
> {{          ProjectRel(O_YEAR=[EXTRACT(FLAG(YEAR), $54)], $f1=[CASE(=($72, 
> 'BRAZIL'), $16, 0)], VOLUME=[$16], ctx=[0@null])}}
> {{            FilterRel(condition=[AND(=($76, 'AMERICA'), >=($54, 
> 1995-01-01), <=($54, 1996-12-31), =($38, 'ECONOMY ANODIZED STEEL'))], 
> ctx=[0@null])}}
> {{              JoinRel(condition=[=($69, $75)], joinType=[inner], 
> ctx=[0@null])}}
> {{                JoinRel(condition=[=($46, $71)], joinType=[inner], 
> ctx=[0@null])}}
> {{                  JoinRel(condition=[=($62, $67)], joinType=[inner], 
> ctx=[0@null])}}
> {{                    JoinRel(condition=[=($51, $59)], joinType=[inner], 
> ctx=[0@null])}}
> {{                      JoinRel(condition=[=($0, $50)], joinTyp

[jira] [Closed] (KYLIN-5696) Logical view with Chinese name sampling or building exception

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5696?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5696.
-

> Logical view with Chinese name sampling or building exception
> -
>
> Key: KYLIN-5696
> URL: https://issues.apache.org/jira/browse/KYLIN-5696
> Project: Kylin
>  Issue Type: Bug
>  Components: Job Engine
>Affects Versions: 5.0-beta
>Reporter: Yaguang Jia
>Assignee: Yaguang Jia
>Priority: Major
> Fix For: 5.0.0
>
>
> *Root Cause*
> The Logical View did not handle special characters (such as Chinese table 
> names) that appear in the database table name when dropping a table.
> *Dev Design*
> Enhance the handling of special characters in DDL statements within the 
> Logical View by using backticks for annotation.
>  
> 
>  
> *Root Cause*
> Logical View 在 drop table 时没有对库表名称中出现的特殊字符(比如中文表名)做兼容处理
> *Dev Design*
> 增加 Logical View 中的 DDL 对特殊字符的处理,用反引号标注



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5891) Provide model level parameter conf api

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5891.
-

> Provide model level parameter conf api
> --
>
> Key: KYLIN-5891
> URL: https://issues.apache.org/jira/browse/KYLIN-5891
> Project: Kylin
>  Issue Type: Bug
>  Components: Modeling
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5909) Replacing ParameterExpression with iteration

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5909.
-

> Replacing ParameterExpression with iteration
> 
>
> Key: KYLIN-5909
> URL: https://issues.apache.org/jira/browse/KYLIN-5909
> Project: Kylin
>  Issue Type: Improvement
>  Components: Query Engine
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5968) Support real-time for website

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5968?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5968.
-

> Support real-time for website
> -
>
> Key: KYLIN-5968
> URL: https://issues.apache.org/jira/browse/KYLIN-5968
> Project: Kylin
>  Issue Type: New Feature
>  Components: Website
>Affects Versions: 5.0-beta
>Reporter: huangsheng
>Priority: Major
> Fix For: 5.0.0
>
> Attachments: 截屏2024-09-05 10.26.06.png, 截屏2024-09-05 10.26.11.png, 
> 截屏2024-09-05 13.55.19.png, 截屏2024-09-05 13.55.52.png
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5918) Add open api to delete project config

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5918.
-

> Add open api to delete project config
> -
>
> Key: KYLIN-5918
> URL: https://issues.apache.org/jira/browse/KYLIN-5918
> Project: Kylin
>  Issue Type: New Feature
>  Components: Others
>Affects Versions: 5.0.0
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5927) Fix refreshing catalog api

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5927?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5927.
-

> Fix refreshing catalog api
> --
>
> Key: KYLIN-5927
> URL: https://issues.apache.org/jira/browse/KYLIN-5927
> Project: Kylin
>  Issue Type: Bug
>  Components: Others
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Closed] (KYLIN-5915) Upgrade jars for vulnerbility

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5915.
-

> Upgrade jars for vulnerbility
> -
>
> Key: KYLIN-5915
> URL: https://issues.apache.org/jira/browse/KYLIN-5915
> Project: Kylin
>  Issue Type: Bug
>  Components: Others
>Affects Versions: 5.0-alpha
>Reporter: pengfei.zhan
>Assignee: pengfei.zhan
>Priority: Major
> Fix For: 5.0.0
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)


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

2024-09-27 Thread liyang (Jira)


 [ 
https://issues.apache.org/jira/browse/KYLIN-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

liyang closed KYLIN-5723.
-

> Optimize Calcite plan to convert spark logical plan
> ---
>
> Key: KYLIN-5723
> URL: https://issues.apache.org/jira/browse/KYLIN-5723
> Project: Kylin
>  Issue Type: Improvement
>Affects Versions: 5.0-beta
>Reporter: Hongrong Cao
>Assignee: Hongrong Cao
>Priority: Major
> Fix For: 5.0.0
>
>
> The problem with calcite plan to spark LogicalPlan is that it uses the 
> DataFrame interface, which means that it parses and builds the LogicalPlan at 
> the same time.
> During the process of calcite plan to spark plan, the select agg and other 
> operators execute the following methods, where the execution of 
> qe.assertAnalyzed() is of interest
> {quote}def ofRows(sparkSession: SparkSession, logicalPlan: LogicalPlan): 
> DataFrame =
>   sparkSession.withActive {
>     val qe = sparkSession.sessionState.executePlan(logicalPlan)
>     qe.assertAnalyzed()
>     new Dataset[Row](qe, RowEncoder(qe.analyzed.schema))
> }
> {quote}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


  1   2   3   4   5   6   7   8   9   10   >