Details
Description
I have below documents ingested in CBAS from KV.
id-0{"name":"dave","gender":"Male","salary":50,"married":false,"age":19,"employed":""} |
id-1{"name":"evan","gender":"Female","salary":100.15,"married":true,"age":25} |
id-2{"name":"john","gender":"Male","salary":150.55,"married":null,"age":44} |
id-3{"name":"sara","gender":"Female","salary":200.34,"married":false,"age":20} |
id-4{"name":"tom","gender":"Male","salary":250.99,"married":true,"age":31} |
If limit and offset have same value we are getting "Internal error" on Analytics workbench
select * from default limit 1 offset 1 |
 Exception in logs
2018-07-23T11:54:29.560Z WARN CBAS.apache.asterix [Executor-5:ClusterController] Variable $$12 could not be found in any input schema. |
org.apache.hyracks.algebricks.common.exceptions.AlgebricksException: Variable $$12 could not be found in any input schema. |
at org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.createVariableEvaluatorFactory(QueryLogicalExpressionJobGen.java:133) ~[asterix-algebra.jar:6.0.0-1355] |
at org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.createEvaluatorFactory(QueryLogicalExpressionJobGen.java:105) ~[asterix-algebra.jar:6.0.0-1355] |
at org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.codegenArguments(QueryLogicalExpressionJobGen.java:161) ~[asterix-algebra.jar:6.0.0-1355] |
at org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.createScalarFunctionEvaluatorFactory(QueryLogicalExpressionJobGen.java:139) ~[asterix-algebra.jar:6.0.0-1355] |
at org.apache.asterix.jobgen.QueryLogicalExpressionJobGen.createEvaluatorFactory(QueryLogicalExpressionJobGen.java:114) ~[asterix-algebra.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.algebra.expressions.ExpressionRuntimeProvider.createEvaluatorFactory(ExpressionRuntimeProvider.java:41) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.algebra.operators.physical.StreamLimitPOperator.contributeRuntimeOperator(StreamLimitPOperator.java:93) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.algebra.operators.logical.AbstractLogicalOperator.contributeRuntimeOperator(AbstractLogicalOperator.java:169) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:110) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compilePlanImpl(PlanCompiler.java:70) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compilePlan(PlanCompiler.java:53) ~[algebricks-core.jar:6.0.0-1355] |
at org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.createJob(HeuristicCompilerFactoryBuilder.java:107) ~[algebricks-compiler.jar:6.0.0-1355] |
at org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:291) ~[asterix-app.jar:6.0.0-1355] |
at org.apache.asterix.app.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1976) ~[asterix-app.jar:6.0.0-1355] |
at org.apache.asterix.app.translator.QueryTranslator.lambda$handleQuery$2(QueryTranslator.java:2483) ~[asterix-app.jar:6.0.0-1355] |
at org.apache.asterix.app.translator.QueryTranslator.createAndRunJob(QueryTranslator.java:2608) ~[asterix-app.jar:6.0.0-1355] |
at org.apache.asterix.app.translator.QueryTranslator.deliverResult(QueryTranslator.java:2527) ~[asterix-app.jar:6.0.0-1355] |
at org.apache.asterix.app.translator.QueryTranslator.handleQuery(QueryTranslator.java:2496) ~[asterix-app.jar:6.0.0-1355] |
at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:393) ~[asterix-app.jar:6.0.0-1355] |
at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:136) [asterix-app.jar:6.0.0-1355] |
at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:66) [asterix-app.jar:6.0.0-1355] |
at org.apache.hyracks.control.cc.work.ApplicationMessageWork$1.run(ApplicationMessageWork.java:59) [hyracks-control-cc.jar:6.0.0-1355] |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_162] |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_162] |
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_162] |