Shulou(Shulou.com)06/03 Report--

After downloading the official tar package, extract it and configure KYLIN_HOME and HIVE_CONF (directory where hive-site.xml is located).

Configure conf/kylin.properties and tomcat/conf/server.xml

conf/kylin.properties Configure according to your own needs, mainly configure the relevant parameters of hive and hbase,

There are two main things to note about tomcat/conf/server.xml:

1.keystore

You need to generate a keystore file, or comment out this paragraph.

2. I didn't modify this in the test environment. It works normally. When deploying the production machine, open the UI at the front end, and there will be problems such as unable to load models, configuration, and environment variables. At the same time, the prompt "failed to take actions" will pop up in the foreground.

After several days of searching, it was found that there was a problem with the front end obtaining resources when decompressing, and the compression was turned off.

compression="on" to compression="off"

And then it's ready to go.

Part of the dimensions filter the wrong questions. The reason we use this project is the kylin-mondrian'dialect pack https://github.com/mustangore/kylin-mondrian-interaction, by mustangore When filtering, an upper function is added before and after the where condition, while in kylin, it is not supported to add an upper function after the where condition. Here, the source code of that package needs to be modified. There is no source code in the project, but there is a patch file based on mondrian4.4, because this project is also based on mondrian code to modify, so first go to the mondrian official github project to download the version 4.4 source code, and then enter the patch file in the mustangore project Address: github.com/pentaho/mondrian/tree/4.4 Unzip and enter the home directory Use the command git apply xxx.patch Patch file into mondrian4.4 source code, which is equivalent to obtain the mustangore project source code. Then modify this class: /src/main/java/mondrian/spi/impl/KylinDialect.java Add a method to this class: @Overridepublic String toUpper(String expr) { return expr;} That's enough, This is equivalent to overriding the methods of the parent class.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.