Till created ASTERIXDB-1993:
-------------------------------
Summary: Extracting first result from a subquery in the select
clause fails.
Key: ASTERIXDB-1993
URL: https://issues.apache.org/jira/browse/ASTERIXDB-1993
Project: Apache AsterixDB
Issue Type: Improvement
Components: COMP - Compiler, SQL - Translator SQL++
Reporter: Till
Assignee: Yingyi Bu
Running
{noformat}
select (select value count(*) from [1,2,3] seq)[0] as cnt;
{noformat}
yields
{noformat}
No serializer/deserializer implemented for type any . [NotImplementedException]
{noformat}
Stack trace:
{noformat}
Jul 19, 2017 7:12:46 PM org.apache.asterix.api.http.server.ApiServlet post
SEVERE: No serializer/deserializer implemented for type any .
org.apache.hyracks.algebricks.common.exceptions.NotImplementedException: No
serializer/deserializer implemented for type any .
at
org.apache.asterix.formats.nontagged.SerializerDeserializerProvider.getNonTaggedSerializerDeserializer(SerializerDeserializerProvider.java:167)
at
org.apache.asterix.dataflow.data.nontagged.serde.ARecordSerializerDeserializer.<init>(ARecordSerializerDeserializer.java:80)
at
org.apache.asterix.formats.nontagged.SerializerDeserializerProvider.getNonTaggedSerializerDeserializer(SerializerDeserializerProvider.java:158)
at
org.apache.asterix.formats.nontagged.SerializerDeserializerProvider.getSerializerDeserializer(SerializerDeserializerProvider.java:100)
at
org.apache.hyracks.algebricks.core.jobgen.impl.JobGenHelper.mkRecordDescriptor(JobGenHelper.java:63)
at
org.apache.hyracks.algebricks.core.algebra.operators.physical.AssignPOperator.contributeRuntimeOperator(AssignPOperator.java:95)
at
org.apache.hyracks.algebricks.core.algebra.operators.logical.AbstractLogicalOperator.contributeRuntimeOperator(AbstractLogicalOperator.java:166)
at
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:97)
at
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:84)
at
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:84)
at
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compileOpRef(PlanCompiler.java:84)
at
org.apache.hyracks.algebricks.core.jobgen.impl.PlanCompiler.compilePlan(PlanCompiler.java:60)
at
org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$1$1.createJob(HeuristicCompilerFactoryBuilder.java:107)
at
org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:333)
at
org.apache.asterix.app.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1822)
at
org.apache.asterix.app.translator.QueryTranslator.lambda$handleQuery$1(QueryTranslator.java:2317)
at
org.apache.asterix.app.translator.QueryTranslator.createAndRunJob(QueryTranslator.java:2417)
at
org.apache.asterix.app.translator.QueryTranslator.deliverResult(QueryTranslator.java:2350)
at
org.apache.asterix.app.translator.QueryTranslator.handleQuery(QueryTranslator.java:2329)
at
org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:376)
at
org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:259)
at
org.apache.asterix.api.http.server.ApiServlet.post(ApiServlet.java:153)
at
org.apache.hyracks.http.server.AbstractServlet.handle(AbstractServlet.java:78)
at
org.apache.hyracks.http.server.HttpRequestHandler.handle(HttpRequestHandler.java:70)
at
org.apache.hyracks.http.server.HttpRequestHandler.call(HttpRequestHandler.java:55)
at
org.apache.hyracks.http.server.HttpRequestHandler.call(HttpRequestHandler.java:36)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
