apache-kylin-4.0.4-bin-spark3（使用mysql存储元数据）下载安装部署

1.下载kylin下载地址下载 Apache Kylin | Apache Kylin2.解压安装tar -zxvf /opt/modules/apache-kylin-4.0.4-bin-spark3 -C /opt/installs3.配置环境vi /etc/profileexport KYLIN_HOME/opt/installs/apache-kylin-4.0.4-bin-spark3/export PATH$PATH:$KYLIN_HOME/binexport HADOOP_CONF_DIR/opt/installs/hadoop3.1.4/etc/hadoopexport HIVE_HOME/opt/installs/hive4.mysql进行的操作1降低密码难度mysql -u root -p EOF SET GLOBAL validate_password.policy LOW; SET GLOBAL validate_password.length 4; FLUSH PRIVILEGES; EOF2创建用户mysql -u root -p EOF CREATE DATABASE IF NOT EXISTS kylin DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; CREATE USER IF NOT EXISTS kylinlocalhost IDENTIFIED BY 123456; GRANT ALL PRIVILEGES ON kylin.* TO kylinlocalhost; FLUSH PRIVILEGES; EOF3验证是否成功mysql -u kylin -p123456 -e SHOW DATABASES;5.更新kylin.propreties配置cat $KYLIN_HOME/conf/kylin.properties EOF # Zookeeper kylin.env.zookeeper-connect-stringhadoop11:2181,hadoop12:2181,hadoop13:2181 # Hadoop 配置目录 kylin.env.hadoop-conf-dir/opt/installs/hadoop3.1.4/etc/hadoop # 使用 MySQL 作为元数据存储 kylin.metadata.urlkylin_metadatajdbc,driverClassNamecom.mysql.cj.jdbc.Driver,urljdbc:mysql://localhost:3306/kylin?useSSLfalseallowPublicKeyRetrievaltruecharacterEncodingutf8,usernamekylin,password123456 # 运行模式 kylin.env.modeALL kylin.server.modeall kylin.server.port7070 # Hive 配置 kylin.source.hive.database-for-flat-tabledefault # Spark 配置 kylin.engine.spark-conf.spark.masteryarn kylin.engine.spark-conf.spark.submit.deployModecluster EOF6.复制jdbc驱动器把jdbc驱动器如mysql-connector-java-8.0.26.jar粘贴到kylin的bin目录下7.启动命令start-all.sh(启动hdfs和yarn)hive-service-manager.sh start (启动hive)zk.sh启动zookeeperkylin.sh start(启动kylin)8.我遇到的报错Caused by: java.lang.ClassNotFoundException: org.apache.commons.configuration.ConfigurationException解决wget -P /opt/installs/apache-kylin-4.0.4-bin-spark3/tomcat/webapps/kylin/WEB-INF/lib/ \ https://repo1.maven.org/maven2/commons-configuration/commons-configuration/2.10/commons-configuration-2.10.jarwget https://repo1.maven.org/maven2/commons-lang/commons-lang/2.6/commons-lang-2.6.jar wget https://repo1.maven.org/maven2/commons-logging/commons-logging/1.2/commons-logging-1.2.jar wget https://repo1.maven.org/maven2/commons-collections/commons-collections/3.2.2/commons-collections-3.2.2.jar