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 28671200B48 for ; Mon, 18 Jul 2016 17:46:37 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 270B2160A65; Mon, 18 Jul 2016 15:46:37 +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 700C6160A5D for ; Mon, 18 Jul 2016 17:46:36 +0200 (CEST) Received: (qmail 1087 invoked by uid 500); 18 Jul 2016 15:46:35 -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 1078 invoked by uid 99); 18 Jul 2016 15:46:35 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 18 Jul 2016 15:46:35 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 21BBE1A7E69 for ; Mon, 18 Jul 2016 15:46:35 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -5.446 X-Spam-Level: X-Spam-Status: No, score=-5.446 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=-1.426] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id gvwwTBLdBcEo for ; Mon, 18 Jul 2016 15:46:34 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with SMTP id 358715F1F3 for ; Mon, 18 Jul 2016 15:46:33 +0000 (UTC) Received: (qmail 1067 invoked by uid 99); 18 Jul 2016 15:46:32 -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; Mon, 18 Jul 2016 15:46:32 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 4C52ADFAF5; Mon, 18 Jul 2016 15:46:32 +0000 (UTC) From: twalthr To: issues@flink.incubator.apache.org Reply-To: issues@flink.incubator.apache.org Message-ID: Subject: [GitHub] flink pull request #2265: [FLINK-3097] [table] Add support for custom functi... Content-Type: text/plain Date: Mon, 18 Jul 2016 15:46:32 +0000 (UTC) archived-at: Mon, 18 Jul 2016 15:46:37 -0000 GitHub user twalthr opened a pull request: https://github.com/apache/flink/pull/2265 [FLINK-3097] [table] Add support for custom functions in Table API Thanks for contributing to Apache Flink. Before you open your pull request, please take the following check list into consideration. If your changes take all of the items into account, feel free to open your pull request. For more information and/or questions please refer to the [How To Contribute guide](http://flink.apache.org/how-to-contribute.html). In addition to going through the list, please provide a meaningful description of your changes. - [x] General - The pull request references the related JIRA issue ("[FLINK-XXX] Jira title text") - The pull request addresses only one issue - Each commit in the PR has a meaningful commit message (including the JIRA id) - [ ] Documentation - Documentation has been added for new functionality - Old documentation affected by the pull request has been updated - JavaDoc for public methods has been added - [x] Tests & Build - Functionality added by the pull request is covered by tests - `mvn clean verify` has been executed successfully locally or a Travis build has passed This PR introduces user-defined scalar functions for the Table and SQL API. I will add documentation soon, but this is the general syntax so far: In Java: ```java public class HashCode extends ScalarFunction { public int eval(String s) { return s.hashCode(); } } tableEnv.registerFunction("hashCode", new HashCode()); Table result = table.select("text.hashCode()"); Table result = tableEnv.sql("SELECT hashCode(text) FROM MyTable") ``` In Scala: ```scala object hashCode extends ScalarFunction { def eval(s: String): Int = { s.hashCode() } } val result = table.select(hashCode(text)); val result = tableEnv.sql("SELECT hashCode(text) FROM MyTable") ``` You can merge this pull request into a Git repository by running: $ git pull https://github.com/twalthr/flink FLINK-3097 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/flink/pull/2265.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #2265 ---- commit 3b792569bccea843646d8c88592e9c20ecf0ed37 Author: twalthr Date: 2016-07-12T10:22:41Z [FLINK-3097] [table] Add support for custom functions in Table API ---- --- 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. ---