Cassandra
  1. Cassandra
  2. CASSANDRA-2246

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

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Minor Minor
    • Resolution: Not a Problem
    • Fix Version/s: 1.1.0
    • Component/s: Examples
    • Labels:

      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

        Issue Links

          Activity

          Hide
          Brandon Williams added a comment -

          Blocking on CASSANDRA-2878 since there is no other sane way to express multiple index expressions.

          Show
          Brandon Williams added a comment - Blocking on CASSANDRA-2878 since there is no other sane way to express multiple index expressions.
          Hide
          Brandon Williams added a comment -

          CASSANDRA-2878 solved this by allowing you to pass a list a of IndexExpressions to setInputRange.

          Show
          Brandon Williams added a comment - CASSANDRA-2878 solved this by allowing you to pass a list a of IndexExpressions to setInputRange.
          Hide
          Dmitriy V. Ryaboy added a comment -

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

          Show
          Dmitriy V. Ryaboy added a comment - 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).

            People

            • Assignee:
              Brandon Williams
              Reporter:
              Matt Kennedy
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 24h
                24h
                Logged:
                Time Spent - Not Specified
                Not Specified

                  Development