You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Matt Kennedy (JIRA)" <ji...@apache.org> on 2011/02/25 01:46:38 UTC

[jira] Created: (CASSANDRA-2246) Enable Pig to use indexed data as described in CASSANDRA-2245

Enable Pig to use indexed data as described in CASSANDRA-2245
-------------------------------------------------------------

                 Key: CASSANDRA-2246
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2246
             Project: Cassandra
          Issue Type: Improvement
          Components: Contrib
    Affects Versions: 0.7.2
            Reporter: Matt Kennedy
            Priority: Minor
             Fix For: 0.8


in contrib/pig, add query parameters to CassandraStorage keyspace/column family string to specify column search predicates.

For example:
rows = LOAD 'cassandra://mykeyspace/mycolumnfamily?country=UK' using CassandraStorage();

This depends on CASSANDRA-2245

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Commented] (CASSANDRA-2246) Enable Pig to use indexed data as described in CASSANDRA-2245

Posted by "Dmitriy V. Ryaboy (Commented) (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CASSANDRA-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13256770#comment-13256770 ] 

Dmitriy V. Ryaboy commented on CASSANDRA-2246:
----------------------------------------------

FYI I suspect you could do this much nicer by making use of Pig's predicate pushdown via LoadMetadata.getPartitionKeys (supply everything you have an index on) and LoadMetadata.setPartitionFilter (apply the selection by using secondary indexes). 
                
> Enable Pig to use indexed data as described in CASSANDRA-2245
> -------------------------------------------------------------
>
>                 Key: CASSANDRA-2246
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2246
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Contrib
>    Affects Versions: 0.7.2
>            Reporter: Matt Kennedy
>            Assignee: Brandon Williams
>            Priority: Minor
>              Labels: hadoop
>             Fix For: 1.1.0
>
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> in contrib/pig, add query parameters to CassandraStorage keyspace/column family string to specify column search predicates.
> For example:
> rows = LOAD 'cassandra://mykeyspace/mycolumnfamily?country=UK' using CassandraStorage();
> This depends on CASSANDRA-1600

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Resolved] (CASSANDRA-2246) Enable Pig to use indexed data as described in CASSANDRA-2245

Posted by "Brandon Williams (Resolved) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brandon Williams resolved CASSANDRA-2246.
-----------------------------------------

       Resolution: Not A Problem
    Fix Version/s:     (was: 1.1.1)
                   1.1.0

CASSANDRA-2878 solved this by allowing you to pass a list a of IndexExpressions to setInputRange.
                
> Enable Pig to use indexed data as described in CASSANDRA-2245
> -------------------------------------------------------------
>
>                 Key: CASSANDRA-2246
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2246
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Contrib
>    Affects Versions: 0.7.2
>            Reporter: Matt Kennedy
>            Assignee: Brandon Williams
>            Priority: Minor
>              Labels: hadoop
>             Fix For: 1.1.0
>
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> in contrib/pig, add query parameters to CassandraStorage keyspace/column family string to specify column search predicates.
> For example:
> rows = LOAD 'cassandra://mykeyspace/mycolumnfamily?country=UK' using CassandraStorage();
> This depends on CASSANDRA-1600

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Assigned] (CASSANDRA-2246) Enable Pig to use indexed data as described in CASSANDRA-2245

Posted by "Brandon Williams (Assigned) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brandon Williams reassigned CASSANDRA-2246:
-------------------------------------------

    Assignee: Brandon Williams
    
> Enable Pig to use indexed data as described in CASSANDRA-2245
> -------------------------------------------------------------
>
>                 Key: CASSANDRA-2246
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2246
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Contrib
>    Affects Versions: 0.7.2
>            Reporter: Matt Kennedy
>            Assignee: Brandon Williams
>            Priority: Minor
>              Labels: hadoop
>             Fix For: 1.1
>
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> in contrib/pig, add query parameters to CassandraStorage keyspace/column family string to specify column search predicates.
> For example:
> rows = LOAD 'cassandra://mykeyspace/mycolumnfamily?country=UK' using CassandraStorage();
> This depends on CASSANDRA-1600

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

[jira] [Updated] (CASSANDRA-2246) Enable Pig to use indexed data as described in CASSANDRA-2245

Posted by "Jonathan Ellis (Updated) (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CASSANDRA-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis updated CASSANDRA-2246:
--------------------------------------

    Description: 
in contrib/pig, add query parameters to CassandraStorage keyspace/column family string to specify column search predicates.

For example:
rows = LOAD 'cassandra://mykeyspace/mycolumnfamily?country=UK' using CassandraStorage();

This depends on CASSANDRA-1600

  was:
in contrib/pig, add query parameters to CassandraStorage keyspace/column family string to specify column search predicates.

For example:
rows = LOAD 'cassandra://mykeyspace/mycolumnfamily?country=UK' using CassandraStorage();

This depends on CASSANDRA-2245

    
> Enable Pig to use indexed data as described in CASSANDRA-2245
> -------------------------------------------------------------
>
>                 Key: CASSANDRA-2246
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-2246
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Contrib
>    Affects Versions: 0.7.2
>            Reporter: Matt Kennedy
>            Priority: Minor
>              Labels: hadoop
>             Fix For: 1.1
>
>   Original Estimate: 24h
>  Remaining Estimate: 24h
>
> in contrib/pig, add query parameters to CassandraStorage keyspace/column family string to specify column search predicates.
> For example:
> rows = LOAD 'cassandra://mykeyspace/mycolumnfamily?country=UK' using CassandraStorage();
> This depends on CASSANDRA-1600

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira