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 "Edward Yoon (JIRA)" <ji...@apache.org> on 2007/10/06 17:29:50 UTC

[jira] Updated: (HADOOP-2003) The boolean expression can be added to the where clause of select statement

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

Edward Yoon updated HADOOP-2003:
--------------------------------

          Component/s: contrib/hbase
        Fix Version/s: 0.16.0
             Priority: Minor  (was: Major)
          Environment: All Environments
    Affects Version/s: 0.14.1

{code}
SELECT { column_name [, column_name] ... | * }
    FROM table_name
    [WHERE <boolean_expression>] 
    [STARTING FROM 'row-key']
    [NUM_VERSIONS = version_count]
    [TIMESTAMP 'timestamp']
    [LIMIT = row_count]
    [INTO FILE 'file_name']
{code}

select * from movieLog_table where length > 100 and studioName = 'Fox';

> The boolean expression can be added to the where clause of select statement
> ---------------------------------------------------------------------------
>
>                 Key: HADOOP-2003
>                 URL: https://issues.apache.org/jira/browse/HADOOP-2003
>             Project: Hadoop
>          Issue Type: Sub-task
>          Components: contrib/hbase
>    Affects Versions: 0.14.1
>         Environment: All Environments
>            Reporter: Edward Yoon
>            Priority: Minor
>             Fix For: 0.16.0
>
>


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