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 2010/04/12 20:29:49 UTC

[jira] Created: (HIVE-1300) support: alter table refresh partition

support: alter table refresh partition
--------------------------------------

                 Key: HIVE-1300
                 URL: https://issues.apache.org/jira/browse/HIVE-1300
             Project: Hadoop Hive
          Issue Type: Improvement
          Components: Query Processor
            Reporter: Namit Jain
            Assignee: Paul Yang
             Fix For: 0.6.0


In some cases, the user wants to touch a partition, since some other operations might be performed on the hdfs directories.
Currently, there is no way to do that.


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (HIVE-1300) support: alter table refresh partition

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

Namit Jain commented on HIVE-1300:
----------------------------------

+1

will commit if the tests pass and Paul verifies that TOUCH can be converted into a reserved keyword

> support: alter table refresh partition
> --------------------------------------
>
>                 Key: HIVE-1300
>                 URL: https://issues.apache.org/jira/browse/HIVE-1300
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Paul Yang
>             Fix For: 0.6.0
>
>         Attachments: HIVE-1300.1.patch, HIVE-1300.2.patch
>
>
> In some cases, the user wants to touch a partition, since some other operations might be performed on the hdfs directories.
> Currently, there is no way to do that.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (HIVE-1300) support: alter table refresh partition

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

Paul Yang updated HIVE-1300:
----------------------------

    Attachment: HIVE-1300.1.patch

Preliminary patch. Added an ALTER ... UPDATE for partitions to force firing of the hooks but I think it should be added for non-partitioned tables as well.

> support: alter table refresh partition
> --------------------------------------
>
>                 Key: HIVE-1300
>                 URL: https://issues.apache.org/jira/browse/HIVE-1300
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Paul Yang
>             Fix For: 0.6.0
>
>         Attachments: HIVE-1300.1.patch
>
>
> In some cases, the user wants to touch a partition, since some other operations might be performed on the hdfs directories.
> Currently, there is no way to do that.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (HIVE-1300) support: alter table touch partition

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

John Sichi commented on HIVE-1300:
----------------------------------

Paul, could you update the wiki for this feature?

http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Alter_Table_Statements


> support: alter table touch partition
> ------------------------------------
>
>                 Key: HIVE-1300
>                 URL: https://issues.apache.org/jira/browse/HIVE-1300
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Paul Yang
>             Fix For: 0.6.0
>
>         Attachments: HIVE-1300.1.patch, HIVE-1300.2.patch
>
>
> In some cases, the user wants to touch a partition, since some other operations might be performed on the hdfs directories.
> Currently, there is no way to do that.

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


[jira] Resolved: (HIVE-1300) support: alter table touch partition

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

Namit Jain resolved HIVE-1300.
------------------------------

    Hadoop Flags: [Reviewed]
      Resolution: Fixed

Committed. Thanks Paul

> support: alter table touch partition
> ------------------------------------
>
>                 Key: HIVE-1300
>                 URL: https://issues.apache.org/jira/browse/HIVE-1300
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Paul Yang
>             Fix For: 0.6.0
>
>         Attachments: HIVE-1300.1.patch, HIVE-1300.2.patch
>
>
> In some cases, the user wants to touch a partition, since some other operations might be performed on the hdfs directories.
> Currently, there is no way to do that.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (HIVE-1300) support: alter table refresh partition

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

Paul Yang updated HIVE-1300:
----------------------------

    Attachment: HIVE-1300.2.patch

* Changed command name to touch, as it seemed more appropriate
* Added touch for non-partitioned tables
* Added negative tests

> support: alter table refresh partition
> --------------------------------------
>
>                 Key: HIVE-1300
>                 URL: https://issues.apache.org/jira/browse/HIVE-1300
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Paul Yang
>             Fix For: 0.6.0
>
>         Attachments: HIVE-1300.1.patch, HIVE-1300.2.patch
>
>
> In some cases, the user wants to touch a partition, since some other operations might be performed on the hdfs directories.
> Currently, there is no way to do that.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (HIVE-1300) support: alter table refresh partition

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

Namit Jain commented on HIVE-1300:
----------------------------------

Can you add a negative test also ? The partition does not exist.
Can you file a follow-up jira for the same functionality for a non-partitioned table ?

Also, can you confirm that no table internally is using 'UPDATE' as a column name.


> support: alter table refresh partition
> --------------------------------------
>
>                 Key: HIVE-1300
>                 URL: https://issues.apache.org/jira/browse/HIVE-1300
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Paul Yang
>             Fix For: 0.6.0
>
>         Attachments: HIVE-1300.1.patch
>
>
> In some cases, the user wants to touch a partition, since some other operations might be performed on the hdfs directories.
> Currently, there is no way to do that.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Updated: (HIVE-1300) support: alter table touch partition

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

Namit Jain updated HIVE-1300:
-----------------------------

    Summary: support: alter table touch partition  (was: support: alter table refresh partition)

> support: alter table touch partition
> ------------------------------------
>
>                 Key: HIVE-1300
>                 URL: https://issues.apache.org/jira/browse/HIVE-1300
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Paul Yang
>             Fix For: 0.6.0
>
>         Attachments: HIVE-1300.1.patch, HIVE-1300.2.patch
>
>
> In some cases, the user wants to touch a partition, since some other operations might be performed on the hdfs directories.
> Currently, there is no way to do that.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] Commented: (HIVE-1300) support: alter table touch partition

Posted by "Paul Yang (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1300?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12862861#action_12862861 ] 

Paul Yang commented on HIVE-1300:
---------------------------------

Wiki has been updated.

> support: alter table touch partition
> ------------------------------------
>
>                 Key: HIVE-1300
>                 URL: https://issues.apache.org/jira/browse/HIVE-1300
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Paul Yang
>             Fix For: 0.6.0
>
>         Attachments: HIVE-1300.1.patch, HIVE-1300.2.patch
>
>
> In some cases, the user wants to touch a partition, since some other operations might be performed on the hdfs directories.
> Currently, there is no way to do that.

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