Analytics : Internal Error with array append query

SELECT ARRAY_APPEND(t.public_likes, "Valerie Smith") AS add_user_likes

FROM `travel_ds` t 

WHERE `type`="hotel" 

LIMIT 1

[

{

"code": 25000,

"msg": "Internal error",

"query_from_user": "SELECT ARRAY_APPEND(t.public_likes, \"Valerie Smith\") AS add_user_likes\nFROM `travel_ds` t \nWHERE `type`=\"hotel\" \nLIMIT 1"

}

]

SELECT ARRAY_APPEND(t.public_likes, "Valerie Smith") AS add_user_likes

FROM `travel-sample` t 

WHERE `type`="hotel" 

LIMIT 1

[

{

"add_user_likes": [

"Julius Tromp I",

"Corrine Hilll",

"Jaeden McKenzie",

"Vallie Ryan",

"Brian Kilback",

"Lilian McLaughlin",

"Ms. Moses Feeney",

"Elnora Trantow",

"Valerie Smith"

]

}

]

018-07-20T08:16:25.761Z INFO CBAS.server.QueryServiceServlet [HttpExecutor(port:8095)-13] handleRequest: {"host":"10.142.180.102:8091","path":"/query/service","statement":"SELECT ARRAY_APPEND(t.public_likes, \\\"Valerie Smith\\\") AS add_user_likes\\nFROM `travel_ds` t \\nWHERE `type`=\\\"hotel\\\" \\nLIMIT 1","pretty":false,"mode":null,"clientContextID":"dfdfc68a-0c96-4a13-8d4b-d0e252012e67","format":null,"timeout":null,"maxResultReads":null,"planFormat":"json","expressionTree":false,"rewrittenExpressionTree":false,"logicalPlan":false,"optimizedLogicalPlan":true,"job":false,"signature":true,"multiStatement":true,"$1":"air","$country":"United States","$iata":"FL","$ty":"hotel","$limit":10}

2018-07-20T08:16:25.763Z INFO CBAS.work.WorkQueue [Worker:ClusterController] Executing: ApplicationMessage: nodeID: b41f065407e1a925710a5ce0e4038452

2018-07-20T08:16:25.764Z INFO CBAS.messaging.CCMessageBroker [Executor-3:ClusterController] Received message: ExecuteStatementRequestMessage(id=94, from=b41f065407e1a925710a5ce0e4038452): SELECT ARRAY_APPEND(t.public_likes, "Valerie Smith") AS add_user_likes

FROM `travel_ds` t

WHERE `type`="hotel"

LIMIT 1;

2018-07-20T08:16:25.766Z INFO CBAS.work.WorkQueue [Worker:ClusterController] Executing: GetNodeControllersInfo

2018-07-20T08:16:25.778Z INFO CBAS.work.WorkQueue [Worker:ClusterController] Executing: JobStart

2018-07-20T08:16:25.780Z INFO CBAS.dataset.DatasetDirectoryService [Worker:ClusterController] DatasetDirectoryService notified of new job JID:0.69

2018-07-20T08:16:25.780Z INFO CBAS.active.ActiveNotificationHandler [Worker:ClusterController] notifyJobCreation(JobId jobId, JobSpecification jobSpecification) was called with jobId = JID:0.69

2018-07-20T08:16:25.780Z INFO CBAS.active.ActiveNotificationHandler [Worker:ClusterController] Job is not of type active job. property found to be: null

2018-07-20T08:16:25.780Z INFO CBAS.executor.ActivityClusterPlanner [Worker:ClusterController] Plan for org.apache.hyracks.api.job.ActivityCluster@907bac2

2018-07-20T08:16:25.780Z INFO CBAS.executor.ActivityClusterPlanner [Worker:ClusterController] Built 1 Task Clusters

2018-07-20T08:16:25.781Z INFO CBAS.executor.ActivityClusterPlanner [Worker:ClusterController] Tasks: [TID:ANID:ODID:3:0:0, TID:ANID:ODID:4:0:0]

2018-07-20T08:16:25.782Z INFO CBAS.executor.JobExecutor [Worker:ClusterController] Runnable TC roots: [TC:[TID:ANID:ODID:3:0:0, TID:ANID:ODID:4:0:0]], inProgressTaskClusters: []

2018-07-20T08:16:25.783Z INFO CBAS.work.WorkQueue [Worker:b41f065407e1a925710a5ce0e4038452] Executing: StartTasks

2018-07-20T08:16:25.785Z INFO CBAS.work.StartTasksWork [Worker:b41f065407e1a925710a5ce0e4038452] Initializing TAID:TID:ANID:ODID:3:0:0:0 -> [org.apache.hyracks.dataflow.std.result.ResultWriterOperatorDescriptor@55b1b9f0, AlgebricksMeta [stream-project [1], stream-limit Constant]] for JID:0.69

2018-07-20T08:16:25.785Z INFO CBAS.work.StartTasksWork [Worker:b41f065407e1a925710a5ce0e4038452] input: 0: CDID:2

2018-07-20T08:16:25.785Z INFO CBAS.work.StartTasksWork [Worker:b41f065407e1a925710a5ce0e4038452] Initializing TAID:TID:ANID:ODID:4:0:0:0 -> [org.apache.hyracks.storage.am.btree.dataflow.BTreeSearchOperatorDescriptor@772e5fb3, AlgebricksMeta [stream-project [0, 1], stream-limit Constant, assign [2] := [org.apache.asterix.runtime.evaluators.constructors.OpenRecordConstructorDescriptor$2@3dee0b61], stream-project [0, 2]], AlgebricksMeta [ets]] for JID:0.69

2018-07-20T08:16:25.785Z INFO CBAS.work.StartTasksWork [Worker:b41f065407e1a925710a5ce0e4038452] input: 0: CDID:2

2018-07-20T08:16:25.791Z INFO CBAS.work.WorkQueue [Worker:ClusterController] Executing: WaitForJobCompletion

2018-07-20T08:16:25.806Z INFO CBAS.dataset.DatasetPartitionWriter [org.apache.hyracks.api.rewriter.runtime.SuperActivity:TAID:TID:ANID:ODID:3:0:0:0:0] open(0)

2018-07-20T08:16:25.806Z INFO CBAS.dataset.DatasetPartitionWriter [org.apache.hyracks.api.rewriter.runtime.SuperActivity:TAID:TID:ANID:ODID:3:0:0:0:0] close(0)

2018-07-20T08:16:25.809Z INFO CBAS.work.WorkQueue [Worker:ClusterController] Executing: RegisterResultPartitionLocation: JobId@JID:0.69 ResultSetId@RSID:0 Partition@0 NPartitions@1 ResultPartitionLocation@10.142.180.102:9117 OrderedResult@true EmptyResult@true

2018-07-20T08:16:25.809Z INFO CBAS.work.WorkQueue [Worker:ClusterController] Executing: ReportResultPartitionWriteCompletion: JobId@JID:0.69 ResultSetId@RSID:0 Partition@0

2018-07-20T08:16:25.813Z INFO CBAS.work.WorkQueue [Worker:b41f065407e1a925710a5ce0e4038452] Executing: NotifyTaskCompleteWork:TAID:TID:ANID:ODID:3:0:0:0

2018-07-20T08:16:25.814Z INFO CBAS.work.WorkQueue [Worker:ClusterController] Executing: TaskComplete: [b41f065407e1a925710a5ce0e4038452[JID:0.69:TAID:TID:ANID:ODID:3:0:0:0]

2018-07-20T08:16:25.814Z WARN CBAS.util.CleanupUtils [Executor-159:b41f065407e1a925710a5ce0e4038452] Failure closing a closeable resource of class

org.apache.hyracks.api.exceptions.HyracksDataException: java.lang.ClassCastException: org.apache.asterix.om.types.BuiltinType$29 cannot be cast to org.apache.asterix.om.types.AbstractCollectionType

at org.apache.hyracks.api.exceptions.HyracksDataException.create(HyracksDataException.java:51) ~[hyracks-api.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.base.AbstractOneInputOneOutputOneFramePushRuntime.close(AbstractOneInputOneOutputOneFramePushRuntime.java:58) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.std.StreamLimitRuntimeFactory$1.close(StreamLimitRuntimeFactory.java:131) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.base.AbstractOneInputOneOutputOneFramePushRuntime.close(AbstractOneInputOneOutputOneFramePushRuntime.java:62) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.meta.AlgebricksMetaOperatorDescriptor$1.close(AlgebricksMetaOperatorDescriptor.java:156) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.api.util.CleanupUtils.close(CleanupUtils.java:65) ~[hyracks-api.jar:6.0.0-1340]

at org.apache.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.close(IndexSearchOperatorNodePushable.java:305) ~[hyracks-storage-am-common.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.std.EmptyTupleSourceRuntimeFactory$1.close(EmptyTupleSourceRuntimeFactory.java:65) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.meta.AlgebricksMetaOperatorDescriptor$SourcePushRuntime.initialize(AlgebricksMetaOperatorDescriptor.java:111) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.lambda$runInParallel$0(SuperActivityOperatorNodePushable.java:208) ~[hyracks-api.jar:6.0.0-1340]

at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_162]

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]

Caused by: java.lang.ClassCastException: org.apache.asterix.om.types.BuiltinType$29 cannot be cast to org.apache.asterix.om.types.AbstractCollectionType

at org.apache.asterix.runtime.evaluators.functions.AbstractArrayAddRemoveEval.evaluate(AbstractArrayAddRemoveEval.java:155) ~[asterix-runtime.jar:6.0.0-1340]

at org.apache.asterix.runtime.evaluators.constructors.OpenRecordConstructorDescriptor$2$1.evaluate(OpenRecordConstructorDescriptor.java:104) ~[asterix-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.std.AssignRuntimeFactory$1.produceTuple(AssignRuntimeFactory.java:168) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.std.AssignRuntimeFactory$1.nextFrame(AssignRuntimeFactory.java:144) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.dataflow.common.comm.io.AbstractFrameAppender.write(AbstractFrameAppender.java:93) ~[hyracks-dataflow-common.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.base.AbstractOneInputOneOutputOneFramePushRuntime.flushAndReset(AbstractOneInputOneOutputOneFramePushRuntime.java:78) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.base.AbstractOneInputOneOutputOneFramePushRuntime.flushIfNotFailed(AbstractOneInputOneOutputOneFramePushRuntime.java:84) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.base.AbstractOneInputOneOutputOneFramePushRuntime.close(AbstractOneInputOneOutputOneFramePushRuntime.java:56) ~[algebricks-runtime.jar:6.0.0-1340]

... 12 more

2018-07-20T08:16:25.816Z WARN CBAS.nc.Task [org.apache.hyracks.api.rewriter.runtime.SuperActivity:TAID:TID:ANID:ODID:4:0:0:0:0] Task TAID:TID:ANID:ODID:4:0:0:0 failed with exception

org.apache.hyracks.api.exceptions.HyracksDataException: java.lang.ClassCastException: org.apache.asterix.om.types.BuiltinType$29 cannot be cast to org.apache.asterix.om.types.AbstractCollectionType

at org.apache.hyracks.api.exceptions.HyracksDataException.create(HyracksDataException.java:51) ~[hyracks-api.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.base.AbstractOneInputOneOutputOneFramePushRuntime.close(AbstractOneInputOneOutputOneFramePushRuntime.java:58) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.std.StreamLimitRuntimeFactory$1.close(StreamLimitRuntimeFactory.java:131) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.base.AbstractOneInputOneOutputOneFramePushRuntime.close(AbstractOneInputOneOutputOneFramePushRuntime.java:62) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.meta.AlgebricksMetaOperatorDescriptor$1.close(AlgebricksMetaOperatorDescriptor.java:156) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.api.util.CleanupUtils.close(CleanupUtils.java:65) ~[hyracks-api.jar:6.0.0-1340]

at org.apache.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.close(IndexSearchOperatorNodePushable.java:305) ~[hyracks-storage-am-common.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.std.EmptyTupleSourceRuntimeFactory$1.close(EmptyTupleSourceRuntimeFactory.java:65) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.algebricks.runtime.operators.meta.AlgebricksMetaOperatorDescriptor$SourcePushRuntime.initialize(AlgebricksMetaOperatorDescriptor.java:111) ~[algebricks-runtime.jar:6.0.0-1340]

at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.lambda$runInParallel$0(SuperActivityOperatorNodePushable.java:208) ~[hyracks-api.jar:6.0.0-1340]

at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[?:1.8.0_162]

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]

Caused by: java.lang.ClassCastException: org.apache.asterix.om.types.BuiltinType$29 cannot be cast to org.apache.asterix.om.types.AbstractCollectionType