Imports:
import java.util.Date
import org.apache.flink.api.scala._
import org.apache.flink.api.common.typeinfo.TypeInformation
import org.apache.flink.api.java.typeutils.RowTypeInfo
import org.apache.flink.table.api.{
DataTypes,
EnvironmentSettings,
TableEnvironment,
TableSchema
}
import org.apache.flink.table.api.bridge.scala._
import org.apache.flink.table.data.RowData
import org.apache.flink.streaming.api.scala.{
DataStream,
StreamExecutionEnvironment
}
import org.apache.flink.types.Row
import org.apache.flink.table.api._
import
org.apache.flink.streaming.api.environment.CheckpointConfig.ExternalizedCheckpointCleanup
import
org.apache.flink.streaming.connectors.elasticsearch.ElasticsearchUpsertTableSinkFactoryBase
import
org.apache.flink.streaming.connectors.elasticsearch7.Elasticsearch7UpsertTableSink
import
org.apache.flink.streaming.connectors.elasticsearch7.Elasticsearch7UpsertTableSinkFactory
import org.apache.flink.table.descriptors.Elasticsearch
import org.apache.flink.table.descriptors._
import org.apache.flink.table.factories.SerializationFormatFactory
import org.apache.flink.formats.json
import org.apache.flink.table.functions.AggregateFunction
import org.apache.flink.types.ListValue
import scala.collection.mutable
On Sun, Oct 25, 2020 at 6:09 PM Rex Fenley <r...@remind101.com> wrote:
> Hello,
>
> I'm trying to create an Accumulator that takes in 2 columns, where each
> "value" is therefore a tuple, and results in a tuple of 2 arrays yet no
> matter what I try I receive an error trace like the one below.
>
> (Oddly, using almost the same pattern with 1 input column (a Long for
> "value") and 1 Array of Longs result/output works perfectly fine, so I'm
> not sure why suddenly using a Tuple should make much of any difference.)
>
> please help.
>
> Error trace:
>
> org.apache.flink.client.program.ProgramInvocationException: The main
> method caused an error: Given parameters do not match any signature.
>
>
> *Actual: (java.lang.Long, java.lang.Boolean) Expected: (scala.Tuple2) *at
> org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:302)
> at
> org.apache.flink.client.program.PackagedProgram.invokeInteractiveModeForExecution(PackagedProgram.java:198)
> at org.apache.flink.client.ClientUtils.executeProgram(ClientUtils.java:149)
> at
> org.apache.flink.client.cli.CliFrontend.executeProgram(CliFrontend.java:699)
> at org.apache.flink.client.cli.CliFrontend.run(CliFrontend.java:232)
> at
> org.apache.flink.client.cli.CliFrontend.parseParameters(CliFrontend.java:916)
> at
> org.apache.flink.client.cli.CliFrontend.lambda$main$10(CliFrontend.java:992)
> at
> org.apache.flink.runtime.security.contexts.NoOpSecurityContext.runSecured(NoOpSecurityContext.java:30)
> at org.apache.flink.client.cli.CliFrontend.main(CliFrontend.java:992)
> Caused by: org.apache.flink.table.api.ValidationException: Given
> parameters do not match any signature.
> Actual: (java.lang.Long, java.lang.Boolean)
> Expected: (scala.Tuple2)
> at
> org.apache.flink.table.planner.expressions.PlannerTypeInferenceUtilImpl.validateArguments(PlannerTypeInferenceUtilImpl.java:112)
> at
> org.apache.flink.table.planner.expressions.PlannerTypeInferenceUtilImpl.runTypeInference(PlannerTypeInferenceUtilImpl.java:71)
> at
> org.apache.flink.table.expressions.resolver.rules.ResolveCallByArgumentsRule$ResolvingCallVisitor.runLegacyTypeInference(ResolveCallByArgumentsRule.java:218)
> at
> org.apache.flink.table.expressions.resolver.rules.ResolveCallByArgumentsRule$ResolvingCallVisitor.lambda$visit$2(ResolveCallByArgumentsRule.java:134)
> at java.base/java.util.Optional.orElseGet(Optional.java:369)
> at
> org.apache.flink.table.expressions.resolver.rules.ResolveCallByArgumentsRule$ResolvingCallVisitor.visit(ResolveCallByArgumentsRule.java:134)
> at
> org.apache.flink.table.expressions.resolver.rules.ResolveCallByArgumentsRule$ResolvingCallVisitor.visit(ResolveCallByArgumentsRule.java:89)
> at
> org.apache.flink.table.expressions.ApiExpressionVisitor.visit(ApiExpressionVisitor.java:39)
> at
> org.apache.flink.table.expressions.UnresolvedCallExpression.accept(UnresolvedCallExpression.java:132)
> at
> org.apache.flink.table.expressions.resolver.rules.ResolveCallByArgumentsRule$ResolvingCallVisitor.visit(ResolveCallByArgumentsRule.java:124)
> at
> org.apache.flink.table.expressions.resolver.rules.ResolveCallByArgumentsRule$ResolvingCallVisitor.visit(ResolveCallByArgumentsRule.java:89)
> at
> org.apache.flink.table.expressions.ApiExpressionVisitor.visit(ApiExpressionVisitor.java:39)
> at
> org.apache.flink.table.expressions.UnresolvedCallExpression.accept(UnresolvedCallExpression.java:132)
> at
> org.apache.flink.table.expressions.resolver.rules.ResolveCallByArgumentsRule.lambda$apply$0(ResolveCallByArgumentsRule.java:83)
> at
> java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:271)
> at
> java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1655)
> at
> java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
> at
> java.base/java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:474)
> at
> java.base/java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:913)
> at
> java.base/java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
> at
> java.base/java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:578)
> at
> org.apache.flink.table.expressions.resolver.rules.ResolveCallByArgumentsRule.apply(ResolveCallByArgumentsRule.java:84)
> at
> org.apache.flink.table.expressions.resolver.ExpressionResolver.lambda$null$1(ExpressionResolver.java:211)
> at java.base/java.util.function.Function.lambda$andThen$1(Function.java:88)
> at
> org.apache.flink.table.expressions.resolver.ExpressionResolver.resolve(ExpressionResolver.java:178)
> at
> org.apache.flink.table.operations.utils.OperationTreeBuilder.aggregate(OperationTreeBuilder.java:237)
> at
> org.apache.flink.table.operations.utils.OperationTreeBuilder.aggregate(OperationTreeBuilder.java:528)
> at
> org.apache.flink.table.api.internal.TableImpl$AggregatedTableImpl.select(TableImpl.java:685)
> at remind.Job$.main(Job.scala:181)
> at remind.Job.main(Job.scala)
> at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at
> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at
> org.apache.flink.client.program.PackagedProgram.callMainMethod(PackagedProgram.java:288)
>
> This is my code:
>
> case class MembershipsIDsAcc(
> var subscriberIDs: mutable.Set[Long],
> var ownerIDs: mutable.Set[Long]
> )
> class MembershipsIDsAgg extends AggregateFunction[Row, MembershipsIDsAcc]
> {
>
> override def createAccumulator(): MembershipsIDsAcc =
> MembershipsIDsAcc(mutable.Set(), mutable.Set())
>
> def accumulate(acc: MembershipsIDsAcc, value: (Long, Boolean)): Unit = {
> acc.subscriberIDs.add(value._1)
> if (value._2) {
> acc.ownerIDs.add(value._1)
> } else {
> acc.ownerIDs.remove(value._1)
> }
> }
>
> def retract(acc: MembershipsIDsAcc, value: (Long, Boolean)): Unit = {
> acc.subscriberIDs.remove(value._1)
> acc.ownerIDs.remove(value._1)
> }
>
> def resetAccumulator(acc: MembershipsIDsAcc): Unit = {
> acc.subscriberIDs = mutable.Set()
> acc.ownerIDs = mutable.Set()
> }
>
> override def getValue(acc: MembershipsIDsAcc): Row = {
> Row.of(acc.subscriberIDs.toArray, acc.ownerIDs.toArray)
> }
>
> override def getResultType: TypeInformation[Row] = {
> new RowTypeInfo(
> createTypeInformation[Array[Long]],
> createTypeInformation[Array[Long]]
> )
> }
> }
>
> // Usage
> ...
> val membershipsByGroupId =
> membershipsNotDeletedTable
> .groupBy($"group_id")
> .aggregate(
> membershipsIDsAgg(
> $"user_id",
> $"owner"
> ) as ("subscriber_ids", "owner_ids")
> )
> .select($"group_id", $"subscriber_ids", $"owner_ids")
> ...
>
> --
>
> Rex Fenley | Software Engineer - Mobile and Backend
>
>
> Remind.com <https://www.remind.com/> | BLOG <http://blog.remind.com/> |
> FOLLOW US <https://twitter.com/remindhq> | LIKE US
> <https://www.facebook.com/remindhq>
>
--
Rex Fenley | Software Engineer - Mobile and Backend
Remind.com <https://www.remind.com/> | BLOG <http://blog.remind.com/>
| FOLLOW
US <https://twitter.com/remindhq> | LIKE US
<https://www.facebook.com/remindhq>
