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

["Edward Yoon (JIRA)" <ji...@apache.org>]

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

udanax edited comment on HADOOP-2003 at 10/6/07 6:08 PM:
--------------------------------------------------------------

{code}
SELECT { column_name [, column_name] ... | * }
    FROM table_name
    [WHERE selection_condition] 
    [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';

      was (Author: udanax):
    {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
>
>
> selects a subset of the tuples in a relation that satisfy a selection condition 
> Result = σ (selection condition)(relation name)
> a boolean expression specified on the attributes of a specified relation 
> a relation that has the same attributes as the source relation; 
>  * stands for the usual comparison operators '<', '<>', '<=', '>', '>=', etc 
>  * clauses can be arbitrarily connected with boolean operators AND, OR, NOT

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