Analytics : Internal error with ARRAY_REMOVE

SELECT ARRAY_REMOVE(t.public_likes, "Vallie Ryan") AS remove_val

FROM `travel_ds` t 

WHERE `type`="hotel" 

LIMIT 1;

[

{

"code": 25000,

"msg": "Internal error",

"query_from_user": "SELECT ARRAY_REMOVE(t.public_likes, \"Vallie Ryan\") AS remove_val\nFROM `travel_ds` t \nWHERE `type`=\"hotel\" \nLIMIT 1;"

}

]

SELECT ARRAY_REMOVE(t.public_likes, "Vallie Ryan") AS remove_val

FROM `travel-sample` t 

WHERE type="hotel" 

LIMIT 1;

[

{

"remove_val": [

"Julius Tromp I",

"Corrine Hilll",

"Jaeden McKenzie",

"Brian Kilback",

"Lilian McLaughlin",

"Ms. Moses Feeney",

"Elnora Trantow"

]

}

]

2018-07-20T08:54:00.799Z INFO CBAS.server.QueryServiceServlet [HttpExecutor(port:8095)-10] handleRequest: {"host":"10.142.180.102:8091","path":"/query/service","statement":"SELECT ARRAY_REMOVE(t.public_likes, \\\"Vallie Ryan\\\") AS remove_val\\nFROM `travel_ds` t \\nWHERE `type`=\\\"hotel\\\" \\nLIMIT 1;","pretty":false,"mode":null,"clientContextID":"2b1e2e33-9d57-489f-a2d9-8cfa40560580","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:54:00.802Z INFO CBAS.work.WorkQueue [Worker:ClusterController] Executing: ApplicationMessage: nodeID: ccc4b525775fc87e2cb3818aca712baa

2018-07-20T08:54:00.802Z INFO CBAS.messaging.CCMessageBroker [Executor-4:ClusterController] Received message: ExecuteStatementRequestMessage(id=27, from=ccc4b525775fc87e2cb3818aca712baa): SELECT ARRAY_REMOVE(t.public_likes, "Vallie Ryan") AS remove_val

FROM `travel_ds` t

WHERE `type`="hotel"

LIMIT 1;;

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

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

2018-07-20T08:54:00.831Z INFO CBAS.dataset.DatasetDirectoryService [Worker:ClusterController] DatasetDirectoryService notified of new job JID:0.27

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

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

2018-07-20T08:54:00.831Z INFO CBAS.executor.ActivityClusterPlanner [Worker:ClusterController] Plan for org.apache.hyracks.api.job.ActivityCluster@4ccaab81

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

2018-07-20T08:54:00.831Z INFO CBAS.executor.ActivityClusterPlanner [Worker:ClusterController] Tasks: [TID:ANID:ODID:2:0:0, TID:ANID:ODID:3:0:0]

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

2018-07-20T08:54:00.833Z INFO CBAS.work.WorkQueue [Worker:ccc4b525775fc87e2cb3818aca712baa] Executing: StartTasks

2018-07-20T08:54:00.834Z INFO CBAS.work.StartTasksWork [Worker:ccc4b525775fc87e2cb3818aca712baa] Initializing TAID:TID:ANID:ODID:2:0:0:0 -> [org.apache.hyracks.storage.am.btree.dataflow.BTreeSearchOperatorDescriptor@5a03669e, AlgebricksMeta [ets], AlgebricksMeta [stream-project [0, 1], stream-limit Constant, assign [2] := [org.apache.asterix.runtime.evaluators.constructors.OpenRecordConstructorDescriptor$2@31a1138a], stream-project [0, 2]]] for JID:0.27

2018-07-20T08:54:00.834Z INFO CBAS.work.StartTasksWork [Worker:ccc4b525775fc87e2cb3818aca712baa] input: 0: CDID:2

2018-07-20T08:54:00.841Z INFO CBAS.work.StartTasksWork [Worker:ccc4b525775fc87e2cb3818aca712baa] Initializing TAID:TID:ANID:ODID:3:0:0:0 -> [org.apache.hyracks.dataflow.std.result.ResultWriterOperatorDescriptor@2faebd94, AlgebricksMeta [stream-project [1], stream-limit Constant]] for JID:0.27

2018-07-20T08:54:00.842Z INFO CBAS.work.StartTasksWork [Worker:ccc4b525775fc87e2cb3818aca712baa] input: 0: CDID:2

2018-07-20T08:54:00.844Z 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:54:00.844Z 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:54:00.847Z INFO CBAS.work.WorkQueue [Worker:ccc4b525775fc87e2cb3818aca712baa] Executing: NotifyTaskCompleteWork:TAID:TID:ANID:ODID:3:0:0:0

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

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

2018-07-20T08:54:00.851Z INFO CBAS.work.WorkQueue [Worker:ClusterController] Executing: TaskComplete: [ccc4b525775fc87e2cb3818aca712baa[JID:0.27:TAID:TID:ANID:ODID:3:0:0:0]

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

2018-07-20T08:54:00.839Z WARN CBAS.util.CleanupUtils [Executor-23:ccc4b525775fc87e2cb3818aca712baa] 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-1347]

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

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

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

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

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

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

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

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

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

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-1347]

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

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

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

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

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

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

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

... 12 more

2018-07-20T08:54:00.856Z WARN CBAS.nc.Task [org.apache.hyracks.api.rewriter.runtime.SuperActivity:TAID:TID:ANID:ODID:2:0:0:0:0] Task TAID:TID:ANID:ODID:2: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-1347]

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