You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "He Yongqiang (JIRA)" <ji...@apache.org> on 2010/08/05 23:47:19 UTC

[jira] Created: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Be able to modify a partition's fileformat and file location information.
-------------------------------------------------------------------------

                 Key: HIVE-1514
                 URL: https://issues.apache.org/jira/browse/HIVE-1514
             Project: Hadoop Hive
          Issue Type: New Feature
            Reporter: He Yongqiang
            Assignee: He Yongqiang




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


[jira] Updated: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

He Yongqiang updated HIVE-1514:
-------------------------------

    Attachment: hive-1514.1.patch

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch
>
>


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


[jira] Updated: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

He Yongqiang updated HIVE-1514:
-------------------------------

    Status: Patch Available  (was: Open)

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch
>
>


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


[jira] Updated: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-1514:
-----------------------------

    Status: Open  (was: Patch Available)

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch, hive-1514.2.patch
>
>


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


[jira] Commented: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12898350#action_12898350 ] 

He Yongqiang commented on HIVE-1514:
------------------------------------

I updated the wiki page here :
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Alter_Table.2BAC8-Partition_Location

This only change the metadata. With this patch, you will be able to let the partition point to some external places, and use a new fileformat. If the metadata you specified is correct, you will be able to do that.

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch, hive-1514.2.patch, hive-1514.3.patch
>
>


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


[jira] Resolved: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain resolved HIVE-1514.
------------------------------

    Hadoop Flags: [Reviewed]
      Resolution: Fixed

Committed. Thanks Yongqiang

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch, hive-1514.2.patch, hive-1514.3.patch
>
>


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


[jira] Updated: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

He Yongqiang updated HIVE-1514:
-------------------------------

    Attachment: hive-1514.3.patch

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch, hive-1514.2.patch, hive-1514.3.patch
>
>


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


[jira] Commented: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "Ashutosh Chauhan (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12898337#action_12898337 ] 

Ashutosh Chauhan commented on HIVE-1514:
----------------------------------------

>From jira description and discussions, its not clear to me what changes went in here.
It will be useful to summarize the use case which this jira satisfies. From cursory look of the patch, it seems following is now possible to do
{code}
ALTER TABLE table_name [partitionSpec] SET LOCATION "new location" set fileformat rcfile
{code}
 or some such. If so, is the use case the following: user created some data for a existing hive table externally (meaning through some process outside of hive) and now wants to use it to query from hive. So, she needs to do metadata operation as above (which is now enabled through this patch) ?

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch, hive-1514.2.patch, hive-1514.3.patch
>
>


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


[jira] Commented: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12896777#action_12896777 ] 

Namit Jain commented on HIVE-1514:
----------------------------------

+        new String[] { "ALTERTABLE_FILEFORMAT", "ALTERPARTITION_FILEFORMAR" });


There is a spelling mistake - should be 
new String[] { "ALTERTABLE_FILEFORMAT", "ALTERPARTITION_FILEFORMAT" });


will result in changing a few log files.

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch, hive-1514.2.patch
>
>


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


[jira] Commented: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12896979#action_12896979 ] 

Namit Jain commented on HIVE-1514:
----------------------------------

+1

will commit if the tests pass

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch, hive-1514.2.patch, hive-1514.3.patch
>
>


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


[jira] Commented: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12898369#action_12898369 ] 

John Sichi commented on HIVE-1514:
----------------------------------

Yongqiang, for reference doc updates, remember to add a phrase like "(Note:  only available starting with 0.7.0)" so that users of earlier Hive versions know they need to upgrade if they want the feature.

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch, hive-1514.2.patch, hive-1514.3.patch
>
>


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


[jira] Updated: (HIVE-1514) Be able to modify a partition's fileformat and file location information.

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

He Yongqiang updated HIVE-1514:
-------------------------------

    Attachment: hive-1514.2.patch

> Be able to modify a partition's fileformat and file location information.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-1514
>                 URL: https://issues.apache.org/jira/browse/HIVE-1514
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: He Yongqiang
>            Assignee: He Yongqiang
>         Attachments: hive-1514.1.patch, hive-1514.2.patch
>
>


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