[jira] [Commented] (CASSANDRA-8576) Primary Key Pushdown For Hadoop

["Alex Liu (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-8576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14349527#comment-14349527 ] 

Alex Liu commented on CASSANDRA-8576:
-------------------------------------

Pig-test on trunk fails, Philip Thompson is fixing it. I attach the patch on trunk, but we need merge it with Philip Thompson's fix.

> Primary Key Pushdown For Hadoop
> -------------------------------
>
>                 Key: CASSANDRA-8576
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-8576
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: Hadoop
>            Reporter: Russell Alexander Spitzer
>            Assignee: Alex Liu
>             Fix For: 2.1.4
>
>         Attachments: 8576-2.1-branch.txt
>
>
> I've heard reports from several users that they would like to have predicate pushdown functionality for hadoop (Hive in particular) based services. 
> Example usecase
> Table with wide partitions, one per customer
> Application team has HQL they would like to run on a single customer
> Currently time to complete scales with number of customers since Input Format can't pushdown primary key predicate
> Current implementation requires a full table scan (since it can't recognize that a single partition was specified)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)