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