You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Paul Yang (JIRA)" <ji...@apache.org> on 2010/03/25 00:53:27 UTC

[jira] Created: (HIVE-1281) Bucketing column names in create table should be case-insensitive

Bucketing column names in create table should be case-insensitive
-----------------------------------------------------------------

                 Key: HIVE-1281
                 URL: https://issues.apache.org/jira/browse/HIVE-1281
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 0.6.0
            Reporter: Paul Yang
            Priority: Minor


This create table fails because 'userId' != 'userid'

{code}
CREATE TABLE tmp_pyang_bucket3 (userId INT) CLUSTERED BY (userid) INTO 32 BUCKETS;
{code}

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


[jira] Assigned: (HIVE-1281) Bucketing column names in create table should be case-insensitive

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

He Yongqiang reassigned HIVE-1281:
----------------------------------

    Assignee: He Yongqiang

> Bucketing column names in create table should be case-insensitive
> -----------------------------------------------------------------
>
>                 Key: HIVE-1281
>                 URL: https://issues.apache.org/jira/browse/HIVE-1281
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.6.0
>            Reporter: Paul Yang
>            Assignee: He Yongqiang
>            Priority: Minor
>
> This create table fails because 'userId' != 'userid'
> {code}
> CREATE TABLE tmp_pyang_bucket3 (userId INT) CLUSTERED BY (userid) INTO 32 BUCKETS;
> {code}

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


[jira] Updated: (HIVE-1281) Bucketing column names in create table should be case-insensitive

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

He Yongqiang updated HIVE-1281:
-------------------------------

    Status: Patch Available  (was: Open)

> Bucketing column names in create table should be case-insensitive
> -----------------------------------------------------------------
>
>                 Key: HIVE-1281
>                 URL: https://issues.apache.org/jira/browse/HIVE-1281
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.6.0
>            Reporter: Paul Yang
>            Assignee: He Yongqiang
>            Priority: Minor
>         Attachments: hive-1281.1.patch
>
>
> This create table fails because 'userId' != 'userid'
> {code}
> CREATE TABLE tmp_pyang_bucket3 (userId INT) CLUSTERED BY (userid) INTO 32 BUCKETS;
> {code}

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


[jira] Updated: (HIVE-1281) Bucketing column names in create table should be case-insensitive

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

Carl Steinbach updated HIVE-1281:
---------------------------------

        Fix Version/s: 0.6.0
    Affects Version/s: 0.5.0
                           (was: 0.6.0)

> Bucketing column names in create table should be case-insensitive
> -----------------------------------------------------------------
>
>                 Key: HIVE-1281
>                 URL: https://issues.apache.org/jira/browse/HIVE-1281
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.5.0
>            Reporter: Paul Yang
>            Assignee: He Yongqiang
>            Priority: Minor
>             Fix For: 0.6.0
>
>         Attachments: hive-1281.1.patch
>
>
> This create table fails because 'userId' != 'userid'
> {code}
> CREATE TABLE tmp_pyang_bucket3 (userId INT) CLUSTERED BY (userid) INTO 32 BUCKETS;
> {code}

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


[jira] Updated: (HIVE-1281) Bucketing column names in create table should be case-insensitive

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

He Yongqiang updated HIVE-1281:
-------------------------------

    Attachment: hive-1281.1.patch

This patch will use lower case for names of "sort columns"/ "bucket columns"/"sort columns" create table.
partition columns can not be case-insensitive because the hdfs is case sensitive.

> Bucketing column names in create table should be case-insensitive
> -----------------------------------------------------------------
>
>                 Key: HIVE-1281
>                 URL: https://issues.apache.org/jira/browse/HIVE-1281
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.6.0
>            Reporter: Paul Yang
>            Assignee: He Yongqiang
>            Priority: Minor
>         Attachments: hive-1281.1.patch
>
>
> This create table fails because 'userId' != 'userid'
> {code}
> CREATE TABLE tmp_pyang_bucket3 (userId INT) CLUSTERED BY (userid) INTO 32 BUCKETS;
> {code}

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


[jira] Updated: (HIVE-1281) Bucketing column names in create table should be case-insensitive

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

Namit Jain updated HIVE-1281:
-----------------------------

      Resolution: Fixed
    Hadoop Flags: [Reviewed]
          Status: Resolved  (was: Patch Available)

Committed. Thanks Yongqiang

> Bucketing column names in create table should be case-insensitive
> -----------------------------------------------------------------
>
>                 Key: HIVE-1281
>                 URL: https://issues.apache.org/jira/browse/HIVE-1281
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.6.0
>            Reporter: Paul Yang
>            Assignee: He Yongqiang
>            Priority: Minor
>         Attachments: hive-1281.1.patch
>
>
> This create table fails because 'userId' != 'userid'
> {code}
> CREATE TABLE tmp_pyang_bucket3 (userId INT) CLUSTERED BY (userid) INTO 32 BUCKETS;
> {code}

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


[jira] Commented: (HIVE-1281) Bucketing column names in create table should be case-insensitive

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

Namit Jain commented on HIVE-1281:
----------------------------------

+1

looks good - will commit if the tests pass

> Bucketing column names in create table should be case-insensitive
> -----------------------------------------------------------------
>
>                 Key: HIVE-1281
>                 URL: https://issues.apache.org/jira/browse/HIVE-1281
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.6.0
>            Reporter: Paul Yang
>            Assignee: He Yongqiang
>            Priority: Minor
>         Attachments: hive-1281.1.patch
>
>
> This create table fails because 'userId' != 'userid'
> {code}
> CREATE TABLE tmp_pyang_bucket3 (userId INT) CLUSTERED BY (userid) INTO 32 BUCKETS;
> {code}

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