Hi Dong Wang,
it seems, Mondrian is not using the Kylin dialect correctly. How do you connect
to Kylin?
In Java, it should look something like this:
-------------------------------------------------------------------------------------------
Class.forName("mondrian.olap4j.MondrianOlap4jDriver");
final Connection connection = DriverManager.getConnection("jdbc:mondrian:"
+ "Jdbc=jdbc:kylin://localhost:7070/your_project_name;"
+ "JdbcDrivers=org.apache.kylin.jdbc.Driver;"
+ "JdbcUser=admin;"
+ "JdbcPassword=KYLIN;"
+ "Catalog=file:/absolute/path/to/your/mondrian/schema.xml;");
// We are dealing with an OLAP connection. we must unwrap it.
final OlapConnection olapConnection = connection.unwrap(OlapConnection.class);
// Prepare a statement.
final OlapStatement olapStatement = olapConnection.createStatement();
// Your MDX Statement
String mdxStatement = "YOUR_MDX_STATEMENT";
CellSet cellSet = olapStatement.executeOlapQuery(mdxStatement);
// Print out.
RectangularCellSetFormatter formatter = new RectangularCellSetFormatter(false);
PrintWriter writer = new PrintWriter(System.out);
formatter.format(cellSet, writer);
writer.flush();
-------------------------------------------------------------------------------------------
You can download and try my Mondrian Lagunitas Snapshot with added Kylin
dialect:
https://github.com/mustangore/thesis/blob/master/Mondrian/mondrian-lagunitas-SNAPSHOT-with-kylin-dialect.jar
<https://github.com/mustangore/thesis/blob/master/Mondrian/mondrian-lagunitas-SNAPSHOT-with-kylin-dialect.jar>
Best regards,
Sébastien
> Am 17.06.2015 um 14:24 schrieb dong wang <[email protected]>:
>
> Hi Sébastien Jelsch,
>
> I use the source codes from
> https://github.com/mustangore/mondrian/tree/lagunitas and apply your
> changes for the 4 files, then I use jar command to create the
> mondrian*.jar, with this jar file, although mondrian can connect kylin,
> however, by default it doesn't use "JOIN" syntax, for example:
>
> it use syntax like: select a.*, b.* from a, b where a.id=b.id, and as we
> expected, it SHOULD be like: select a.*, b.* from a jon b on a.id=b.id, so,
> is there any more changes before building the mondrian jar file?
>
>
> 2015-06-12 19:00 GMT+08:00 Tao Wong <[email protected]>:
>
>> Problem solved !
>> it's case sensitivity in my schema xml file as the tables and columns in
>> kylin are all uppercase.
>>
>> 2015-06-12 18:25 GMT+08:00 Tao Wong <[email protected]>:
>>
>>> Hi,divye.
>>>
>>> i got some progress. thank you
>>> it results that the commons-httpclient-20020423.jar in saiku is too old
>>> and we update it with commons-httpclient-3.1.jar.
>>> but another problem arises as below:
>>>
>>> name:kylin
>>> driver:mondrian.olap4j.MondrianOlap4jDriver
>>>
>>>
>> url:jdbc:mondrian:Jdbc=jdbc:kylin:/hostname:8080/user;Catalog=mondrian:///datasources/kylin.xml;JdbcDrivers=org.apache.kylin.jdbc.Driver
>>> 18:17:59,340 WARN [HttpMethodBase] Going to buffer response body of
>> large
>>> or unknown size. Using getResponseBodyAsStream instead is recommended.
>>> 18:17:59,359 ERROR [SecurityAwareConnectionManager] Error connecting:
>> kylin
>>> mondrian.rolap.RolapSchema$MondrianSchemaException: Table 'test_table'
>>> does not exist in database. (in Table) (at line 0, column 97)
>>> at
>>>
>> mondrian.rolap.RolapSchemaLoaderHandlerImpl.warning(RolapSchemaLoaderHandlerImpl.java:72)
>>> at
>>>
>> mondrian.rolap.RolapSchemaLoaderHandlerImpl.warning(RolapSchemaLoaderHandlerImpl.java:62)
>>> at
>>>
>> mondrian.rolap.RolapSchema$PhysTable.populateColumns(RolapSchema.java:1835)
>>> at
>>>
>> mondrian.rolap.RolapSchema$PhysRelationImpl.ensurePopulated(RolapSchema.java:1519)
>>> at
>>>
>> mondrian.rolap.RolapSchema$PhysTable.ensurePopulated(RolapSchema.java:1729)
>>> at
>>>
>> mondrian.rolap.RolapSchemaLoader.registerTable(RolapSchemaLoader.java:1051)
>>>
>>> howerver the test_table does exist in our project.
>>> have you encounter this ever?
>>>
>>> Thanks
>>>
>>> 2015-06-12 16:47 GMT+08:00 divye sheth <[email protected]>:
>>>
>>>> Hi Tao,
>>>>
>>>> I am using the kylin-0.7.1 incubating version but with modifications as
>>>> suggested by Sebastian in the previous mail chain. For Mondrian I am
>> using
>>>> the jar provided by Sebastian.
>>>>
>>>> Your error looks like you have not made the kylin-jdbc-${version}.jar
>>>> available in Saiku's classpath.
>>>>
>>>> Thanks
>>>> Divye Sheth
>>>>
>>>> On Fri, Jun 12, 2015 at 7:34 AM, Tao Wong <[email protected]> wrote:
>>>>
>>>>> Hi @divye
>>>>> which kylin version do you used?
>>>>> could you provide more details about it?
>>>>> I am trying to connect kylin with saiku ,but it always error with
>>>>> "java.sql.SQLException: No suitable driver found for
>>>>> jdbc:kylin://hostname:8080/projectname".
>>>>> many thanks。
>>>>>
>>>>> 2015-06-11 21:16 GMT+08:00 divye sheth <[email protected]>:
>>>>>
>>>>>> Hi Sebastian,
>>>>>>
>>>>>> Thanks! I was able to query kylin using mondrian 4 on the cube that
>> I
>>>>>> built. Was just wondering why it did not work with the sample cube
>>>> that
>>>>> can
>>>>>> be created via sample.sh script in kylin, the joins in kylin sample
>>>> cube
>>>>>> are inner joins.
>>>>>>
>>>>>> Next task is to get it working with OSGI, any thoughts about it are
>>>>>> welcome.
>>>>>>
>>>>>> Divye Sheth
>>>>>>
>>>>>> On Wed, Jun 10, 2015 at 3:05 PM, Tao Wong <[email protected]>
>> wrote:
>>>>>>
>>>>>>> Hi Sébastien
>>>>>>>
>>>>>>> I also encouter this dilemma, could you help me?
>>>>>>> I want to connect saiku with kylin :
>>>>>>>
>>>>>>> configure in saiku:
>>>>>>>
>>>>>>> URL:jdbc:kylin://MACHINE-NAME:PORT/KYLINPROJECT
>>>>>>> jdbc Driver:org.apache.kylin.jdbc.Driver
>>>>>>> username:ADMIN
>>>>>>> password:KYLIN
>>>>>>>
>>>>>>> the error log:
>>>>>>> driver:mondrian.olap4j.MondrianOlap4jDriver
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> url:jdbc:mondrian:Jdbc=jdbc:kylin://machinename:8080//user;Catalog=mondrian:///datasources/user.xml;JdbcDrivers=org.apache.kylin.jdbc.Driver
>>>>>>> 17:23:32,131 ERROR [SecurityAwareConnectionManager] Error
>>>> connecting:
>>>>>> kylin
>>>>>>> mondrian.olap.MondrianException: Mondrian Error:Internal error:
>>>> Error
>>>>>> while
>>>>>>> creating SQL connection: Jdbc=jdbc:kylin://machinename:8080//user;
>>>>>>> JdbcUser=ADMIN; JdbcPassword=KYLIN
>>>>>>> at
>>>>>>>
>>>> mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:992)
>>>>>>> at mondrian.olap.Util.newInternal(Util.java:2543)
>>>>>>> at mondrian.olap.Util.newError(Util.java:2559)
>>>>>>> at
>>>> mondrian.rolap.RolapConnection.<init>(RolapConnection.java:239)
>>>>>>> at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:191)
>>>>>>> at
>>>>>>>
>>>> mondrian.rolap.RolapSchemaLoader.loadStage1(RolapSchemaLoader.java:313)
>>>>>>> at
>>>>>>>
>>>> mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:272)
>>>>>>> at
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4303)
>>>>>>>
>>>>>>> 2015-06-09 19:40 GMT+08:00 divye sheth <[email protected]>:
>>>>>>>
>>>>>>>> Hi Sebastian,
>>>>>>>>
>>>>>>>> I am using the sample.sh script provided by Kylin to build the
>>>> cube.
>>>>> I
>>>>>>> just
>>>>>>>> checked that the type of join used while building the cube is
>>>> infact
>>>>>>> INNER.
>>>>>>>> I am also creating another cube with my own data to check with
>> the
>>>>>> inner
>>>>>>>> join.
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>> Divye Sheth
>>>>>>>>
>>>>>>>> On Tue, Jun 9, 2015 at 3:37 PM, Sébastien Jelsch <
>>>>>>>> [email protected]
>>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> @Divye:
>>>>>>>>> I got the same error at the beginning.
>>>>>>>>> Take a look at your SQL statement. It uses „join“, which is
>>>>>> equivalent
>>>>>>> to
>>>>>>>>> an inner join. However, build your cube with inner joins
>>>> instead of
>>>>>>> left
>>>>>>>> or
>>>>>>>>> right join, this should fix your problem.
>>>>>>>>>
>>>>>>>>> @Li Yang
>>>>>>>>> Thank you!
>>>>>>>>>
>>>>>>>>> @Julian Hyde:
>>>>>>>>> Yeah, Mondrian 4 rocks! First tests are very promising.
>>>>>>>>>
>>>>>>>>> @Luke Han:
>>>>>>>>> Thanks, I’ll write a howto in the coming days.
>>>>>>>>>
>>>>>>>>> Best regards,
>>>>>>>>> Sébastien Jelsch
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>> Am 09.06.2015 um 07:58 schrieb divye sheth <
>>>> [email protected]
>>>>>> :
>>>>>>>>>>
>>>>>>>>>> Hi Sebastian,
>>>>>>>>>>
>>>>>>>>>> After using your jar I was able to remove the eigenbase
>>>>> exception.
>>>>>>> But
>>>>>>>>> then
>>>>>>>>>> it gives me another exception below is the summary of the
>>>> same.
>>>>>>>>>>
>>>>>>>>>> Caused by: java.lang.RuntimeException: Failed to query kylin
>>>>> server
>>>>>>>> with
>>>>>>>>>> exception {"url":"http://localhost:7070/kylin/api/query
>>>>>>>>> ","exception":"Can't
>>>>>>>>>> find any realization. Please confirm with providers. SQL
>>>> digest:
>>>>>> fact
>>>>>>>>> table
>>>>>>>>>> DEFAULT.KYLIN_SALES,group by
>>>>>>>>>> [DEFAULT.KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME],filter on
>>>>>> [],with
>>>>>>>>>> aggregates[].\nwhile executing SQL: \"select
>>>>>>>>>> \"KYLIN_CATEGORY_GROUPINGS\".\"META_CATEG_NAME\" as \"c0\"
>>>> from
>>>>>>>>>> \"KYLIN_SALES\" as \"KYLIN_SALES\" join
>>>>>> \"KYLIN_CATEGORY_GROUPINGS\"
>>>>>>> as
>>>>>>>>>> \"KYLIN_CATEGORY_GROUPINGS\" on
>>>>> \"KYLIN_SALES\".\"LEAF_CATEG_ID\" =
>>>>>>>>>> \"KYLIN_CATEGORY_GROUPINGS\".\"LEAF_CATEG_ID\" group by
>>>>>>>>>> \"KYLIN_CATEGORY_GROUPINGS\".\"META_CATEG_NAME\" order by
>> CASE
>>>>> WHEN
>>>>>>>>>> \"KYLIN_CATEGORY_GROUPINGS\".\"META_CATEG_NAME\" IS NULL
>> THEN
>>>> 1
>>>>>> ELSE
>>>>>>> 0
>>>>>>>>> END,
>>>>>>>>>> \"KYLIN_CATEGORY_GROUPINGS\".\"META_CATEG_NAME\" ASC\""}
>>>>>>>>>>
>>>>>>>>>> Am I missing something here? I am trying to access Kylin via
>>>>> Java.
>>>>>> I
>>>>>>>> have
>>>>>>>>>> made sure that the latest mondrian and kylin-jdbc drivers
>> are
>>>>>>> available
>>>>>>>>> in
>>>>>>>>>> the classpath. Is there something on the Kylin server that I
>>>> am
>>>>>>>> missing?
>>>>>>>>>> Please suggest.
>>>>>>>>>>
>>>>>>>>>> Thanks!
>>>>>>>>>> Divye Sheth
>>>>>>>>>>
>>>>>>>>>> On Tue, Jun 9, 2015 at 8:13 AM, Li Yang <[email protected]>
>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Great work! I've merged the pull request into 0.7-staging,
>>>>>>>>>>> commit 716bd9dcc2ab43e642b106db838458a684932495
>>>>>>>>>>>
>>>>>>>>>>> On Tue, Jun 9, 2015 at 8:30 AM, Julian Hyde <
>>>> [email protected]>
>>>>>>> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Yay! Go Mondrian 4!
>>>>>>>>>>>>
>>>>>>>>>>>> Julian
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> On Mon, Jun 8, 2015 at 3:27 AM, Sébastien Jelsch <
>>>>>>>>>>>> [email protected]
>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> I found the reason for this issue (
>>>>>>>>>>>>> https://issues.apache.org/jira/browse/KYLIN-819 <
>>>>>>>>>>>>> https://issues.apache.org/jira/browse/KYLIN-819> ) and
>>>> fixed
>>>>>> it (
>>>>>>>>>>>>> https://github.com/apache/incubator-kylin/pull/9 <
>>>>>>>>>>>>> https://github.com/apache/incubator-kylin/pull/9> ).
>>>>>>>>>>>>>
>>>>>>>>>>>>> And I have some good news: With Mondrian 4 ( the
>> lagunitas
>>>>>> branch:
>>>>>>>>>>>>> https://github.com/pentaho/mondrian/tree/lagunitas <
>>>>>>>>>>>>> https://github.com/pentaho/mondrian/tree/lagunitas> )
>> and
>>>> my
>>>>>>> kylin
>>>>>>>>>>>>> dialect ( https://github.com/pentaho/mondrian/pull/480 <
>>>>>>>>>>>>> https://github.com/pentaho/mondrian/pull/480> ) I’m able
>>>> to
>>>>>> work
>>>>>>>> with
>>>>>>>>>>>>> Mondrian and Kylin! In the coming days I’ll write a HowTo
>>>>> about
>>>>>> my
>>>>>>>>>>>>> experiences.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Best regards,
>>>>>>>>>>>>> Sébastien Jelsch
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>> Am 22.05.2015 um 18:33 schrieb Luke Han <
>>>> [email protected]>:
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Please handle this part to Shanghai team, I will put
>> this
>>>>> story
>>>>>>> in
>>>>>>>>>>>> v0.7.2
>>>>>>>>>>>>>> (after successful release v0.7.1).
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Thanks.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Best Regards!
>>>>>>>>>>>>>> ---------------------
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Luke Han
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> 2015-05-23 0:25 GMT+08:00 divye sheth <
>>>> [email protected]
>>>>>> :
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Will wait for the core committers. In the meantime
>> might
>>>> as
>>>>>> well
>>>>>>>>>>> test
>>>>>>>>>>>>> kylin
>>>>>>>>>>>>>>> with 0.9.2.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Thanks!
>>>>>>>>>>>>>>> On May 22, 2015 21:52, "Julian Hyde" <[email protected]
>>>
>>>>>> wrote:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> Calcite 0.9.2 -> 1.0 is a tricky upgrade. I think you
>>>>> should
>>>>>>>> leave
>>>>>>>>>>> it
>>>>>>>>>>>>> to
>>>>>>>>>>>>>>>> the core committers.
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> I wouldn't even be sure that the upgrade from 0.9.1 to
>>>>> 0.9.2
>>>>>>>> worked
>>>>>>>>>>>>> until
>>>>>>>>>>>>>>>> the tests had passed.
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>> On Fri, May 22, 2015 at 9:11 AM, divye sheth <
>>>>>>>> [email protected]
>>>>>>>>>>>>
>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> The 0.9.2 release builds fine with Kylin (just built
>>>> kylin
>>>>>>> have
>>>>>>>>>>> not
>>>>>>>>>>>>>>>>> tested). With the Calcite 1.0 release there have been
>>>>>>>> significant
>>>>>>>>>>>>>>>>> class/package renaming and movement as well as some
>>>>>> additional
>>>>>>>>>>>> classes
>>>>>>>>>>>>>>>>> coming in. Currently I am trying to figure out
>>>>>>>>>>> AvaticaPrepareResult
>>>>>>>>>>>> ->
>>>>>>>>>>>>>>>>> Meta.Signature
>>>>>>>>>>>>>>>>> I am trying my best here. Java is something that I am
>>>> not
>>>>>> that
>>>>>>>>>>>> strong
>>>>>>>>>>>>>>>> with
>>>>>>>>>>>>>>>>> :-)
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> Thanks
>>>>>>>>>>>>>>>>> Divye Sheth
>>>>>>>>>>>>>>>>> On May 22, 2015 21:12, "Julian Hyde" <
>> [email protected]
>>>>>
>>>>>>> wrote:
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> There are significant API changes between Calcite
>> 0.9
>>>> and
>>>>>>> 1.0.
>>>>>>>>>>> Read
>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>> 1.0
>>>>>>>>>>>>>>>>>> release notes
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> https://github.com/apache/incubator-calcite/blob/branch-1.3/doc/history.md#100-incubating--2015-01-31
>>>>>>>>>>>>>>>>>> ,
>>>>>>>>>>>>>>>>>> and use the API mapping
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>
>>>> https://issues.apache.org/jira/secure/attachment/12681620/mapping.txt
>>>>>>>>>>>>>>>> if
>>>>>>>>>>>>>>>>>> you need to. Consider upgrading to 0.9.2 (the last
>>>>> release
>>>>>>> with
>>>>>>>>>>> the
>>>>>>>>>>>>>>> old
>>>>>>>>>>>>>>>>>> API) and getting that working before moving to the
>>>>> renamed
>>>>>>> API.
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> I've logged
>>>>>> https://issues.apache.org/jira/browse/KYLIN-780
>>>>>>> to
>>>>>>>>>>>> track
>>>>>>>>>>>>>>>>> this.
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> On Thu, May 21, 2015 at 9:51 PM, divye sheth <
>>>>>>>>>>> [email protected]
>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> Thanks Julian, will try porting optiq 0.9 to
>> calcite
>>>>> 1.0.
>>>>>>> Will
>>>>>>>>>>>>>>> commit
>>>>>>>>>>>>>>>>> if
>>>>>>>>>>>>>>>>>>> successfull.
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> Thanks
>>>>>>>>>>>>>>>>>>> Divye Sheth
>>>>>>>>>>>>>>>>>>> On May 21, 2015 22:18, "Julian Hyde" <
>>>> [email protected]>
>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> It seems that Mondrian is trying to access a
>> string
>>>>>> column
>>>>>>> as
>>>>>>>>>>> if
>>>>>>>>>>>>>>> it
>>>>>>>>>>>>>>>>>> were
>>>>>>>>>>>>>>>>>>> a
>>>>>>>>>>>>>>>>>>>> long. Maybe you declared the column of the wrong
>>>> type
>>>>> in
>>>>>>> your
>>>>>>>>>>>>>>>>> Mondrian
>>>>>>>>>>>>>>>>>>>> schema file? Or maybe Kylin is not reporting the
>>>> type
>>>>>>>>>>> accurately.
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> The JDBC driver code that is failing to convert (
>>>>>>>>>>>>>>>>>>>> *net.hydromatic.optiq.runtime.AbstractCursor*) is
>> in
>>>>>> Optiq,
>>>>>>>> now
>>>>>>>>>>>>>>>>> called
>>>>>>>>>>>>>>>>>>>> Calcite. Later versions of Calcite are more
>>>> permissive
>>>>>>> about
>>>>>>>>>>>>>>>>>> conversions
>>>>>>>>>>>>>>>>>>> so
>>>>>>>>>>>>>>>>>>>> if Kylin upgraded to a more recent version of
>>>> Calcite
>>>>>> that
>>>>>>>>>>> would
>>>>>>>>>>>>>>>>>> probably
>>>>>>>>>>>>>>>>>>>> improve things.
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>> On Wed, May 20, 2015 at 2:47 AM, divye sheth <
>>>>>>>>>>>>>>> [email protected]
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> Hi Devs,
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> I am trying to get Mondrian to run over Kylin but
>>>> get
>>>>> an
>>>>>>>>>>>>>>>> exception
>>>>>>>>>>>>>>>>>>> while
>>>>>>>>>>>>>>>>>>>>> creating a connection to Kylin via Mondrian below
>>>> are
>>>>>> the
>>>>>>>>>>> steps
>>>>>>>>>>>>>>>>> that
>>>>>>>>>>>>>>>>>> I
>>>>>>>>>>>>>>>>>>>> have
>>>>>>>>>>>>>>>>>>>>> followed:
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> 1. Setup Kylin using On-hadoop Install
>>>>>>>>>>>>>>>>>>>>> 2. Execute the ./sample.sh script to create
>> sample
>>>>> cube
>>>>>> in
>>>>>>>>>>>>>>> Kylin
>>>>>>>>>>>>>>>>>>>>> 3. Build Cube
>>>>>>>>>>>>>>>>>>>>> 4. Test queries against the cube. Also tested
>> using
>>>>> JDBC
>>>>>>>>>>>>>>> driver.
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> But when I try to execute MDX using Mondrian on
>>>> top of
>>>>>>>> Kylin I
>>>>>>>>>>>>>>>> get
>>>>>>>>>>>>>>>>> an
>>>>>>>>>>>>>>>>>>>>> exception trace as follows:
>>>>>>>>>>>>>>>>>>>>> *[Mondrian Monitor]:[2015-05-20
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> 14:55:34,563][DEBUG][mondrian.server.MonitorImpl$Actor.run(MonitorImpl.java:975)]
>>>>>>>>>>>>>>>>>>>>> - StatementEndEvent(0)*
>>>>>>>>>>>>>>>>>>>>> *java.lang.RuntimeException: cannot convert to
>> long
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>
>>>> (net.hydromatic.optiq.runtime.AbstractCursor$StringAccessor@fff056c
>>>>>>>>>>>>>>>>>> )*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> net.hydromatic.optiq.runtime.AbstractCursor$AccessorImpl.cannotConvert(AbstractCursor.java:287)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> net.hydromatic.optiq.runtime.AbstractCursor$AccessorImpl.getLong(AbstractCursor.java:243)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> net.hydromatic.optiq.runtime.AbstractCursor$AccessorImpl.getInt(AbstractCursor.java:239)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> net.hydromatic.avatica.AvaticaResultSet.getInt(AvaticaResultSet.java:220)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.rolap.aggmatcher.JdbcSchema$Table.loadColumns(JdbcSchema.java:972)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>
>>>> mondrian.rolap.aggmatcher.JdbcSchema$Table.load(JdbcSchema.java:775)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.rolap.RolapSchema$PhysTable.populateColumns(RolapSchema.java:1853)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.rolap.RolapSchema$PhysRelationImpl.ensurePopulated(RolapSchema.java:1519)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.rolap.RolapSchema$PhysTable.ensurePopulated(RolapSchema.java:1729)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.rolap.RolapSchemaLoader.registerTable(RolapSchemaLoader.java:1051)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.rolap.RolapSchemaLoader.validatePhysicalSchema(RolapSchemaLoader.java:715)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>
>> mondrian.rolap.RolapSchemaLoader.loadStage2(RolapSchemaLoader.java:376)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>
>> mondrian.rolap.RolapSchemaLoader.loadStage1(RolapSchemaLoader.java:336)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>
>> mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:272)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.rolap.RolapSchemaLoader.createSchema(RolapSchemaLoader.java:4303)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>
>>>>> mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:210)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>
>>>> mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:62)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>
>>>>>>> mondrian.rolap.RolapConnection.<init>(RolapConnection.java:160)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>
>>>>>>> mondrian.rolap.RolapConnection.<init>(RolapConnection.java:84)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>
>>>>> mondrian.olap.DriverManager.getConnection(DriverManager.java:112)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>
>>>>>>>>
>> mondrian.olap.DriverManager.getConnection(DriverManager.java:68)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:153)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:139)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>
>>>>> java.sql.DriverManager.getConnection(DriverManager.java:571)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>
>>>>> java.sql.DriverManager.getConnection(DriverManager.java:233)*
>>>>>>>>>>>>>>>>>>>>> * at
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>
>>>> com.fractal.mondrian.kylin.MondrianKylin.main(MondrianKylin.java:27)*
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> I tried searching a lot but the only link I could
>>>> find
>>>>>>>> related
>>>>>>>>>>>>>>> to
>>>>>>>>>>>>>>>>>> this
>>>>>>>>>>>>>>>>>>>>> issue was
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>> https://groups.google.com/forum/#!searchin/optiq-dev/mondrian/optiq-dev/qMd5FyOtp28/-BBsC4ScKe0J
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> *Kylin Version: 0.7-1*
>>>>>>>>>>>>>>>>>>>>> *Hadoop: 2.6*
>>>>>>>>>>>>>>>>>>>>> *Hbase: 0.98*
>>>>>>>>>>>>>>>>>>>>> *Hive: 1.0.1*
>>>>>>>>>>>>>>>>>>>>> *Mondrian Jar: 4.3*
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> Attached is the mondrian xml for reference that
>>>>>>> corresponds
>>>>>>>> to
>>>>>>>>>>>>>>>> the
>>>>>>>>>>>>>>>>>> cube
>>>>>>>>>>>>>>>>>>>> in
>>>>>>>>>>>>>>>>>>>>> Kylin.
>>>>>>>>>>>>>>>>>>>>> I am not pretty sure what am I doing wrong, any
>>>>>>>> help/pointers
>>>>>>>>>>>>>>>> would
>>>>>>>>>>>>>>>>>> be
>>>>>>>>>>>>>>>>>>>>> appreciated a lot. Apologize if this is not a
>> Kylin
>>>>>> issue.
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> I am new to the Kylin community.
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>> Thanks
>>>>>>>>>>>>>>>>>>>>> Divye Sheth
>>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>>
>>
