phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-136) Support derived tables
Date Tue, 22 Apr 2014 02:52:14 GMT

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

ASF GitHub Bot commented on PHOENIX-136:
----------------------------------------

GitHub user maryannxue opened a pull request:

    https://github.com/apache/incubator-phoenix/pull/31

    PHOENIX-136 Support derived tables

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/maryannxue/incubator-phoenix master

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/incubator-phoenix/pull/31.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 #31
    
----
commit 05b584181fe36102feca765886fcda75b770b2b2
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-12T21:41:53Z

    Fix PHOENIX-44 Cannot create index on tables with case-sensitive schema names

commit 02af57c96476c9d205d07ba96974c49188a282fa
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-21T02:54:17Z

    Merge remote-tracking branch 'asf/master'

commit bd20346da5336d3d240493fdbfbcd5cc03280810
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-21T03:08:23Z

    PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization is preferred
for multi inner join queries

commit 9a2ced8936d6cedbc44a4ed2de2c6f72f4f4307f
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-21T04:59:29Z

    PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization is preferred
for multi inner join queries

commit 20a97904e48829f8b412bcfb0ac2084259133126
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-21T05:53:21Z

    PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization is preferred
for multi inner join queries

commit 7568516fabfb416f5dcbfa89468b839963802a87
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-21T22:14:14Z

    Revert "PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization
is preferred for multi inner join queries"
    
    This reverts commit 20a97904e48829f8b412bcfb0ac2084259133126.

commit 3fb95819959d22deb2c03e895d976e7d933007f2
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-21T22:14:56Z

    Revert "PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization
is preferred for multi inner join queries"
    
    This reverts commit 9a2ced8936d6cedbc44a4ed2de2c6f72f4f4307f.

commit ca0b55d048a6c547a5d6b081dd84dea01011e5c1
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-21T22:16:13Z

    Revert "PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization
is preferred for multi inner join queries"
    
    This reverts commit bd20346da5336d3d240493fdbfbcd5cc03280810.

commit c4df65791a163070362662aad7ce5916faa3c3d7
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-21T22:18:13Z

    Merge remote-tracking branch 'asf/master'

commit 9b5df132480b6bd25c0c33dd818278a5fc1b3f55
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-21T22:22:38Z

    PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization is preferred
for multi inner join queries

commit 3e677489c0cb811c1bb3d266581330fe11fdd674
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-22T00:17:15Z

    PHOENIX-68 Add Option "FAVOR_STAR_JOIN" to indicate if star join optimization is preferred
for multi inner join queries

commit 776c1a11b286ebd358f9111f3ff1c99c3f7c7883
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-27T18:41:58Z

    Merge remote-tracking branch 'asf/master'

commit 6d26e78096091624502d4382de23f655626bca58
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-28T19:36:38Z

    Merge remote-tracking branch 'asf/master'

commit df561c8d8ab59651d7e797dc0da501cceb4c6030
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-28T19:48:06Z

    PHOENIX-85 Refine error handling in HashJoinPlan execution and add warnings

commit 53631fa509e2a660241c717a4eb0c131b251ff5d
Author: maryannxue <maryannxue@apache.org>
Date:   2014-02-28T23:42:14Z

    PHOENIX-85 Refine error handling in HashJoinPlan execution and add warnings

commit 4fb71128f6ac961acbba7db9c3041c53bd18a64a
Author: maryannxue <maryannxue@apache.org>
Date:   2014-03-01T01:53:26Z

    Merge remote-tracking branch 'asf/master'

commit 6a800b53abc6b6dac24daff1eae74100d6c73b97
Author: maryannxue <maryannxue@apache.org>
Date:   2014-03-01T02:10:20Z

    Merge remote-tracking branch 'asf/master'

commit af32148215ec4cb443ba9d79c705c94196f1ff03
Author: maryannxue <maryannxue@apache.org>
Date:   2014-03-03T01:26:48Z

    Merge remote-tracking branch 'asf/master'

commit 012018d2f58cfb35f7574301c68314ead2f31b9d
Author: maryannxue <maryannxue@apache.org>
Date:   2014-03-03T01:30:49Z

    PHOENIX-89 Statements are not closed using PhoenixConnection.executeStatements()

commit c4bd34ff11f75d00bb74008a03247889b3b0160a
Author: maryannxue <maryannxue@apache.org>
Date:   2014-03-31T01:52:33Z

    Merge remote-tracking branch 'asf/master'

commit 8fce312e63138f23c1befcf3a7dbbb573275eaf1
Author: maryannxue <maryannxue@apache.org>
Date:   2014-03-31T01:59:00Z

    PHOENIX-71 Support sub-joins

commit b1d9340e36f750c66b993eb5e8571371f36ca9f9
Author: maryannxue <maryannxue@apache.org>
Date:   2014-04-01T00:19:57Z

    PHOENIX-71 Support sub-joins

commit a3c8f7572a5aa3704ec817f5c42d691df2b631f6
Author: maryannxue <maryannxue@apache.org>
Date:   2014-04-01T00:43:04Z

    PHOENIX-905 Wrong calculation of maxSetBit in ValueBitSet#or(ImmutableBytesWritable)

commit 2a99a6d5062a37eb654796550347786195b91b89
Author: maryannxue <maryannxue@apache.org>
Date:   2014-04-01T00:50:22Z

    PHOENIX-905 Wrong calculation of maxSetBit in ValueBitSet#or(ImmutableBytesWritable)

commit 860a70d2fe08d16bba7a412810feae957089b39b
Author: maryannxue <maryannxue@apache.org>
Date:   2014-04-01T17:44:32Z

    PHOENIX-905 Wrong calculation of maxSetBit in ValueBitSet#or(ImmutableBytesWritable)

commit 037779bd1de9409e741bd97a03c55cec072106c8
Author: maryannxue <maryannxue@apache.org>
Date:   2014-04-10T18:19:06Z

    Merge remote-tracking branch 'asf/master'

commit 71569be703d185e5fc6102423ab15aaa3361cb77
Author: maryannxue <maryannxue@apache.org>
Date:   2014-04-10T18:37:14Z

    PHOENIX-927 Support derived tables in joins

commit 47d9fd827e4f47795ce5f4bfa0c5116ebd6b1e16
Author: maryannxue <maryannxue@apache.org>
Date:   2014-04-13T20:42:27Z

    PHOENIX-927 Support derived tables in joins

commit a28a9f454c31e50a0b3cfe974ccf894b8dfd19d2
Author: maryannxue <maryannxue@apache.org>
Date:   2014-04-22T02:35:29Z

    Merge remote-tracking branch 'asf/master'

commit ffcc2715f69e3b2c3a63b368656fc02b60561935
Author: maryannxue <maryannxue@apache.org>
Date:   2014-04-22T02:47:47Z

    PHOENIX-136 Support derived tables

----


> Support derived tables
> ----------------------
>
>                 Key: PHOENIX-136
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-136
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: James Taylor
>            Assignee: James Taylor
>              Labels: enhancement
>
> Add support for derived queries of the form:
> SELECT * FROM ( SELECT company, revenue FROM Company ORDER BY revenue) LIMIT 10
> Adding support for this requires a compile time change as well as a runtime execution
change. The first version of the compile-time change could limit aggregation to only be allowed
in the inner or the outer query, but not both. In this case, the inner and outer queries can
be combined into a single query with the outer select becoming just a remapping of a subset
of the projection from the inner select. The second version of the compile-time change could
handle aggregation in the inner and outer select by performing client side (this is likely
a less common scenario).
> For the runtime execution, change the UngroupedAggregateRegionObserver would be modified
to look for a new "TopNLimit" attribute with an int value in the Scan. This would control
the maximum number of values for the coprocessor to hold on to as the scan is performed. Then
the GroupedAggregatingResultIterator would be modified to handle keeping the topN values received
back from all the child iterators.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message