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 16:16:50 UTC
[jira] Created: (HADOOP-2003) The boolean expression can be added
to the where clause of select statement
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
Reporter: Edward Yoon
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (HADOOP-2003) The boolean expression
can be added to the where clause of select statement
Posted by "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:20 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}
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}
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 rows in a relation that satisfy a selection condition (yet, by only iterator series-based process)
> 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.
[jira] Assigned: (HADOOP-2003) The boolean expression can be added
to the where clause of select statement
Posted by "Jim Kellerman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jim Kellerman reassigned HADOOP-2003:
-------------------------------------
Assignee: Edward Yoon
> 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
> Assignee: 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 '<', '<=', '>', '>=', '!=', '='
> * 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.
[jira] Updated: (HADOOP-2003) The boolean expression can be added
to the where clause of select statement
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (HADOOP-2003) The boolean expression can be added
to the where clause of select statement
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2003:
--------------------------------
Description:
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 '<', '<=', '>', '>=', '!=', '='
* clauses can be arbitrarily connected with boolean operators AND, OR, NOT
was:
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
description update.
> 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 '<', '<=', '>', '>=', '!=', '='
> * 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.
[jira] Issue Comment Edited: (HADOOP-2003) The boolean expression
can be added to the where clause of select statement
Posted by "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/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.
[jira] Updated: (HADOOP-2003) The boolean expression can be added
to the where clause of select statement
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2003:
--------------------------------
Description:
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
was:
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 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
> 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.
[jira] Issue Comment Edited: (HADOOP-2003) The boolean expression
can be added to the where clause of select statement
Posted by "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/7/07 9:35 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 table where length > 100 and length not in ('108', 'Fox');
{code}
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 movieLog_table where length > 100 and studioName = '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.
[jira] Updated: (HADOOP-2003) The boolean expression can be added
to the where clause of select statement
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2003:
--------------------------------
Description:
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 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
was:
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
> 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 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.
[jira] Updated: (HADOOP-2003) The boolean expression can be added
to the where clause of select statement
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2003?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2003:
--------------------------------
Description:
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
> 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.
[jira] Issue Comment Edited: (HADOOP-2003) The boolean expression
can be added to the where clause of select statement
Posted by "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.