From issues-return-2229-archive-asf-public=cust-asf.ponee.io@hivemall.incubator.apache.org Thu Apr 5 13:20:14 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 1AB3C18064F for ; Thu, 5 Apr 2018 13:20:13 +0200 (CEST) Received: (qmail 12474 invoked by uid 500); 5 Apr 2018 11:20:13 -0000 Mailing-List: contact issues-help@hivemall.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hivemall.incubator.apache.org Delivered-To: mailing list issues@hivemall.incubator.apache.org Received: (qmail 12465 invoked by uid 99); 5 Apr 2018 11:20:13 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 05 Apr 2018 11:20:13 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id BE295C1BC1 for ; Thu, 5 Apr 2018 11:20:12 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -4.011 X-Spam-Level: X-Spam-Status: No, score=-4.011 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H2=-0.001, T_RP_MATCHES_RCVD=-0.01] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id RJkOJmlU5S06 for ; Thu, 5 Apr 2018 11:20:10 +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 E35695F1D5 for ; Thu, 5 Apr 2018 11:20:09 +0000 (UTC) Received: (qmail 11718 invoked by uid 99); 5 Apr 2018 11:20:09 -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; Thu, 05 Apr 2018 11:20:09 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 0CBF8F4DC0; Thu, 5 Apr 2018 11:20:09 +0000 (UTC) From: myui To: issues@hivemall.incubator.apache.org Reply-To: issues@hivemall.incubator.apache.org References: In-Reply-To: Subject: [GitHub] incubator-hivemall issue #135: [WIP] Merge Brickhouse functions Content-Type: text/plain Message-Id: <20180405112009.0CBF8F4DC0@git1-us-west.apache.org> Date: Thu, 5 Apr 2018 11:20:09 +0000 (UTC) Github user myui commented on the issue: https://github.com/apache/incubator-hivemall/pull/135 ```sql create temporary function array_slice as 'hivemall.tools.array.ArraySliceUDF'; select array_slice( array("zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten"), 0, -- offset 2 -- length ), array_slice( array("zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten"), 6, -- offset 3 -- length ), array_slice( array("zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten"), 6, -- offset 10 -- length ), array_slice( array("zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten"), 6 -- offset ), array_slice( array("zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten"), -3 -- offset ), array_slice( array("zero", "one", "two", "three", "four", "five", "six", "seven", "eight", "nine", "ten"), -3, -- offset 2 -- length ); ``` > ["zero","one"] ["six","seven","eight"] ["six","seven","eight","nine","ten"] ["six","seven","eight","nine","ten"] ["eight","nine","ten"] ["eight","nine"] ---