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