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

2014-07-09 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14055974#comment-14055974 ] James Taylor commented on PHOENIX-1056: --- Thanks, [~jaywong]. That's a good

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

2014-07-09 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor reopened PHOENIX-1067: --- Thanks for the additional documentation - it looks good, [~ram_krish]. In your local svn

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

2014-07-09 Thread ramkrishna.s.vasudevan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056169#comment-14056169 ] ramkrishna.s.vasudevan commented on PHOENIX-1067: - Done. And now the

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

2014-07-09 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056217#comment-14056217 ] James Taylor commented on PHOENIX-1016: --- Thanks for the patch, [~tdsilva]. It's

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

2014-07-09 Thread Josh Mahonin (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056222#comment-14056222 ] Josh Mahonin commented on PHOENIX-1071: --- Hi Andrew, With the phoenix-pig module,

[jira] [Created] (PHOENIX-1074) ParallelIteratorRegionSplitterFactory get Splits is not rational

2014-07-09 Thread jay wong (JIRA)
jay wong created PHOENIX-1074: - Summary: ParallelIteratorRegionSplitterFactory get Splits is not rational Key: PHOENIX-1074 URL: https://issues.apache.org/jira/browse/PHOENIX-1074 Project: Phoenix

pull request for local indexes to go into master

2014-07-09 Thread James Taylor
Rajeshbabu has submitted a pull request for local indexes to go into master. It'd be great if a few other folks good give it a look: https://github.com/apache/phoenix/pull/1 @JeffreyZ? @Jesse? Thanks, James

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

2014-07-09 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1073?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056427#comment-14056427 ] James Taylor commented on PHOENIX-1073: --- Probably best to start on the dev list to

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

2014-07-09 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-1073. --- Resolution: Invalid A memory table in every region is needed?

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

2014-07-09 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056430#comment-14056430 ] James Taylor commented on PHOENIX-1062: --- I don't think universally every one would

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

2014-07-09 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1055?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056436#comment-14056436 ] James Taylor commented on PHOENIX-1055: --- It kind of a nice to have for every

[jira] [Created] (PHOENIX-1075) Mathematical order of operations are improperly evaluated.

2014-07-09 Thread Kyle Buzsaki (JIRA)
Kyle Buzsaki created PHOENIX-1075: - Summary: Mathematical order of operations are improperly evaluated. Key: PHOENIX-1075 URL: https://issues.apache.org/jira/browse/PHOENIX-1075 Project: Phoenix

[jira] [Commented] (PHOENIX-1075) Mathematical order of operations are improperly evaluated.

2014-07-09 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056468#comment-14056468 ] James Taylor commented on PHOENIX-1075: --- Nice catch. There may be something in

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

2014-07-09 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056538#comment-14056538 ] Jeffrey Zhong commented on PHOENIX-1056: Other issues can be easily addressed

TO_UNSIGNED_DATE function missing in Phoenix

2014-07-09 Thread anil gupta
Hi All, Phoenix has a DataType Unsigned_Date but now i am unable to use these columns for filtering. For using a date column in sql query i can use to_date(). I think similarly we need to have to_unsigned_date function. I can file a jira for this. Can anyone guide me how to introduce this

[jira] [Created] (PHOENIX-1076) to_unsigned_date() function missing in sql of Phoenix

2014-07-09 Thread Anil Gupta (JIRA)
Anil Gupta created PHOENIX-1076: --- Summary: to_unsigned_date() function missing in sql of Phoenix Key: PHOENIX-1076 URL: https://issues.apache.org/jira/browse/PHOENIX-1076 Project: Phoenix

[jira] [Created] (PHOENIX-1077) IN list of row value constructors doesn't work for tenant specific views

2014-07-09 Thread Samarth Jain (JIRA)
Samarth Jain created PHOENIX-1077: - Summary: IN list of row value constructors doesn't work for tenant specific views Key: PHOENIX-1077 URL: https://issues.apache.org/jira/browse/PHOENIX-1077

Re: TO_UNSIGNED_DATE function missing in Phoenix

2014-07-09 Thread James Taylor
Hi Anil, Try using CAST to explicitly cast the result to an unsigned date, like this: CAST(TO_DATE(someDate) AS UNSIGNED_DATE) Thanks, James On Wed, Jul 9, 2014 at 8:38 PM, anil gupta anilgupt...@gmail.com wrote: Hi All, Phoenix has a DataType Unsigned_Date but now i am unable to use these

[jira] [Commented] (PHOENIX-1076) to_unsigned_date() function missing in sql of Phoenix

2014-07-09 Thread Anil Gupta (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1076?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056606#comment-14056606 ] Anil Gupta commented on PHOENIX-1076: - [~jamestaylor]: Can you provide me high level

Re: TO_UNSIGNED_DATE function missing in Phoenix

2014-07-09 Thread anil gupta
Hi James, I tried following query: select * from events where dummy_date=CAST(TO_DATE('2012-12-23', '-MM-dd') AS UNSIGNED_DATE) and id='1234' limit 50; But, i get following error: Error: ERROR 602 (42P00): Syntax error. Missing LPAREN at line 1, column 30. (state=42P00,code=602) Can you tell

[jira] [Commented] (PHOENIX-938) Use higher priority queue for index updates to prevent deadlock

2014-07-09 Thread Jesse Yates (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056785#comment-14056785 ] Jesse Yates commented on PHOENIX-938: - Started looking at this today at first,

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

2014-07-09 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1071?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056796#comment-14056796 ] Andrew Purtell commented on PHOENIX-1071: - Thanks [~jmahonin], good point, we

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

2014-07-09 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),

[jira] [Commented] (PHOENIX-938) Use higher priority queue for index updates to prevent deadlock

2014-07-09 Thread Andrew Purtell (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056818#comment-14056818 ] Andrew Purtell commented on PHOENIX-938: I linked over to HBASE-11355 with a

[jira] [Commented] (PHOENIX-938) Use higher priority queue for index updates to prevent deadlock

2014-07-09 Thread Jesse Yates (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056848#comment-14056848 ] Jesse Yates commented on PHOENIX-938: - Thanks Andy! Perhaps just a bit tired today to

Re: TO_UNSIGNED_DATE function missing in Phoenix

2014-07-09 Thread James Taylor
Yes, that should work. Look like bugs to me. On Wednesday, July 9, 2014, anil gupta anilgupt...@gmail.com wrote: Hi James, I am using Phoenix3.0 along with HBase0.94.15. Do you mean to say that this query should work even if dummy_date is unsigned_date? select * from events where

[jira] [Created] (PHOENIX-1078) Unable to run pig script with Phoenix.

2014-07-09 Thread Anil Gupta (JIRA)
Anil Gupta created PHOENIX-1078: --- Summary: Unable to run pig script with Phoenix. Key: PHOENIX-1078 URL: https://issues.apache.org/jira/browse/PHOENIX-1078 Project: Phoenix Issue Type: Bug

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

2014-07-09 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1069?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14056910#comment-14056910 ] Hudson commented on PHOENIX-1069: - SUCCESS: Integrated in Phoenix | Master | Hadoop1

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

2014-07-09 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeffrey Zhong reassigned PHOENIX-1069: -- Assignee: Jeffrey Zhong Improve CsvBulkLoadTool to build indexes when loading data.

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

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

[jira] [Assigned] (PHOENIX-1077) IN list of row value constructors doesn't work for tenant specific views

2014-07-09 Thread Eli Levine (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eli Levine reassigned PHOENIX-1077: --- Assignee: Eli Levine IN list of row value constructors doesn't work for tenant specific

[jira] [Updated] (PHOENIX-1080) Fix PhoenixRuntime.decodepk for salted tables. Add integration tests.

2014-07-09 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Samarth Jain updated PHOENIX-1080: -- Attachment: encodeDecode_master_4.patch encodeDecode_master_4.patch - for master and 4.0

[jira] [Updated] (PHOENIX-1074) ParallelIteratorRegionSplitterFactory get Splits is not rational

2014-07-09 Thread jay wong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] jay wong updated PHOENIX-1074: -- Issue Type: Bug (was: Wish) ParallelIteratorRegionSplitterFactory get Splits is not rational

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

2014-07-09 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1056?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14057040#comment-14057040 ] Jeffrey Zhong commented on PHOENIX-1056: {quote} Sometimes build all the data in

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

2014-07-09 Thread Jeffrey Zhong (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeffrey Zhong reopened PHOENIX-1072: there are some test failures. Reopen it. Fast fail sqlline.py when pass wrong quorum

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

2014-07-09 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14057060#comment-14057060 ] Hudson commented on PHOENIX-1072: - SUCCESS: Integrated in Phoenix | 3.0 | Hadoop1 #129

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

2014-07-09 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14057061#comment-14057061 ] Hudson commented on PHOENIX-1072: - SUCCESS: Integrated in Phoenix | Master | Hadoop1