[jira] [Comment Edited] (PHOENIX-2722) support mysql "limit,offset" clauses

[ https://issues.apache.org/jira/browse/PHOENIX-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198464#comment-15198464 ] James Taylor edited comment on PHOENIX-2722 at 3/17/16 12:14 AM: - I

[jira] [Commented] (PHOENIX-2771) Improve the performance of IndexTool by building the index mutations at reducer side

[ https://issues.apache.org/jira/browse/PHOENIX-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201792#comment-15201792 ] Sergey Soldatov commented on PHOENIX-2771: -- Hm. I will check the IT tests. > Improve the

[jira] [Updated] (PHOENIX-2782) Index hint is ignored if table alias is used in the query

[ https://issues.apache.org/jira/browse/PHOENIX-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Simon Lee updated PHOENIX-2782: --- Description: It is not clear to me whether this issue is a bug or an expected behavior. Anyway,

[jira] [Commented] (PHOENIX-2777) UPSERT an empty array by sql

[ https://issues.apache.org/jira/browse/PHOENIX-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198570#comment-15198570 ] James Taylor commented on PHOENIX-2777: --- There is no way currently (for the same reason as

Re: GSoC - 2016

Thanks Zhang *T. Pranavan* *BSc Eng Undergraduate| Department of Computer Science & Engineering ,University of Moratuwa* *Mobile| *0775136836 On 20 March 2016 at 01:12, Zhang, Haoran wrote: > Hi Pranavan, > > Here is the

[jira] [Updated] (PHOENIX-2228) Support CREATE TABLE in Phoenix-Calcite Integration

[ https://issues.apache.org/jira/browse/PHOENIX-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla updated PHOENIX-2228: - Attachment: PHOENIX-2228-wip.patch [~julianhyde] [~maryannxue]

[jira] [Commented] (PHOENIX-1121) Improve tracing in Phoenix

[ https://issues.apache.org/jira/browse/PHOENIX-1121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201084#comment-15201084 ] James Taylor commented on PHOENIX-1121: --- Hello [~menaka] - welcome. I'm glad to hear you're

[jira] [Updated] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2405: -- Summary: Improve performance and stability of server side sort for ORDER BY (was: Improve

[jira] [Commented] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201980#comment-15201980 ] Wang, Gang commented on PHOENIX-2405: - Yes it is, so if use this fallback mechanism we have to

[jira] [Updated] (PHOENIX-2093) Support dropping columns from a table that has views

[ https://issues.apache.org/jira/browse/PHOENIX-2093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-2093: Issue Type: Bug (was: Sub-task) Parent: (was: PHOENIX-1508) > Support

[jira] [Updated] (PHOENIX-2228) Support CREATE TABLE in Phoenix-Calcite Integration

[ https://issues.apache.org/jira/browse/PHOENIX-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla updated PHOENIX-2228: - Attachment: (was: PHOENIX-2228-wip.patch) > Support CREATE TABLE in

[jira] [Updated] (PHOENIX-2783) Creating secondary index with duplicated columns makes the catalog corrupted

[ https://issues.apache.org/jira/browse/PHOENIX-2783?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-2783: - Attachment: PHOENIX-2783-2.patch > Creating secondary index with duplicated columns

[jira] [Commented] (PHOENIX-2535) Create shaded clients (thin + thick)

[ https://issues.apache.org/jira/browse/PHOENIX-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201651#comment-15201651 ] Sergey Soldatov commented on PHOENIX-2535: -- [~jmahonin] thank you for trying. I'll take a look.

[jira] [Updated] (PHOENIX-2722) support mysql "limit,offset" clauses

[ https://issues.apache.org/jira/browse/PHOENIX-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-2722: --- Attachment: PHOENIX-2722_formatted.patch bq. I don't understand the need for this grammar

Re: Implement Custom Aggregate Functions in Phoenix

Hi, I found this in Phoenix UDF documentation: - After compiling your code to a jar, you need to deploy the jar into the HDFS. It would be better to add the jar to HDFS folder configured for hbase.dynamic.jars.dir. My question is, can that be any 'udf-user-specific' jar which need to

[jira] [Created] (PHOENIX-2777) UPSERT an empty array by sql

Powpow Shen created PHOENIX-2777: Summary: UPSERT an empty array by sql Key: PHOENIX-2777 URL: https://issues.apache.org/jira/browse/PHOENIX-2777 Project: Phoenix Issue Type: New Feature

[jira] [Commented] (PHOENIX-2405) Improve stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15200435#comment-15200435 ] Wang, Gang commented on PHOENIX-2405: - Thanks [~jamestaylor], Yes, definitely, Apache Mnemonic

[jira] [Commented] (PHOENIX-2779) JOIN on NULL valued columns returns result

[ https://issues.apache.org/jira/browse/PHOENIX-2779?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15197906#comment-15197906 ] ckran commented on PHOENIX-2779: To reproduce this problem: create table a (code varchar(8) primary

[jira] [Commented] (PHOENIX-2771) Improve the performance of IndexTool by building the index mutations at reducer side

[ https://issues.apache.org/jira/browse/PHOENIX-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201318#comment-15201318 ] Hadoop QA commented on PHOENIX-2771: {color:red}-1 overall{color}. Here are the results of testing

Re: Implement Custom Aggregate Functions in Phoenix

No need to register your custom UDFs. Did you see these directions: https://phoenix.apache.org/udf.html#How_to_write_custom_UDF? Have you tried it yet? On Thu, Mar 17, 2016 at 6:49 PM, Swapna Swapna wrote: > Yes, we do have support UPPER and LOWER. I just provided as an

[jira] [Updated] (PHOENIX-2482) Recognize the ANSI SUBSTRING function

[ https://issues.apache.org/jira/browse/PHOENIX-2482?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Liew updated PHOENIX-2482: Labels: phoenix string substring (was: ) > Recognize the ANSI SUBSTRING function >

[jira] [Commented] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201908#comment-15201908 ] stack commented on PHOENIX-2405: bq. Add means we can have a switch to use or not use Mnemonic way to

[jira] [Comment Edited] (PHOENIX-2535) Create shaded clients (thin + thick)

[ https://issues.apache.org/jira/browse/PHOENIX-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201519#comment-15201519 ] Josh Mahonin edited comment on PHOENIX-2535 at 3/18/16 2:16 PM: Sorry

[jira] [Updated] (PHOENIX-2752) Update query server documentation for 4.7.0 release

[ https://issues.apache.org/jira/browse/PHOENIX-2752?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Elser updated PHOENIX-2752: Attachment: PHOENIX-2752.addendum.patch [~jamestaylor], saw you had applied the original patch.

Re: Implement Custom Aggregate Functions in Phoenix

Hi Swapna, We don't support custom aggregate functions, only scalar functions (see PHOENIX-2069). For a custom aggregate function, you'd need to add them to phoenix-core and rebuild the jar. We're open to adding them to the code base if they're general enough. That's how FIRST_VALUE, LAST_VALUE,

Re: GSoC - 2016

Hi James, Thanks for the new issue. I will have a look over it and give an update on this issue. Thanks *T. Pranavan* *BSc Eng Undergraduate| Department of Computer Science & Engineering ,University of Moratuwa* *Mobile| *0775136836 On 18 March 2016 at 07:11, James Taylor

[jira] [Issue Comment Deleted] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yanping Wang updated PHOENIX-2405: -- Comment: was deleted (was: We can consider open a JIRA for Mnemonic and Phoenix integration

[jira] [Comment Edited] (PHOENIX-2769) Order by desc return wrong results

[ https://issues.apache.org/jira/browse/PHOENIX-2769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198758#comment-15198758 ] Joseph Sun edited comment on PHOENIX-2769 at 3/17/16 5:16 AM: -- I execute

[jira] [Commented] (PHOENIX-2228) Support CREATE TABLE in Phoenix-Calcite Integration

[ https://issues.apache.org/jira/browse/PHOENIX-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15202931#comment-15202931 ] Haoran Zhang commented on PHOENIX-2228: --- Hi [~kdmu], As SqlParserImpl is generated by antlr

[jira] [Updated] (PHOENIX-2782) Index hint is ignored if table alias is used in the query

[ https://issues.apache.org/jira/browse/PHOENIX-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Simon Lee updated PHOENIX-2782: --- Description: It is not clear to me whether this issue is a bug or an expected behavior. Anyway,

[jira] [Commented] (PHOENIX-2783) Creating secondary index with duplicated columns makes the catalog corrupted

[ https://issues.apache.org/jira/browse/PHOENIX-2783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201276#comment-15201276 ] Hadoop QA commented on PHOENIX-2783: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Commented] (PHOENIX-2228) Support CREATE TABLE in Phoenix-Calcite Integration

[ https://issues.apache.org/jira/browse/PHOENIX-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15202921#comment-15202921 ] Kaide Mu commented on PHOENIX-2228: --- Hi, [~rajeshbabu], I created the following SqlCreateSequence

[jira] [Updated] (PHOENIX-2771) Improve the performance of IndexTool by building the index mutations at reducer side

[ https://issues.apache.org/jira/browse/PHOENIX-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-2771: - Attachment: PHOENIX-2771-1.patch > Improve the performance of IndexTool by building the

[jira] [Commented] (PHOENIX-1119) Use Zipkin to visualize Phoenix metrics data

[ https://issues.apache.org/jira/browse/PHOENIX-1119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15197919#comment-15197919 ] Abhishek Tiwari commented on PHOENIX-1119: -- [~jamestaylor] HI James, I am Abhishek, an

[jira] [Updated] (PHOENIX-2784) phoenix-spark: Allow coercion of DATE fields to TIMESTAMP when loading DataFrames

[ https://issues.apache.org/jira/browse/PHOENIX-2784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Josh Mahonin updated PHOENIX-2784: -- Attachment: PHOENIX-2784.patch > phoenix-spark: Allow coercion of DATE fields to TIMESTAMP

[jira] [Created] (PHOENIX-2784) phoenix-spark: Allow coercion of DATE fields to TIMESTAMP when loading DataFrames

Josh Mahonin created PHOENIX-2784: - Summary: phoenix-spark: Allow coercion of DATE fields to TIMESTAMP when loading DataFrames Key: PHOENIX-2784 URL: https://issues.apache.org/jira/browse/PHOENIX-2784

[jira] [Comment Edited] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201933#comment-15201933 ] Wang, Gang edited comment on PHOENIX-2405 at 3/18/16 6:38 PM: -- Thanks

[jira] [Commented] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201127#comment-15201127 ] stack commented on PHOENIX-2405: [~ywang261] bq. as Gary commented, we can use above code to allocate

[jira] [Commented] (PHOENIX-2783) Creating secondary index with duplicated columns makes the catalog corrupted

[ https://issues.apache.org/jira/browse/PHOENIX-2783?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201952#comment-15201952 ] Sergey Soldatov commented on PHOENIX-2783: -- Updated the patch. > Creating secondary index with

[jira] [Updated] (PHOENIX-2777) UPSERT an empty array by sql

[ https://issues.apache.org/jira/browse/PHOENIX-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Powpow Shen updated PHOENIX-2777: - Description: ARRAY type field can be inserted by *ARRAY['blah']* which has *ARRAY_LENGTH* 1,

[jira] [Commented] (PHOENIX-2405) Improve stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15200756#comment-15200756 ] Yanping Wang commented on PHOENIX-2405: --- We can consider open a JIRA for Mnemonic and Phoenix

[jira] [Commented] (PHOENIX-2777) UPSERT an empty array by sql

[ https://issues.apache.org/jira/browse/PHOENIX-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198572#comment-15198572 ] Powpow Shen commented on PHOENIX-2777: -- I see. Thank you, James. > UPSERT an empty array by sql >

[jira] [Comment Edited] (PHOENIX-2769) Order by desc return wrong results

[ https://issues.apache.org/jira/browse/PHOENIX-2769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198758#comment-15198758 ] Joseph Sun edited comment on PHOENIX-2769 at 3/17/16 5:21 AM: -- I execute

[jira] [Commented] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15202028#comment-15202028 ] Yanping Wang commented on PHOENIX-2405: --- Gary, It is probably better to trigger fallback after

[jira] [Created] (PHOENIX-2783) Creating secondary index with duplicated columns makes the catalog corrupted

Sergey Soldatov created PHOENIX-2783: Summary: Creating secondary index with duplicated columns makes the catalog corrupted Key: PHOENIX-2783 URL: https://issues.apache.org/jira/browse/PHOENIX-2783

[jira] [Resolved] (PHOENIX-2777) UPSERT an empty array by sql

[ https://issues.apache.org/jira/browse/PHOENIX-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-2777. --- Resolution: Duplicate Empty values in Phoenix are treated as null, so this is essentially a

[jira] [Updated] (PHOENIX-2405) Improve stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2405: -- Labels: gsoc2016 (was: ) > Improve stability of server side sort for ORDER BY >

[jira] [Commented] (PHOENIX-2760) Upgrade phoenix-server and phoenix-server-client to Avatica 1.7.1

[ https://issues.apache.org/jira/browse/PHOENIX-2760?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201972#comment-15201972 ] Josh Elser commented on PHOENIX-2760: - Just kicked precommit too. > Upgrade phoenix-server and

[jira] [Commented] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201951#comment-15201951 ] stack commented on PHOENIX-2405: bq. Thanks stack, how about fallback to Mnemonic only if

[jira] [Commented] (PHOENIX-2724) Query with large number of guideposts is slower compared to no stats

[ https://issues.apache.org/jira/browse/PHOENIX-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15200775#comment-15200775 ] Samarth Jain commented on PHOENIX-2724: --- I created a table with 300 million rows and 330K+

[jira] [Commented] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201870#comment-15201870 ] Yanping Wang commented on PHOENIX-2405: --- Hi, Stack, Your concern is certainly valid. Yes, the

[jira] [Commented] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201034#comment-15201034 ] ramkrishna.s.vasudevan commented on PHOENIX-2405: - If using mmap() was a stability

[jira] [Commented] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15200993#comment-15200993 ] ramkrishna.s.vasudevan commented on PHOENIX-2405: - I was looking into this issue after

Re: Implement Custom Aggregate Functions in Phoenix

Thank you James for swift response. is the process (adding to phoenix-core and rebuild the jar) remains the same for custom UDF's as well (like as for custom aggregate functions)? ex: we have UDF's like UPPER, LOWER ,etc On Thu, Mar 17, 2016 at 5:53 PM, James Taylor

[jira] [Created] (PHOENIX-2776) Use the right value for empty key value in UngroupedAggregateRegionObserver

Samarth Jain created PHOENIX-2776: - Summary: Use the right value for empty key value in UngroupedAggregateRegionObserver Key: PHOENIX-2776 URL: https://issues.apache.org/jira/browse/PHOENIX-2776

Re: GSoC - 2016

Great! I think PHOENIX-1121 is a good one - there's plenty of work there to keep you occupied for the whole time. I think PHOENIX-1178 is a bit too undefined to include at this point. Thanks, James On Thu, Mar 17, 2016 at 11:07 PM, Pranavan Theivendiram < pranavan...@cse.mrt.ac.lk> wrote:

[jira] [Commented] (PHOENIX-2405) Improve stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15200319#comment-15200319 ] James Taylor commented on PHOENIX-2405: --- [~ywang261] - do you think Apache Mnemonic can help us

[jira] [Commented] (PHOENIX-2178) Tracing - total time listed for a certain trace does not correlate with query wall clock time

[ https://issues.apache.org/jira/browse/PHOENIX-2178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198230#comment-15198230 ] Ashish Tiwari commented on PHOENIX-2178: [~jamestaylor] > Tracing - total time listed for a

[jira] [Commented] (PHOENIX-2760) Upgrade phoenix-server and phoenix-server-client to Avatica 1.7.1

[ https://issues.apache.org/jira/browse/PHOENIX-2760?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15202239#comment-15202239 ] Hadoop QA commented on PHOENIX-2760: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Updated] (PHOENIX-1178) Collect and use histogram information during query optimization

[ https://issues.apache.org/jira/browse/PHOENIX-1178?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1178: -- Labels: (was: gsoc2016) > Collect and use histogram information during query optimization >

[jira] [Created] (PHOENIX-2782) Index hint is ignored if table alias is used in the query

Simon Lee created PHOENIX-2782: -- Summary: Index hint is ignored if table alias is used in the query Key: PHOENIX-2782 URL: https://issues.apache.org/jira/browse/PHOENIX-2782 Project: Phoenix

[jira] [Commented] (PHOENIX-2769) Order by desc return wrong results

[ https://issues.apache.org/jira/browse/PHOENIX-2769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198758#comment-15198758 ] Joseph Sun commented on PHOENIX-2769: - I execute some sql ,the problem is reproduced. > select

[jira] [Commented] (PHOENIX-2228) Support CREATE TABLE in Phoenix-Calcite Integration

[ https://issues.apache.org/jira/browse/PHOENIX-2228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201727#comment-15201727 ] Julian Hyde commented on PHOENIX-2228: -- [~rajeshbabu], WIP patch looks good. In addition to the IT,

[jira] [Updated] (PHOENIX-2771) Improve the performance of IndexTool by building the index mutations at reducer side

[ https://issues.apache.org/jira/browse/PHOENIX-2771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sergey Soldatov updated PHOENIX-2771: - Attachment: PHOENIX-2771-2.patch Added support for timestamp aggregation. This is

[jira] [Reopened] (PHOENIX-2777) UPSERT an empty array by sql

[ https://issues.apache.org/jira/browse/PHOENIX-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor reopened PHOENIX-2777: --- > UPSERT an empty array by sql > > > Key:

Fwd: GSoC - 2016

[Adding Taylor in] *T. Pranavan* *BSc Eng Undergraduate| Department of Computer Science & Engineering ,University of Moratuwa* *Mobile| *0775136836 -- Forwarded message -- From: Pranavan Theivendiram Date: 18 March 2016 at 07:02 Subject: GSoC - 2016 To:

Re: GSoC - 2016

Hi Pranavan, Congratulations on winning GSoC-2015. We'd welcome a proposal for a GSoC project with Phoenix for 2016. That particular JIRA is already part of a different proposal - would you consider this issue: https://issues.apache.org/jira/browse/PHOENIX-2405? This one would be very interesting

[jira] [Created] (PHOENIX-2778) DELETE by specifying dynamic columns

Powpow Shen created PHOENIX-2778: Summary: DELETE by specifying dynamic columns Key: PHOENIX-2778 URL: https://issues.apache.org/jira/browse/PHOENIX-2778 Project: Phoenix Issue Type: New

[jira] [Updated] (PHOENIX-2758) Ordered GROUP BY not occurring with leading PK equality expression

[ https://issues.apache.org/jira/browse/PHOENIX-2758?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2758: -- Attachment: PHOENIX-2758_wip.patch > Ordered GROUP BY not occurring with leading PK equality

[jira] [Comment Edited] (PHOENIX-2405) Improve stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15200435#comment-15200435 ] Wang, Gang edited comment on PHOENIX-2405 at 3/17/16 9:54 PM: -- Thanks

GSoC - 2016

Dear devs, I am Pranavan Theivendiram from University of Moratuwa. I am winner of GSoC-2015. I have done a project with Apache Software foundation (Apache Stratos). I am interested in working in the following issue. JIRA ISSUE - https://issues.apache.org/jira/browse/PHOENIX-2062?filter=12334770

Re: Implement Custom Aggregate Functions in Phoenix

No, custom UDFs can be added dynamically as described here: https://phoenix.apache.org/udf.html. No need to re-build Phoenix. It's just custom aggregates that would require rebuilding. FYI, we have support for UPPER and LOWER already. On Thu, Mar 17, 2016 at 6:09 PM, Swapna Swapna

[jira] [Comment Edited] (PHOENIX-2769) Order by desc return wrong results

[ https://issues.apache.org/jira/browse/PHOENIX-2769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198758#comment-15198758 ] Joseph Sun edited comment on PHOENIX-2769 at 3/17/16 5:17 AM: -- I execute

[jira] [Commented] (PHOENIX-2405) Improve stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15200618#comment-15200618 ] Wang, Gang commented on PHOENIX-2405: - After reading the code of class MappedByteBufferQueue, I

Re: GSoC - 2016

Hi James, I went through some of the jira issues. The following two issues are interesting for me. I have some experience in the past. Hence, it will be handy for me. Please let me know, if anyone is working on these issues. 1178 - https://issues.apache.org/jira/browse/PHOENIX-1178 1121 -

Re: Implement Custom Aggregate Functions in Phoenix

Yes, we do have support UPPER and LOWER. I just provided as an example to refer to UDF. For custom UDF's, i understand that we can go ahead and create custom UDF jar. but how do we register that function? As per the blog, i found the below lines: *Finally, we'll need to register our new

[jira] [Commented] (PHOENIX-2744) Extend phoenix to store secondary index in elastic search

[ https://issues.apache.org/jira/browse/PHOENIX-2744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201309#comment-15201309 ] Naveen commented on PHOENIX-2744: - Bump*** > Extend phoenix to store secondary index in elastic search

[jira] [Commented] (PHOENIX-2178) Tracing - total time listed for a certain trace does not correlate with query wall clock time

[ https://issues.apache.org/jira/browse/PHOENIX-2178?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198477#comment-15198477 ] James Taylor commented on PHOENIX-2178: --- Thanks, [~ashishtiwari88] - we appreciate the proposal. A

[jira] [Commented] (PHOENIX-2746) Delete on the table with immutable rows may fail with INVALID_FILTER_ON_IMMUTABLE_ROWS error code.

[ https://issues.apache.org/jira/browse/PHOENIX-2746?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15200532#comment-15200532 ] Hudson commented on PHOENIX-2746: - FAILURE: Integrated in Phoenix-master #1175 (See

[jira] [Commented] (PHOENIX-2722) support mysql "limit,offset" clauses

[ https://issues.apache.org/jira/browse/PHOENIX-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198464#comment-15198464 ] James Taylor commented on PHOENIX-2722: --- I don't understand the need for [ FETCH { FIRST | NEXT }

[jira] [Updated] (PHOENIX-2405) Improve stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2405: -- Summary: Improve stability of server side sort for ORDER BY (was: Use Java heap memory

[jira] [Comment Edited] (PHOENIX-2724) Query with large number of guideposts is slower compared to no stats

[ https://issues.apache.org/jira/browse/PHOENIX-2724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15200775#comment-15200775 ] Samarth Jain edited comment on PHOENIX-2724 at 3/18/16 1:32 AM: I

[jira] [Comment Edited] (PHOENIX-2722) support mysql "limit,offset" clauses

[ https://issues.apache.org/jira/browse/PHOENIX-2722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15198464#comment-15198464 ] James Taylor edited comment on PHOENIX-2722 at 3/17/16 12:12 AM: - I

[jira] [Commented] (PHOENIX-2405) Improve performance and stability of server side sort for ORDER BY

[ https://issues.apache.org/jira/browse/PHOENIX-2405?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201008#comment-15201008 ] James Taylor commented on PHOENIX-2405: --- Thanks, [~ram_krish]. There's a GSoC student who's