配置yanagishima 既能连接Presto 又能连接Hive

Bertha 。 2023-02-18 14:22 83阅读 0赞

### 修改yanagishima的配置文件 \[ yanagishima/conf/yanagishima.properties\] ###

# yanagishima 原生配置文件
    
    # yanagishima web port
    jetty.port=7080
    # if query result exceeds this limit, to show rest of result is skipped
    select.limit=500
    # http header name for audit log
    audit.http.header.name=some.auth.header
    use.audit.http.header.name=false
    # limit to convert from tsv to values query
    to.values.query.limit=500
    # authorization feature
    check.datasource=false
    cors.enabled=false
    
    
    # 配置 查询引擎即支持 presto 又支持hive
    sql.query.engines=presto,hive
    
    
    #配置presto信息
    
    # 30 minutes. If presto query exceeds this time, yanagishima cancel the query.
    presto.query.max-run-time-seconds=1800
    # 1GB. If presto query result file size exceeds this value, yanagishima cancel the query.
    presto.max-result-file-byte-size=1073741824
    # you can specify freely. But you need to specify same name to presto.coordinator.server.[...] and presto.redirect.server.[...] and catalog.[...] and schema.[...]
    presto.datasources=prestocluster
    auth.your-presto=false
    # presto coordinator url
    presto.coordinator.server.prestocluster=http://presto-server:8989
    # almost same as presto coordinator url. If you use reverse proxy, specify it
    presto.redirect.server.your-presto=http://presto.coordinator:8080
    # presto catalog name
    catalog.prestocluster=hive
    # presto schema name
    schema.prestocluster=default
    resource.manager.url.prestocluster=http://localhost:8088
    
    
    #单独配置hive信息
    hive.datasources=prestocluster
    hive.jdbc.url.prestocluster=jdbc:hive2://hive-server:10000/default
    hive.jdbc.user.prestocluster=hdfs
    hive.jdbc.password.prestocluster=hdfs
    hive.query.max-run-time-seconds.prestocluster=3600
    hive.max-result-file-byte-size=1073741824
    hive.query.max-run-time-seconds=3600

[yanagishima github : https://github.com/yanagishima/yanagishima][yanagishima github _ https_github.com_yanagishima_yanagishima]

web config : [https://yanagishima.github.io/yanagishima/config/][https_yanagishima.github.io_yanagishima_config]

[yanagishima github _ https_github.com_yanagishima_yanagishima]: https://github.com/yanagishima/yanagishima
[https_yanagishima.github.io_yanagishima_config]: https://yanagishima.github.io/yanagishima/config/