Awesome Sébastien! We will take a look and merge our pull request and include in 0.7.2 release.
Could you please help to draft the how to doc for others to refer? Thank you very much. Best Regards! --------------------- Luke Han 2015-06-08 10:13 GMT-07:00 Sébastien Jelsch <[email protected]>: > 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 > >>>>>>>>>>> > >>>>>>>>>> > >>>>>>>>> > >>>>>>>> > >>>>>>> > >>>>>> > >>>>> > >>> > >>> > >
