You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Min Zhou (JIRA)" <ji...@apache.org> on 2009/09/04 04:04:57 UTC
[jira] Created: (HIVE-814) exception alter a int typed column to
date/datetime/timestamp
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.
[jira] Resolved: (HIVE-814) exception alter a int typed column to
date/datetime/timestamp
Posted by "Paul Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Yang resolved HIVE-814.
----------------------------
Resolution: Fixed
Fix Version/s: 0.6.0
0.5.0
Release Note: Addressed by HIVE-1059
> 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
> Fix For: 0.5.0, 0.6.0
>
>
> 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.
[jira] Reopened: (HIVE-814) exception alter a int typed column to
date/datetime/timestamp
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-814?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach reopened HIVE-814:
---------------------------------
> 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.
[jira] Resolved: (HIVE-814) exception alter a int typed column to
date/datetime/timestamp
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (HIVE-814) exception alter a int typed column to
date/datetime/timestamp
Posted by "Paul Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-814?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12805630#action_12805630 ]
Paul Yang commented on HIVE-814:
--------------------------------
Currently, hive does not yet support date, datetime, timestamp types. See: https://issues.apache.org/jira/browse/HIVE-1059
> 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.