[jira] [Commented] (PHOENIX-2989) Allow DistinctPrefixFilter optimization when HAVING clause only reference COUNT(DISTINCT)

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15328025#comment-15328025 ] James Taylor commented on PHOENIX-2989: --- Patch looks good. Here's a good test you

[jira] [Commented] (PHOENIX-2989) Allow DistinctPrefixFilter optimization when HAVING clause only reference COUNT(DISTINCT)

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15328062#comment-15328062 ] James Taylor commented on PHOENIX-2989: --- +1. Nice test :-) I like the idea of com

[jira] [Assigned] (PHOENIX-2961) select on a composite primary key fails when DESC is set in the table

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor reassigned PHOENIX-2961: - Assignee: James Taylor (was: Samarth Jain) > select on a composite primary key fails w

[jira] [Updated] (PHOENIX-2961) select on a composite primary key fails when DESC is set in the table

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2961: -- Attachment: PHOENIX-2961.patch Please review, [~samarthjain]. > select on a composite primary

[jira] [Updated] (PHOENIX-2983) ClassCastException on auto coerce of BIGINT to DECIMAL

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2983: -- Attachment: PHOENIX-2983_v2.patch Thanks for the review, [~samarthjain]. Here's an updated pat

[jira] [Commented] (PHOENIX-2992) Remove ORDER BY from COUNT(DISTINCT...)-only SELECT statements

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15328277#comment-15328277 ] James Taylor commented on PHOENIX-2992: --- We should remove the ORDER BY for all cas

[jira] [Updated] (PHOENIX-2983) ClassCastException on auto coerce of BIGINT to DECIMAL

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2983: -- Attachment: PHOENIX-2983_v3.patch Final patch > ClassCastException on auto coerce of BIGINT t

[jira] [Resolved] (PHOENIX-2277) Indexes on tenant views not working correctly

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-2277. --- Resolution: Duplicate Fix Version/s: (was: 4.8.0) This is a duplicate of PHOENIX-

[jira] [Updated] (PHOENIX-2277) Indexes on tenant views not working correctly

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2277: -- Labels: SFDC (was: SFDC verify) > Indexes on tenant views not working correctly > ---

[jira] [Created] (PHOENIX-2994) Coalesce function may return null

2016-06-13 Thread James Taylor (JIRA)
James Taylor created PHOENIX-2994: - Summary: Coalesce function may return null Key: PHOENIX-2994 URL: https://issues.apache.org/jira/browse/PHOENIX-2994 Project: Phoenix Issue Type: Bug

[jira] [Updated] (PHOENIX-2994) Coalesce function may return null

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2994: -- Attachment: PHOENIX-2994.patch Please review, [~samarthjain]. > Coalesce function may return

[jira] [Commented] (PHOENIX-2992) Remove ORDER BY from aggregate-only SELECT statements

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15328589#comment-15328589 ] James Taylor commented on PHOENIX-2992: --- +1 for v1. The AVG compiles to two aggreg

[jira] [Commented] (PHOENIX-2992) Remove ORDER BY from aggregate-only SELECT statements

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15328683#comment-15328683 ] James Taylor commented on PHOENIX-2992: --- FWIW, you should always run a {{mvn packa

[jira] [Resolved] (PHOENIX-2994) Coalesce function may return null

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2994?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-2994. --- Resolution: Fixed > Coalesce function may return null > - >

[jira] [Resolved] (PHOENIX-2920) Incorrect Queries on Multi-tenant tables with WHERE clause containing Row Value Constructor

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-2920. --- Resolution: Fixed > Incorrect Queries on Multi-tenant tables with WHERE clause containing Ro

[jira] [Resolved] (PHOENIX-2961) select on a composite primary key fails when DESC is set in the table

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2961?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-2961. --- Resolution: Fixed > select on a composite primary key fails when DESC is set in the table >

[jira] [Resolved] (PHOENIX-2983) ClassCastException on auto coerce of BIGINT to DECIMAL

2016-06-13 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2983?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-2983. --- Resolution: Fixed > ClassCastException on auto coerce of BIGINT to DECIMAL > ---

[jira] [Commented] (PHOENIX-2940) Remove STATS RPCs from rowlock

2016-06-14 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15330023#comment-15330023 ] James Taylor commented on PHOENIX-2940: --- Do you think we can target this JIRA for

[jira] [Commented] (PHOENIX-2940) Remove STATS RPCs from rowlock

2016-06-14 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15330057#comment-15330057 ] James Taylor commented on PHOENIX-2940: --- No problem, [~elserj] - I suspected as mu

[jira] [Commented] (PHOENIX-2995) Write performance severely degrades with large number of views

2016-06-14 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15330152#comment-15330152 ] James Taylor commented on PHOENIX-2995: --- Thanks for raising this, [~mujtabachohan]

[jira] [Commented] (PHOENIX-2940) Remove STATS RPCs from rowlock

2016-06-14 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15330198#comment-15330198 ] James Taylor commented on PHOENIX-2940: --- Yes, that sounds correct. The RpcSchedule

[jira] [Commented] (PHOENIX-2940) Remove STATS RPCs from rowlock

2016-06-14 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15330736#comment-15330736 ] James Taylor commented on PHOENIX-2940: --- Patch looks good, [~elserj]. Not sure I

[jira] [Commented] (PHOENIX-2982) Keep the number of active handlers balanced across salt buckets

2016-06-14 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15330791#comment-15330791 ] James Taylor commented on PHOENIX-2982: --- Sorry for the delayed response, [~junegun

[jira] [Commented] (PHOENIX-2995) Write performance severely degrades with large number of views

2016-06-14 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15330892#comment-15330892 ] James Taylor commented on PHOENIX-2995: --- Thanks, [~mujtabachohan]. What does a sam

[jira] [Created] (PHOENIX-2998) Add test for setting RPC timeout for a connection

2016-06-14 Thread James Taylor (JIRA)
James Taylor created PHOENIX-2998: - Summary: Add test for setting RPC timeout for a connection Key: PHOENIX-2998 URL: https://issues.apache.org/jira/browse/PHOENIX-2998 Project: Phoenix Issue

[jira] [Updated] (PHOENIX-2998) Add test for setting RPC timeout for a connection

2016-06-14 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2998: -- Attachment: PHOENIX-2998.patch > Add test for setting RPC timeout for a connection > -

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

2016-06-14 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15331143#comment-15331143 ] James Taylor commented on PHOENIX-2535: --- [~sergey.soldatov] - is this good to go f

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

2016-06-14 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15331151#comment-15331151 ] James Taylor commented on PHOENIX-2535: --- Great! [~elserj] already +1'ed it, so I'm

[jira] [Commented] (PHOENIX-2276) Creating index on a global view on a multi-tenant table fails with NPE

2016-06-15 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15332791#comment-15332791 ] James Taylor commented on PHOENIX-2276: --- One minor fix on commit nit if you agree.

[jira] [Commented] (PHOENIX-2276) Creating index on a global view on a multi-tenant table fails with NPE

2016-06-15 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2276?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15332989#comment-15332989 ] James Taylor commented on PHOENIX-2276: --- Yes, tomorrow is fine. Thanks, [~maryannx

[jira] [Commented] (PHOENIX-2952) array_length return negative value

2016-06-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15334075#comment-15334075 ] James Taylor commented on PHOENIX-2952: --- Would you mind taking a look, [~ram_krish

[jira] [Commented] (PHOENIX-3000) Reduce memory consumption during DISTINCT aggregation

2016-06-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3000?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15334517#comment-15334517 ] James Taylor commented on PHOENIX-3000: --- +1 on the patch. That's pretty interestin

[jira] [Commented] (PHOENIX-2979) ScannerLeaseRenewalIT tests are failing

2016-06-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2979?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15334772#comment-15334772 ] James Taylor commented on PHOENIX-2979: --- So just to confirm, it's working for you

[jira] [Commented] (PHOENIX-2940) Remove STATS RPCs from rowlock

2016-06-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15334788#comment-15334788 ] James Taylor commented on PHOENIX-2940: --- bq. Clearing the table from the cache als

[jira] [Commented] (PHOENIX-2952) array_length return negative value

2016-06-16 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1533#comment-1533 ] James Taylor commented on PHOENIX-2952: --- Can you take a look [~ram_krish]? Sounds

[jira] [Commented] (PHOENIX-2940) Remove STATS RPCs from rowlock

2016-06-17 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15336628#comment-15336628 ] James Taylor commented on PHOENIX-2940: --- Couple minor API recommendations, [~elser

[jira] [Updated] (PHOENIX-2952) array_length return negative value

2016-06-17 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2952: -- Fix Version/s: 4.8.0 > array_length return negative value > --

[jira] [Updated] (PHOENIX-2952) array_length return negative value

2016-06-17 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2952: -- Assignee: Joseph Sun > array_length return negative value > --

[jira] [Commented] (PHOENIX-2952) array_length return negative value

2016-06-17 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2952?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15336644#comment-15336644 ] James Taylor commented on PHOENIX-2952: --- +1, [~ram_krish]. Please commit to master

[jira] [Commented] (PHOENIX-2940) Remove STATS RPCs from rowlock

2016-06-17 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15336779#comment-15336779 ] James Taylor commented on PHOENIX-2940: --- bq. Replacing with byte[] or ImmutableByt

[jira] [Commented] (PHOENIX-3005) Use DistinctPrefixFilter for DISTINCT index scans

2016-06-17 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15337583#comment-15337583 ] James Taylor commented on PHOENIX-3005: --- No, it should work the same for indexes.

[jira] [Commented] (PHOENIX-2961) select on a composite primary key fails when DESC is set in the table

2016-06-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2961?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15337619#comment-15337619 ] James Taylor commented on PHOENIX-2961: --- [~dhe...@salesforce.com] - can you take a

[jira] [Commented] (PHOENIX-3005) Use DistinctPrefixFilter for DISTINCT index scans

2016-06-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15338121#comment-15338121 ] James Taylor commented on PHOENIX-3005: --- That's a bug, probably due to the cast fr

[jira] [Updated] (PHOENIX-3006) FloorDecimalExpression.(List) should be public

2016-06-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3006: -- Attachment: PHOENIX-3006_v2.patch Good find, [~lhofhansl]. There is a unit test, but it's brok

[jira] [Commented] (PHOENIX-3005) Use DistinctPrefixFilter for DISTINCT index scans

2016-06-18 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15338278#comment-15338278 ] James Taylor commented on PHOENIX-3005: --- If an index is being used where C1 is ind

[jira] [Commented] (PHOENIX-3005) Use DistinctPrefixFilter for DISTINCT index scans

2016-06-19 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15338413#comment-15338413 ] James Taylor commented on PHOENIX-3005: --- Should get compiled twice, once using dat

[jira] [Commented] (PHOENIX-2166) Prevent writing to tracing table when tracing data collected

2016-06-19 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15338622#comment-15338622 ] James Taylor commented on PHOENIX-2166: --- There's a bunch of changes in that patch

[jira] [Commented] (PHOENIX-3005) Use DistinctPrefixFilter for DISTINCT index scans

2016-06-19 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15338662#comment-15338662 ] James Taylor commented on PHOENIX-3005: --- Looks to be working fine. The index is us

[jira] [Commented] (PHOENIX-3005) Use DistinctPrefixFilter for COUNT(DISTINCT...) index scans

2016-06-19 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15338825#comment-15338825 ] James Taylor commented on PHOENIX-3005: --- You may have already discovered, but it l

[jira] [Updated] (PHOENIX-3005) Use DistinctPrefixFilter for COUNT(DISTINCT...) index scans

2016-06-19 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3005: -- Attachment: PHOENIX-3005_v1.patch Try this patch and see if it's better, [~lhofhansl]. There w

[jira] [Commented] (PHOENIX-3005) Use DistinctPrefixFilter for COUNT(DISTINCT...) index scans

2016-06-19 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15338850#comment-15338850 ] James Taylor commented on PHOENIX-3005: --- Does my patch work too, [~lhofhansl]? I t

[jira] [Commented] (PHOENIX-3005) Use DistinctPrefixFilter for COUNT(DISTINCT...) index scans

2016-06-19 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15338867#comment-15338867 ] James Taylor commented on PHOENIX-3005: --- +1. Thanks, [~lhofhansl]! > Use Distinct

[jira] [Commented] (PHOENIX-2940) Remove STATS RPCs from rowlock

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15339800#comment-15339800 ] James Taylor commented on PHOENIX-2940: --- Looks good, [~elserj]. Let's commit this

[jira] [Resolved] (PHOENIX-2950) Implement CRON job to start async index builds and restart failed jobs

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-2950. --- Resolution: Fixed > Implement CRON job to start async index builds and restart failed jobs >

[jira] [Resolved] (PHOENIX-2998) Add test for setting RPC timeout for a connection

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-2998. --- Resolution: Fixed Assignee: James Taylor Fix Version/s: 4.8.0 > Add test for

[jira] [Commented] (PHOENIX-2999) Upgrading Multi-tenant table to map with namespace using upgradeUtil

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340159#comment-15340159 ] James Taylor commented on PHOENIX-2999: --- Only the physical table would have a name

[jira] [Commented] (PHOENIX-2999) Upgrading Multi-tenant table to map with namespace using upgradeUtil

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340214#comment-15340214 ] James Taylor commented on PHOENIX-2999: --- So in this scenario: B.P (physical table

[jira] [Created] (PHOENIX-3010) Allow optional rolling restart for major release

2016-06-20 Thread James Taylor (JIRA)
James Taylor created PHOENIX-3010: - Summary: Allow optional rolling restart for major release Key: PHOENIX-3010 URL: https://issues.apache.org/jira/browse/PHOENIX-3010 Project: Phoenix Issue

[jira] [Commented] (PHOENIX-3010) Allow optional rolling restart for major release

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340275#comment-15340275 ] James Taylor commented on PHOENIX-3010: --- It would be a client-side config that sim

[jira] [Commented] (PHOENIX-3010) Allow optional rolling restart for major release

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340289#comment-15340289 ] James Taylor commented on PHOENIX-3010: --- No, server would be upgrade, say to 5.0 f

[jira] [Commented] (PHOENIX-3010) Allow optional rolling restart for major release

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3010?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340405#comment-15340405 ] James Taylor commented on PHOENIX-3010: --- Ah, yes, you're right. We'd need to do th

[jira] [Commented] (PHOENIX-2999) Upgrading Multi-tenant table to map with namespace using upgradeUtil

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340440#comment-15340440 ] James Taylor commented on PHOENIX-2999: --- No problem, [~an...@apache.org]. So do we

[jira] [Commented] (PHOENIX-3011) Fix missing apache licenses

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340629#comment-15340629 ] James Taylor commented on PHOENIX-3011: --- +1 > Fix missing apache licenses > -

[jira] [Updated] (PHOENIX-3009) Estimated Size for PTable is ~20% greater than actual size

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3009: -- Attachment: PHOENIX-3009.patch Here's a patch that adjusts the size calculations with some fie

[jira] [Updated] (PHOENIX-2995) Write performance severely degrades with large number of views

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2995: -- Assignee: Thomas D'Silva (was: James Taylor) > Write performance severely degrades with large

[jira] [Commented] (PHOENIX-2995) Write performance severely degrades with large number of views

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340838#comment-15340838 ] James Taylor commented on PHOENIX-2995: --- FYI, stats are now cached outside of PTab

[jira] [Updated] (PHOENIX-2995) Write performance severely degrades with large number of views

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2995: -- Fix Version/s: 4.9.0 > Write performance severely degrades with large number of views > -

[jira] [Commented] (PHOENIX-3012) DistinctPrefixFilter logic fails with local indexes

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340951#comment-15340951 ] James Taylor commented on PHOENIX-3012: --- To take into account local indexes, see S

[jira] [Commented] (PHOENIX-2995) Write performance severely degrades with large number of views

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2995?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340957#comment-15340957 ] James Taylor commented on PHOENIX-2995: --- One other pretty easy thing to do would b

[jira] [Commented] (PHOENIX-2792) Enable Kerberos auth over SPNEGO for QueryServer

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340992#comment-15340992 ] James Taylor commented on PHOENIX-2792: --- +1. LGTM (assuming you did manual testing

[jira] [Commented] (PHOENIX-3002) Upgrading to 4.8 doesn't recreate local indexes

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341001#comment-15341001 ] James Taylor commented on PHOENIX-3002: --- Minor nit, no need for the null check her

[jira] [Commented] (PHOENIX-3012) DistinctPrefixFilter logic fails with local indexes and salted tables

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341059#comment-15341059 ] James Taylor commented on PHOENIX-3012: --- The caller of {{ScanUtil.setRowKeyOffset(

[jira] [Updated] (PHOENIX-3013) TO_CHAR fails to handle indexed null value

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3013: -- Fix Version/s: 4.8.0 > TO_CHAR fails to handle indexed null value > --

[jira] [Commented] (PHOENIX-3013) TO_CHAR fails to handle indexed null value

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341060#comment-15341060 ] James Taylor commented on PHOENIX-3013: --- +1. Would you mind getting this into 4.8

[jira] [Commented] (PHOENIX-3013) TO_CHAR fails to handle indexed null value

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341074#comment-15341074 ] James Taylor commented on PHOENIX-3013: --- [~samarthjain] - would you mind reviewing

[jira] [Commented] (PHOENIX-3012) DistinctPrefixFilter logic fails with local indexes and salted tables

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341122#comment-15341122 ] James Taylor commented on PHOENIX-3012: --- Not sure if you meant to do this rather t

[jira] [Commented] (PHOENIX-3012) DistinctPrefixFilter logic fails with local indexes and salted tables

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341139#comment-15341139 ] James Taylor commented on PHOENIX-3012: --- Mujtaba wasn't sure which commit yet. >

[jira] [Commented] (PHOENIX-2993) Tephra: Prune invalid transaction set once all data for a given invalid transaction has been dropped

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2993?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341159#comment-15341159 ] James Taylor commented on PHOENIX-2993: --- Thanks for the excellent design doc, [~po

[jira] [Commented] (PHOENIX-3012) DistinctPrefixFilter logic fails with local indexes and salted tables

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341163#comment-15341163 ] James Taylor commented on PHOENIX-3012: --- Touch base with Mujtaba tomorrow - it mig

[jira] [Commented] (PHOENIX-3012) DistinctPrefixFilter logic fails with local indexes and salted tables

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341169#comment-15341169 ] James Taylor commented on PHOENIX-3012: --- And sorry for the bugs - as you've witnes

[jira] [Commented] (PHOENIX-3012) DistinctPrefixFilter logic fails with local indexes and salted tables

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341191#comment-15341191 ] James Taylor commented on PHOENIX-3012: --- Never mind on my idea for a fix. The rows

[jira] [Commented] (PHOENIX-3012) DistinctPrefixFilter logic fails with local indexes and salted tables

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341224#comment-15341224 ] James Taylor commented on PHOENIX-3012: --- isReverse is true when {{plan.getOrderBy(

[jira] [Commented] (PHOENIX-3014) SELECT DISTINCT pk ORDER BY pk DESC gives the wrong results

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341226#comment-15341226 ] James Taylor commented on PHOENIX-3014: --- See comment here: https://issues.apache.

[jira] [Commented] (PHOENIX-3012) DistinctPrefixFilter logic fails with local indexes and salted tables

2016-06-20 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341248#comment-15341248 ] James Taylor commented on PHOENIX-3012: --- FWIW, my idea for a fix could just be don

[jira] [Updated] (PHOENIX-3014) SELECT DISTINCT pk ORDER BY pk DESC gives the wrong results

2016-06-21 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3014: -- Attachment: PHOENIX-3014_untested.patch [~lhofhansl] - here's an untested patch. > SELECT DIS

[jira] [Updated] (PHOENIX-3014) SELECT DISTINCT pk ORDER BY pk DESC gives the wrong results

2016-06-21 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3014: -- Fix Version/s: 4.8.0 > SELECT DISTINCT pk ORDER BY pk DESC gives the wrong results > -

[jira] [Commented] (PHOENIX-3014) SELECT DISTINCT pk ORDER BY pk DESC gives the wrong results

2016-06-21 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341701#comment-15341701 ] James Taylor commented on PHOENIX-3014: --- [~samarthjain] - if Lars doesn't have tim

[jira] [Commented] (PHOENIX-3015) Any metadata changes may cause unpredictable result when local indexes are using

2016-06-21 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341717#comment-15341717 ] James Taylor commented on PHOENIX-3015: --- The drop of the local index should update

[jira] [Commented] (PHOENIX-3012) DistinctPrefixFilter logic fails with local indexes and salted tables

2016-06-21 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341841#comment-15341841 ] James Taylor commented on PHOENIX-3012: --- +1 > DistinctPrefixFilter logic fails wi

[jira] [Commented] (PHOENIX-3002) Upgrading to 4.8 doesn't recreate local indexes

2016-06-21 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15341994#comment-15341994 ] James Taylor commented on PHOENIX-3002: --- The init method still needs to open a con

[jira] [Commented] (PHOENIX-3016) NO_UPGRADE_ATTRIB on a PhoenixConnection shouldn't prevent opening of HConnection

2016-06-21 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15342034#comment-15342034 ] James Taylor commented on PHOENIX-3016: --- +1 > NO_UPGRADE_ATTRIB on a PhoenixConne

[jira] [Commented] (PHOENIX-2949) Fix estimated region size when checking for serial query

2016-06-23 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15346051#comment-15346051 ] James Taylor commented on PHOENIX-2949: --- +1. Would you mind checking this into 4.8

[jira] [Commented] (PHOENIX-3023) Slow performance when limit queries are executed in parallel by default

2016-06-24 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15348122#comment-15348122 ] James Taylor commented on PHOENIX-3023: --- Looks good, [~samarthjain]. Couple of que

[jira] [Commented] (PHOENIX-3027) Upserting rows to a table with a mutable index using a tenant specific connection fails

2016-06-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15349484#comment-15349484 ] James Taylor commented on PHOENIX-3027: --- Minor nit - can we move the calculation o

[jira] [Updated] (PHOENIX-3023) Slow performance when limit queries are executed in parallel by default

2016-06-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3023?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3023: -- Fix Version/s: 4.8.0 > Slow performance when limit queries are executed in parallel by default

[jira] [Commented] (PHOENIX-3023) Slow performance when limit queries are executed in parallel by default

2016-06-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3023?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15349491#comment-15349491 ] James Taylor commented on PHOENIX-3023: --- +1. Looks great, [~samarthjain]! > Slow

[jira] [Resolved] (PHOENIX-2664) Upgrade from 4.1.0 to 4.6.0 fails

2016-06-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-2664. --- Resolution: Invalid We only support upgrade for two minor releases back (see [1]). Going dir

[jira] [Commented] (PHOENIX-3025) CsvBulkloadTool is failing with java.lang.IncompatibleClassChangeError

2016-06-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15349605#comment-15349605 ] James Taylor commented on PHOENIX-3025: --- Would shading of HBase really only make s

[jira] [Commented] (PHOENIX-2902) Adjust PhoenixDatabaseMetadata#getSchemas query if namespaces are enabled

2016-06-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15350001#comment-15350001 ] James Taylor commented on PHOENIX-2902: --- Thanks for the patch, [~an...@apache.org]

[jira] [Commented] (PHOENIX-3018) Write local updates to region than HTable in master branch

2016-06-25 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3018?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15350006#comment-15350006 ] James Taylor commented on PHOENIX-3018: --- [~rajeshbabu] - this looks like the same

<    1   2   3   4   5   6   7   8   9   10   >