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/05/20 01:03:53 UTC

[jira] Created: (HIVE-1354) partition level properties honored if it exists

partition level properties honored if it exists
-----------------------------------------------

                 Key: HIVE-1354
                 URL: https://issues.apache.org/jira/browse/HIVE-1354
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: Namit Jain


drop table partition_test_partitioned;

create table partition_test_partitioned(key string, value string) partitioned by (dt string);

alter table partition_test_partitioned set fileformat rcfile;
insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
show table extended like partition_test_partitioned partition(dt=101);

alter table partition_test_partitioned set fileformat Sequencefile;
insert overwrite table partition_test_partitioned partition(dt=102) select * from src1;
show table extended like partition_test_partitioned partition(dt=102);

insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
show table extended like partition_test_partitioned partition(dt=101);

drop table partition_test_partitioned;


Partition (dt=101) still points to RCFile, since it was created as a RCFile

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


[jira] Assigned: (HIVE-1354) partition level properties honored if it exists

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

Namit Jain reassigned HIVE-1354:
--------------------------------

    Assignee: Namit Jain

> partition level properties honored if it exists
> -----------------------------------------------
>
>                 Key: HIVE-1354
>                 URL: https://issues.apache.org/jira/browse/HIVE-1354
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.1354.1.patch
>
>
> drop table partition_test_partitioned;
> create table partition_test_partitioned(key string, value string) partitioned by (dt string);
> alter table partition_test_partitioned set fileformat rcfile;
> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
> show table extended like partition_test_partitioned partition(dt=101);
> alter table partition_test_partitioned set fileformat Sequencefile;
> insert overwrite table partition_test_partitioned partition(dt=102) select * from src1;
> show table extended like partition_test_partitioned partition(dt=102);
> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
> show table extended like partition_test_partitioned partition(dt=101);
> drop table partition_test_partitioned;
> Partition (dt=101) still points to RCFile, since it was created as a RCFile

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


[jira] Updated: (HIVE-1354) partition level properties honored if it exists

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

Namit Jain updated HIVE-1354:
-----------------------------

          Status: Patch Available  (was: Open)
    Hadoop Flags: [Reviewed]

> partition level properties honored if it exists
> -----------------------------------------------
>
>                 Key: HIVE-1354
>                 URL: https://issues.apache.org/jira/browse/HIVE-1354
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.1354.1.patch
>
>
> drop table partition_test_partitioned;
> create table partition_test_partitioned(key string, value string) partitioned by (dt string);
> alter table partition_test_partitioned set fileformat rcfile;
> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
> show table extended like partition_test_partitioned partition(dt=101);
> alter table partition_test_partitioned set fileformat Sequencefile;
> insert overwrite table partition_test_partitioned partition(dt=102) select * from src1;
> show table extended like partition_test_partitioned partition(dt=102);
> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
> show table extended like partition_test_partitioned partition(dt=101);
> drop table partition_test_partitioned;
> Partition (dt=101) still points to RCFile, since it was created as a RCFile

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


[jira] Updated: (HIVE-1354) partition level properties honored if it exists

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

He Yongqiang updated HIVE-1354:
-------------------------------

        Status: Resolved  (was: Patch Available)
    Resolution: Fixed

I just committed. Thanks Namit!

> partition level properties honored if it exists
> -----------------------------------------------
>
>                 Key: HIVE-1354
>                 URL: https://issues.apache.org/jira/browse/HIVE-1354
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.1354.1.patch
>
>
> drop table partition_test_partitioned;
> create table partition_test_partitioned(key string, value string) partitioned by (dt string);
> alter table partition_test_partitioned set fileformat rcfile;
> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
> show table extended like partition_test_partitioned partition(dt=101);
> alter table partition_test_partitioned set fileformat Sequencefile;
> insert overwrite table partition_test_partitioned partition(dt=102) select * from src1;
> show table extended like partition_test_partitioned partition(dt=102);
> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
> show table extended like partition_test_partitioned partition(dt=101);
> drop table partition_test_partitioned;
> Partition (dt=101) still points to RCFile, since it was created as a RCFile

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


[jira] Updated: (HIVE-1354) partition level properties honored if it exists

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

Carl Steinbach updated HIVE-1354:
---------------------------------

    Fix Version/s: 0.6.0

> partition level properties honored if it exists
> -----------------------------------------------
>
>                 Key: HIVE-1354
>                 URL: https://issues.apache.org/jira/browse/HIVE-1354
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>             Fix For: 0.6.0
>
>         Attachments: hive.1354.1.patch
>
>
> drop table partition_test_partitioned;
> create table partition_test_partitioned(key string, value string) partitioned by (dt string);
> alter table partition_test_partitioned set fileformat rcfile;
> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
> show table extended like partition_test_partitioned partition(dt=101);
> alter table partition_test_partitioned set fileformat Sequencefile;
> insert overwrite table partition_test_partitioned partition(dt=102) select * from src1;
> show table extended like partition_test_partitioned partition(dt=102);
> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
> show table extended like partition_test_partitioned partition(dt=101);
> drop table partition_test_partitioned;
> Partition (dt=101) still points to RCFile, since it was created as a RCFile

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


[jira] Updated: (HIVE-1354) partition level properties honored if it exists

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

Namit Jain updated HIVE-1354:
-----------------------------

    Attachment: hive.1354.1.patch

> partition level properties honored if it exists
> -----------------------------------------------
>
>                 Key: HIVE-1354
>                 URL: https://issues.apache.org/jira/browse/HIVE-1354
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: hive.1354.1.patch
>
>
> drop table partition_test_partitioned;
> create table partition_test_partitioned(key string, value string) partitioned by (dt string);
> alter table partition_test_partitioned set fileformat rcfile;
> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
> show table extended like partition_test_partitioned partition(dt=101);
> alter table partition_test_partitioned set fileformat Sequencefile;
> insert overwrite table partition_test_partitioned partition(dt=102) select * from src1;
> show table extended like partition_test_partitioned partition(dt=102);
> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
> show table extended like partition_test_partitioned partition(dt=101);
> drop table partition_test_partitioned;
> Partition (dt=101) still points to RCFile, since it was created as a RCFile

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