Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Message-ID: <13387660.14641287371964105.JavaMail.jira@thor>
Date: Sun, 17 Oct 2010 23:19:24 -0400 (EDT)
From: "Carl Steinbach (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Subject: [jira] Resolved: (HIVE-814) exception alter a int typed column to
 date/datetime/timestamp
In-Reply-To: <1265782046.1252029897466.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Carl Steinbach resolved HIVE-814.
---------------------------------

       Resolution: Won't Fix
    Fix Version/s:     (was: 0.6.0)
                       (was: 0.5.0)

> exception alter a int typed column to date/datetime/timestamp
> -------------------------------------------------------------
>
>                 Key: HIVE-814
>                 URL: https://issues.apache.org/jira/browse/HIVE-814
>             Project: Hadoop Hive
>          Issue Type: Bug
>            Reporter: Min Zhou
>
> As fas as i know, time types can only be used in partitions,  normal columns is not allowed to be set as those types . But it's found can alter a no time types column to date/datetime/timestamp,but exceptions will be throwed when describing.
> hive> create table pokes(foo int, bar string);
> OK
> Time taken: 0.894 seconds
> hive> alter table pokes replace columns(foo date, bar string);
> OK
> Time taken: 0.266 seconds
> hive> describe pokes;      
> FAILED: Error in metadata: MetaException(message:java.lang.IllegalArgumentException Error: type expected at the position 0 of 'date:string' but 'date' is found.)
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

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