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 >> >>>>>>>> >> >>>>>>> >> >>>>>> >> >>>>> >> >>>> >> >>> >> >> >> >>
