[jira] [Commented] (PHOENIX-2477) ClassCastException in IndexedWALEditCodec after HBASE-14501 (possible dataloss)

[ https://issues.apache.org/jira/browse/PHOENIX-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15041174#comment-15041174 ] Hudson commented on PHOENIX-2477: - FAILURE: Integrated in Phoenix-master #1002 (See [ht

[jira] [Commented] (PHOENIX-2455) Partial results for a query when PHOENIX-2194 is applied

[ https://issues.apache.org/jira/browse/PHOENIX-2455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15040810#comment-15040810 ] James Taylor commented on PHOENIX-2455: --- [~ankit.singhal] - thanks for reporting t

[jira] [Updated] (PHOENIX-2455) Partial results for a query when PHOENIX-2194 is applied

[ https://issues.apache.org/jira/browse/PHOENIX-2455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2455: -- Fix Version/s: 4.7.0 > Partial results for a query when PHOENIX-2194 is applied >

[jira] [Commented] (PHOENIX-2221) Option to make data regions not writable when index regions are not available

[ https://issues.apache.org/jira/browse/PHOENIX-2221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15040794#comment-15040794 ] James Taylor commented on PHOENIX-2221: --- Thinking about this a bit more, implement

[jira] [Commented] (PHOENIX-2221) Option to make data regions not writable when index regions are not available

[ https://issues.apache.org/jira/browse/PHOENIX-2221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15039763#comment-15039763 ] James Taylor commented on PHOENIX-2221: --- Thanks, [~ayingshu]. There's an issue wit

[jira] [Commented] (PHOENIX-2480) SQL Query with multiple projection selections over multiple tables having LEFT OUTER JOINS returns completely null for random columns even when data is present

[ https://issues.apache.org/jira/browse/PHOENIX-2480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15039728#comment-15039728 ] Maryann Xue commented on PHOENIX-2480: -- Sorry, [~vivek.kt], for my late response. D

[jira] [Commented] (PHOENIX-2477) ClassCastException in IndexedWALEditCodec after HBASE-14501 (possible dataloss)

[ https://issues.apache.org/jira/browse/PHOENIX-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15039722#comment-15039722 ] James Taylor commented on PHOENIX-2477: --- Thanks for checking in your fix, [~enis].

[jira] [Created] (PHOENIX-2488) Setting query timeout programmatically for DDL statements doesn't work

Samarth Jain created PHOENIX-2488: - Summary: Setting query timeout programmatically for DDL statements doesn't work Key: PHOENIX-2488 URL: https://issues.apache.org/jira/browse/PHOENIX-2488 Project: P

[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: Description: Phoenix uses SUBSTR whereas the ANSI SQL-92 standard is SUBSTRING. http://savage.net

[ANNOUNCE] Upcoming Apache Phoenix 4.7.0 release

I would like to volunteer to be the 4.7.0 Release Manager. We are thinking of cutting a RC for the 4.7.0 release the week of Dec 14, are folks ok with this? This is the list of JIRAs targeted to the 4.7.0 release https://issues.apache.org/jira/issues/?jql=project%20%3D%20PHOENIX%20AND%20resolution

[jira] [Updated] (PHOENIX-2487) Make queries fail faster

[ https://issues.apache.org/jira/browse/PHOENIX-2487?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-2487: -- Summary: Make queries fail faster (was: Use a completion service on the client to fetch scan

[jira] [Created] (PHOENIX-2487) Use a completion service on the client to fetch scan results

Samarth Jain created PHOENIX-2487: - Summary: Use a completion service on the client to fetch scan results Key: PHOENIX-2487 URL: https://issues.apache.org/jira/browse/PHOENIX-2487 Project: Phoenix

[jira] [Updated] (PHOENIX-2446) Immutable index - Index vs base table row count does not match when index is created during data load

[ https://issues.apache.org/jira/browse/PHOENIX-2446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2446: -- Fix Version/s: 4.7.0 > Immutable index - Index vs base table row count does not match when ind

[jira] [Updated] (PHOENIX-2478) Rows committed in transaction overlapping index creation are not populated

[ https://issues.apache.org/jira/browse/PHOENIX-2478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2478: -- Fix Version/s: 4.7.0 > Rows committed in transaction overlapping index creation are not popula

[jira] [Updated] (PHOENIX-2356) Set TRANSACTIONAL to true for derived views when transitioning to transactional table

[ https://issues.apache.org/jira/browse/PHOENIX-2356?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2356: -- Fix Version/s: 4.7.0 > Set TRANSACTIONAL to true for derived views when transitioning to > tr

[jira] [Updated] (PHOENIX-1901) Performance test transaction implementation

[ https://issues.apache.org/jira/browse/PHOENIX-1901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1901: -- Fix Version/s: 4.7.0 > Performance test transaction implementation > -

[jira] [Commented] (PHOENIX-2249) SYSTEM.STATS not update after region merge occurs.

[ https://issues.apache.org/jira/browse/PHOENIX-2249?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15038619#comment-15038619 ] James Taylor commented on PHOENIX-2249: --- Thanks for the patch, [~ankit.singhal]. L

[jira] [Updated] (PHOENIX-2249) SYSTEM.STATS not update after region merge occurs.

[ https://issues.apache.org/jira/browse/PHOENIX-2249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2249: -- Fix Version/s: 4.7.0 > SYSTEM.STATS not update after region merge occurs. > --

[jira] [Commented] (PHOENIX-2470) Skip overlapped scan left after StaleRegionBoundaryCacheException

[ https://issues.apache.org/jira/browse/PHOENIX-2470?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15038572#comment-15038572 ] James Taylor commented on PHOENIX-2470: --- [~ankit.singhal] - please spin up a patch

[jira] [Updated] (PHOENIX-2477) ClassCastException in IndexedWALEditCodec after HBASE-14501 (possible dataloss)

[ https://issues.apache.org/jira/browse/PHOENIX-2477?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2477: -- Fix Version/s: 4.7.0 > ClassCastException in IndexedWALEditCodec after HBASE-14501 (possible

[jira] [Resolved] (PHOENIX-2458) Refactoring tests that start the txn manager to use BaseOwnClusterIT

[ https://issues.apache.org/jira/browse/PHOENIX-2458?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva resolved PHOENIX-2458. - Resolution: Fixed > Refactoring tests that start the txn manager to use BaseOwnClusterIT

[jira] [Updated] (PHOENIX-2221) Option to make data regions not writable when index regions are not available

[ https://issues.apache.org/jira/browse/PHOENIX-2221?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2221: -- Fix Version/s: 4.7.0 > Option to make data regions not writable when index regions are not ava

[jira] [Created] (PHOENIX-2486) Document Phoenix's support for global and request/sql level client side metrics

Samarth Jain created PHOENIX-2486: - Summary: Document Phoenix's support for global and request/sql level client side metrics Key: PHOENIX-2486 URL: https://issues.apache.org/jira/browse/PHOENIX-2486 P

[jira] [Updated] (PHOENIX-2485) Expose number of open phoenix connections in global client metrics

[ https://issues.apache.org/jira/browse/PHOENIX-2485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-2485: -- Fix Version/s: 4.7.0 > Expose number of open phoenix connections in global client metrics > --

[jira] [Created] (PHOENIX-2485) Expose number of open phoenix connections in global client metrics

Samarth Jain created PHOENIX-2485: - Summary: Expose number of open phoenix connections in global client metrics Key: PHOENIX-2485 URL: https://issues.apache.org/jira/browse/PHOENIX-2485 Project: Phoen

[jira] [Created] (PHOENIX-2484) sqlline is spitting out too many loglines

Samarth Jain created PHOENIX-2484: - Summary: sqlline is spitting out too many loglines Key: PHOENIX-2484 URL: https://issues.apache.org/jira/browse/PHOENIX-2484 Project: Phoenix Issue Type:

[jira] [Updated] (PHOENIX-2481) JSON Bulkload Tool

[ https://issues.apache.org/jira/browse/PHOENIX-2481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2481: -- Fix Version/s: 4.7.0 > JSON Bulkload Tool > -- > > Key: PHOENI

[jira] [Updated] (PHOENIX-1261) Update stats table asynchronously

[ https://issues.apache.org/jira/browse/PHOENIX-1261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1261: -- Assignee: Samarth Jain > Update stats table asynchronously > -

[jira] [Updated] (PHOENIX-1261) Update stats table asynchronously

[ https://issues.apache.org/jira/browse/PHOENIX-1261?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1261: -- Fix Version/s: 4.7.0 > Update stats table asynchronously > - >

[jira] [Updated] (PHOENIX-2417) Compress memory used by row key byte[] of guideposts

[ https://issues.apache.org/jira/browse/PHOENIX-2417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2417: -- Assignee: Samarth Jain > Compress memory used by row key byte[] of guideposts > --

[jira] [Updated] (PHOENIX-1734) Local index improvements

[ https://issues.apache.org/jira/browse/PHOENIX-1734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1734: -- Fix Version/s: 4.7.0 > Local index improvements > > >

[jira] [Updated] (PHOENIX-2417) Compress memory used by row key byte[] of guideposts

[ https://issues.apache.org/jira/browse/PHOENIX-2417?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2417: -- Fix Version/s: 4.7.0 > Compress memory used by row key byte[] of guideposts >

[jira] [Commented] (PHOENIX-2475) Date arithmetic broken for time and timestamp

[ https://issues.apache.org/jira/browse/PHOENIX-2475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15038526#comment-15038526 ] James Taylor commented on PHOENIX-2475: --- Thanks, [~Dumindux] - FWIW, I'm 99% sure

[jira] [Updated] (PHOENIX-2408) Update statistics fails to complete

[ https://issues.apache.org/jira/browse/PHOENIX-2408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2408: -- Fix Version/s: 4.7.0 > Update statistics fails to complete > -

[jira] [Updated] (PHOENIX-2408) Update statistics fails to complete

[ https://issues.apache.org/jira/browse/PHOENIX-2408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2408: -- Assignee: Samarth Jain > Update statistics fails to complete > ---

[jira] [Updated] (PHOENIX-2475) Date arithmetic broken for time and timestamp

[ https://issues.apache.org/jira/browse/PHOENIX-2475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-2475: -- Fix Version/s: 4.7.0 > Date arithmetic broken for time and timestamp > ---

[jira] [Commented] (PHOENIX-2480) SQL Query with multiple projection selections over multiple tables having LEFT OUTER JOINS returns completely null for random columns even when data is present

[ https://issues.apache.org/jira/browse/PHOENIX-2480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15038170#comment-15038170 ] Vivek K T commented on PHOENIX-2480: [~maryannxue] Sorry for bothering much, could y

[jira] [Commented] (PHOENIX-2480) SQL Query with multiple projection selections over multiple tables having LEFT OUTER JOINS returns completely null for random columns even when data is present

[ https://issues.apache.org/jira/browse/PHOENIX-2480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15037901#comment-15037901 ] Vivek K T commented on PHOENIX-2480: [~maryannxue] I'm confused!!! I've downloaded t

[jira] [Commented] (PHOENIX-2480) SQL Query with multiple projection selections over multiple tables having LEFT OUTER JOINS returns completely null for random columns even when data is present

[ https://issues.apache.org/jira/browse/PHOENIX-2480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15037841#comment-15037841 ] Vivek K T commented on PHOENIX-2480: [~maryannxue] so this issue is fixed only in re

[jira] [Commented] (PHOENIX-2480) SQL Query with multiple projection selections over multiple tables having LEFT OUTER JOINS returns completely null for random columns even when data is present

[ https://issues.apache.org/jira/browse/PHOENIX-2480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15037851#comment-15037851 ] Maryann Xue commented on PHOENIX-2480: -- Yes, it will be included in the next Phoeni

[jira] [Commented] (PHOENIX-2480) SQL Query with multiple projection selections over multiple tables having LEFT OUTER JOINS returns completely null for random columns even when data is present

[ https://issues.apache.org/jira/browse/PHOENIX-2480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15037779#comment-15037779 ] Maryann Xue commented on PHOENIX-2480: -- No worries. Thanks for reporting this issue

[jira] [Updated] (PHOENIX-2480) SQL Query with multiple projection selections over multiple tables having LEFT OUTER JOINS returns completely null for random columns even when data is present

[ https://issues.apache.org/jira/browse/PHOENIX-2480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue updated PHOENIX-2480: - Fix Version/s: 4.7.0 > SQL Query with multiple projection selections over multiple tables having

[jira] [Resolved] (PHOENIX-2480) SQL Query with multiple projection selections over multiple tables having LEFT OUTER JOINS returns completely null for random columns even when data is present

[ https://issues.apache.org/jira/browse/PHOENIX-2480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue resolved PHOENIX-2480. -- Resolution: Fixed > SQL Query with multiple projection selections over multiple tables having

[jira] [Assigned] (PHOENIX-2475) Date arithmetic broken for time and timestamp

[ https://issues.apache.org/jira/browse/PHOENIX-2475?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dumindu Buddhika reassigned PHOENIX-2475: - Assignee: Dumindu Buddhika > Date arithmetic broken for time and timestamp > --

[jira] [Commented] (PHOENIX-2475) Date arithmetic broken for time and timestamp

[ https://issues.apache.org/jira/browse/PHOENIX-2475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15037758#comment-15037758 ] Dumindu Buddhika commented on PHOENIX-2475: --- Yes [~jamestaylor], I will take a

[jira] [Commented] (PHOENIX-2480) SQL Query with multiple projection selections over multiple tables having LEFT OUTER JOINS returns completely null for random columns even when data is present

[ https://issues.apache.org/jira/browse/PHOENIX-2480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15037679#comment-15037679 ] Vivek K T commented on PHOENIX-2480: [~maryannxue] Sorry about the priority, my mist