Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@minotaur.apache.org Received: (qmail 55739 invoked from network); 3 Jun 2010 02:10:14 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 3 Jun 2010 02:10:14 -0000 Received: (qmail 61531 invoked by uid 500); 3 Jun 2010 02:10:14 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 61513 invoked by uid 500); 3 Jun 2010 02:10:14 -0000 Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hadoop.apache.org Delivered-To: mailing list hive-dev@hadoop.apache.org Received: (qmail 61505 invoked by uid 99); 3 Jun 2010 02:10:14 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Jun 2010 02:10:14 +0000 X-ASF-Spam-Status: No, hits=-1492.4 required=10.0 tests=ALL_TRUSTED,AWL X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Jun 2010 02:10:14 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id o5329sl4017843 for ; Thu, 3 Jun 2010 02:09:54 GMT Message-ID: <405355.150221275530994008.JavaMail.jira@thor> Date: Wed, 2 Jun 2010 22:09:54 -0400 (EDT) From: "John Sichi (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Commented: (HIVE-1385) UDF field() doesn't work In-Reply-To: <20346752.150141275530396980.JavaMail.jira@thor> 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-1385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12874915#action_12874915 ] John Sichi commented on HIVE-1385: ---------------------------------- I think the bug is with usage of Object.equals for the comparison. Doing a toString on both sides first seems like a reasonable fix given the current spec for the function, or we could do whatever Paul did for IN. > UDF field() doesn't work > ------------------------ > > Key: HIVE-1385 > URL: https://issues.apache.org/jira/browse/HIVE-1385 > Project: Hadoop Hive > Issue Type: Bug > Components: Query Processor > Affects Versions: 0.5.0 > Reporter: Siying Dong > Priority: Minor > Fix For: 0.6.0 > > > I tried it against one of my table: > hive> desc r; > OK > key int > value string > a string > hive> select * from r; > OK > 4 val_356 NULL > 4 val_356 NULL > 484 val_169 NULL > 484 val_169 NULL > 2000 val_169 NULL > 2000 val_169 NULL > 3000 val_169 NULL > 3000 val_169 NULL > 4000 val_125 NULL > 4000 val_125 NULL > hive> select *, field(value, 'val_169') from r; > OK > 4 val_356 NULL 0 > 4 val_356 NULL 0 > 484 val_169 NULL 0 > 484 val_169 NULL 0 > 2000 val_169 NULL 0 > 2000 val_169 NULL 0 > 3000 val_169 NULL 0 > 3000 val_169 NULL 0 > 4000 val_125 NULL 0 > 4000 val_125 NULL 0 -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.