[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15159495#comment-15159495
]
Nick Dimiduk commented on PHOENIX-2646:
---
Looks like I can use {{ARRAY_TO_STRING}} and tweak the
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15159453#comment-15159453
]
James Taylor commented on PHOENIX-2646:
---
The calcite branch does. I think it's best to target this
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15159449#comment-15159449
]
Nick Dimiduk commented on PHOENIX-2646:
---
Seems we don't have UNNEST either.
> Extend VARCHAR
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15159440#comment-15159440
]
James Taylor commented on PHOENIX-2646:
---
bq. Not sure whether EXISTS would work on an array.
I
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15159419#comment-15159419
]
Julian Hyde commented on PHOENIX-2646:
--
I'd only expect ANY and ALL to work for a small set of
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15159279#comment-15159279
]
Julian Hyde commented on PHOENIX-2646:
--
I don't know what "array ANY, ALL functions" are.
> Extend
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15159281#comment-15159281
]
Nick Dimiduk commented on PHOENIX-2646:
---
http://phoenix.apache.org/language/functions.html#any
>
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15159248#comment-15159248
]
Nick Dimiduk commented on PHOENIX-2646:
---
Looks like my function implementation doesn't work with
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15154561#comment-15154561
]
James Taylor commented on PHOENIX-2646:
---
bq. I looked into doing my own UDF but shied away because
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15153427#comment-15153427
]
Julian Hyde commented on PHOENIX-2646:
--
No quarrel with their user-defined types and functions
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15153416#comment-15153416
]
Nick Dimiduk commented on PHOENIX-2646:
---
bq. Postgres is wonderful but some of their ideas about
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15153191#comment-15153191
]
Julian Hyde commented on PHOENIX-2646:
--
PS Yes standard SQL looks like FORTAN, I freely admit it.
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15153188#comment-15153188
]
Julian Hyde commented on PHOENIX-2646:
--
CALCITE-1066 is a work in progress. It would allow extra
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15153107#comment-15153107
]
James Taylor commented on PHOENIX-2646:
---
I think a compatibility mode would be at the mercy of all
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15153103#comment-15153103
]
James Taylor commented on PHOENIX-2646:
---
Made the filter public (didn't realize it wasn't by
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15153101#comment-15153101
]
Nick Dimiduk commented on PHOENIX-2646:
---
[~julianhyde] interesting. Does Calcite already have the
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15153092#comment-15153092
]
Nick Dimiduk commented on PHOENIX-2646:
---
Our need for this feature is pretty dire; I'll want to
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15152985#comment-15152985
]
James Taylor commented on PHOENIX-2646:
---
My preference would be to do any necessary work in our
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15152919#comment-15152919
]
Nick Dimiduk commented on PHOENIX-2646:
---
So the preference is to add {{SIMILAR TO}} syntax to
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15152828#comment-15152828
]
Julian Hyde commented on PHOENIX-2646:
--
Calcite has {{SIMILAR TO}}, which is standard and (per the
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15152790#comment-15152790
]
James Taylor commented on PHOENIX-2646:
---
Given our desire to get the Calcite integration work
[
https://issues.apache.org/jira/browse/PHOENIX-2646?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15152672#comment-15152672
]
Nick Dimiduk commented on PHOENIX-2646:
---
Any preference on whether I pursue this as a new operator
22 matches
Mail list logo