[jira] [Commented] (PHOENIX-2679) Implement column family schema structure in Calcite-Phoenix

2016-10-04 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15547766#comment-15547766 ] Maryann Xue commented on PHOENIX-2679: -- I'm implementing it using shadow tables, which means each

[jira] [Commented] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15547158#comment-15547158 ] James Taylor commented on PHOENIX-3347: --- +1 to change conformance to DEFAULT > Change conformance

[jira] [Commented] (PHOENIX-3265) Surround columns named date with double quotes

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15547152#comment-15547152 ] James Taylor commented on PHOENIX-3265: --- I'd recommend surrounding any reserved words in tests in

[jira] [Comment Edited] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15547105#comment-15547105 ] Eric Lomore edited comment on PHOENIX-3347 at 10/5/16 12:12 AM:

[jira] [Commented] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15547135#comment-15547135 ] James Taylor commented on PHOENIX-6: Would you mind filing a separate JIRA for your use case? If I

[jira] [Comment Edited] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15547105#comment-15547105 ] Eric Lomore edited comment on PHOENIX-3347 at 10/4/16 11:59 PM:

[jira] [Commented] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15547105#comment-15547105 ] Eric Lomore commented on PHOENIX-3347: -- {code}public boolean isFromRequired() Whether FROM clause

[jira] [Updated] (PHOENIX-3297) Combining an RVC query and a filter on a datatype smaller than 8 bytes causes an Illegal Data Exception

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3297: -- Fix Version/s: 4.9.0 > Combining an RVC query and a filter on a datatype smaller than 8 bytes

[jira] [Updated] (PHOENIX-3348) SELECT DISTINCT with a non-rowkey array and another column returns incorrect results

2016-10-04 Thread Julian Jaffe (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3348?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Jaffe updated PHOENIX-3348: -- Summary: SELECT DISTINCT with a non-rowkey array and another column returns incorrect results

[jira] [Updated] (PHOENIX-3297) Combining an RVC query and a filter on a datatype smaller than 8 bytes causes an Illegal Data Exception

2016-10-04 Thread Julian Jaffe (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Jaffe updated PHOENIX-3297: -- Affects Version/s: 4.8.0 > Combining an RVC query and a filter on a datatype smaller than 8

[jira] [Created] (PHOENIX-3348) SELECT DISTINCT with a non-rowkey array and an id returns incorrect results

2016-10-04 Thread Julian Jaffe (JIRA)
Julian Jaffe created PHOENIX-3348: - Summary: SELECT DISTINCT with a non-rowkey array and an id returns incorrect results Key: PHOENIX-3348 URL: https://issues.apache.org/jira/browse/PHOENIX-3348

[jira] [Commented] (PHOENIX-3265) Surround columns named date with double quotes

2016-10-04 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15547038#comment-15547038 ] Julian Hyde commented on PHOENIX-3265: -- CALCITE-1256 only applies if the name is ALSO a built-in

[jira] [Commented] (PHOENIX-3265) Surround columns named date with double quotes

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15547013#comment-15547013 ] Eric Lomore commented on PHOENIX-3265: -- https://issues.apache.org/jira/browse/CALCITE-1256 It seems

[jira] [Comment Edited] (PHOENIX-3265) Surround columns named date with double quotes

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546993#comment-15546993 ] Eric Lomore edited comment on PHOENIX-3265 at 10/4/16 11:16 PM: I tried

[jira] [Comment Edited] (PHOENIX-3265) Surround columns named date with double quotes

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546993#comment-15546993 ] Eric Lomore edited comment on PHOENIX-3265 at 10/4/16 11:17 PM: I tried

[jira] [Commented] (PHOENIX-3265) Surround columns named date with double quotes

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546993#comment-15546993 ] Eric Lomore commented on PHOENIX-3265: -- I tried a few things. Fixing this for create table/view is

[jira] [Comment Edited] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread Cameron Hatfield (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546874#comment-15546874 ] Cameron Hatfield edited comment on PHOENIX-6 at 10/4/16 10:56 PM: -- For the

Re: [DISCUSS] Making upgrade to a new minor release a manual step

2016-10-04 Thread Josh Elser
+1 to the idea. Automatic upgrades on your behalf with knowledge can be scary. But, let me pose a hypothetical: say I upgrade from Phoenix X to Phoenix Y. I have some application that using Phoenix X and I want to make sure that before I finish my upgrade to Phoenix Y that things are "OK". It

[jira] [Commented] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread Cameron Hatfield (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546874#comment-15546874 ] Cameron Hatfield commented on PHOENIX-6: For the help with my use case question, not really, due to

[jira] [Comment Edited] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread Cameron Hatfield (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546874#comment-15546874 ] Cameron Hatfield edited comment on PHOENIX-6 at 10/4/16 10:34 PM: -- For the

[jira] [Commented] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546680#comment-15546680 ] James Taylor commented on PHOENIX-6: With Phoenix, for non transactional tables, the updates to the

[jira] [Commented] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread Cameron Hatfield (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546605#comment-15546605 ] Cameron Hatfield commented on PHOENIX-6: Ahh, I saw where I was getting confused. I thought that

[jira] [Commented] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546487#comment-15546487 ] James Taylor commented on PHOENIX-6: Yes, agreed, [~cameron.hatfield]. If these two statements are in

[jira] [Comment Edited] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread Cameron Hatfield (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15543705#comment-15543705 ] Cameron Hatfield edited comment on PHOENIX-6 at 10/4/16 7:45 PM: - At what

[jira] [Comment Edited] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread Cameron Hatfield (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546436#comment-15546436 ] Cameron Hatfield edited comment on PHOENIX-6 at 10/4/16 7:43 PM: - Except,

[jira] [Commented] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread Cameron Hatfield (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546436#comment-15546436 ] Cameron Hatfield commented on PHOENIX-6: Except, in the second case (two statements, same batch),

[jira] [Commented] (PHOENIX-3265) Surround columns named date with double quotes

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546346#comment-15546346 ] James Taylor commented on PHOENIX-3265: --- How about this? {{SELECT k1 FROM t WHERE "DATE" >=

[jira] [Comment Edited] (PHOENIX-3265) Surround columns named date with double quotes

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546325#comment-15546325 ] Eric Lomore edited comment on PHOENIX-3265 at 10/4/16 7:04 PM: --- An

[jira] [Commented] (PHOENIX-3265) Surround columns named date with double quotes

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546325#comment-15546325 ] Eric Lomore commented on PHOENIX-3265: -- An interrelated issue is the following SQL select satement

[jira] [Commented] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546291#comment-15546291 ] James Taylor commented on PHOENIX-3347: --- We'll need to change to a conformance that allows SELECT

[jira] [Updated] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3347: - Description: Current conformance settings do not allow SELECT statements without a FROM

[jira] [Commented] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-10-04 Thread Hadoop QA (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546279#comment-15546279 ] Hadoop QA commented on PHOENIX-3181: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Updated] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3347: - Description: Current conformance settings do not allow SELECT statements without a FROM

[jira] [Updated] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3347: - Description: Current conformance settings do not allow SELECT statements without a FROM clause

[jira] [Updated] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3347: - Description: Current conformance settings do not allow SELECT statements without a FROM clause

[jira] [Updated] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3347: - Description: Current conformance settings do not allow SELECT statements without a FROM clause

[jira] [Updated] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3347: - Description: Current conformance settings do not allow SELECT statements without a FROM clause

[jira] [Updated] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3347: - Description: Current conformance settings do not allow SELECT statements without a FROM clause

[jira] [Assigned] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore reassigned PHOENIX-3347: Assignee: Eric Lomore > Change conformance or remove SELECT statements without FROM

[jira] [Updated] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3347: - Description: Current conformance settings do not allow SELECT statements without a FROM clause

[jira] [Updated] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3347: - Description: Current conformance settings do not allow SELECT statements without a FROM clause

[jira] [Updated] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3347?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3347: - Description: Current conformance settings do not allow SELECT statements without a FROM clause

[jira] [Created] (PHOENIX-3347) Change conformance or remove SELECT statements without FROM clauses

2016-10-04 Thread Eric Lomore (JIRA)
Eric Lomore created PHOENIX-3347: Summary: Change conformance or remove SELECT statements without FROM clauses Key: PHOENIX-3347 URL: https://issues.apache.org/jira/browse/PHOENIX-3347 Project:

[jira] [Commented] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546218#comment-15546218 ] James Taylor commented on PHOENIX-6: The UPSERT VALUES ... ON DUPLICATE KEY will be evaluated on the

[jira] [Commented] (PHOENIX-2548) Local Indexing Not Looks Like Working As Expected

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546191#comment-15546191 ] James Taylor commented on PHOENIX-2548: --- I tried the above in 4.8.0 release and got the following

[jira] [Comment Edited] (PHOENIX-6) Support ON DUPLICATE KEY construct

2016-10-04 Thread Cameron Hatfield (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-6?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15543705#comment-15543705 ] Cameron Hatfield edited comment on PHOENIX-6 at 10/4/16 6:01 PM: - At what

[jira] [Commented] (PHOENIX-3265) Surround columns named date with double quotes

2016-10-04 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546136#comment-15546136 ] Eric Lomore commented on PHOENIX-3265: -- Another keyword experiencing the same issue is {{dec}}. >

[jira] [Commented] (PHOENIX-2548) Local Indexing Not Looks Like Working As Expected

2016-10-04 Thread Jacobo Coll (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2548?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15546130#comment-15546130 ] Jacobo Coll commented on PHOENIX-2548: -- Hi there, Is there any progress on this? I had also the

[jira] [Updated] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3181: -- Attachment: PHOENIX-3181_v2.patch Passed twice, trying one more time to make sure. > Run

[jira] [Updated] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3181: -- Attachment: (was: PHOENIX-3181_v2.patch) > Run test methods in parallel to reduce test

[jira] [Commented] (PHOENIX-2827) Support OFFSET in Calcite-Phoenix

2016-10-04 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15545942#comment-15545942 ] ASF GitHub Bot commented on PHOENIX-2827: - Github user lomoree closed the pull request at:

[GitHub] phoenix pull request #213: PHOENIX-2827 Support OFFSET in Calcite-Phoenix

2016-10-04 Thread lomoree
Github user lomoree closed the pull request at: https://github.com/apache/phoenix/pull/213 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is

[jira] [Commented] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-10-04 Thread Hadoop QA (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15544679#comment-15544679 ] Hadoop QA commented on PHOENIX-3181: {color:red}-1 overall{color}. Here are the results of testing

[jira] [Updated] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3181: -- Attachment: PHOENIX-3181_v2.patch > Run test methods in parallel to reduce test suite run

[jira] [Updated] (PHOENIX-3181) Run test methods in parallel to reduce test suite run time

2016-10-04 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3181: -- Attachment: (was: PHOENIX-3181_v2.patch) > Run test methods in parallel to reduce test

[jira] [Commented] (PHOENIX-2948) Snapshot support for Phoenix Tables

2016-10-04 Thread Sergey Soldatov (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-2948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15544486#comment-15544486 ] Sergey Soldatov commented on PHOENIX-2948: -- I suggest to improve this approach to not only