You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Till (JIRA)" <ji...@apache.org> on 2017/07/20 02:16:00 UTC

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

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)