mondrian-kylin连接

jchrr9hc  于 2021-06-26  发布在  Kylin
关注(0)|答案(0)|浏览(284)

有没有人有蒙德里安和Kylin之间联系的有效例子?我发现mondrian上的独特版本可以在github上的这个报告中找到,它可以独立运行,远离pentaho/saiku的其他东西。
因此,我下载了war并将其移动到tomcat的webapps目录中,然后按照本网站的建议升级了一些jar。
问题是似乎什么都不管用。
我将数据源定义如下:
数据源-\kylin.xml

<?xml version="1.0"?>
<!--
http://mondrian.pentaho.com/documentation/installation.php#5_1_Describe_the_data_sources_in_datasources.xml
-->
<DataSources>
  <DataSource>
    <DataSourceName>test</DataSourceName>
    <DataSourceDescription>test from kylin</DataSourceDescription>
    <URL>http://localhost:8080/xmondrian/xmla</URL>
    <DataSourceInfo>Provider=mondrian; Jdbc=jdbc:kylin://192.168.127.100:7070/Luca_test; JdbcDrivers=org.apache.kylin.jdbc.Driver; JdbcUser=ADMIN; JdbcPassword=KYLIN</DataSourceInfo>
    <ProviderName>Mondrian</ProviderName>
    <ProviderType>MDP</ProviderType>
    <AuthenticationMode>Unauthenticated</AuthenticationMode>
    <Catalogs>
        <Catalog name="test">
            <Definition>/WEB-INF/schema/test.xml</Definition>
        </Catalog>
    </Catalogs>
  </DataSource>
</DataSources>

test.xml(模式)

<?xml version="1.0"?>
<Schema name="schema qualcosa" description="ancora di +" measuresCaption="bho" defaultRole="non lo so">
  <Cube name="il nome del cubo" caption="non ho idea di cosa possa essere" visible="true" description="come sopra + esteso" cache="false" enabled="true">
    <Table name="SAK_FACT_TRANSACTIONS" schema="UNIFIEDDATA_WORK" alias="transaction">
    </Table>
    <Dimension type="StandardDimension" visible="true" foreignKey="PRICE" name="SAK_FACT_TRANSACTIONS_PRICE">
    </Dimension>
    <Measure name="price" column="PRICE" datatype="Numeric" aggregator="sum" formatter="$#,##0.00" description="price come sopra" visible="true">
    </Measure>
  </Cube>
</Schema>

tomcat日志显示:

10:06:06,331 ERROR [XmlaServlet] Errors when handling XML/A message
mondrian.xmla.XmlaException: Mondrian Error:XMLA Discover unparse results error
        at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2904)
        at mondrian.xmla.XmlaHandler.process(XmlaHandler.java:671)
        at mondrian.xmla.impl.DefaultXmlaServlet.handleSoapBody(DefaultXmlaServlet.java:507)
        at mondrian.xmla.XmlaServlet.doPost(XmlaServlet.java:318)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
        at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
        at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.NullPointerException
        at mondrian.olap.Util.readURL(Util.java:3243)
        at mondrian.server.UrlRepositoryContentFinder.getContent(UrlRepositoryContentFinder.java:44)
        at mondrian.server.FileRepository.getServerInfo(FileRepository.java:236)
        at mondrian.server.FileRepository.getConnection(FileRepository.java:117)
        at mondrian.server.MondrianServerImpl.getConnection(MondrianServerImpl.java:262)
        at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:2976)
        at mondrian.xmla.XmlaHandler.getConnection(XmlaHandler.java:177)
        at mondrian.xmla.Rowset.populate(Rowset.java:219)
        at mondrian.xmla.Rowset.unparse(Rowset.java:194)
        at mondrian.xmla.XmlaHandler.discover(XmlaHandler.java:2898)
        ... 27 more

该模式已验证到工作台模式中。任何帮助都将受到感激和欢迎。任何帮助。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题