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

[Edward Yoon (JIRA)]

    [ 
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/7/07 9:36 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}

Result = σ ~length>100, studioName = 'Fox'~ (movieLog_table)

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

NOT IN ();
select * from table where length > 100 and length not in ('108', 'Fox');

      was (Author: udanax):
    {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}

Result = σ ~length>100, studioName = 'Fox'~ (movieLog_table)

{code}
select * from table where length > 100 and length not in ('108', 'Fox');
{code}
  
> 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 rows in a relation that satisfy a selection condition 
> (yet, by only iterator series-based process)
> Result = σ ~selection_condition~ (Relation)
> 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.