Hi Luke,
I have posted this with the optiq community as well will update the mailing
list as soon as I get something. Also I think (may be wrong here) the
mondrian jar does not have dependency on optiq, the Kylin jdbc jar has
though and the version of optiq jar is the latest i.e 0.9
As mentioned in an old post here "
https://groups.google.com/forum/#!topic/optiq-dev/qMd5FyOtp28"; I tried
specifying the datatype in the mondrian schema but still the issue remains.
I did a debug and found this cast exception is something that is being
thrown from Kylin at the time of creating a connection. Below is the code
that I have written for the same:
Class.forName("mondrian.olap4j.MondrianOlap4jDriver");
String jdbcURL = "jdbc:kylin://localhost:7070/learn_kylin";
String cnxURL = "jdbc:mondrian:Jdbc=" + jdbcURL + ";";
cnxURL += "JdbcDrivers=org.apache.kylin.jdbc.Driver;";
cnxURL += "JdbcUser=ADMIN;";
cnxURL += "JdbcPassword=KYLIN;";
cnxURL += "Catalog=file:/home/divye/Documents/kylin/learn_kylin.xml;";
System.out.println("cnxURL ==> " + cnxURL);
*Connection conn = DriverManager.getConnection(cnxURL); //this is where it
is breaking*
OlapConnection olapConnection = (OlapConnection) conn
.unwrap(OlapConnection.class);
System.out.println(olapConnection);
String query = "SELECT NON EMPTY( {[Measures].[Price]}) ON COLUMNS, NON
EMPTY({[Category].[CategoryHierarchy].[Category Name].Members}) on ROWS
from [Data Cube]";
CellSet cellSet = olapConnection.createStatement().executeOlapQuery(
query);
System.out.println("--------------------------------------------");
CellSetFormatter csf = new TraditionalCellSetFormatter();
PrintWriter pw = new PrintWriter(System.out);
csf.format(cellSet, pw);
pw.flush();
csf = new RectangularCellSetFormatter(true);
pw = new PrintWriter(System.out);
csf.format(cellSet, pw);
pw.flush();
Attached is the run log for the same.
P.S I am not that good with Java so some of my findings/assumptions above
may be incorrect, please do correct me wherever I have faltered.
Thanks
Divye Sheth
On Wed, May 20, 2015 at 4:37 PM, Luke Han <[email protected]> wrote:
> Looks like there's data type issue: * cannot convert to long *
>
> Could you please double check the column type in Hive/Kylin and Mondrian?
> And, it looks like Mondrian depends on old Optiq not Calcite, you could
> search calcite with this issue also.
>
> @Julian, could you also help to comment?
>
> Thanks.
>
>
> Best Regards!
> ---------------------
>
> Luke Han
>
> 2015-05-20 18:06 GMT+08:00 dong wang <[email protected]>:
>
> > Also very interested in this topic, i vaguely remember that mondrian
> > supports both SQL and MDX, do you access KYLIN through SQL or MDX since
> it
> > seems that KYLIN only supports SQL currently~
> >
> > 2015-05-20 17:47 GMT+08:00 divye sheth <[email protected]>:
> >
> > > 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
> > >
> >
>
cnxURL ==>
jdbc:mondrian:Jdbc=jdbc:kylin://localhost:7070/learn_kylin;JdbcDrivers=org.apache.kylin.jdbc.Driver;JdbcUser=ADMIN;JdbcPassword=KYLIN;Catalog=file:/home/divye/Documents/kylin/learn_kylin.xml;
[main]:[2015-05-20
16:59:13,906][WARN][mondrian.olap.MondrianPropertiesBase.populate(MondrianPropertiesBase.java:213)]
- mondrian.properties can't be found under
'/home/divye/workspace/MondrianKylin/.' or classloader
[main]:[2015-05-20
16:59:13,909][INFO][mondrian.olap.MondrianPropertiesBase.populate(MondrianPropertiesBase.java:236)]
- Mondrian: loaded 0 system properties
[main]:[2015-05-20
16:59:14,025][DEBUG][mondrian.rolap.agg.SegmentCacheWorker.<init>(SegmentCacheWorker.java:52)]
- Segment cache initialized: mondrian.rolap.cache.MemorySegmentCache
[main]:[2015-05-20
16:59:14,051][DEBUG][mondrian.server.MondrianServerImpl.<init>(MondrianServerImpl.java:197)]
- new MondrianServer: id=1
[main]:[2015-05-20
16:59:14,182][INFO][mondrian.rolap.RolapUtil.loadDrivers(RolapUtil.java:403)] -
Mondrian: JDBC driver org.apache.kylin.jdbc.Driver loaded successfully
[main]:[2015-05-20
16:59:14,183][INFO][mondrian.rolap.RolapUtil.loadDrivers(RolapUtil.java:403)] -
Mondrian: JDBC driver sun.jdbc.odbc.JdbcOdbcDriver loaded successfully
[main]:[2015-05-20
16:59:14,183][WARN][mondrian.rolap.RolapUtil.loadDrivers(RolapUtil.java:407)] -
Mondrian: Warning: JDBC driver org.hsqldb.jdbcDriver not found
[main]:[2015-05-20
16:59:14,184][WARN][mondrian.rolap.RolapUtil.loadDrivers(RolapUtil.java:407)] -
Mondrian: Warning: JDBC driver oracle.jdbc.OracleDriver not found
[main]:[2015-05-20
16:59:14,184][WARN][mondrian.rolap.RolapUtil.loadDrivers(RolapUtil.java:407)] -
Mondrian: Warning: JDBC driver com.mysql.jdbc.Driver not found
[main]:[2015-05-20
16:59:14,203][DEBUG][mondrian.server.MondrianServerImpl.addConnection(MondrianServerImpl.java:329)]
- addConnection , id=1, statements=0, connections=0
[Mondrian Monitor]:[2015-05-20
16:59:14,205][DEBUG][mondrian.server.MonitorImpl$Actor.run(MonitorImpl.java:975)]
- ConnectionStartEvent(0)
[main]:[2015-05-20
16:59:14,205][DEBUG][mondrian.server.MondrianServerImpl.addStatement(MondrianServerImpl.java:382)]
- addStatement , id=1, statements=0, connections=1
[Mondrian Monitor]:[2015-05-20
16:59:14,207][DEBUG][mondrian.server.MonitorImpl$Actor.run(MonitorImpl.java:975)]
- StatementStartEvent(0)
[main]:[2015-05-20
16:59:14,214][DEBUG][mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:107)]
- get: catalog=file:/home/divye/Documents/kylin/learn_kylin.xml,
connectionKey=jdbc:kylin://localhost:7070/learn_kylin{}, jdbcUser=ADMIN,
dataSourceStr=null, dataSource=null, dialect=null, jdbcConnectionUuid=null,
useSchemaPool=true, useContentChecksum=false, map-size=0, md5-map-size=0
[main]:[2015-05-20
16:59:14,217][INFO][mondrian.spi.VirtualFileHandler$1.apply(VirtualFileHandler.java:49)]
- VirtualFileHandler: Property not set. Tryingstandard implementations
[main]:[2015-05-20
16:59:14,218][INFO][mondrian.spi.VirtualFileHandler$1.apply(VirtualFileHandler.java:57)]
- VirtualFileHandler: Using mondrian.spi.impl.ApacheVfsVirtualFileHandler
[main]:[2015-05-20
16:59:14,241][INFO][org.apache.commons.vfs.VfsLog.info(VfsLog.java:122)] -
Using "/tmp/vfs_cache" as temporary files store.
[main]:[2015-05-20
16:59:14,297][DEBUG][org.apache.commons.vfs.VfsLog.debug(VfsLog.java:77)] -
Skipping provider "org.apache.commons.vfs.provider.ftp.FtpFileProvider" because
required class "org.apache.commons.net.ftp.FTPFile" is not available.
[main]:[2015-05-20
16:59:14,305][DEBUG][org.apache.commons.vfs.VfsLog.debug(VfsLog.java:77)] -
Skipping provider "org.apache.commons.vfs.provider.sftp.SftpFileProvider"
because required class "com.jcraft.jsch.JSch" is not available.
[main]:[2015-05-20
16:59:14,330][DEBUG][org.apache.commons.vfs.cache.SoftRefFilesCache.putFile(SoftRefFilesCache.java:144)]
- putFile: file:///home/divye/workspace/MondrianKylin
[main]:[2015-05-20
16:59:14,331][DEBUG][org.apache.commons.vfs.cache.SoftRefFilesCache.putFile(SoftRefFilesCache.java:144)]
- putFile: file:///home/divye/Documents/kylin/learn_kylin.xml
[main]:[2015-05-20
16:59:14,341][DEBUG][mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:198)]
- get(key=<73991ccbdf64647e4eab09a3f2208b45,
ad8dd78f795e1b5083004ee7e5307048>) returned null
[main]:[2015-05-20
16:59:14,446][DEBUG][mondrian.rolap.RolapSchemaLoader.loadStage0(RolapSchemaLoader.java:230)]
- RolapSchema.load: catalogStr:
<Schema name="Kylin" caption="Kylin" description="Kylin" metamodelVersion="4.0"
Caption="Kylin">
<PhysicalSchema>
<Table name="KYLIN_CAL_DT">
<Key>
<Column name="cal_dt" type="String"/>
</Key>
</Table>
<Table name="KYLIN_CATEGORY_GROUPINGS">
<Key>
<Column name="leaf_categ_id"/>
</Key>
</Table>
<Table name="kylin_sales"/>
</PhysicalSchema>
<Dimension name="Period" table="KYLIN_CAL_DT" type="TIME" key="Date">
<Attributes>
<Attribute name="Year" keyColumn="year_id" hasHierarchy="false"
levelType="TimeYears"/>
<Attribute name="Quarter" hasHierarchy="false"
levelType="TimeQuarters">
<Key>
<Column name="year_id"/>
<Column name="qtr_of_year_id"/>
</Key>
<Name>
<Column name="qtr_of_year_id"/>
</Name>
</Attribute>
<Attribute name="Month" hasHierarchy="false" levelType="TimeMonths">
<Key>
<Column name="year_id"/>
<Column name="month_of_year_id"/>
</Key>
<Name>
<Column name="month_of_year_id"/>
</Name>
</Attribute>
<Attribute name="Day of Month" hasHierarchy="false"
levelType="TimeDays">
<Key>
<Column name="year_id"/>
<Column name="month_of_year_id"/>
<Column name="day_of_month_id"/>
</Key>
<Name>
<Column name="day_of_month_id"/>
</Name>
</Attribute>
<Attribute name="Date" keyColumn="cal_dt" hasHierarchy="false"
type="String"/>
</Attributes>
<Hierarchies>
<Hierarchy name="PeriodHierarchy" hasAll="true">
<Level attribute="Year"/>
<Level attribute="Quarter"/>
<Level attribute="Month"/>
<Level attribute="Day of Month"/>
</Hierarchy>
</Hierarchies>
</Dimension>
<Dimension name="Category" table="KYLIN_CATEGORY_GROUPINGS"
key="Category_id">
<Attributes>
<Attribute name="Category_id" table="kylin_category_groupings"
keyColumn="leaf_categ_id" hasHierarchy="false"/>
<Attribute name="Category Name" table="kylin_category_groupings"
keyColumn="meta_categ_name" hasHierarchy="false"/>
</Attributes>
<Hierarchies>
<Hierarchy name="CategoryHierarchy" hasAll="true">
<Level attribute="Category Name"/>
</Hierarchy>
</Hierarchies>
</Dimension>
<Cube name="Data Cube">
<Dimensions>
<Dimension source="Period"/>
<Dimension source="Category"/>
</Dimensions>
<MeasureGroups>
<MeasureGroup name="Syndicated" table="KYLIN_SALES">
<Measures>
<Measure name="Price" column="price" aggregator="sum"
formatString="#,###" datatype="String"/>
<Measure name="Count" column="price" aggregator="count"
formatString="#,###" datatype="Integer"/>
</Measures>
<DimensionLinks>
<ForeignKeyLink dimension="Period" foreignKeyColumn="Date"/>
<ForeignKeyLink dimension="Category"
foreignKeyColumn="Category_id"/>
</DimensionLinks>
</MeasureGroup>
</MeasureGroups>
</Cube>
</Schema>
[main]:[2015-05-20
16:59:14,466][DEBUG][mondrian.server.MondrianServerRegistry.getVersion(MondrianServerRegistry.java:73)]
- Vendor: Pentaho
[main]:[2015-05-20
16:59:14,467][DEBUG][mondrian.server.MondrianServerRegistry.getVersion(MondrianServerRegistry.java:75)]
- Title: mondrian
[main]:[2015-05-20
16:59:14,467][DEBUG][mondrian.server.MondrianServerRegistry.getVersion(MondrianServerRegistry.java:77)]
- Version: 4.3-SNAPSHOT
[main]:[2015-05-20
16:59:14,472][DEBUG][mondrian.server.MondrianServerRegistry.getVersion(MondrianServerRegistry.java:79)]
- Major Version: 4
[main]:[2015-05-20
16:59:14,472][DEBUG][mondrian.server.MondrianServerRegistry.getVersion(MondrianServerRegistry.java:81)]
- Minor Version: 0
[main]:[2015-05-20
16:59:14,534][DEBUG][mondrian.rolap.RolapSchemaLoader.loadStage1(RolapSchemaLoader.java:305)]
- RolapSchema.load: dump xmlschema
Schema
name = "Kylin"
caption = "Kylin"
description = "Kylin"
measuresCaption = null
defaultRole = null
quoteSql = "true"
missingLink = "warning"
metamodelVersion = "4.0"
locales = null
childArray: array of 4 values
childArray[0]: PhysicalSchema
childArray: array of 3 values
childArray[0]: Table
name = "KYLIN_CAL_DT"
schema = null
alias = null
keyColumn = null
childArray: array of 1 values
childArray[0]: Key
name = null
array: array of 1 values
array[0]: Column
table = null
name = "cal_dt"
aggColumn = null
childArray[1]: Table
name = "KYLIN_CATEGORY_GROUPINGS"
schema = null
alias = null
keyColumn = null
childArray: array of 1 values
childArray[0]: Key
name = null
array: array of 1 values
array[0]: Column
table = null
name = "leaf_categ_id"
aggColumn = null
childArray[2]: Table
name = "kylin_sales"
schema = null
alias = null
keyColumn = null
childArray: array of 0 values
childArray[1]: Dimension
name = "Period"
source = null
visible = "true"
caption = null
description = null
type = "TIME"
table = "KYLIN_CAL_DT"
key = "Date"
hanger = "false"
childArray: array of 2 values
childArray[0]: Attributes
array: array of 5 values
array[0]: Attribute
name = "Year"
caption = null
description = null
visible = "true"
levelType = "TimeYears"
approxRowCount = null
table = null
keyColumn = "year_id"
nameColumn = null
orderByColumn = null
captionColumn = null
datatype = "String"
hasHierarchy = "false"
hierarchyHasAll = "true"
hierarchyCaption = null
hierarchyAllMemberName = null
hierarchyAllMemberCaption = null
hierarchyAllLevelName = null
hierarchyDefaultMember = null
childArray: array of 0 values
array[1]: Attribute
name = "Quarter"
caption = null
description = null
visible = "true"
levelType = "TimeQuarters"
approxRowCount = null
table = null
keyColumn = null
nameColumn = null
orderByColumn = null
captionColumn = null
datatype = "String"
hasHierarchy = "false"
hierarchyHasAll = "true"
hierarchyCaption = null
hierarchyAllMemberName = null
hierarchyAllMemberCaption = null
hierarchyAllLevelName = null
hierarchyDefaultMember = null
childArray: array of 2 values
childArray[0]: Key
name = null
array: array of 2 values
array[0]: Column
table = null
name = "year_id"
aggColumn = null
array[1]: Column
table = null
name = "qtr_of_year_id"
aggColumn = null
childArray[1]: Name
array: array of 1 values
array[0]: Column
table = null
name = "qtr_of_year_id"
aggColumn = null
array[2]: Attribute
name = "Month"
caption = null
description = null
visible = "true"
levelType = "TimeMonths"
approxRowCount = null
table = null
keyColumn = null
nameColumn = null
orderByColumn = null
captionColumn = null
datatype = "String"
hasHierarchy = "false"
hierarchyHasAll = "true"
hierarchyCaption = null
hierarchyAllMemberName = null
hierarchyAllMemberCaption = null
hierarchyAllLevelName = null
hierarchyDefaultMember = null
childArray: array of 2 values
childArray[0]: Key
name = null
array: array of 2 values
array[0]: Column
table = null
name = "year_id"
aggColumn = null
array[1]: Column
table = null
name = "month_of_year_id"
aggColumn = null
childArray[1]: Name
array: array of 1 values
array[0]: Column
table = null
name = "month_of_year_id"
aggColumn = null
array[3]: Attribute
name = "Day of Month"
caption = null
description = null
visible = "true"
levelType = "TimeDays"
approxRowCount = null
table = null
keyColumn = null
nameColumn = null
orderByColumn = null
captionColumn = null
datatype = "String"
hasHierarchy = "false"
hierarchyHasAll = "true"
hierarchyCaption = null
hierarchyAllMemberName = null
hierarchyAllMemberCaption = null
hierarchyAllLevelName = null
hierarchyDefaultMember = null
childArray: array of 2 values
childArray[0]: Key
name = null
array: array of 3 values
array[0]: Column
table = null
name = "year_id"
aggColumn = null
array[1]: Column
table = null
name = "month_of_year_id"
aggColumn = null
array[2]: Column
table = null
name = "day_of_month_id"
aggColumn = null
childArray[1]: Name
array: array of 1 values
array[0]: Column
table = null
name = "day_of_month_id"
aggColumn = null
array[4]: Attribute
name = "Date"
caption = null
description = null
visible = "true"
levelType = "Regular"
approxRowCount = null
table = null
keyColumn = "cal_dt"
nameColumn = null
orderByColumn = null
captionColumn = null
datatype = "String"
hasHierarchy = "false"
hierarchyHasAll = "true"
hierarchyCaption = null
hierarchyAllMemberName = null
hierarchyAllMemberCaption = null
hierarchyAllLevelName = null
hierarchyDefaultMember = null
childArray: array of 0 values
childArray[1]: Hierarchies
array: array of 1 values
array[0]: Hierarchy
name = "PeriodHierarchy"
visible = "true"
hasAll = "true"
allMemberName = null
allMemberCaption = null
allLevelName = null
defaultMember = null
caption = null
description = null
childArray: array of 4 values
childArray[0]: Level
name = null
visible = "true"
attribute = "Year"
parentAttribute = null
nullParentValue = null
hideMemberIf = "Never"
formatter = null
caption = null
description = null
childArray: array of 0 values
childArray[1]: Level
name = null
visible = "true"
attribute = "Quarter"
parentAttribute = null
nullParentValue = null
hideMemberIf = "Never"
formatter = null
caption = null
description = null
childArray: array of 0 values
childArray[2]: Level
name = null
visible = "true"
attribute = "Month"
parentAttribute = null
nullParentValue = null
hideMemberIf = "Never"
formatter = null
caption = null
description = null
childArray: array of 0 values
childArray[3]: Level
name = null
visible = "true"
attribute = "Day of Month"
parentAttribute = null
nullParentValue = null
hideMemberIf = "Never"
formatter = null
caption = null
description = null
childArray: array of 0 values
childArray[2]: Dimension
name = "Category"
source = null
visible = "true"
caption = null
description = null
type = "OTHER"
table = "KYLIN_CATEGORY_GROUPINGS"
key = "Category_id"
hanger = "false"
childArray: array of 2 values
childArray[0]: Attributes
array: array of 2 values
array[0]: Attribute
name = "Category_id"
caption = null
description = null
visible = "true"
levelType = "Regular"
approxRowCount = null
table = "kylin_category_groupings"
keyColumn = "leaf_categ_id"
nameColumn = null
orderByColumn = null
captionColumn = null
datatype = "String"
hasHierarchy = "false"
hierarchyHasAll = "true"
hierarchyCaption = null
hierarchyAllMemberName = null
hierarchyAllMemberCaption = null
hierarchyAllLevelName = null
hierarchyDefaultMember = null
childArray: array of 0 values
array[1]: Attribute
name = "Category Name"
caption = null
description = null
visible = "true"
levelType = "Regular"
approxRowCount = null
table = "kylin_category_groupings"
keyColumn = "meta_categ_name"
nameColumn = null
orderByColumn = null
captionColumn = null
datatype = "String"
hasHierarchy = "false"
hierarchyHasAll = "true"
hierarchyCaption = null
hierarchyAllMemberName = null
hierarchyAllMemberCaption = null
hierarchyAllLevelName = null
hierarchyDefaultMember = null
childArray: array of 0 values
childArray[1]: Hierarchies
array: array of 1 values
array[0]: Hierarchy
name = "CategoryHierarchy"
visible = "true"
hasAll = "true"
allMemberName = null
allMemberCaption = null
allLevelName = null
defaultMember = null
caption = null
description = null
childArray: array of 1 values
childArray[0]: Level
name = null
visible = "true"
attribute = "Category Name"
parentAttribute = null
nullParentValue = null
hideMemberIf = "Never"
formatter = null
caption = null
description = null
childArray: array of 0 values
childArray[3]: Cube
name = "Data Cube"
visible = "true"
caption = null
description = null
defaultMeasure = null
cache = "true"
enabled = "true"
enableScenarios = "false"
childArray: array of 2 values
childArray[0]: Dimensions
array: array of 2 values
array[0]: Dimension
name = null
source = "Period"
visible = "true"
caption = null
description = null
type = "OTHER"
table = null
key = null
hanger = "false"
childArray: array of 0 values
array[1]: Dimension
name = null
source = "Category"
visible = "true"
caption = null
description = null
type = "OTHER"
table = null
key = null
hanger = "false"
childArray: array of 0 values
childArray[1]: MeasureGroups
array: array of 1 values
array[0]: MeasureGroup
name = "Syndicated"
type = "fact"
table = "KYLIN_SALES"
ignoreUnrelatedDimensions = "false"
approxRowCount = null
childArray: array of 2 values
childArray[0]: Measures
array: array of 2 values
array[0]: Measure
name = "Price"
column = "price"
table = null
formatString = "#,###"
datatype = "String"
aggregator = "sum"
formatter = null
caption = null
description = null
visible = null
childArray: array of 0 values
array[1]: Measure
name = "Count"
column = "price"
table = null
formatString = "#,###"
datatype = "Integer"
aggregator = "count"
formatter = null
caption = null
description = null
visible = null
childArray: array of 0 values
childArray[1]: DimensionLinks
array: array of 2 values
array[0]: ForeignKeyLink
foreignKeyColumn = "Date"
attribute = null
dimension = "Period"
foreignKey: null
array[1]: ForeignKeyLink
foreignKeyColumn = "Category_id"
attribute = null
dimension = "Category"
foreignKey: null
[main]:[2015-05-20
16:59:14,555][DEBUG][mondrian.server.MondrianServerImpl.addConnection(MondrianServerImpl.java:329)]
- addConnection , id=1, statements=1, connections=1
[Mondrian Monitor]:[2015-05-20
16:59:14,555][DEBUG][mondrian.server.MonitorImpl$Actor.run(MonitorImpl.java:975)]
- ConnectionStartEvent(1)
[main]:[2015-05-20
16:59:14,555][DEBUG][mondrian.server.MondrianServerImpl.addStatement(MondrianServerImpl.java:382)]
- addStatement , id=1, statements=1, connections=2
[Mondrian Monitor]:[2015-05-20
16:59:14,556][DEBUG][mondrian.server.MonitorImpl$Actor.run(MonitorImpl.java:975)]
- StatementStartEvent(1)
[main]:[2015-05-20
16:59:14,564][DEBUG][org.apache.kylin.jdbc.KylinConnectionImpl.<init>(KylinConnectionImpl.java:69)]
- Kylin base url localhost:7070, project name learn_kylin
[main]:[2015-05-20
16:59:14,588][DEBUG][org.apache.commons.httpclient.params.DefaultHttpParams.setParameter(DefaultHttpParams.java:151)]
- Set parameter http.useragent = Jakarta Commons-HttpClient/3.1
[main]:[2015-05-20
16:59:14,590][DEBUG][org.apache.commons.httpclient.params.DefaultHttpParams.setParameter(DefaultHttpParams.java:151)]
- Set parameter http.protocol.version = HTTP/1.1
[main]:[2015-05-20
16:59:14,592][DEBUG][org.apache.commons.httpclient.params.DefaultHttpParams.setParameter(DefaultHttpParams.java:151)]
- Set parameter http.connection-manager.class = class
org.apache.commons.httpclient.SimpleHttpConnectionManager
[main]:[2015-05-20
16:59:14,593][DEBUG][org.apache.commons.httpclient.params.DefaultHttpParams.setParameter(DefaultHttpParams.java:151)]
- Set parameter http.protocol.cookie-policy = default
[main]:[2015-05-20
16:59:14,593][DEBUG][org.apache.commons.httpclient.params.DefaultHttpParams.setParameter(DefaultHttpParams.java:151)]
- Set parameter http.protocol.element-charset = US-ASCII
[main]:[2015-05-20
16:59:14,593][DEBUG][org.apache.commons.httpclient.params.DefaultHttpParams.setParameter(DefaultHttpParams.java:151)]
- Set parameter http.protocol.content-charset = ISO-8859-1
[main]:[2015-05-20
16:59:14,595][DEBUG][org.apache.commons.httpclient.params.DefaultHttpParams.setParameter(DefaultHttpParams.java:151)]
- Set parameter http.method.retry-handler =
org.apache.commons.httpclient.DefaultHttpMethodRetryHandler@7482742d
[main]:[2015-05-20
16:59:14,595][DEBUG][org.apache.commons.httpclient.params.DefaultHttpParams.setParameter(DefaultHttpParams.java:151)]
- Set parameter http.dateparser.patterns = [EEE, dd MMM yyyy HH:mm:ss zzz,
EEEE, dd-MMM-yy HH:mm:ss zzz, EEE MMM d HH:mm:ss yyyy, EEE, dd-MMM-yyyy
HH:mm:ss z, EEE, dd-MMM-yyyy HH-mm-ss z, EEE, dd MMM yy HH:mm:ss z, EEE
dd-MMM-yyyy HH:mm:ss z, EEE dd MMM yyyy HH:mm:ss z, EEE dd-MMM-yyyy HH-mm-ss z,
EEE dd-MMM-yy HH:mm:ss z, EEE dd MMM yy HH:mm:ss z, EEE,dd-MMM-yy HH:mm:ss z,
EEE,dd-MMM-yyyy HH:mm:ss z, EEE, dd-MM-yyyy HH:mm:ss z]
[main]:[2015-05-20
16:59:14,613][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:72)]
- Java version: 1.7.0_71
[main]:[2015-05-20
16:59:14,613][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:73)]
- Java vendor: Oracle Corporation
[main]:[2015-05-20
16:59:14,614][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:74)]
- Java class path:
/home/divye/workspace/MondrianKylin:/home/divye/Documents/kylin/kylin-jdbc-0.7.1-incubating-SNAPSHOT.jar:/home/divye/Downloads/mondrian-4.3-20150505.064238-411.jar:/home/divye/Desktop/windows/saiku-server/tomcat/webapps/saiku/WEB-INF/lib/olap4j-1.2.0-SNAPSHOT.jar:/home/divye/Desktop/windows/saiku-server/tomcat/webapps/saiku/WEB-INF/lib/olap4j-xmlaserver-1.2.0.jar:/home/divye/Desktop/windows/saiku-server/tomcat/webapps/saiku/WEB-INF/lib/eigenbase-xom-1.3.1.jar:/home/divye/Desktop/windows/saiku-server/tomcat/webapps/saiku/WEB-INF/lib/commons-collections-3.2.jar:/home/divye/Desktop/windows/saiku-server/tomcat/webapps/saiku/WEB-INF/lib/eigenbase-resgen-1.3.1.jar:/home/divye/Desktop/windows/saiku-server/tomcat/webapps/saiku/WEB-INF/lib/commons-vfs-1.0.jar:/home/divye/Desktop/windows/saiku-server/tomcat/webapps/saiku/WEB-INF/lib/commons-io-1.3.2.jar
[main]:[2015-05-20
16:59:14,614][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:75)]
- Operating system name: Linux
[main]:[2015-05-20
16:59:14,614][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:76)]
- Operating system architecture: amd64
[main]:[2015-05-20
16:59:14,615][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:77)]
- Operating system version: 3.13.0-53-generic
[main]:[2015-05-20
16:59:14,706][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:82)]
- SUN 1.7: SUN (DSA key/parameter generation; DSA signing; SHA-1, MD5 digests;
SecureRandom; X.509 certificates; JKS keystore; PKIX CertPathValidator; PKIX
CertPathBuilder; LDAP, Collection CertStores, JavaPolicy Policy;
JavaLoginConfig Configuration)
[main]:[2015-05-20
16:59:14,706][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:82)]
- SunRsaSign 1.7: Sun RSA signature provider
[main]:[2015-05-20
16:59:14,707][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:82)]
- SunEC 1.7: Sun Elliptic Curve provider (EC, ECDSA, ECDH)
[main]:[2015-05-20
16:59:14,707][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:82)]
- SunJSSE 1.7: Sun JSSE provider(PKCS12, SunX509 key/trust factories, SSLv3,
TLSv1)
[main]:[2015-05-20
16:59:14,708][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:82)]
- SunJCE 1.7: SunJCE Provider (implements RSA, DES, Triple DES, AES, Blowfish,
ARCFOUR, RC2, PBE, Diffie-Hellman, HMAC)
[main]:[2015-05-20
16:59:14,708][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:82)]
- SunJGSS 1.7: Sun (Kerberos v5, SPNEGO)
[main]:[2015-05-20
16:59:14,709][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:82)]
- SunSASL 1.7: Sun SASL provider(implements client mechanisms for: DIGEST-MD5,
GSSAPI, EXTERNAL, PLAIN, CRAM-MD5, NTLM; server mechanisms for: DIGEST-MD5,
GSSAPI, CRAM-MD5, NTLM)
[main]:[2015-05-20
16:59:14,709][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:82)]
- XMLDSig 1.0: XMLDSig (DOM XMLSignatureFactory; DOM KeyInfoFactory)
[main]:[2015-05-20
16:59:14,710][DEBUG][org.apache.commons.httpclient.HttpClient.<clinit>(HttpClient.java:82)]
- SunPCSC 1.7: Sun PC/SC provider
[main]:[2015-05-20
16:59:14,738][DEBUG][org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:692)]
- Open connection to localhost:7070
[main]:[2015-05-20
16:59:14,755][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "POST /kylin/api/user/authentication HTTP/1.1[\r][\n]"
[main]:[2015-05-20
16:59:14,757][DEBUG][org.apache.commons.httpclient.HttpMethodBase.addHostRequestHeader(HttpMethodBase.java:1352)]
- Adding Host request header
[main]:[2015-05-20
16:59:14,775][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Accept: application/json, text/plain, */*[\r][\n]"
[main]:[2015-05-20
16:59:14,775][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Content-Type: application/json[\r][\n]"
[main]:[2015-05-20
16:59:14,776][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Authorization: Basic QURNSU46S1lMSU4=[\r][\n]"
[main]:[2015-05-20
16:59:14,776][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "User-Agent: Jakarta Commons-HttpClient/3.1[\r][\n]"
[main]:[2015-05-20
16:59:14,777][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Host: localhost:7070[\r][\n]"
[main]:[2015-05-20
16:59:14,777][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Content-Length: 2[\r][\n]"
[main]:[2015-05-20
16:59:14,778][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "[\r][\n]"
[main]:[2015-05-20
16:59:14,779][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
>> "{}"
[main]:[2015-05-20
16:59:14,779][DEBUG][org.apache.commons.httpclient.methods.EntityEnclosingMethod.writeRequestBody(EntityEnclosingMethod.java:508)]
- Request body sent
[main]:[2015-05-20
16:59:14,916][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "HTTP/1.1 200 OK[\r][\n]"
[main]:[2015-05-20
16:59:14,917][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "HTTP/1.1 200 OK[\r][\n]"
[main]:[2015-05-20
16:59:14,920][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Server: Apache-Coyote/1.1[\r][\n]"
[main]:[2015-05-20
16:59:14,921][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Set-Cookie: JSESSIONID=3C45CC4FDFF43A459E12A7C8EAC9B94F; Path=/kylin/;
HttpOnly[\r][\n]"
[main]:[2015-05-20
16:59:14,922][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Pragma: no-cache[\r][\n]"
[main]:[2015-05-20
16:59:14,924][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Cache-Control: no-cache, no-store, max-age=0[\r][\n]"
[main]:[2015-05-20
16:59:14,925][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Expires: Thu, 01 Jan 1970 00:00:00 GMT[\r][\n]"
[main]:[2015-05-20
16:59:14,925][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Content-Type: application/json;charset=UTF-8[\r][\n]"
[main]:[2015-05-20
16:59:14,926][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Content-Language: en-IN[\r][\n]"
[main]:[2015-05-20
16:59:14,927][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Content-Length: 246[\r][\n]"
[main]:[2015-05-20
16:59:14,928][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Date: Wed, 20 May 2015 11:29:15 GMT[\r][\n]"
[main]:[2015-05-20
16:59:14,929][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\r][\n]"
[main]:[2015-05-20
16:59:14,932][DEBUG][org.apache.commons.httpclient.cookie.CookieSpecBase.parseAttribute(CookieSpecBase.java:337)]
- Unrecognized cookie attribute: name=HttpOnly, value=null
[main]:[2015-05-20
16:59:14,933][DEBUG][org.apache.commons.httpclient.HttpMethodBase.processCookieHeaders(HttpMethodBase.java:1651)]
- Cookie accepted: "$Version=0; JSESSIONID=3C45CC4FDFF43A459E12A7C8EAC9B94F;
$Path=/kylin/"
[main]:[2015-05-20
16:59:14,937][DEBUG][org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:692)]
- Open connection to localhost:7070
[main]:[2015-05-20
16:59:14,944][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "GET /kylin/api/tables_and_columns?project=learn_kylin HTTP/1.1[\r][\n]"
[main]:[2015-05-20
16:59:14,945][DEBUG][org.apache.commons.httpclient.HttpMethodBase.addHostRequestHeader(HttpMethodBase.java:1352)]
- Adding Host request header
[main]:[2015-05-20
16:59:14,946][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Accept: application/json, text/plain, */*[\r][\n]"
[main]:[2015-05-20
16:59:14,947][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Content-Type: application/json[\r][\n]"
[main]:[2015-05-20
16:59:14,948][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Authorization: Basic QURNSU46S1lMSU4=[\r][\n]"
[main]:[2015-05-20
16:59:14,949][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "User-Agent: Jakarta Commons-HttpClient/3.1[\r][\n]"
[main]:[2015-05-20
16:59:14,950][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Host: localhost:7070[\r][\n]"
[main]:[2015-05-20
16:59:14,951][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "[\r][\n]"
[main]:[2015-05-20
16:59:15,183][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "HTTP/1.1 200 OK[\r][\n]"
[main]:[2015-05-20
16:59:15,184][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "HTTP/1.1 200 OK[\r][\n]"
[main]:[2015-05-20
16:59:15,185][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Server: Apache-Coyote/1.1[\r][\n]"
[main]:[2015-05-20
16:59:15,186][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Set-Cookie: JSESSIONID=199223E1CC3702B7B58E7AF36635F0DE; Path=/kylin/;
HttpOnly[\r][\n]"
[main]:[2015-05-20
16:59:15,187][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Content-Type: application/json;charset=UTF-8[\r][\n]"
[main]:[2015-05-20
16:59:15,188][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Transfer-Encoding: chunked[\r][\n]"
[main]:[2015-05-20
16:59:15,189][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Vary: Accept-Encoding[\r][\n]"
[main]:[2015-05-20
16:59:15,190][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Date: Wed, 20 May 2015 11:29:15 GMT[\r][\n]"
[main]:[2015-05-20
16:59:15,191][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\r][\n]"
[main]:[2015-05-20
16:59:15,192][DEBUG][org.apache.commons.httpclient.cookie.CookieSpecBase.parseAttribute(CookieSpecBase.java:337)]
- Unrecognized cookie attribute: name=HttpOnly, value=null
[main]:[2015-05-20
16:59:15,193][DEBUG][org.apache.commons.httpclient.HttpMethodBase.processCookieHeaders(HttpMethodBase.java:1651)]
- Cookie accepted: "$Version=0; JSESSIONID=199223E1CC3702B7B58E7AF36635F0DE;
$Path=/kylin/"
[main]:[2015-05-20
16:59:15,427][WARN][org.apache.commons.httpclient.HttpMethodBase.getResponseBody(HttpMethodBase.java:682)]
- Going to buffer response body of large or unknown size. Using
getResponseBodyAsStream instead is recommended.
[main]:[2015-05-20
16:59:15,427][DEBUG][org.apache.commons.httpclient.HttpMethodBase.getResponseBody(HttpMethodBase.java:685)]
- Buffering response body
[main]:[2015-05-20
16:59:15,427][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "2"
[main]:[2015-05-20
16:59:15,428][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "0"
[main]:[2015-05-20
16:59:15,428][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "0"
[main]:[2015-05-20
16:59:15,429][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "0"
[main]:[2015-05-20
16:59:15,429][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "[\r]"
[main]:[2015-05-20
16:59:15,429][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\n]"
[main]:[2015-05-20
16:59:15,433][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<<
"[{"columns":[{"table_NAME":"KYLIN_CAL_DT","table_SCHEM":"DEFAULT","column_NAME":"WEEK_BEG_DT","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"DATE","data_TYPE":91,"column_SIZE":-1,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":-1,"ordinal_POSITION":1,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_CAL_DT","table_SCHEM":"DEFAULT","column_NAME":"CAL_DT","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"DATE","data_TYPE":91,"column_SIZE":-1,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":-1,"ordinal_POSITION":2,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null}],"table_NAME":"KYLIN_CAL_DT","table_SCHEM":"DEFAULT","self_REFERENCING_COL_NAME":null,"ref_GENERATION":null,"table_CAT":"defaultCatalog","table_TYPE":"TABLE","remarks":null,"type_CAT":null,"type_SCHEM":null,"type_NAME":null},{"columns":[{"table_NAME":"KYLIN_CATEGORY_GROUPINGS","table_SCHEM":"DEFAULT","column_NAME":"META_CATEG_NAME","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"VARCHAR(256)
CHARACTER SET \"UTF-16LE\" COLLATE
\"UTF-16LE$en_US$primary\"","data_TYPE":12,"column_SIZE":256,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":256,"ordinal_POSITION":1,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_CATEGORY_GROUPINGS","table_SCHEM":"DEFAULT","column_NAME":"CATEG_LVL3_NAME","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"VARCHAR(256)
CHARACTER SET \"UTF-16LE\" COLLATE
\"UTF-16LE$en_US$primary\"","data_TYPE":12,"column_SIZE":256,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":256,"ordinal_POSITION":2,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_CATEGORY_GROUPINGS","table_SCHEM":"DEFAULT","column_NAME":"USER_DEFINED_FIELD1","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"VARCHAR(256)
CHARACTER SET \"UTF-16LE\" COLLATE
\"UTF-16LE$en_US$primary\"","data_TYPE":12,"column_SIZE":256,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":256,"ordinal_POSITION":3,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_CATEGORY_GROUPINGS","table_SCHEM":"DEFAULT","column_NAME":"SITE_ID","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"INTEGER","data_TYPE":4,"column_SIZE":-1,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":-1,"ordinal_POSITION":4,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_CATEGORY_GROUPINGS","table_SCHEM":"DEFAULT","column_NAME":"CATEG_LVL2_NAME","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"VARCHAR(256)
CHARACTER SET \"UTF-16LE\" COLLATE
\"UTF-16LE$en_US$primary\"","data_TYPE":12,"column_SIZE":256,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":256,"ordinal_POSITION":5,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_CATEGORY_GROUPINGS","table_SCHEM":"DEFAULT","column_NAME":"UPD_DATE","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"VARCHA"
[main]:[2015-05-20
16:59:15,439][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "R(256) CHARACTER SET \"UTF-16LE\" COLLATE
\"UTF-16LE$en_US$primary\"","data_TYPE":12,"column_SIZE":256,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":256,"ordinal_POSITION":6,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_CATEGORY_GROUPINGS","table_SCHEM":"DEFAULT","column_NAME":"UPD_USER","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"VARCHAR(256)
CHARACTER SET \"UTF-16LE\" COLLATE
\"UTF-16LE$en_US$primary\"","data_TYPE":12,"column_SIZE":256,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":256,"ordinal_POSITION":7,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_CATEGORY_GROUPINGS","table_SCHEM":"DEFAULT","column_NAME":"USER_DEFINED_FIELD3","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"VARCHAR(256)
CHARACTER SET \"UTF-16LE\" COLLATE
\"UTF-16LE$en_US$primary\"","data_TYPE":12,"column_SIZE":256,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":256,"ordinal_POSITION":8,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_CATEGORY_GROUPINGS","table_SCHEM":"DEFAULT","column_NAME":"LEAF_CATEG_ID","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"BIGINT","data_TYPE":-5,"column_SIZE":-1,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":-1,"ordinal_POSITION":9,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null}],"table_NAME":"KYLIN_CATEGORY_GROUPINGS","table_SCHEM":"DEFAULT","self_REFERENCING_COL_NAME":null,"ref_GENERATION":null,"table_CAT":"defaultCatalog","table_TYPE":"TABLE","remarks":null,"type_CAT":null,"type_SCHEM":null,"type_NAME":null},{"columns":[{"table_NAME":"KYLIN_SALES","table_SCHEM":"DEFAULT","column_NAME":"LEAF_CATEG_ID","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"BIGINT","data_TYPE":-5,"column_SIZE":-1,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":-1,"ordinal_POSITION":1,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_SALES","table_SCHEM":"DEFAULT","column_NAME":"PART_DT","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"DATE","data_TYPE":91,"column_SIZE":-1,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":-1,"ordinal_POSITION":2,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_SALES","table_SCHEM":"DEFAULT","column_NAME":"SELLER_ID","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"BIGINT","data_TYPE":-5,"column_SIZE":-1,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":-1,"ordinal_POSITION":3,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_SALES","table_SCHEM":"DEFAULT","column_NAME":"LSTG_FORMAT_NAME","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"VARCHAR(256)
CHARACTER SET \"UTF-16LE\" COLLATE
\"UTF-16LE$en_US$primary\"","data_TYPE":12,"column_SIZE":256,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":"
[main]:[2015-05-20
16:59:15,440][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "[\r]"
[main]:[2015-05-20
16:59:15,441][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\n]"
[main]:[2015-05-20
16:59:15,442][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "5"
[main]:[2015-05-20
16:59:15,443][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "3"
[main]:[2015-05-20
16:59:15,444][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "3"
[main]:[2015-05-20
16:59:15,445][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "[\r]"
[main]:[2015-05-20
16:59:15,445][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\n]"
[main]:[2015-05-20
16:59:15,445][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<<
"256,"ordinal_POSITION":4,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_SALES","table_SCHEM":"DEFAULT","column_NAME":"LSTG_SITE_ID","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"INTEGER","data_TYPE":4,"column_SIZE":-1,"buffer_LENGTH":-1,"decimal_DIGITS":0,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":-1,"ordinal_POSITION":5,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null},{"table_NAME":"KYLIN_SALES","table_SCHEM":"DEFAULT","column_NAME":"PRICE","table_CAT":"defaultCatalog","remarks":null,"type_NAME":"DECIMAL(19,
4)","data_TYPE":3,"column_SIZE":19,"buffer_LENGTH":-1,"decimal_DIGITS":4,"num_PREC_RADIX":10,"nullable":1,"column_DEF":null,"sql_DATA_TYPE":-1,"sql_DATETIME_SUB":-1,"char_OCTET_LENGTH":19,"ordinal_POSITION":6,"is_NULLABLE":"YES","scope_CATLOG":null,"scope_SCHEMA":null,"scope_TABLE":null,"source_DATA_TYPE":-1,"is_AUTOINCREMENT":null}],"table_NAME":"KYLIN_SALES","table_SCHEM":"DEFAULT","self_REFERENCING_COL_NAME":null,"ref_GENERATION":null,"table_CAT":"defaultCatalog","table_TYPE":"TABLE","remarks":null,"type_CAT":null,"type_SCHEM":null,"type_NAME":null}]"
[main]:[2015-05-20
16:59:15,446][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "[\r]"
[main]:[2015-05-20
16:59:15,446][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\n]"
[main]:[2015-05-20
16:59:15,447][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "0"
[main]:[2015-05-20
16:59:15,447][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "[\r]"
[main]:[2015-05-20
16:59:15,448][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\n]"
[main]:[2015-05-20
16:59:15,448][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<< "[\r]"
[main]:[2015-05-20
16:59:15,449][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\n]"
[main]:[2015-05-20
16:59:15,449][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\r][\n]"
[main]:[2015-05-20
16:59:15,450][DEBUG][org.apache.commons.httpclient.HttpMethodBase.shouldCloseConnection(HttpMethodBase.java:1024)]
- Resorting to protocol version default close connection policy
[main]:[2015-05-20
16:59:15,450][DEBUG][org.apache.commons.httpclient.HttpMethodBase.shouldCloseConnection(HttpMethodBase.java:1028)]
- Should NOT close connection, using HTTP/1.1
[main]:[2015-05-20
16:59:15,451][DEBUG][org.apache.commons.httpclient.HttpConnection.releaseConnection(HttpConnection.java:1178)]
- Releasing connection back to connection manager.
[main]:[2015-05-20
16:59:15,622][DEBUG][org.apache.kylin.jdbc.Driver$1.onConnectionInit(Driver.java:121)]
- Connection inited.
[main]:[2015-05-20
16:59:15,721][DEBUG][org.apache.kylin.jdbc.stub.KylinClient.runKylinQuery(KylinClient.java:273)]
- Post body:
{"sql":"select version()","project":"learn_kylin"}
[main]:[2015-05-20
16:59:15,721][DEBUG][org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:692)]
- Open connection to localhost:7070
[main]:[2015-05-20
16:59:15,776][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "POST /kylin/api/query HTTP/1.1[\r][\n]"
[main]:[2015-05-20
16:59:15,778][DEBUG][org.apache.commons.httpclient.HttpMethodBase.addHostRequestHeader(HttpMethodBase.java:1352)]
- Adding Host request header
[main]:[2015-05-20
16:59:15,780][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Accept: application/json, text/plain, */*[\r][\n]"
[main]:[2015-05-20
16:59:15,781][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Content-Type: application/json[\r][\n]"
[main]:[2015-05-20
16:59:15,781][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Authorization: Basic QURNSU46S1lMSU4=[\r][\n]"
[main]:[2015-05-20
16:59:15,782][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "User-Agent: Jakarta Commons-HttpClient/3.1[\r][\n]"
[main]:[2015-05-20
16:59:15,783][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Host: localhost:7070[\r][\n]"
[main]:[2015-05-20
16:59:15,783][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Content-Length: 50[\r][\n]"
[main]:[2015-05-20
16:59:15,784][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "[\r][\n]"
[main]:[2015-05-20
16:59:15,784][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
>> "{"sql":"select version()","project":"learn_kylin"}"
[main]:[2015-05-20
16:59:15,785][DEBUG][org.apache.commons.httpclient.methods.EntityEnclosingMethod.writeRequestBody(EntityEnclosingMethod.java:508)]
- Request body sent
[main]:[2015-05-20
16:59:15,897][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "HTTP/1.1 200 OK[\r][\n]"
[main]:[2015-05-20
16:59:15,899][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "HTTP/1.1 200 OK[\r][\n]"
[main]:[2015-05-20
16:59:15,900][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Server: Apache-Coyote/1.1[\r][\n]"
[main]:[2015-05-20
16:59:15,901][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Set-Cookie: JSESSIONID=0B9272DBAED8AC966FFB341F4900ACB1; Path=/kylin/;
HttpOnly[\r][\n]"
[main]:[2015-05-20
16:59:15,902][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Content-Type: application/json;charset=UTF-8[\r][\n]"
[main]:[2015-05-20
16:59:15,903][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Content-Length: 926[\r][\n]"
[main]:[2015-05-20
16:59:15,903][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Date: Wed, 20 May 2015 11:29:16 GMT[\r][\n]"
[main]:[2015-05-20
16:59:15,904][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\r][\n]"
[main]:[2015-05-20
16:59:15,905][DEBUG][org.apache.commons.httpclient.cookie.CookieSpecBase.parseAttribute(CookieSpecBase.java:337)]
- Unrecognized cookie attribute: name=HttpOnly, value=null
[main]:[2015-05-20
16:59:15,906][DEBUG][org.apache.commons.httpclient.HttpMethodBase.processCookieHeaders(HttpMethodBase.java:1651)]
- Cookie accepted: "$Version=0; JSESSIONID=0B9272DBAED8AC966FFB341F4900ACB1;
$Path=/kylin/"
[main]:[2015-05-20
16:59:15,907][DEBUG][org.apache.commons.httpclient.HttpMethodBase.getResponseBody(HttpMethodBase.java:685)]
- Buffering response body
[main]:[2015-05-20
16:59:15,908][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<<
"{"columnMetas":null,"results":null,"cube":null,"affectedRowCount":0,"isException":true,"exceptionMessage":"error
while executing SQL \"select version()\": parse failed: Encountered \"<EOF>\"
at line 1, column 16.\nWas expecting one of:\n \"FROM\" ...\n \",\" ...\n
\"AS\" ...\n <IDENTIFIER> ...\n <QUOTED_IDENTIFIER> ...\n
<BACK_QUOTED_IDENTIFIER> ...\n <BRACKET_QUOTED_IDENTIFIER> ...\n
<UNICODE_QUOTED_IDENTIFIER> ...\n \"NOT\" ...\n \"IN\" ...\n
\"BETWEEN\" ...\n \"LIKE\" ...\n \"SIMILAR\" ...\n \"=\" ...\n
\">\" ...\n \"<\" ...\n \"<=\" ...\n \">=\" ...\n \"<>\" ...\n
\"+\" ...\n \"-\" ...\n \"*\" ...\n \"/\" ...\n \"||\" ...\n
\"AND\" ...\n \"OR\" ...\n \"IS\" ...\n \"MEMBER\" ...\n
\"SUBMULTISET\" ...\n \"MULTISET\" ...\n \"[\" ...\n \"OVER\" ...\n
","duration":1,"totalScanCount":0,"hitCache":true,"partial":false}"
[main]:[2015-05-20
16:59:15,909][DEBUG][org.apache.commons.httpclient.HttpMethodBase.shouldCloseConnection(HttpMethodBase.java:1024)]
- Resorting to protocol version default close connection policy
[main]:[2015-05-20
16:59:15,909][DEBUG][org.apache.commons.httpclient.HttpMethodBase.shouldCloseConnection(HttpMethodBase.java:1028)]
- Should NOT close connection, using HTTP/1.1
[main]:[2015-05-20
16:59:15,910][DEBUG][org.apache.commons.httpclient.HttpConnection.releaseConnection(HttpConnection.java:1178)]
- Releasing connection back to connection manager.
[main]:[2015-05-20
16:59:15,931][ERROR][org.apache.kylin.jdbc.KylinMetaImpl.prepare(KylinMetaImpl.java:341)]
-
java.lang.NullPointerException
at
org.apache.kylin.jdbc.stub.KylinClient.genColumnMeta(KylinClient.java:230)
at org.apache.kylin.jdbc.stub.KylinClient.query(KylinClient.java:182)
at org.apache.kylin.jdbc.KylinMetaImpl.prepare(KylinMetaImpl.java:339)
at
net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:76)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
mondrian.spi.impl.JdbcDialectImpl.isDatabase(JdbcDialectImpl.java:1410)
at
mondrian.spi.impl.ImpalaDialect$1.acceptsConnection(ImpalaDialect.java:48)
at
mondrian.spi.impl.JdbcDialectFactory.createDialect(JdbcDialectFactory.java:122)
at
mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:341)
at
mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:341)
at
mondrian.spi.DialectManager$CachingDialectFactory.createDialect(DialectManager.java:461)
at
mondrian.spi.DialectManager$DialectManagerImpl.createDialect(DialectManager.java:300)
at mondrian.spi.DialectManager.createDialect(DialectManager.java:107)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:215)
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)
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)
[main]:[2015-05-20
16:59:15,934][DEBUG][mondrian.spi.impl.JdbcDialectImpl.isDatabase(JdbcDialectImpl.java:1425)]
- NOT Using IMPALA dialect.
java.sql.SQLException: error while executing SQL "select version()": Failed to
query kylin server with exception null
at net.hydromatic.avatica.Helper.createException(Helper.java:39)
at
net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:79)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
mondrian.spi.impl.JdbcDialectImpl.isDatabase(JdbcDialectImpl.java:1410)
at
mondrian.spi.impl.ImpalaDialect$1.acceptsConnection(ImpalaDialect.java:48)
at
mondrian.spi.impl.JdbcDialectFactory.createDialect(JdbcDialectFactory.java:122)
at
mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:341)
at
mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:341)
at
mondrian.spi.DialectManager$CachingDialectFactory.createDialect(DialectManager.java:461)
at
mondrian.spi.DialectManager$DialectManagerImpl.createDialect(DialectManager.java:300)
at mondrian.spi.DialectManager.createDialect(DialectManager.java:107)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:215)
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)
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)
Caused by: java.lang.RuntimeException: Failed to query kylin server with
exception null
at org.apache.kylin.jdbc.KylinMetaImpl.prepare(KylinMetaImpl.java:342)
at
net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:76)
... 29 more
[main]:[2015-05-20
16:59:15,936][DEBUG][org.apache.kylin.jdbc.Driver$1.onStatementClose(Driver.java:137)]
- statement closed.
[main]:[2015-05-20
16:59:15,938][DEBUG][org.apache.kylin.jdbc.stub.KylinClient.runKylinQuery(KylinClient.java:273)]
- Post body:
{"sql":"select version()","project":"learn_kylin"}
[main]:[2015-05-20
16:59:15,938][DEBUG][org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:692)]
- Open connection to localhost:7070
[main]:[2015-05-20
16:59:15,941][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "POST /kylin/api/query HTTP/1.1[\r][\n]"
[main]:[2015-05-20
16:59:15,942][DEBUG][org.apache.commons.httpclient.HttpMethodBase.addHostRequestHeader(HttpMethodBase.java:1352)]
- Adding Host request header
[main]:[2015-05-20
16:59:15,942][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Accept: application/json, text/plain, */*[\r][\n]"
[main]:[2015-05-20
16:59:15,942][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Content-Type: application/json[\r][\n]"
[main]:[2015-05-20
16:59:15,943][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Authorization: Basic QURNSU46S1lMSU4=[\r][\n]"
[main]:[2015-05-20
16:59:15,943][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "User-Agent: Jakarta Commons-HttpClient/3.1[\r][\n]"
[main]:[2015-05-20
16:59:15,943][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Host: localhost:7070[\r][\n]"
[main]:[2015-05-20
16:59:15,944][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "Content-Length: 50[\r][\n]"
[main]:[2015-05-20
16:59:15,944][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
>> "[\r][\n]"
[main]:[2015-05-20
16:59:15,944][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
>> "{"sql":"select version()","project":"learn_kylin"}"
[main]:[2015-05-20
16:59:15,945][DEBUG][org.apache.commons.httpclient.methods.EntityEnclosingMethod.writeRequestBody(EntityEnclosingMethod.java:508)]
- Request body sent
[main]:[2015-05-20
16:59:16,092][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "HTTP/1.1 200 OK[\r][\n]"
[main]:[2015-05-20
16:59:16,092][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "HTTP/1.1 200 OK[\r][\n]"
[main]:[2015-05-20
16:59:16,093][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Server: Apache-Coyote/1.1[\r][\n]"
[main]:[2015-05-20
16:59:16,093][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Set-Cookie: JSESSIONID=B0F8C5D828567F0BAD2B90CD525A8C89; Path=/kylin/;
HttpOnly[\r][\n]"
[main]:[2015-05-20
16:59:16,094][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Content-Type: application/json;charset=UTF-8[\r][\n]"
[main]:[2015-05-20
16:59:16,094][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Content-Length: 926[\r][\n]"
[main]:[2015-05-20
16:59:16,094][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "Date: Wed, 20 May 2015 11:29:16 GMT[\r][\n]"
[main]:[2015-05-20
16:59:16,095][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:70)] -
<< "[\r][\n]"
[main]:[2015-05-20
16:59:16,095][DEBUG][org.apache.commons.httpclient.cookie.CookieSpecBase.parseAttribute(CookieSpecBase.java:337)]
- Unrecognized cookie attribute: name=HttpOnly, value=null
[main]:[2015-05-20
16:59:16,095][DEBUG][org.apache.commons.httpclient.HttpMethodBase.processCookieHeaders(HttpMethodBase.java:1651)]
- Cookie accepted: "$Version=0; JSESSIONID=B0F8C5D828567F0BAD2B90CD525A8C89;
$Path=/kylin/"
[main]:[2015-05-20
16:59:16,096][DEBUG][org.apache.commons.httpclient.HttpMethodBase.getResponseBody(HttpMethodBase.java:685)]
- Buffering response body
[main]:[2015-05-20
16:59:16,096][DEBUG][org.apache.commons.httpclient.Wire.wire(Wire.java:84)] -
<<
"{"columnMetas":null,"results":null,"cube":null,"affectedRowCount":0,"isException":true,"exceptionMessage":"error
while executing SQL \"select version()\": parse failed: Encountered \"<EOF>\"
at line 1, column 16.\nWas expecting one of:\n \"FROM\" ...\n \",\" ...\n
\"AS\" ...\n <IDENTIFIER> ...\n <QUOTED_IDENTIFIER> ...\n
<BACK_QUOTED_IDENTIFIER> ...\n <BRACKET_QUOTED_IDENTIFIER> ...\n
<UNICODE_QUOTED_IDENTIFIER> ...\n \"NOT\" ...\n \"IN\" ...\n
\"BETWEEN\" ...\n \"LIKE\" ...\n \"SIMILAR\" ...\n \"=\" ...\n
\">\" ...\n \"<\" ...\n \"<=\" ...\n \">=\" ...\n \"<>\" ...\n
\"+\" ...\n \"-\" ...\n \"*\" ...\n \"/\" ...\n \"||\" ...\n
\"AND\" ...\n \"OR\" ...\n \"IS\" ...\n \"MEMBER\" ...\n
\"SUBMULTISET\" ...\n \"MULTISET\" ...\n \"[\" ...\n \"OVER\" ...\n
","duration":0,"totalScanCount":0,"hitCache":true,"partial":false}"
[main]:[2015-05-20
16:59:16,097][DEBUG][org.apache.commons.httpclient.HttpMethodBase.shouldCloseConnection(HttpMethodBase.java:1024)]
- Resorting to protocol version default close connection policy
[main]:[2015-05-20
16:59:16,097][DEBUG][org.apache.commons.httpclient.HttpMethodBase.shouldCloseConnection(HttpMethodBase.java:1028)]
- Should NOT close connection, using HTTP/1.1
[main]:[2015-05-20
16:59:16,097][DEBUG][org.apache.commons.httpclient.HttpConnection.releaseConnection(HttpConnection.java:1178)]
- Releasing connection back to connection manager.
[main]:[2015-05-20
16:59:16,111][ERROR][org.apache.kylin.jdbc.KylinMetaImpl.prepare(KylinMetaImpl.java:341)]
-
java.lang.NullPointerException
at
org.apache.kylin.jdbc.stub.KylinClient.genColumnMeta(KylinClient.java:230)
at org.apache.kylin.jdbc.stub.KylinClient.query(KylinClient.java:182)
at org.apache.kylin.jdbc.KylinMetaImpl.prepare(KylinMetaImpl.java:339)
at
net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:76)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
mondrian.spi.impl.JdbcDialectImpl.isDatabase(JdbcDialectImpl.java:1410)
at
mondrian.spi.impl.NetezzaDialect$1.acceptsConnection(NetezzaDialect.java:36)
at
mondrian.spi.impl.JdbcDialectFactory.createDialect(JdbcDialectFactory.java:122)
at
mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:341)
at
mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:341)
at
mondrian.spi.DialectManager$CachingDialectFactory.createDialect(DialectManager.java:461)
at
mondrian.spi.DialectManager$DialectManagerImpl.createDialect(DialectManager.java:300)
at mondrian.spi.DialectManager.createDialect(DialectManager.java:107)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:215)
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)
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)
[main]:[2015-05-20
16:59:16,113][DEBUG][mondrian.spi.impl.JdbcDialectImpl.isDatabase(JdbcDialectImpl.java:1425)]
- NOT Using NETEZZA dialect.
java.sql.SQLException: error while executing SQL "select version()": Failed to
query kylin server with exception null
at net.hydromatic.avatica.Helper.createException(Helper.java:39)
at
net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:79)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
mondrian.spi.impl.JdbcDialectImpl.isDatabase(JdbcDialectImpl.java:1410)
at
mondrian.spi.impl.NetezzaDialect$1.acceptsConnection(NetezzaDialect.java:36)
at
mondrian.spi.impl.JdbcDialectFactory.createDialect(JdbcDialectFactory.java:122)
at
mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:341)
at
mondrian.spi.DialectManager$ChainDialectFactory.createDialect(DialectManager.java:341)
at
mondrian.spi.DialectManager$CachingDialectFactory.createDialect(DialectManager.java:461)
at
mondrian.spi.DialectManager$DialectManagerImpl.createDialect(DialectManager.java:300)
at mondrian.spi.DialectManager.createDialect(DialectManager.java:107)
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:215)
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)
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)
Caused by: java.lang.RuntimeException: Failed to query kylin server with
exception null
at org.apache.kylin.jdbc.KylinMetaImpl.prepare(KylinMetaImpl.java:342)
at
net.hydromatic.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:76)
... 29 more
[main]:[2015-05-20
16:59:16,116][DEBUG][org.apache.kylin.jdbc.Driver$1.onStatementClose(Driver.java:137)]
- statement closed.
[main]:[2015-05-20
16:59:16,126][DEBUG][mondrian.server.MondrianServerImpl.removeConnection(MondrianServerImpl.java:351)]
- removeConnection , id=1, statements=2, connections=2
[main]:[2015-05-20
16:59:16,127][DEBUG][mondrian.server.MondrianServerImpl.removeStatement(MondrianServerImpl.java:404)]
- removeStatement , id=1, statements=2, connections=1
[Mondrian Monitor]:[2015-05-20
16:59:16,127][DEBUG][mondrian.server.MonitorImpl$Handler.visit(MonitorImpl.java:606)]
- ConnectionInfo{cellCacheHitCount=0, cellCacheRequestCount=0,
cellCacheMissCount=0, cellCachePendingCount=0, statementStartCount=1,
statementEndCount=0, executeStartCount=0, executeEndCount=0}
[Mondrian Monitor]:[2015-05-20
16:59:16,132][DEBUG][mondrian.server.MonitorImpl$Actor.run(MonitorImpl.java:975)]
- ConnectionEndEvent(1)
[Mondrian Monitor]:[2015-05-20
16:59:16,133][DEBUG][mondrian.server.MonitorImpl$Handler.visit(MonitorImpl.java:660)]
- StatementInfo{statementId=1, executeStartCount=0, executeEndCount=0,
phaseCount=0, cellCacheRequestCount=0, cellCacheHitCount=0,
cellCacheMissCount=0, cellCachePendingCount=0, sqlStatementStartCount=0,
sqlStatementExecuteCount=0, sqlStatementEndCount=0,
sqlStatementRowFetchCount=0, sqlStatementExecuteNanos=0, cellRequestCount=0}
[Mondrian Monitor]:[2015-05-20
16:59:16,134][DEBUG][mondrian.server.MonitorImpl$Actor.run(MonitorImpl.java:975)]
- StatementEndEvent(1)
[main]:[2015-05-20
16:59:16,143][DEBUG][org.apache.kylin.jdbc.KylinMetaImpl.getTables(KylinMetaImpl.java:110)]
- Get tables with conn KylinConnectionImpl [baseUrl=localhost:7070,
project=learn_kylin,
metaProject=org.apache.kylin.jdbc.KylinMetaImpl$MetaProject@5d9c832a]
[main]:[2015-05-20
16:59:16,143][DEBUG][org.apache.kylin.jdbc.KylinMetaImpl$MetaProject.getMetaTables(KylinMetaImpl.java:491)]
- getMetaTables with catalog:null, schema:null, table:%
[main]:[2015-05-20
16:59:16,228][DEBUG][org.apache.kylin.jdbc.KylinMetaImpl.getColumns(KylinMetaImpl.java:137)]
- Get columns with conn KylinConnectionImpl [baseUrl=localhost:7070,
project=learn_kylin,
metaProject=org.apache.kylin.jdbc.KylinMetaImpl$MetaProject@5d9c832a]
[main]:[2015-05-20
16:59:16,229][DEBUG][org.apache.kylin.jdbc.KylinMetaImpl$MetaProject.getMetaColumns(KylinMetaImpl.java:508)]
- getMetaColumns with catalog:null, schema:null, table:KYLIN_CAL_DT, column:%
[main]:[2015-05-20
16:59:16,232][DEBUG][mondrian.server.MondrianServerImpl.removeStatement(MondrianServerImpl.java:404)]
- removeStatement , id=1, statements=1, connections=1
Exception in thread "main" java.lang.RuntimeException: cannot convert to long
(net.hydromatic.optiq.runtime.AbstractCursor$StringAccessor@15353c19)
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)
