[jira] [Comment Edited] (PHOENIX-3510) Phoenix LIKE operator with bind parameters - Error -1 (00000) : while preparing SQL; Binded parameter in the SELECT clause

2016-12-01 Thread Bartlomiej Niemienionek (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15711239#comment-15711239 ] Bartlomiej Niemienionek edited comment on PHOENIX-3510 at 12/1/16 8:01 AM: ---

[GitHub] phoenix issue #222: PHOENIX-3355 Register Phoenix built-in functions as Calc...

2016-12-01 Thread lomoree
Github user lomoree commented on the issue: https://github.com/apache/phoenix/pull/222 1. There are still a number of cases that don't pass. Many of them are due to existing features not being supported, and many are due to other issues within Calcite-Phoenix. I have compiled a list o

[jira] [Commented] (PHOENIX-3355) Register Phoenix built-in functions as Calcite functions

2016-12-01 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15712402#comment-15712402 ] ASF GitHub Bot commented on PHOENIX-3355: - Github user lomoree commented on the

[jira] [Commented] (PHOENIX-3511) Async Secondary index MR job fails for large data > 200 M records

2016-12-01 Thread Loknath Priyatham Teja Singamsetty (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15712427#comment-15712427 ] Loknath Priyatham Teja Singamsetty commented on PHOENIX-3511: ---

[jira] [Comment Edited] (PHOENIX-3511) Async Secondary index MR job fails for large data > 200 M records

2016-12-01 Thread Loknath Priyatham Teja Singamsetty (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15712427#comment-15712427 ] Loknath Priyatham Teja Singamsetty edited comment on PHOENIX-3511 at 12/1/16 4:38 PM: --

[jira] [Updated] (PHOENIX-3511) Async Secondary index MR job fails for large data > 200 M records

2016-12-01 Thread Loknath Priyatham Teja Singamsetty (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Loknath Priyatham Teja Singamsetty updated PHOENIX-3511: - Attachment: phoenix-3511-v2.patch > Async Second

[jira] [Commented] (PHOENIX-3511) Async Secondary index MR job fails for large data > 200 M records

2016-12-01 Thread Loknath Priyatham Teja Singamsetty (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15712436#comment-15712436 ] Loknath Priyatham Teja Singamsetty commented on PHOENIX-3511: ---

[jira] [Commented] (PHOENIX-3511) Async Secondary index MR job fails for large data > 200 M records

2016-12-01 Thread Hadoop QA (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15712597#comment-15712597 ] Hadoop QA commented on PHOENIX-3511: {color:red}-1 overall{color}. Here are the res

Create multiple databases

2016-12-01 Thread Pramod Deshmukh
I am new bee to Phoenix and wondering if there is a way to create multiple databases and create role based access. We have a use case to have a muti-tenant environment on database level. Please suggest Thanks, Pramod

[jira] [Updated] (PHOENIX-3359) Update JDBC urls to match connection type

2016-12-01 Thread Eric Lomore (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3359?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Eric Lomore updated PHOENIX-3359: - Assignee: (was: Eric Lomore) > Update JDBC urls to match connection type > -

[jira] [Commented] (PHOENIX-3256) Support CREATE SCHEMA in Phoenix-Calcite Integration

2016-12-01 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15712787#comment-15712787 ] Maryann Xue commented on PHOENIX-3256: -- +1 to the patch. Thank you very much, [~raj

[jira] [Commented] (PHOENIX-3511) Async Secondary index MR job fails for large data > 200 M records

2016-12-01 Thread Samarth Jain (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713004#comment-15713004 ] Samarth Jain commented on PHOENIX-3511: --- [~singamteja], apologies for not being cl

Re: [VOTE] Release of Apache Phoenix 4.8.2 RC2

2016-12-01 Thread Josh Elser
Hey Lars, Is a +1 from yourself to be implied here (if not, anyone want to add one)? Would be nice to get this one out too. - Josh Thomas D'Silva wrote: +1 Ran integration tests. Ran some manual tests for indexes and transactions. On Wed, Nov 23, 2016 at 12:20 PM, Josh Elser wrote: +1 (

[ANNOUNCE] Apache Phoenix 4.9 released

2016-12-01 Thread James Taylor
Apache Phoenix enables OLTP and operational analytics for Apache Hadoop through SQL support using Apache HBase as its backing store and providing integration with other projects in the ecosystem such as Apache Spark, Apache Hive, Apache Pig, Apache Flume, and Apache MapReduce. We're pleased to ann

[GitHub] phoenix issue #222: PHOENIX-3355 Register Phoenix built-in functions as Calc...

2016-12-01 Thread maryannxue
Github user maryannxue commented on the issue: https://github.com/apache/phoenix/pull/222 No differentiation between the regex functions (String based and Byte based) -- Let's just add support for this one? Invert and MD5 Function don't work (phoenix doesn't supply the correct

[jira] [Commented] (PHOENIX-3355) Register Phoenix built-in functions as Calcite functions

2016-12-01 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713400#comment-15713400 ] ASF GitHub Bot commented on PHOENIX-3355: - Github user maryannxue commented on t

[GitHub] phoenix issue #222: PHOENIX-3355 Register Phoenix built-in functions as Calc...

2016-12-01 Thread lomoree
Github user lomoree commented on the issue: https://github.com/apache/phoenix/pull/222 1. No differentiation between the regex functions (String based and Byte based) Yep I'll try some approaches to make this work. 2. Invert and MD5 Function don't work (phoenix doesn't sup

[jira] [Commented] (PHOENIX-3355) Register Phoenix built-in functions as Calcite functions

2016-12-01 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713442#comment-15713442 ] ASF GitHub Bot commented on PHOENIX-3355: - Github user lomoree commented on the

[jira] [Commented] (PHOENIX-3488) Support COUNT(DISTINCT x) in Phoenix-Calcite Integration

2016-12-01 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713467#comment-15713467 ] ASF GitHub Bot commented on PHOENIX-3488: - Github user lomoree commented on a di

[GitHub] phoenix pull request #223: PHOENIX-3488 Support COUNT(DISTINCT x) in Phoenix...

2016-12-01 Thread lomoree
Github user lomoree commented on a diff in the pull request: https://github.com/apache/phoenix/pull/223#discussion_r90563623 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/calcite/rules/PhoenixConverterRules.java --- @@ -899,9 +899,6 @@ public static boolean isConvertible

[GitHub] phoenix issue #222: PHOENIX-3355 Register Phoenix built-in functions as Calc...

2016-12-01 Thread maryannxue
Github user maryannxue commented on the issue: https://github.com/apache/phoenix/pull/222 2. We'll leave it then. I think the future solution can be either 1) add as built-in funcs in Calcite; or 2) add type derivation mechanism for UDFs in Calcite. 3. See "getAdjustedTime" in Cal

[jira] [Commented] (PHOENIX-3355) Register Phoenix built-in functions as Calcite functions

2016-12-01 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713492#comment-15713492 ] ASF GitHub Bot commented on PHOENIX-3355: - Github user maryannxue commented on t

[jira] [Resolved] (PHOENIX-3488) Support COUNT(DISTINCT x) in Phoenix-Calcite Integration

2016-12-01 Thread Maryann Xue (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Maryann Xue resolved PHOENIX-3488. -- Resolution: Fixed > Support COUNT(DISTINCT x) in Phoenix-Calcite Integration > ---

[GitHub] phoenix pull request #223: PHOENIX-3488 Support COUNT(DISTINCT x) in Phoenix...

2016-12-01 Thread lomoree
Github user lomoree closed the pull request at: https://github.com/apache/phoenix/pull/223 --- 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 en

[jira] [Commented] (PHOENIX-3488) Support COUNT(DISTINCT x) in Phoenix-Calcite Integration

2016-12-01 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15713748#comment-15713748 ] ASF GitHub Bot commented on PHOENIX-3488: - Github user lomoree closed the pull r

about phoenix client configuration

2016-12-01 Thread Daniel Ding
hi, all: I’m using phoenix to write data and my jvm application always have too much threads (exceeds 700 threads. if include my own 400 threads’ pool, the threads in application sometimes will exceed 1200..). I’v found the phoenix-xxx-thread and HConnection is the main cause, so I tried to co

about phoenix client configuration

2016-12-01 Thread Daniel Ding
hi, all: I’m using phoenix to write data and my jvm application always have too much threads (exceeds 700 threads. if include my own 400 threads’ pool, the threads in application sometimes will exceed 1200..). I’v found the phoenix-xxx-thread and HConnection is the main cause, so I tried to co

[jira] [Created] (PHOENIX-3514) java.lang.IndexOutOfBoundsException

2016-12-01 Thread Yongxian Yuan (JIRA)
Yongxian Yuan created PHOENIX-3514: -- Summary: java.lang.IndexOutOfBoundsException Key: PHOENIX-3514 URL: https://issues.apache.org/jira/browse/PHOENIX-3514 Project: Phoenix Issue Type: Bug

[jira] [Updated] (PHOENIX-3514) java.lang.IndexOutOfBoundsException

2016-12-01 Thread Yongxian Yuan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Yongxian Yuan updated PHOENIX-3514: --- Attachment: log.txt IndexMaintainer.java We found that the variables in the

[jira] [Created] (PHOENIX-3515) CsvLineParser Improvement

2016-12-01 Thread Jeongdae Kim (JIRA)
Jeongdae Kim created PHOENIX-3515: - Summary: CsvLineParser Improvement Key: PHOENIX-3515 URL: https://issues.apache.org/jira/browse/PHOENIX-3515 Project: Phoenix Issue Type: Improvement

[jira] [Updated] (PHOENIX-3515) CsvLineParser Improvement

2016-12-01 Thread Jeongdae Kim (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-3515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jeongdae Kim updated PHOENIX-3515: -- Attachment: PHOENIX-3515.1.patch > CsvLineParser Improvement > - > >