[
https://issues.apache.org/jira/browse/CALCITE-507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14355683#comment-14355683
]
Vladimir Sitnikov commented on CALCITE-507:
-------------------------------------------
[~julianhyde], can you please post your `cd mongodb && mvn verify -Pit` log?
Can you please proof-read the update in HOWTO.md (
https://github.com/apache/incubator-calcite/pull/50/files#diff-a12873c54f48832b960cf2ced5eef49e
)?
I get the following as I rebase to the latest master (see updated
https://github.com/apache/incubator-calcite/pull/50):
{noformat}
Failed tests:
MongoAdapterIT.testDate:739 Internal error: Error while applying rule
MongoProjectRule, args
[rel#258:LogicalProject.NONE.[](input=rel#168:Subset#0.MONGO.[],EXPR$0=CAST(ITEM($0,
'date')):DATE)]
MongoAdapterIT.testDistinctCount:585 Internal error: Error while applying
rule MongoProjectRule, args
[rel#721:LogicalProject.NONE.[](input=rel#710:Subset#8.NONE.[],STATE=CAST(ITEM($0,
'state')):VARCHAR(2) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary",CITY=CAST(ITEM($0, 'city')):VARCHAR(20) CHARACTER
SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary")]
MongoAdapterIT.testDistinctCountOrderBy:617 Internal error: Error while
applying rule MongoProjectRule, args
[rel#620:LogicalProject.NONE.[](input=rel#167:Subset#0.MONGO.[],STATE=CAST(ITEM($0,
'state')):VARCHAR(2) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary",CITY=CAST(ITEM($0, 'city')):VARCHAR(20) CHARACTER
SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary")]
MongoAdapterIT.testFilter:653 Internal error: Error while applying rule
MongoProjectRule, args
[rel#231:LogicalProject.NONE.[](input=rel#225:Subset#2.NONE.[],STATE=$1,CITY=$0)]
MongoAdapterIT.testFilterRedundant:314 Internal error: Error while applying
rule MongoProjectRule, args
[rel#314:LogicalProject.NONE.[](input=rel#311:Subset#2.NONE.[],CITY=$0,LONGITUDE=$1,LATITUDE=$2,POP=$3,STATE=$4,ID=$5)]
MongoAdapterIT.testFilterReversed:670 Internal error: Error while applying
rule MongoProjectRule, args
[rel#240:LogicalProject.NONE.[](input=rel#234:Subset#2.NONE.[],STATE=$1,CITY=$0)]
MongoAdapterIT.testFilterSortDesc:264 Internal error: Error while applying
rule MongoProjectRule, args
[rel#322:LogicalProject.NONE.[](input=rel#296:Subset#2.NONE.[],CITY=$0,LONGITUDE=$1,LATITUDE=$2,POP=$3,STATE=$4,ID=$5)]
MongoAdapterIT.testGroupByHaving:498 Internal error: Error while applying
rule MongoFilterRule, args
[rel#316:LogicalFilter.NONE.[](input=rel#313:Subset#2.NONE.[],condition=>($1,
1500))]
MongoAdapterIT.testGroupByMinMaxSum:550 Internal error: Error while applying
rule MongoProjectRule, args
[rel#274:LogicalProject.NONE.[](input=rel#268:Subset#3.NONE.[],C=$1,STATE=$0,MIN_POP=$2,MAX_POP=$3,SUM_POP=$4)]
MongoAdapterIT.testGroupByOneColumn:463 Internal error: Error while applying
rule MongoProjectRule, args
[rel#250:LogicalProject.NONE.[](input=rel#157:Subset#0.MONGO.[],STATE=CAST(ITEM($0,
'state')):VARCHAR(2) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary")]
MongoAdapterIT.testGroupByOneColumnNotProjected:445 Internal error: Error
while applying rule MongoProjectRule, args
[rel#261:LogicalProject.NONE.[](input=rel#254:Subset#2.NONE.[],EXPR$0=$1)]
MongoAdapterIT.testGroupByOneColumnReversed:481 Internal error: Error while
applying rule MongoProjectRule, args
[rel#298:LogicalProject.NONE.[](input=rel#290:Subset#2.NONE.[],C=$1,STATE=$0)]
MongoAdapterIT.testGroupComposite:567 Internal error: Error while applying
rule MongoProjectRule, args
[rel#251:LogicalProject.NONE.[](input=rel#243:Subset#3.NONE.[],C=$2,STATE=$0,CITY=$1)]
MongoAdapterIT.testInPlan:359 Internal error: Error while applying rule
MongoProjectRule, args
[rel#235:LogicalProject.NONE.[](input=rel#228:Subset#2.NONE.[],store_id=$0,store_name=$1)]
MongoAdapterIT.testLimit:214 Internal error: Error while applying rule
MongoProjectRule, args
[rel#278:LogicalProject.NONE.[](input=rel#163:Subset#0.MONGO.[],STATE=CAST(ITEM($0,
'state')):VARCHAR(2) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary",ID=CAST(ITEM($0, '_id')):VARCHAR(5) CHARACTER SET
"ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary")]
MongoAdapterIT.testOffsetLimit:200 Internal error: Error while applying rule
MongoProjectRule, args
[rel#197:LogicalProject.NONE.[](input=rel#156:Subset#0.MONGO.[],STATE=CAST(ITEM($0,
'state')):VARCHAR(2) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary",ID=CAST(ITEM($0, '_id')):VARCHAR(5) CHARACTER SET
"ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary")]
MongoAdapterIT.testProject:639 Internal error: Error while applying rule
MongoProjectRule, args
[rel#179:LogicalProject.NONE.[](input=rel#169:Subset#0.MONGO.[],CITY=CAST(ITEM($0,
'city')):VARCHAR(20) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary",STATE=CAST(ITEM($0, 'state')):VARCHAR(2) CHARACTER
SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary")]
MongoAdapterIT.testSelectWhere:331 Internal error: Error while applying rule
MongoProjectRule, args
[rel#196:LogicalProject.NONE.[](input=rel#192:Subset#2.NONE.[],warehouse_id=$0,warehouse_state_province=$1)]
MongoAdapterIT.testSort:170 Internal error: Error while applying rule
MongoProjectRule, args
[rel#195:LogicalProject.NONE.[](input=rel#190:Subset#1.NONE.[],CITY=$0,LONGITUDE=$1,LATITUDE=$2,POP=$3,STATE=$4,ID=$5)]
MongoAdapterIT.testSortLimit:183 Internal error: Error while applying rule
MongoProjectRule, args
[rel#200:LogicalProject.NONE.[](input=rel#172:Subset#0.MONGO.[],STATE=CAST(ITEM($0,
'state')):VARCHAR(2) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary",ID=CAST(ITEM($0, '_id')):VARCHAR(5) CHARACTER SET
"ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary")]
MongoAdapterIT.testUnionPlan:278 Internal error: Error while applying rule
MongoProjectRule, args
[rel#270:LogicalProject.NONE.[](input=rel#265:Subset#4.NONE.[],product_id=$0)]
MongoAdapterIT.testZips:410 Internal error: Error while applying rule
MongoProjectRule, args
[rel#621:LogicalProject.NONE.[](input=rel#173:Subset#0.MONGO.[],STATE=CAST(ITEM($0,
'state')):VARCHAR(2) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary",CITY=CAST(ITEM($0, 'city')):VARCHAR(20) CHARACTER
SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary")]
Tests run: 28, Failures: 22, Errors: 0, Skipped: 5{noformat}
The error is like
{noformat}
java.lang.AssertionError: Internal error: Error while applying rule
MongoProjectRule, args
[rel#7:LogicalProject.NONE.[](input=rel#6:Subset#0.MONGO.[],STATE=CAST(ITEM($0,
'state')):VARCHAR(2) CHARACTER SET "ISO-8859-1" COLLATE
"ISO-8859-1$en_US$primary",ID=CAST(ITEM($0, '_id')):VARCHAR(5) CHARACTER SET
"ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary")]
at org.apache.calcite.util.Util.newInternal(Util.java:743)
at
org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:251)
at
org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:795)
at org.apache.calcite.tools.Programs$5.run(Programs.java:272)
at
org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:320)
at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:142)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:280)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:188)
at
org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:521)
at
org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:417)
at
org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:386)
at
org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:174)
at
org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:471)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:434)
at
org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:117)
at
org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:450)
at
org.apache.calcite.test.CalciteAssert$AssertQuery.runs(CalciteAssert.java:1176)
at
org.apache.calcite.test.MongoAdapterIT.testOffsetLimit(MongoAdapterIT.java:200)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at
org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47)
at
org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at
org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44)
at
org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70)
at
org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
at org.junit.runner.JUnitCore.run(JUnitCore.java:160)
at
com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:74)
at
com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:211)
at
com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:67)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:134)
{noformat}
{noformat}
Caused by: java.lang.AssertionError
at org.apache.calcite.plan.volcano.RelSubset.<init>(RelSubset.java:108)
at
org.apache.calcite.plan.volcano.RelSet.getOrCreateSubset(RelSet.java:154)
at
org.apache.calcite.plan.volcano.VolcanoPlanner.changeTraits(VolcanoPlanner.java:694)
at org.apache.calcite.plan.RelOptRule.convert(RelOptRule.java:510)
at
org.apache.calcite.adapter.mongodb.MongoRules$MongoProjectRule.convert(MongoRules.java:263)
at
org.apache.calcite.rel.convert.ConverterRule.onMatch(ConverterRule.java:116)
at
org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:228)
... 42 more
{noformat}
> Add Vagrant files to enable testing of data storages: mysql, postgresql,
> mongo, etc
> -----------------------------------------------------------------------------------
>
> Key: CALCITE-507
> URL: https://issues.apache.org/jira/browse/CALCITE-507
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.0.0-incubating
> Reporter: Vladimir Sitnikov
> Assignee: Julian Hyde
> Labels: newbie
> Fix For: next
>
>
> As discussed in email list, it makes sense to implement Vagrant (or similar)
> VM machines to simplify testing of the downstream executors.
> Currently it is not clear how to configure mysql/mongo/etc.
> Not sure if it should be a set of separate configurations or a single
> configuration with all the batteries included.
> For instance, Vagrant allows to configure a [set of
> machines|https://docs.vagrantup.com/v2/multi-machine/index.html], while still
> providing a way to start just a subset.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
