You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-dev@hadoop.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2008/09/05 20:10:44 UTC

[jira] Updated: (HADOOP-4085) internationalization support and sort order (ascedning/descending) support in create table

     [ https://issues.apache.org/jira/browse/HADOOP-4085?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HADOOP-4085:
-------------------------------

    Attachment: patch1

The change fixes the mentioned problems. Tests have been added.
Can someone from Hive please comment on the changes ?

> internationalization support and sort order (ascedning/descending) support in create table
> ------------------------------------------------------------------------------------------
>
>                 Key: HADOOP-4085
>                 URL: https://issues.apache.org/jira/browse/HADOOP-4085
>             Project: Hadoop Core
>          Issue Type: Bug
>          Components: contrib/hive
>            Reporter: Namit Jain
>            Assignee: Namit Jain
>         Attachments: patch1
>
>
> User cannot specify utf8 strings in the query, both for selection and filtering. Mysql syntax should be followed: 
> select _utf8 'string' from <TableName>
> select <selectExpr> from <TableName> where col = _utf8 0x<HexValue>
> To start with, utf8 strings should be supported. Support for other character sets can be added in the future on demand.
> The identifiers (table name/column name etc.) cannot be utf8 strings, it is only for the data values.
> Although, in create table, the user has the option of specifying sorted columns, he does not have the option of specifying whether they are ascending or descending.
> Create Table syntax should be enhanced to support that.

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