[ASTERIXDB-1993] Extracting first result from a subquery in the select clause fails.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: COMP - Compiler, SQL - Translator SQL++
• Assignee: Dmitry Lychagin
• Reporter: Till Westmann
• Created: 20/Jul/17 02:15
• Updated: 23/Aug/17 00:10

Description

Running

select (select value count(*) from [1,2,3] seq)[0] as cnt;

yields

No serializer/deserializer implemented for type any . [NotImplementedException]

Stack trace:

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)