Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 8F1A6200BC1 for ; Wed, 16 Nov 2016 23:50:55 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 8E629160B02; Wed, 16 Nov 2016 22:50:55 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 8823F160B22 for ; Wed, 16 Nov 2016 23:50:54 +0100 (CET) Received: (qmail 20465 invoked by uid 500); 16 Nov 2016 22:50:53 -0000 Mailing-List: contact issues-help@flink.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@flink.apache.org Delivered-To: mailing list issues@flink.apache.org Received: (qmail 20293 invoked by uid 99); 16 Nov 2016 22:50:53 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Nov 2016 22:50:53 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 2419DC0AF5 for ; Wed, 16 Nov 2016 22:50:53 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -7.019 X-Spam-Level: X-Spam-Status: No, score=-7.019 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id E9FgUxte9Zr1 for ; Wed, 16 Nov 2016 22:50:52 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with SMTP id 66F9D5FDF1 for ; Wed, 16 Nov 2016 22:50:51 +0000 (UTC) Received: (qmail 9021 invoked by uid 99); 16 Nov 2016 22:49:35 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Nov 2016 22:49:35 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 55DEAF1785; Wed, 16 Nov 2016 22:49:35 +0000 (UTC) From: fhueske To: issues@flink.incubator.apache.org Reply-To: issues@flink.incubator.apache.org References: In-Reply-To: Subject: [GitHub] flink pull request #2653: [FLINK-4469] [table] Add support for user defined ... Content-Type: text/plain Message-Id: <20161116224935.55DEAF1785@git1-us-west.apache.org> Date: Wed, 16 Nov 2016 22:49:35 +0000 (UTC) archived-at: Wed, 16 Nov 2016 22:50:55 -0000 Github user fhueske commented on a diff in the pull request: https://github.com/apache/flink/pull/2653#discussion_r88346802 --- Diff: flink-libraries/flink-table/src/main/scala/org/apache/flink/api/table/validate/FunctionCatalog.scala --- @@ -47,13 +52,50 @@ class FunctionCatalog { sqlFunctions += sqlFunction } + /** Register multiple sql functions at one time. The functions has the same name. **/ + def registerSqlFunctions(functions: Seq[SqlFunction]): Unit = { + if (functions.nonEmpty) { + sqlFunctions --= sqlFunctions.filter(_.getName == functions.head.getName) + sqlFunctions ++= functions + } + } + def getSqlOperatorTable: SqlOperatorTable = ChainedSqlOperatorTable.of( new BasicOperatorTable(), new ListSqlOperatorTable(sqlFunctions) ) /** + * Lookup table function and create an TableFunctionCall if we find a match. + */ + def lookupTableFunction[T](name: String, children: Seq[Expression]): TableFunctionCall[T] = { + val funcClass = functionBuilders + .getOrElse(name.toLowerCase, throw ValidationException(s"Undefined function: $name")) + funcClass match { + // user-defined table function call + case tf if classOf[TableFunction[T]].isAssignableFrom(tf) => + Try(UserDefinedFunctionUtils.instantiate(tf.asInstanceOf[Class[TableFunction[T]]])) match { + case Success(tableFunction) => { + val clazz: Type = tableFunction.getClass.getGenericSuperclass + val generic = clazz match { + case cls: ParameterizedType => cls.getActualTypeArguments.toSeq.head + case _ => throw new TableException( + "New TableFunction classes need to inherit from TableFunction class," + + " and statement the generic type.") + } + implicit val typeInfo: TypeInformation[T] = TypeExtractor.createTypeInfo(generic) + .asInstanceOf[TypeInformation[T]] + TableFunctionCall(tableFunction, children, None) + } + case Failure(e) => throw ValidationException(e.getMessage) + } + case _ => + throw ValidationException("Unsupported table function.") --- End diff -- I think this exception message could be improved. It is throw if the registered method does not implement the `TableFunction` interface. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is enabled but not working, please contact infrastructure at infrastructure@apache.org or file a JIRA ticket with INFRA. ---