Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E1C9511234 for ; Mon, 30 Jun 2014 08:42:24 +0000 (UTC) Received: (qmail 11730 invoked by uid 500); 30 Jun 2014 08:42:24 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 11665 invoked by uid 500); 30 Jun 2014 08:42:24 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 11652 invoked by uid 500); 30 Jun 2014 08:42:24 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 11645 invoked by uid 99); 30 Jun 2014 08:42:24 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Jun 2014 08:42:24 +0000 Date: Mon, 30 Jun 2014 08:42:24 +0000 (UTC) From: "dima machlin (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HIVE-7314) Wrong results of UDF when hive.cache.expr.evaluation is set MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-7314?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] dima machlin updated HIVE-7314: ------------------------------- Description: It seems that the expression caching doesn't work when using UDF inside another UDF or a hive function. For example : tbl has one row : 'a','b' The following query : {code:sql} select concat(custUDF(a),' ', custUDF(b)) from tbl; {code} returns 'a a' seems to cache custUDF(a) and use it for custUDF(b). Same query without the concat works fine. Replacing the concat with another custom UDF also returns 'a a' was: It seems that the expression caching doesn't work when using UDF inside another UDF or a hive function. For example : tbl has one row : 'a','b' The following query : select concat(custUDF(a),' ', custUDF(b)) from tbl; returns 'a a' seems to cache custUDF(a) and use it for custUDF(b). Same query without the concat works fine. Replacing the concat with another custom UDF also returns 'a a' > Wrong results of UDF when hive.cache.expr.evaluation is set > ----------------------------------------------------------- > > Key: HIVE-7314 > URL: https://issues.apache.org/jira/browse/HIVE-7314 > Project: Hive > Issue Type: Bug > Affects Versions: 0.12.0 > Reporter: dima machlin > > It seems that the expression caching doesn't work when using UDF inside another UDF or a hive function. > For example : > tbl has one row : 'a','b' > The following query : > {code:sql} select concat(custUDF(a),' ', custUDF(b)) from tbl; {code} > returns 'a a' > seems to cache custUDF(a) and use it for custUDF(b). > Same query without the concat works fine. > Replacing the concat with another custom UDF also returns 'a a' -- This message was sent by Atlassian JIRA (v6.2#6252)