[jira] [Commented] (PHOENIX-3242) Support CREATE OR REPLACE FUNCTION in Phoenix-Calcite Integration

[ https://issues.apache.org/jira/browse/PHOENIX-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15460202#comment-15460202 ] Rajeshbabu Chintaguntla commented on PHOENIX-3242: -- [~maryannxue] The

[jira] [Commented] (PHOENIX-3235) Tephra errors when trying to create a transactional table in Phoenix 4.8.0

[ https://issues.apache.org/jira/browse/PHOENIX-3235?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15460069#comment-15460069 ] Ali Anwar commented on PHOENIX-3235: The Tephra JIRA to track the fix for this: http

[jira] [Commented] (PHOENIX-3242) Support CREATE OR REPLACE FUNCTION in Phoenix-Calcite Integration

[ https://issues.apache.org/jira/browse/PHOENIX-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459944#comment-15459944 ] Maryann Xue commented on PHOENIX-3242: -- Thanks for the patch, [~rajeshbabu]! Did th

[jira] [Commented] (PHOENIX-2650) Please delete old releases from mirroring system

[ https://issues.apache.org/jira/browse/PHOENIX-2650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459903#comment-15459903 ] James Taylor commented on PHOENIX-2650: --- [~mujtabachohan] - would you mind removin

[jira] [Commented] (PHOENIX-2650) Please delete old releases from mirroring system

[ https://issues.apache.org/jira/browse/PHOENIX-2650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459852#comment-15459852 ] Sebb commented on PHOENIX-2650: --- Please tidy up https://dist.apache.org/repos/dist/releas

[jira] [Comment Edited] (PHOENIX-2946) Projected comparison between date and timestamp columns always returns true

[ https://issues.apache.org/jira/browse/PHOENIX-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459421#comment-15459421 ] Kevin Liew edited comment on PHOENIX-2946 at 9/2/16 8:17 PM: -

[jira] [Comment Edited] (PHOENIX-2946) Projected comparison between date and timestamp columns always returns true

[ https://issues.apache.org/jira/browse/PHOENIX-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459421#comment-15459421 ] Kevin Liew edited comment on PHOENIX-2946 at 9/2/16 8:16 PM: -

[jira] [Comment Edited] (PHOENIX-2946) Projected comparison between date and timestamp columns always returns true

[ https://issues.apache.org/jira/browse/PHOENIX-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459421#comment-15459421 ] Kevin Liew edited comment on PHOENIX-2946 at 9/2/16 8:16 PM: -

[jira] [Commented] (PHOENIX-2641) Implicit wildcard in LIKE predicate search pattern

[ https://issues.apache.org/jira/browse/PHOENIX-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459482#comment-15459482 ] ASF GitHub Bot commented on PHOENIX-2641: - Github user kliewkliew commented on t

[GitHub] phoenix issue #200: PHOENIX-2641 Implicit wildcard in LIKE predicate search ...

Github user kliewkliew commented on the issue: https://github.com/apache/phoenix/pull/200 @twdsilva Changes were made and rebased, --- 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

[jira] [Assigned] (PHOENIX-476) Support declaration of DEFAULT in CREATE statement

[ https://issues.apache.org/jira/browse/PHOENIX-476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Liew reassigned PHOENIX-476: -- Assignee: Kevin Liew > Support declaration of DEFAULT in CREATE statement > --

[jira] [Commented] (PHOENIX-2946) Projected comparison between date and timestamp columns always returns true

[ https://issues.apache.org/jira/browse/PHOENIX-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459421#comment-15459421 ] Kevin Liew commented on PHOENIX-2946: - Sure. So signed date-time type are bytes-comp

[jira] [Created] (PHOENIX-3245) Incorrect results from ResultSet.getBoolean()

Jonathan Leech created PHOENIX-3245: --- Summary: Incorrect results from ResultSet.getBoolean() Key: PHOENIX-3245 URL: https://issues.apache.org/jira/browse/PHOENIX-3245 Project: Phoenix Issue

[jira] [Commented] (PHOENIX-1716) queries with to_char() return incorrect results

[ https://issues.apache.org/jira/browse/PHOENIX-1716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459276#comment-15459276 ] Jonathan Leech commented on PHOENIX-1716: - this no longer seems to be an issue i

[GitHub] phoenix issue #200: PHOENIX-2641 Implicit wildcard in LIKE predicate search ...

Github user twdsilva commented on the issue: https://github.com/apache/phoenix/pull/200 @kliewkliew Can you please rebase? I cannot apply the patch to master. --- 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

[jira] [Commented] (PHOENIX-2641) Implicit wildcard in LIKE predicate search pattern

[ https://issues.apache.org/jira/browse/PHOENIX-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459185#comment-15459185 ] ASF GitHub Bot commented on PHOENIX-2641: - Github user twdsilva commented on the

[jira] [Commented] (PHOENIX-3230) SYSTEM.CATALOG get restored from snapshot with multi-client connection

[ https://issues.apache.org/jira/browse/PHOENIX-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459098#comment-15459098 ] Mujtaba Chohan commented on PHOENIX-3230: - Just regular index on base table in 4

[jira] [Commented] (PHOENIX-3230) SYSTEM.CATALOG get restored from snapshot with multi-client connection

[ https://issues.apache.org/jira/browse/PHOENIX-3230?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459079#comment-15459079 ] Samarth Jain commented on PHOENIX-3230: --- [~mujtabachohan] - did you have any view

[jira] [Comment Edited] (PHOENIX-1367) VIEW derived from another VIEW doesn't use parent VIEW indexes

[ https://issues.apache.org/jira/browse/PHOENIX-1367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459058#comment-15459058 ] Thomas D'Silva edited comment on PHOENIX-1367 at 9/2/16 5:10 PM: -

[jira] [Commented] (PHOENIX-1367) VIEW derived from another VIEW doesn't use parent VIEW indexes

[ https://issues.apache.org/jira/browse/PHOENIX-1367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459058#comment-15459058 ] Thomas D'Silva commented on PHOENIX-1367: - While adding parent indexes to a view

[GitHub] phoenix pull request #200: PHOENIX-2641 Implicit wildcard in LIKE predicate ...

Github user twdsilva commented on a diff in the pull request: https://github.com/apache/phoenix/pull/200#discussion_r77378073 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/compile/ExpressionCompiler.java --- @@ -517,8 +518,13 @@ public Expression visitLeave(LikeParseNode

[jira] [Commented] (PHOENIX-2641) Implicit wildcard in LIKE predicate search pattern

[ https://issues.apache.org/jira/browse/PHOENIX-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459033#comment-15459033 ] ASF GitHub Bot commented on PHOENIX-2641: - Github user twdsilva commented on a d

[jira] [Comment Edited] (PHOENIX-476) Support declaration of DEFAULT in CREATE statement

[ https://issues.apache.org/jira/browse/PHOENIX-476?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459018#comment-15459018 ] James Taylor edited comment on PHOENIX-476 at 9/2/16 4:50 PM: -

[jira] [Comment Edited] (PHOENIX-476) Support declaration of DEFAULT in CREATE statement

[ https://issues.apache.org/jira/browse/PHOENIX-476?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459018#comment-15459018 ] James Taylor edited comment on PHOENIX-476 at 9/2/16 4:49 PM: -

[jira] [Commented] (PHOENIX-476) Support declaration of DEFAULT in CREATE statement

[ https://issues.apache.org/jira/browse/PHOENIX-476?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459018#comment-15459018 ] James Taylor commented on PHOENIX-476: -- [~kliew] - would you be interested in this o

[jira] [Comment Edited] (PHOENIX-3054) Counting zero null rows returns an empty result set

[ https://issues.apache.org/jira/browse/PHOENIX-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459002#comment-15459002 ] James Taylor edited comment on PHOENIX-3054 at 9/2/16 4:40 PM: ---

[jira] [Commented] (PHOENIX-3054) Counting zero null rows returns an empty result set

[ https://issues.apache.org/jira/browse/PHOENIX-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15459002#comment-15459002 ] James Taylor commented on PHOENIX-3054: --- That's a good catch with the MergeSortRes

[jira] [Commented] (PHOENIX-2641) Implicit wildcard in LIKE predicate search pattern

[ https://issues.apache.org/jira/browse/PHOENIX-2641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458967#comment-15458967 ] ASF GitHub Bot commented on PHOENIX-2641: - Github user kliewkliew commented on a

[GitHub] phoenix pull request #200: PHOENIX-2641 Implicit wildcard in LIKE predicate ...

Github user kliewkliew commented on a diff in the pull request: https://github.com/apache/phoenix/pull/200#discussion_r77374014 --- Diff: phoenix-core/src/main/java/org/apache/phoenix/compile/ExpressionCompiler.java --- @@ -517,8 +518,13 @@ public Expression visitLeave(LikeParseNo

[jira] [Commented] (PHOENIX-3054) Counting zero null rows returns an empty result set

[ https://issues.apache.org/jira/browse/PHOENIX-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458927#comment-15458927 ] Hadoop QA commented on PHOENIX-3054: {color:red}-1 overall{color}. Here are the res

[jira] [Updated] (PHOENIX-3054) Counting zero null rows returns an empty result set

[ https://issues.apache.org/jira/browse/PHOENIX-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-3054: -- Fix Version/s: 4.9.0 > Counting zero null rows returns an empty result set > -

[jira] [Comment Edited] (PHOENIX-3054) Counting zero null rows returns an empty result set

[ https://issues.apache.org/jira/browse/PHOENIX-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458730#comment-15458730 ] Ankit Singhal edited comment on PHOENIX-3054 at 9/2/16 3:03 PM: --

[jira] [Updated] (PHOENIX-3054) Counting zero null rows returns an empty result set

[ https://issues.apache.org/jira/browse/PHOENIX-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3054: --- Attachment: PHOENIX-3054_v1.patch > Counting zero null rows returns an empty result set > --

[jira] [Commented] (PHOENIX-3054) Counting zero null rows returns an empty result set

[ https://issues.apache.org/jira/browse/PHOENIX-3054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458730#comment-15458730 ] Ankit Singhal commented on PHOENIX-3054: Thanks [~jamestaylor] for detailing the

[jira] [Updated] (PHOENIX-3242) Support CREATE OR REPLACE FUNCTION in Phoenix-Calcite Integration

[ https://issues.apache.org/jira/browse/PHOENIX-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla updated PHOENIX-3242: - Attachment: PHOENIX-3242-wip.patch [~maryannxue] Here is the patch to su

[jira] [Created] (PHOENIX-3242) Support CREATE Function in Phoenix-Calcite Integration

Rajeshbabu Chintaguntla created PHOENIX-3242: Summary: Support CREATE Function in Phoenix-Calcite Integration Key: PHOENIX-3242 URL: https://issues.apache.org/jira/browse/PHOENIX-3242 Proje

[jira] [Assigned] (PHOENIX-3243) Support DROP FUNCTION in Phoenix-Calcite Integration

[ https://issues.apache.org/jira/browse/PHOENIX-3243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla reassigned PHOENIX-3243: Assignee: Rajeshbabu Chintaguntla > Support DROP FUNCTION in Phoe

[jira] [Created] (PHOENIX-3244) Support adding/listing udf jars in Phoenix-Calcite Integration

Rajeshbabu Chintaguntla created PHOENIX-3244: Summary: Support adding/listing udf jars in Phoenix-Calcite Integration Key: PHOENIX-3244 URL: https://issues.apache.org/jira/browse/PHOENIX-3244

[jira] [Updated] (PHOENIX-3242) Support CREATE OR REPLACE FUNCTION in Phoenix-Calcite Integration

[ https://issues.apache.org/jira/browse/PHOENIX-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla updated PHOENIX-3242: - Summary: Support CREATE OR REPLACE FUNCTION in Phoenix-Calcite Integratio

[jira] [Created] (PHOENIX-3243) Support DROP FUNCTION in Phoenix-Calcite Integration

Rajeshbabu Chintaguntla created PHOENIX-3243: Summary: Support DROP FUNCTION in Phoenix-Calcite Integration Key: PHOENIX-3243 URL: https://issues.apache.org/jira/browse/PHOENIX-3243 Project

[jira] [Commented] (PHOENIX-3201) Implement DAYOFWEEK and DAYOFYEAR built-in functions

[ https://issues.apache.org/jira/browse/PHOENIX-3201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458542#comment-15458542 ] Ankit Singhal commented on PHOENIX-3201: [~jamestaylor]/[~samarthjain], This can

[jira] [Commented] (PHOENIX-3221) "LOCAL" keyword is not adhered for "phoenix.query.dateFormatTimeZone"

[ https://issues.apache.org/jira/browse/PHOENIX-3221?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458525#comment-15458525 ] Ankit Singhal commented on PHOENIX-3221: [~jamestaylor], please review. > "LOCA

[jira] [Updated] (PHOENIX-3241) Convert_tz doesn't allow timestamp data type

[ https://issues.apache.org/jira/browse/PHOENIX-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3241: --- Attachment: PHOENIX-3241.patch > Convert_tz doesn't allow timestamp data type >

[jira] [Updated] (PHOENIX-3241) Convert_tz doesn't allow timestamp data type

[ https://issues.apache.org/jira/browse/PHOENIX-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3241: --- Attachment: (was: PHOENIX-3241.patch) > Convert_tz doesn't allow timestamp data type > -

[jira] [Updated] (PHOENIX-3241) Convert_tz doesn't allow timestamp data type

[ https://issues.apache.org/jira/browse/PHOENIX-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3241: --- Description: As per documentation, we allow timestamp data type of convert_tz but as per co

[jira] [Updated] (PHOENIX-3241) Convert_tz doesn't allow timestamp data type

[ https://issues.apache.org/jira/browse/PHOENIX-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3241: --- Attachment: PHOENIX-3241.patch > Convert_tz doesn't allow timestamp data type >

[jira] [Commented] (PHOENIX-3241) Convert_tz doesn't allow timestamp data type

[ https://issues.apache.org/jira/browse/PHOENIX-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458501#comment-15458501 ] Ankit Singhal commented on PHOENIX-3241: [~jamestaylor], please review. > Conve

[jira] [Updated] (PHOENIX-3241) Convert_tz doesn't allow timestamp data type

[ https://issues.apache.org/jira/browse/PHOENIX-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3241: --- Description: As per documentation, we allow timestamp data type of convert_tz but as per cod

[jira] [Updated] (PHOENIX-3241) Convert_tz doesn't allow timestamp data type

[ https://issues.apache.org/jira/browse/PHOENIX-3241?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal updated PHOENIX-3241: --- Summary: Convert_tz doesn't allow timestamp data type (was: Convert_tz doesn) > Convert_tz

[jira] [Created] (PHOENIX-3241) Convert_tz doesn

Ankit Singhal created PHOENIX-3241: -- Summary: Convert_tz doesn Key: PHOENIX-3241 URL: https://issues.apache.org/jira/browse/PHOENIX-3241 Project: Phoenix Issue Type: Bug Reporter

[jira] [Resolved] (PHOENIX-3229) java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW' Exception In Saiku

[ https://issues.apache.org/jira/browse/PHOENIX-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal resolved PHOENIX-3229. Resolution: Fixed > java.lang.IllegalArgumentException: Unable to PTableType enum for valu

[jira] [Reopened] (PHOENIX-3229) java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW' Exception In Saiku

[ https://issues.apache.org/jira/browse/PHOENIX-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal reopened PHOENIX-3229: > java.lang.IllegalArgumentException: Unable to PTableType enum for value of > 'MATERIALIZED

[jira] [Comment Edited] (PHOENIX-3229) java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW' Exception In Saiku

[ https://issues.apache.org/jira/browse/PHOENIX-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458277#comment-15458277 ] Ankit Singhal edited comment on PHOENIX-3229 at 9/2/16 11:37 AM: -

[jira] [Resolved] (PHOENIX-3229) java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW' Exception In Saiku

[ https://issues.apache.org/jira/browse/PHOENIX-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ankit Singhal resolved PHOENIX-3229. Resolution: Fixed Fix Version/s: 4.8.0 > java.lang.IllegalArgumentException: Unable

[jira] [Commented] (PHOENIX-3229) java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW' Exception In Saiku

[ https://issues.apache.org/jira/browse/PHOENIX-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15458277#comment-15458277 ] Ankit Singhal commented on PHOENIX-3229: 0 down vote Couldn't find , how "MATER

[jira] [Updated] (PHOENIX-3240) ClassCastException from Pig loader

[ https://issues.apache.org/jira/browse/PHOENIX-3240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] YoungWoo Kim updated PHOENIX-3240: -- Description: I'm loading data from Hive table to Phoenix table in using Phoenix-Pig integrati

[jira] [Created] (PHOENIX-3240) ClassCastException from Pig loader

YoungWoo Kim created PHOENIX-3240: - Summary: ClassCastException from Pig loader Key: PHOENIX-3240 URL: https://issues.apache.org/jira/browse/PHOENIX-3240 Project: Phoenix Issue Type: Bug

[jira] [Updated] (PHOENIX-3240) ClassCastException from Pig loader

[ https://issues.apache.org/jira/browse/PHOENIX-3240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] YoungWoo Kim updated PHOENIX-3240: -- Description: I'm loading data from Hive table to Phoenix table in using Phoenix-Pig integrati

[jira] [Updated] (PHOENIX-3229) java.lang.IllegalArgumentException: Unable to PTableType enum for value of 'MATERIALIZED VIEW' Exception In Saiku

[ https://issues.apache.org/jira/browse/PHOENIX-3229?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venkatesh C updated PHOENIX-3229: - Issue Type: Bug (was: Task) > java.lang.IllegalArgumentException: Unable to PTableType enum for