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