Return-Path: 
 <hive-dev-return-1722-apmail-hadoop-hive-dev-archive=hadoop.apache.org@hadoop.apache.org>
Delivered-To: apmail-hadoop-hive-dev-archive@minotaur.apache.org
Received: (qmail 1052 invoked from network); 29 Jan 2009 02:39:28 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 29 Jan 2009 02:39:28 -0000
Received: (qmail 85081 invoked by uid 500); 29 Jan 2009 02:39:28 -0000
Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org
Received: (qmail 85059 invoked by uid 500); 29 Jan 2009 02:39:28 -0000
Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:hive-dev-help@hadoop.apache.org>
List-Unsubscribe: <mailto:hive-dev-unsubscribe@hadoop.apache.org>
List-Post: <mailto:hive-dev@hadoop.apache.org>
List-Id: <hive-dev.hadoop.apache.org>
Reply-To: hive-dev@hadoop.apache.org
Delivered-To: mailing list hive-dev@hadoop.apache.org
Received: (qmail 85048 invoked by uid 99); 29 Jan 2009 02:39:28 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Jan 2009 18:39:28 -0800
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2009 02:39:20 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id DB6E1234C498
	for <hive-dev@hadoop.apache.org>; Wed, 28 Jan 2009 18:38:59 -0800 (PST)
Message-ID: <1057869699.1233196739897.JavaMail.jira@brutus>
Date: Wed, 28 Jan 2009 18:38:59 -0800 (PST)
From: "Zheng Shao (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Subject: [jira] Updated: (HIVE-164) Support CASE and IF statement
In-Reply-To: <918402023.1228977704250.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/HIVE-164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zheng Shao updated HIVE-164:
----------------------------

    Attachment: HIVE-164.1.patch

This simple patch provides "IF".
The majority of the cases are that users just want a simple "IF". This patch provides this simple functionality.

For "CASE" with variable number of arguments, let's move the discussion to a new jira.




> Support CASE and IF statement
> -----------------------------
>
>                 Key: HIVE-164
>                 URL: https://issues.apache.org/jira/browse/HIVE-164
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Zheng Shao
>            Assignee: David Phillips
>         Attachments: HIVE-164.1.patch
>
>
> See http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html for details.
> Syntax:
> {code}
> CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [<ELSE result] END
> CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END 
> IF(expr1,expr2,expr3)
> {code}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.