[ https://issues.apache.org/jira/browse/PHOENIX-3744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16037869#comment-16037869 ]
ASF GitHub Bot commented on PHOENIX-3744: ----------------------------------------- GitHub user akshita-malhotra opened a pull request: https://github.com/apache/phoenix/pull/255 PHOENIX-3744 for 4.x-HBase-0.98 PHOENIX-3744 patch for 4.x-HBase-0.98 branch You can merge this pull request into a Git repository by running: $ git pull https://github.com/akshita-malhotra/phoenix PHOENIX-3744-4.x Alternatively you can review and apply these changes as the patch at: https://github.com/apache/phoenix/pull/255.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #255 ---- commit 718dfb2b11c3b57ae1dc94b79d15ada516bba4a9 Author: Akshita <akshita.malho...@salesforce.com> Date: 2017-06-05T23:49:08Z PHOENIX-3744 for 4.x-HBase-0.98 ---- > Support snapshot scanners for MR-based queries > ---------------------------------------------- > > Key: PHOENIX-3744 > URL: https://issues.apache.org/jira/browse/PHOENIX-3744 > Project: Phoenix > Issue Type: Bug > Reporter: James Taylor > Assignee: Akshita Malhotra > Attachments: PHOENIX-3744.patch, PHOENIX-3744.patch, > PHOENIX-3744.patch > > > HBase support scanning over snapshots, with a SnapshotScanner that accesses > the region directly in HDFS. We should make sure that Phoenix can support > that. > Not sure how we'd want to decide when to run a query over a snapshot. Some > ideas: > - if there's an SCN set (i.e. the query is running at a point in time in the > past) > - if the memstore is empty > - if the query is being run at a timestamp earlier than any memstore data > - as a config option on the table > - as a query hint > - based on some kind of optimizer rule (i.e. based on estimated # of bytes > that will be scanned) > Phoenix typically runs a query at the timestamp at which it was compiled. Any > data committed after this time should not be seen while a query is running. -- This message was sent by Atlassian JIRA (v6.3.15#6346)