You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2009/11/17 16:19:39 UTC
[jira] Created: (HIVE-938) dynamic partitions by altering table
dynamic partitions by altering table
------------------------------------
Key: HIVE-938
URL: https://issues.apache.org/jira/browse/HIVE-938
Project: Hadoop Hive
Issue Type: New Feature
Components: Query Processor
Reporter: Namit Jain
{ create table T(a int, b string, ds string); insert overwrite table T select * from S where ds >= '2009-11-1' and ds <= '2009-11-16'; alter table T partitioned by (ds); }
should make T partitioned by the unique values of ds
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-938) dynamic partitions by altering table
Posted by "Ning Zhang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12778941#action_12778941 ]
Ning Zhang commented on HIVE-938:
---------------------------------
@prasad, currently we don't allow changing partition keys in DDL. If we want to support that, we need a rebuild/repartitioning, eventually touching the data as well as the metadata.
> dynamic partitions by altering table
> ------------------------------------
>
> Key: HIVE-938
> URL: https://issues.apache.org/jira/browse/HIVE-938
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
>
> { create table T(a int, b string, ds string); insert overwrite table T select * from S where ds >= '2009-11-1' and ds <= '2009-11-16'; alter table T partitioned by (ds); }
> should make T partitioned by the unique values of ds
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-938) dynamic partitions by altering table
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12778939#action_12778939 ]
Namit Jain commented on HIVE-938:
---------------------------------
Prasad Chakka added a comment - 17/Nov/09 03:25 PM
@Namit: you can't change the partition keys of a table.
> dynamic partitions by altering table
> ------------------------------------
>
> Key: HIVE-938
> URL: https://issues.apache.org/jira/browse/HIVE-938
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
>
> { create table T(a int, b string, ds string); insert overwrite table T select * from S where ds >= '2009-11-1' and ds <= '2009-11-16'; alter table T partitioned by (ds); }
> should make T partitioned by the unique values of ds
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.