[ https://issues.apache.org/jira/browse/KYLIN-5145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17469038#comment-17469038 ]
qingquanzhang edited comment on KYLIN-5145 at 1/5/22, 9:13 AM: --------------------------------------------------------------- I found the cause of the problem, The spark installed in the environment is 2.4.5.However, Kylin4 does not support Spark 2.4.5 So I added a line in find-spark-dependency. sh :export SPARK_HOME=/opt/kylin/spark-3.1.1-bin-hadoop3.2 I also put spark-3.1.1-bin-hadoop3.2 in the corresponding directory. But when I debug the code,I found that the value of the "SPARK_VERSION" variable is not the version I set. But 2.4.5(org.apache.spark.utils.KylinReflectUtils#getSessionState ) When I run kylin.sh start, I see a message :Skip spark which not owned by kylin. SPARK_HOME is /opt/kylin/spark-3.1.1-bin-hadoop3.2 and KYLIN_HOME is /opt/kylin . The build engine works, but the query engine does not. I am very confused, was (Author: qingquan): I found the cause of the problem, I added a line in find-spark-dependency. sh :export SPARK_HOME=/opt/kylin/spark-3.1.1-bin-hadoop3.2 But when I debug the code,I found that the value of the "SPARK_VERSION" variable is not the version I set.(org.apache.spark.utils.KylinReflectUtils#getSessionState ) When I run kylin.sh start, I see a message :Skip spark which not owned by kylin. SPARK_HOME is /opt/kylin/spark-3.1.1-bin-hadoop3.2 and KYLIN_HOME is /opt/kylin . I am very confused > Query Failed:wrong number of arguments while executing SQL > ---------------------------------------------------------- > > Key: KYLIN-5145 > URL: https://issues.apache.org/jira/browse/KYLIN-5145 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v4.0.0 > Environment: spark3.1.1 > hadoop3.1.3 > hive:3.1.2 > kylin4.0.0-spark3 > Reporter: qingquanzhang > Priority: Major > Attachments: find-spark-dependency.sh, kylin.log > > > An error occurred when I initiated the query: > java.lang.IllegalArgumentException: wrong number of arguments while executing > SQL: "select * from (select count(*) from kylin_sales) limit 50000" -- This message was sent by Atlassian Jira (v8.20.1#820001)