Richard Calaba created KYLIN-1525:
-------------------------------------

             Summary: XML/A for Kylin
                 Key: KYLIN-1525
                 URL: https://issues.apache.org/jira/browse/KYLIN-1525
             Project: Kylin
          Issue Type: New Feature
          Components: Query Engine
            Reporter: Richard Calaba
            Assignee: liyang


It would be great if Kylin can be accessed also by standard OLAP tools 
supporting XML/A so native OLAP queries can be raised by Kylin.

I have seen somewhere on the Internet the option to use Pentaho Mondrian with 
some Kylin-patch to achieve this. However I found much simpler solution 
open-sourced here - https://github.com/Wondersoft/olaper .

The idea would be to include the Olaper code-line and use it to generate Cubes 
Query interface for XML/A directly in Kylin. Kylin knows both - the logical 
structure of the Cube and the storage structure - that's excatly what is needed 
for Olaper to make it work - you need JDBC Driver and then a 2 metadata files 
(cube.json and table.json) to describe to the Olaper the logical and physical 
cube structure ...

I believe that would be very powerful extension opening Kylin to other OLAP UI 
tools (like Saiku i.e.). Today we just rely on Tableau UI consuming Kylin 
through ODBC driver.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to