UNNEST Results to SYNTAX ERROR

Hi, I've tried using phoenix-4.6.0-Hbase-1.1 and phoenix-4.7.0-Hbase-1.1 to test if UNNEST is now available but it returns a syntax error. Both are resulting to this error sqlline version 1.1.8 0: jdbc:phoenix:localhost> SELECT t.k FROM UNNEST((SELECT k FROM a)) AS t(k); Error: ERROR 601

[jira] [Commented] (PHOENIX-3732) Support for dynamic columns in UPSERT in Phoenix-Calcite

[ https://issues.apache.org/jira/browse/PHOENIX-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15923496#comment-15923496 ] Kevin Liew commented on PHOENIX-3732: - To clarify, Phoenix supports the following syntax with

Re: [VOTE] Release of Apache Phoenix 4.10.0 RC1

+1 Checked sums and signatures: ok Built from source against HBase 0.98.24-hadoop2: ok (7u80) Built from source against HBase 1.2.4: ok (7u80) Unit tests pass against HBase 0.98.24-hadoop2: ok (7u80) Integration tests pass against HBase 0.98.24-hadoop2: ok (7u80) Unit tests pass against HBase

[jira] [Updated] (PHOENIX-3735) ServerExceptionIT hangs or fails

[ https://issues.apache.org/jira/browse/PHOENIX-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Purtell updated PHOENIX-3735: Environment: HBase 1.2.4 (was: HBase 1.2) > ServerExceptionIT hangs or fails >

[jira] [Created] (PHOENIX-3736) ArithmeticQueryIT.testDecimalUpsertSelect fails

Andrew Purtell created PHOENIX-3736: --- Summary: ArithmeticQueryIT.testDecimalUpsertSelect fails Key: PHOENIX-3736 URL: https://issues.apache.org/jira/browse/PHOENIX-3736 Project: Phoenix

[jira] [Updated] (PHOENIX-3735) ServerExceptionIT hangs or fails

[ https://issues.apache.org/jira/browse/PHOENIX-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Purtell updated PHOENIX-3735: Summary: ServerExceptionIT hangs or fails (was: ServerExceptionIT hangs) >

[jira] [Updated] (PHOENIX-3735) ServerExceptionIT hangs or fails

[ https://issues.apache.org/jira/browse/PHOENIX-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew Purtell updated PHOENIX-3735: Description: ServerExceptionIT hangs or fails when run against HBase 1.2.4. Passes when

[jira] [Created] (PHOENIX-3735) ServerExceptionIT hangs

Andrew Purtell created PHOENIX-3735: --- Summary: ServerExceptionIT hangs Key: PHOENIX-3735 URL: https://issues.apache.org/jira/browse/PHOENIX-3735 Project: Phoenix Issue Type: Bug

[GitHub] phoenix pull request #234: Load balancer

GitHub user rahulsIOT opened a pull request: https://github.com/apache/phoenix/pull/234 Load balancer You can merge this pull request into a Git repository by running: $ git pull https://github.com/rahulsIOT/phoenix LoadBalancer Alternatively you can review and apply these

[jira] [Commented] (PHOENIX-3732) Support for dynamic columns in UPSERT in Phoenix-Calcite

[ https://issues.apache.org/jira/browse/PHOENIX-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15907600#comment-15907600 ] James Taylor commented on PHOENIX-3732: --- We allow dynamic columns to be defined in the SELECT

[jira] [Comment Edited] (PHOENIX-3623) Integrate Omid with Phoenix

[ https://issues.apache.org/jira/browse/PHOENIX-3623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15907410#comment-15907410 ] Ohad Shacham edited comment on PHOENIX-3623 at 3/13/17 1:23 PM: Hi

[jira] [Comment Edited] (PHOENIX-3623) Integrate Omid with Phoenix

[ https://issues.apache.org/jira/browse/PHOENIX-3623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15907410#comment-15907410 ] Ohad Shacham edited comment on PHOENIX-3623 at 3/13/17 1:22 PM: Hi

[jira] [Commented] (PHOENIX-3732) Support for dynamic columns in UPSERT in Phoenix-Calcite

[ https://issues.apache.org/jira/browse/PHOENIX-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15906936#comment-15906936 ] Kevin Liew commented on PHOENIX-3732: - Also, though Phoenix doesn't support it (which seems

[jira] [Resolved] (PHOENIX-3700) Implement getConnectioInfo methods in PhoenixCalciteConnection

[ https://issues.apache.org/jira/browse/PHOENIX-3700?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla resolved PHOENIX-3700. -- Resolution: Fixed > Implement getConnectioInfo methods in

[jira] [Resolved] (PHOENIX-3704) Table in PhoenixTable#tableMapping is getting replaced by original PTable after commit in Phoenix-Calcite

[ https://issues.apache.org/jira/browse/PHOENIX-3704?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla resolved PHOENIX-3704. -- Resolution: Fixed > Table in PhoenixTable#tableMapping is getting

[jira] [Comment Edited] (PHOENIX-3732) Support for dynamic columns in UPSERT in Phoenix-Calcite

[ https://issues.apache.org/jira/browse/PHOENIX-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15906933#comment-15906933 ] Kevin Liew edited comment on PHOENIX-3732 at 3/13/17 6:58 AM: -- The Phoenix

[jira] [Commented] (PHOENIX-3732) Support for dynamic columns in UPSERT in Phoenix-Calcite

[ https://issues.apache.org/jira/browse/PHOENIX-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15906933#comment-15906933 ] Kevin Liew commented on PHOENIX-3732: - The Phoenix grammar for dynamic columns in {{UPSERT}} differs

[jira] [Updated] (PHOENIX-3732) Support for dynamic columns in UPSERT in Phoenix-Calcite

[ https://issues.apache.org/jira/browse/PHOENIX-3732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Liew updated PHOENIX-3732: Description: https://phoenix.apache.org/dynamic_columns.html {quote} To upsert a row with