[jira] [Created] (PHOENIX-1063) Filtering by a value doesn't filter the NULL values in Phoenix 4.0.0

2014-07-08 Thread Puneet (JIRA)
Puneet created PHOENIX-1063: --- Summary: Filtering by a value doesn't filter the NULL values in Phoenix 4.0.0 Key: PHOENIX-1063 URL: https://issues.apache.org/jira/browse/PHOENIX-1063 Project: Phoenix

[jira] [Commented] (PHOENIX-1055) Add support for the built-in functions HEX, OCT, and BIN

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14054615#comment-14054615 ] James Taylor commented on PHOENIX-1055: --- Thanks for the patch, [~kbuzsaki]. Would

[jira] [Commented] (PHOENIX-1002) Add support for % operator

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14054632#comment-14054632 ] James Taylor commented on PHOENIX-1002: --- Thanks for the patch, [~kbuzsaki]. Same c

[jira] [Comment Edited] (PHOENIX-1002) Add support for % operator

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14054632#comment-14054632 ] James Taylor edited comment on PHOENIX-1002 at 7/8/14 8:20 AM: ---

[jira] [Commented] (PHOENIX-539) Implement parallel scanner that does not spool to disk

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14054651#comment-14054651 ] James Taylor commented on PHOENIX-539: -- The lease timeout is a different issue, I be

[jira] [Commented] (PHOENIX-539) Implement parallel scanner that does not spool to disk

2014-07-08 Thread Lars Hofhansl (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14054650#comment-14054650 ] Lars Hofhansl commented on PHOENIX-539: --- Lemme look at the patch in a bit. The app

[jira] [Created] (PHOENIX-1065) In order by case, I think nulls last will be default

2014-07-08 Thread jay wong (JIRA)
jay wong created PHOENIX-1065: - Summary: In order by case, I think nulls last will be default Key: PHOENIX-1065 URL: https://issues.apache.org/jira/browse/PHOENIX-1065 Project: Phoenix Issue Type

[jira] [Created] (PHOENIX-1064) In order by case, I think nulls last will be default

2014-07-08 Thread jay wong (JIRA)
jay wong created PHOENIX-1064: - Summary: In order by case, I think nulls last will be default Key: PHOENIX-1064 URL: https://issues.apache.org/jira/browse/PHOENIX-1064 Project: Phoenix Issue Type

[jira] [Updated] (PHOENIX-1064) In order by case, I think nulls last will be default

2014-07-08 Thread jay wong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jay wong updated PHOENIX-1064: -- Description: 1. jdbc:phoenix:ip:/hbase-phoenix-l> select * from testorder; |PK1 |COL1

[jira] [Created] (PHOENIX-1066) CLONE - In order by case, I think nulls last will be default

2014-07-08 Thread jay wong (JIRA)
jay wong created PHOENIX-1066: - Summary: CLONE - In order by case, I think nulls last will be default Key: PHOENIX-1066 URL: https://issues.apache.org/jira/browse/PHOENIX-1066 Project: Phoenix I

[jira] [Updated] (PHOENIX-1064) In order by case, I think nulls last will be default

2014-07-08 Thread jay wong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jay wong updated PHOENIX-1064: -- Attachment: PHOENIX-1064.patch > In order by case, I think nulls last will be default > -

[jira] [Commented] (PHOENIX-539) Implement parallel scanner that does not spool to disk

2014-07-08 Thread Gabriel Reid (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14054914#comment-14054914 ] Gabriel Reid commented on PHOENIX-539: -- {quote}The lease timeout is a different issu

[jira] [Commented] (PHOENIX-539) Implement parallel scanner that does not spool to disk

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055009#comment-14055009 ] James Taylor commented on PHOENIX-539: -- Thanks for the explanation, [~gabriel.reid].

[jira] [Commented] (PHOENIX-1061) PhoenixSQLParser can't handle Long.MIN_VALUE (-9223372036854775808) as a literal.

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055036#comment-14055036 ] James Taylor commented on PHOENIX-1061: --- Related to PHOENIX-385. The reason is tha

[jira] [Resolved] (PHOENIX-1063) Filtering by a value doesn't filter the NULL values in Phoenix 4.0.0

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-1063. --- Resolution: Duplicate Duplicate of PHOENIX-1057. Please let us know if you can repro this o

[jira] [Resolved] (PHOENIX-1065) In order by case, I think nulls last will be default

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-1065. --- Resolution: Duplicate Duplicate of PHOENIX-1064 > In order by case, I think nulls last wil

[jira] [Resolved] (PHOENIX-1066) CLONE - In order by case, I think nulls last will be default

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-1066. --- Resolution: Fixed Duplicate of PHOENIX-1064 > CLONE - In order by case, I think nulls last

[jira] [Updated] (PHOENIX-1064) Change default of ORDER BY so that nulls sort last

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1064: -- Fix Version/s: 5.0.0 Summary: Change default of ORDER BY so that nulls sort last (w

[jira] [Commented] (PHOENIX-1056) A ImportTsv tool for phoenix to build table data and all index data.

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055150#comment-14055150 ] James Taylor commented on PHOENIX-1056: --- What functionality does this add above an

[jira] [Closed] (PHOENIX-952) Support ANY and ALL built-ins for ARRAYs

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor closed PHOENIX-952. > Support ANY and ALL built-ins for ARRAYs > > >

[jira] [Commented] (PHOENIX-1062) A SQL Trimmer for log sql execute times

2014-07-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055158#comment-14055158 ] James Taylor commented on PHOENIX-1062: --- Can you explain the use case for needing

[jira] [Created] (PHOENIX-1067) Add documentation for ANY/ALL support with arrays

2014-07-08 Thread James Taylor (JIRA)
James Taylor created PHOENIX-1067: - Summary: Add documentation for ANY/ALL support with arrays Key: PHOENIX-1067 URL: https://issues.apache.org/jira/browse/PHOENIX-1067 Project: Phoenix Issue

[jira] [Updated] (PHOENIX-1055) Add support for the built-in functions HEX, OCT, and BIN

2014-07-08 Thread Kyle Buzsaki (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1055?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kyle Buzsaki updated PHOENIX-1055: -- Attachment: PHOENIX-1055_2.patch I'm working on integrating the ENCODE built-in and the new b

[jira] [Created] (PHOENIX-1068) Add Support for MOD built-in function.

2014-07-08 Thread Kyle Buzsaki (JIRA)
Kyle Buzsaki created PHOENIX-1068: - Summary: Add Support for MOD built-in function. Key: PHOENIX-1068 URL: https://issues.apache.org/jira/browse/PHOENIX-1068 Project: Phoenix Issue Type: Bug

[jira] [Updated] (PHOENIX-1068) Add Support for MOD built-in function.

2014-07-08 Thread Kyle Buzsaki (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kyle Buzsaki updated PHOENIX-1068: -- Attachment: PHOENIX-1068 Updated patch from the modulus operator issue found here: https://i

[jira] [Comment Edited] (PHOENIX-1068) Add Support for MOD built-in function.

2014-07-08 Thread Kyle Buzsaki (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055298#comment-14055298 ] Kyle Buzsaki edited comment on PHOENIX-1068 at 7/8/14 6:50 PM: ---

[jira] [Commented] (PHOENIX-1002) Add support for % operator

2014-07-08 Thread Kyle Buzsaki (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055308#comment-14055308 ] Kyle Buzsaki commented on PHOENIX-1002: --- Updated patch for modulus function has be

[jira] [Updated] (PHOENIX-1068) Add Support for MOD built-in function.

2014-07-08 Thread Kyle Buzsaki (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kyle Buzsaki updated PHOENIX-1068: -- Issue Type: New Feature (was: Bug) > Add Support for MOD built-in function. > --

[jira] [Resolved] (PHOENIX-539) Implement parallel scanner that does not spool to disk

2014-07-08 Thread Gabriel Reid (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gabriel Reid resolved PHOENIX-539. -- Resolution: Fixed Fix Version/s: 4.1 3.1 5.0.0

[jira] [Commented] (PHOENIX-1056) A ImportTsv tool for phoenix to build table data and all index data.

2014-07-08 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055387#comment-14055387 ] Jeffrey Zhong commented on PHOENIX-1056: Oh, I'm late to see the JIRA. I had a d

[jira] [Created] (PHOENIX-1069) Improve CsvBulkLoadTool to build indexes when loading data.

2014-07-08 Thread Jeffrey Zhong (JIRA)
Jeffrey Zhong created PHOENIX-1069: -- Summary: Improve CsvBulkLoadTool to build indexes when loading data. Key: PHOENIX-1069 URL: https://issues.apache.org/jira/browse/PHOENIX-1069 Project: Phoenix

[jira] [Created] (PHOENIX-1070) Update website instructions for using Squirrel (and other SQL tools)

2014-07-08 Thread Gabriel Reid (JIRA)
Gabriel Reid created PHOENIX-1070: - Summary: Update website instructions for using Squirrel (and other SQL tools) Key: PHOENIX-1070 URL: https://issues.apache.org/jira/browse/PHOENIX-1070 Project: Pho

[jira] [Commented] (PHOENIX-539) Implement parallel scanner that does not spool to disk

2014-07-08 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055404#comment-14055404 ] Hudson commented on PHOENIX-539: SUCCESS: Integrated in Phoenix | Master | Hadoop1 #262 (

[jira] [Commented] (PHOENIX-539) Implement parallel scanner that does not spool to disk

2014-07-08 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055412#comment-14055412 ] Hudson commented on PHOENIX-539: SUCCESS: Integrated in Phoenix | 3.0 | Hadoop1 #126 (See

[jira] [Updated] (PHOENIX-1069) Improve CsvBulkLoadTool to build indexes when loading data.

2014-07-08 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeffrey Zhong updated PHOENIX-1069: --- Attachment: phoenix-1069.patch This is the patch I mentioned phoenix-1056 which is much sim

[jira] [Created] (PHOENIX-1071) Provide integration for exposing Phoenix tables as Spark RDDs

2014-07-08 Thread Andrew Purtell (JIRA)
Andrew Purtell created PHOENIX-1071: --- Summary: Provide integration for exposing Phoenix tables as Spark RDDs Key: PHOENIX-1071 URL: https://issues.apache.org/jira/browse/PHOENIX-1071 Project: Phoeni

[jira] [Updated] (PHOENIX-1071) Provide integration for exposing Phoenix tables as Spark RDDs

2014-07-08 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1071?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Purtell updated PHOENIX-1071: Description: A core concept of Apache Spark is the resilient distributed dataset (RDD), a

[jira] [Updated] (PHOENIX-1002) Add support for % operator

2014-07-08 Thread Kyle Buzsaki (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kyle Buzsaki updated PHOENIX-1002: -- Attachment: PHOENIX-1002_2.patch I tried my hand at a very rough implementation of the modulu

[jira] [Commented] (PHOENIX-1002) Add support for % operator

2014-07-08 Thread Kyle Buzsaki (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055670#comment-14055670 ] Kyle Buzsaki commented on PHOENIX-1002: --- A little more testing from sqlline shows

[jira] [Commented] (PHOENIX-1016) Support MINVALUE, MAXVALUE, and CYCLE options in CREATE SEQUENCE

2014-07-08 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055744#comment-14055744 ] Thomas D'Silva commented on PHOENIX-1016: - James, I have attached a patch for t

[jira] [Updated] (PHOENIX-1016) Support MINVALUE, MAXVALUE, and CYCLE options in CREATE SEQUENCE

2014-07-08 Thread Thomas D'Silva (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas D'Silva updated PHOENIX-1016: Attachment: PHOENIX-1016.patch PHOENIX-1016.3.0.patch > Support MINVALUE,

[jira] [Created] (PHOENIX-1072) Fast fail sqlline.py when pass wrong quorum string or hbase cluster hasnt' started yet

2014-07-08 Thread Jeffrey Zhong (JIRA)
Jeffrey Zhong created PHOENIX-1072: -- Summary: Fast fail sqlline.py when pass wrong quorum string or hbase cluster hasnt' started yet Key: PHOENIX-1072 URL: https://issues.apache.org/jira/browse/PHOENIX-1072

[jira] [Updated] (PHOENIX-1072) Fast fail sqlline.py when pass wrong quorum string or hbase cluster hasnt' started yet

2014-07-08 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeffrey Zhong updated PHOENIX-1072: --- Attachment: phoenix-1072.patch During initialization, we use client retry=2 instead. > Fas

[jira] [Commented] (PHOENIX-1062) A SQL Trimmer for log sql execute times

2014-07-08 Thread jay wong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055756#comment-14055756 ] jay wong commented on PHOENIX-1062: --- [~jamestaylor] when any sql execute. just like

[jira] [Commented] (PHOENIX-1069) Improve CsvBulkLoadTool to build indexes when loading data.

2014-07-08 Thread jay wong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055789#comment-14055789 ] jay wong commented on PHOENIX-1069: --- Nice work. please upload the org.apache.hadoop.h

[jira] [Commented] (PHOENIX-1056) A ImportTsv tool for phoenix to build table data and all index data.

2014-07-08 Thread jay wong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055794#comment-14055794 ] jay wong commented on PHOENIX-1056: --- Yep. [~jeffreyz] The patch is a Alpha version. I

[jira] [Commented] (PHOENIX-1056) A ImportTsv tool for phoenix to build table data and all index data.

2014-07-08 Thread jay wong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14055809#comment-14055809 ] jay wong commented on PHOENIX-1056: --- [~jamestaylor] yes . It create both table data an

[jira] [Created] (PHOENIX-1073) A memory table in every region is needed?

2014-07-08 Thread jay wong (JIRA)
jay wong created PHOENIX-1073: - Summary: A memory table in every region is needed? Key: PHOENIX-1073 URL: https://issues.apache.org/jira/browse/PHOENIX-1073 Project: Phoenix Issue Type: Wish