Hi Divye, you can download my mondrian lagunitas snapshot with added kylin dialect and give it a try: https://github.com/mustangore/thesis/tree/master/Mondrian <https://github.com/mustangore/thesis/tree/master/Mondrian>
Best regards, Sébastien Jelsch > Am 08.06.2015 um 17:43 schrieb divye sheth <[email protected]>: > > I was referring to the latest stack trace of the eigenbase exception. I > think i have goofed up a little in the previous mail. Will build > mondrian-jdbc jar from the specified branch and will post the results. > > Thanks! > Divye Sheth > On Jun 8, 2015 9:08 PM, "divye sheth" <[email protected]> wrote: > >> Thanks Sebastian, I am using Mondrian 4 but not the branch you mentioned. >> I have checked out the branch and will be building the mondrian jar, the >> build.sh script does not make the jar. Will checkout the new kylin branch >> and build again. Just for my info, what caused this issue? >> >> Thank! >> Divye Sheth >> On Jun 8, 2015 20:25, "Sébastien Jelsch" <[email protected]> wrote: >> >>> I found the reason for this issue ( >>> https://issues.apache.org/jira/browse/KYLIN-819 ) and fixed it ( >>> https://github.com/apache/incubator-kylin/pull/9/files ). >>> >>> 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 >>>>>>>>>>> >>>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>> >>>>> >>> >>>
