List Info

Thread: Created: (HADOOP-2003) The boolean expression can be added to the where clause of select stat




Created: (HADOOP-2003) The boolean expression can be added to the where clause of select stat
country flaguser name
United States
2007-10-06 09:16:50
The boolean expression can be added to the where clause of
select statement
------------------------------------------------------------
---------------

                 Key: HADOOP-2003
                 URL: htt
ps://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.


Updated: (HADOOP-2003) The boolean expression can be added to the where clause of select stat
country flaguser name
United States
2007-10-06 10:29:50
     [ https://issues.apache.org/jira/browse/HADOOP-2003?page=co
m.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


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']


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: htt
ps://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.


Updated: (HADOOP-2003) The boolean expression can be added to the where clause of select stat
country flaguser name
United States
2007-10-06 20:07:50
     [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2003?PAGE=COM.A
TLASSIAN.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.


Issue Comment Edited: (HADOOP-2003) The boolean expression can be added to the where clause o
country flaguser name
United States
2007-10-06 20:09:50
    [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2003?PAGE=COM.A
TLASSIAN.JIRA.PLUGIN.SYSTEM.ISSUETABPANELS:COMMENT-TABPANEL#
ACTION_12532890 ] 

UDANAX EDITED COMMENT ON HADOOP-2003 AT 10/6/07 6:08 PM:
------------------------------------------------------------
--


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']


SELECT * FROM MOVIELOG_TABLE WHERE LENGTH > 100 AND
STUDIONAME = 'FOX';

      WAS (AUTHOR: UDANAX):
    
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']


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.


Updated: (HADOOP-2003) The boolean expression can be added to the where clause of select stat
country flaguser name
United States
2007-10-06 20:11:51
     [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2003?PAGE=COM.A
TLASSIAN.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.


Updated: (HADOOP-2003) The boolean expression can be added to the where clause of select stat
country flaguser name
United States
2007-10-06 20:21:50
     [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2003?PAGE=COM.A
TLASSIAN.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.


Issue Comment Edited: (HADOOP-2003) The boolean expression can be added to the where clause o
country flaguser name
United States
2007-10-06 20:21:50
    [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2003?PAGE=COM.A
TLASSIAN.JIRA.PLUGIN.SYSTEM.ISSUETABPANELS:COMMENT-TABPANEL#
ACTION_12532890 ] 

UDANAX EDITED COMMENT ON HADOOP-2003 AT 10/6/07 6:20 PM:
------------------------------------------------------------
--


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']


RESULT = ? ~LENGTH>100, STUDIONAME = 'FOX'~
(MOVIELOG_TABLE)


SELECT * FROM MOVIELOG_TABLE WHERE LENGTH > 100 AND
STUDIONAME = 'FOX';


      WAS (AUTHOR: UDANAX):
    
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']


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.


Issue Comment Edited: (HADOOP-2003) The boolean expression can be added to the where clause o
country flaguser name
United States
2007-10-07 23:35:50
    [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2003?PAGE=COM.A
TLASSIAN.JIRA.PLUGIN.SYSTEM.ISSUETABPANELS:COMMENT-TABPANEL#
ACTION_12532890 ] 

UDANAX EDITED COMMENT ON HADOOP-2003 AT 10/7/07 9:35 PM:
------------------------------------------------------------
--


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']


RESULT = ? ~LENGTH>100, STUDIONAME = 'FOX'~
(MOVIELOG_TABLE)


SELECT * FROM TABLE WHERE LENGTH > 100 AND LENGTH NOT IN
('108', 'FOX');


      WAS (AUTHOR: UDANAX):
    
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']


RESULT = ? ~LENGTH>100, STUDIONAME = 'FOX'~
(MOVIELOG_TABLE)


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)
> 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.


Issue Comment Edited: (HADOOP-2003) The boolean expression can be added to the where clause o
country flaguser name
United States
2007-10-07 23:37:50
    [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2003?PAGE=COM.A
TLASSIAN.JIRA.PLUGIN.SYSTEM.ISSUETABPANELS:COMMENT-TABPANEL#
ACTION_12532890 ] 

UDANAX EDITED COMMENT ON HADOOP-2003 AT 10/7/07 9:36 PM:
------------------------------------------------------------
--


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']


RESULT = ? ~LENGTH>100, STUDIONAME = 'FOX'~
(MOVIELOG_TABLE)


SELECT * FROM MOVIELOG_TABLE WHERE LENGTH > 100 AND
STUDIONAME = 'FOX';


NOT IN ();
SELECT * FROM TABLE WHERE LENGTH > 100 AND LENGTH NOT IN
('108', 'FOX');

      WAS (AUTHOR: UDANAX):
    
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']


RESULT = ? ~LENGTH>100, STUDIONAME = 'FOX'~
(MOVIELOG_TABLE)


SELECT * FROM TABLE WHERE LENGTH > 100 AND LENGTH NOT IN
('108', '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)
> 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.


Updated: (HADOOP-2003) The boolean expression can be added to the where clause of select stat
country flaguser name
United States
2007-10-10 03:11:50
     [
HTTPS://ISSUES.APACHE.ORG/JIRA/BROWSE/HADOOP-2003?PAGE=COM.A
TLASSIAN.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.


[1-10]

about | contact  Other archives ( Real Estate discussion Medical topics )