saiku+kettle整合（十一）日志相关

最新推荐文章于 2018-11-21 15:12:26 发布

weixin_33841722

最新推荐文章于 2018-11-21 15:12:26 发布

阅读量200

点赞数

CC 4.0 BY-SA版权

文章标签： java

原文链接：https://juejin.im/post/5a4ef335f265da3e38494bab

本文介绍如何配置Saiku的日志记录功能，通过设置log4j来捕获SQL和MDX相关的日志信息，并提供了详细的log4j.xml配置示例。

title: saiku+kettle整合（十一）日志相关 tags:

OLAP categories: saiku date: 2016-08-25 18:18:54

日志相关

saiku使用log4j记录日志。详细配置见log4j.xml

对于开发测试环境下建议打开所有的log配置。

    <appender name="MONDRIAN" class="org.apache.log4j.RollingFileAppender">
      <param name="File" value="${catalina.base}/logs/mondrian.log"/>
      <param name="Append" value="false"/>
      <param name="MaxFileSize" value="500KB"/>
      <param name="MaxBackupIndex" value="1"/>
     
      <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern" value="%d %-5p [%c] %m%n"/>
      </layout>
    </appender>
     
    <category name="mondrian">
       <priority value="DEBUG"/>
       <appender-ref ref="MONDRIAN"/>
    </category>
    <appender name="MDXLOG" class="org.apache.log4j.RollingFileAppender">
      <param name="File" value="${catalina.base}/logs/mondrian_mdx.log"/>
      <param name="Append" value="false"/>
      <param name="MaxFileSize" value="500KB"/>
      <param name="MaxBackupIndex" value="1"/>
      <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern" value="%d %-5p [%c] %m%n"/>
      </layout>
    </appender>
     
    <category name="mondrian.mdx">
       <priority value="DEBUG"/>
       <appender-ref ref="MDXLOG"/>
    </category>
    <appender name="SQLLOG" class="org.apache.log4j.RollingFileAppender">
      <param name="File" value="${catalina.base}/logs/mondrian_sql.log"/>
      <param name="Append" value="false"/>
      <param name="MaxFileSize" value="500KB"/>
      <param name="MaxBackupIndex" value="1"/>
      <layout class="org.apache.log4j.PatternLayout">
        <param name="ConversionPattern" value="%d %-5p [%c] %m%n"/>
      </layout>
    </appender>
     
    <category name="mondrian.sql">
       <priority value="DEBUG"/>
       <appender-ref ref="SQLLOG"/>
    </category>
复制代码

此配置会打印包括sql，mdx相关的log

日志路径见saiku-server/tomcat/logs/saiku.log

2016-09-06 16:11:46,728 DEBUG [mondrian.sql] 62: Segment.load: executing sql [select "dim_date"."year_number" as "c0", "dim_date"."quarter_number" as "c1", avg("earthquakes"."mag") as "m0", avg("earthquakes"."depth") as "m1" from "earthquakes" as "earthquakes", "dim_date" as "dim_date" where "earthquakes"."time" = "dim_date"."date_sk" group by "dim_date"."year_number", "dim_date"."quarter_number"]
复制代码