trino 357
yanagishima v23.0
export JAVA_HOME=/home/bduser/zulu-jdk11.0.10
echo PATH=/home/bduser/zulu-jdk11.0.10/bin:$PATH
export PATH=/home/bduser/zulu-jdk11.0.10/bin:$PATH
wget https://services.gradle.org/distributions/gradle-6.8.2-bin.zip
unzip gradle-6.8.2-bin.zip
export GRADLE_HOME="/opt/gradle-6.8.2"
export PATH=$PATH:$GRADLE_HOME/bin
gradle -v
wget https://nodejs.org/dist/v10.16.3/node-v10.16.3-linux-x64.tar.xz
tar -xf node-v10.16.3-linux-x64.tar.xz
mv node-v10.16.3-linux-x64 nodejs
chown -R root:root nodejs
nodejs/bin/node -v
ln -s /opt/software/nodejs/bin/node /usr/local/bin
ln -s /opt/software/nodejs/bin/npm /usr/local/bin
ll /usr/local/bin/
npm config set unsafe-perm
npm config -g set unsafe-perm
npm install -g mirror-config-china --registry=http://registry.npm.taobao.org
npm install node-sass
git clone https://github.com/yanagishima/yanagishima.git
cd yanagishima
#查询当前可供选择的tag
git tag
#切换对应的分支,选择 22.0 版本,安装jdk11版本,必须使用20.0之后的分支
git checkout -b 22.0 refs/tags/22.0
#查看当前所在分支
git branch
修改一些文件 主要问题时 presto分解,当前免费版本叫 trino,代码引用和权限确认都需要改造
不然后去启动报错如下:
2021/11/19 15:57:02.619 +0800 ERROR [PrestoController] [Yanagishima] Authentication failed: Basic authentication or X-Trino-User must be sent
io.prestosql.client.ClientException: Authentication failed: Basic authentication or X-Trino-User must be sent
重新修改 Yanagishima 源码,将 presto相关的部分改为trino
https://github.com/yanagishima/yanagishima/pull/298/files
注意:trino的版本需要你本地版本一直,不如上面修改的代码里trino版本需要改为我的本地trino版本 357
编辑编译文件 build.gradle
repositories {
mavenCentral()
maven { url 'http://maven.aliyun.com/nexus/content/groups/public/' }
maven { url 'http://maven.aliyun.com/nexus/content/repositories/jcenter' }
maven { url "https://repo.hortonworks.com/repository/jetty-hadoop" }
maven { url "https://repo.hortonworks.com/content/repositories/releases" }
maven { url "https://repo.hortonworks.com/content/groups/public" }
maven { url "https://plugins.gradle.org/m2/" }
}
./gradlew distZip
编译好的压缩包在 build/distributions 下, 拷贝到需要部署的位置 解压后 修改配置文件
···
##cat application.yml
server:
port: 8084
jetty:
max-http-form-post-size: 2GB
spring:
application:
name: yanagishima
datasource:
driver-class-name: com.mysql.jdbc.Driver
username: ****
password: ****
url: jdbc:mysql://192.168.16.**:3306/yanagishima?allowPublicKeyRetrieval=true&useSSL=false
initialization-mode: always
resources:
static-locations: file:web
# Metrics
gement:
metrics:
export.prometheus.enabled: true
distribution:
percentiles:
http.server.requests: 0.5, 0.75, 0.95, 0.99
endpoint:
metrics.enabled: true
prometheus.enabled: true
heapdump.enabled: false
health:
show-details: always
env:
keys-to-sanitize: .*password.*
endpoints:
web.exposure.include: '*'
# Datasources
sql.query.engines: presto
check.datasource: false
select.limit: 500
audit.http.header.name: some.auth.header
use.audit.http.header.name: false
to.values.query.limit: 500
cors.enabled: true
# Trino
presto.datasources: docker-presto
presto.query.max-run-time-seconds: 1800
presto.max-result-file-byte-size: 1073741824
auth.docker-presto: false
presto.coordinator.server.docker-presto: http://localhost:8085
presto.redirect.server.docker-presto: http://localhost:8085/ui
catalog.docker-presto: hive
schema.docker-presto: default
/opt/software/zulu-jdk11.0.10/bin/java 添加到bin/yanagishima-start.sh 中 保证java是11版本
nohup bin/yanagishima-start.sh >y.log 2>&1 &
web 访问:
http://192.168.16.36:8084/
编译好下载路径
yanagishima-23.0 编译后.zip
欢迎点赞
https://download.csdn.net/download/htmljsp/86890544 免费资源,欢迎点赞