asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmitry Lychagin (Jira)" <j...@apache.org>
Subject [jira] [Comment Edited] (ASTERIXDB-2709) ST_UNION operator with select query inside does not work in the master branch
Date Fri, 10 Apr 2020 01:36:00 GMT

    [ https://issues.apache.org/jira/browse/ASTERIXDB-2709?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17080160#comment-17080160
] 

Dmitry Lychagin edited comment on ASTERIXDB-2709 at 4/10/20, 1:35 AM:
----------------------------------------------------------------------

The patch to fix function registration is available at 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/5704 

With that patch the following query will work
{noformat}
strict_st_union((SELECT VALUE gbu FROM [st_make_point(1.0,1.0),st_make_point(1.0,2.0)] as
gbu));
{noformat}

SQL aggregate rewriting is still broken, so the following query won't yet work:
{noformat}
FROM [st_make_point(1.0,1.0),st_make_point(1.0,2.0)] as gbu
SELECT st_union(gbu) as agg_value
{noformat}
In order to fix this query we need a "sql-*" runtime for this function



was (Author: dlychagin-cb):
The patch to fix function registration is available at 
https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/5704 

With that patch the following query will work
{{noformat}}
strict_st_union((SELECT VALUE gbu FROM [st_make_point(1.0,1.0),st_make_point(1.0,2.0)] as
gbu));
{{noformat}}

SQL aggregate rewriting is still broken, so the following query won't yet work:
{{noformat}}
FROM [st_make_point(1.0,1.0),st_make_point(1.0,2.0)] as gbu
SELECT st_union(gbu) as agg_value
{{noformat}}
In order to fix this query we need a "sql-*" runtime for this function


> ST_UNION operator with select query inside does not work in the master branch
> -----------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-2709
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2709
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: FUN - Functions
>            Reporter: Mehnaz Tabassum Mahin
>            Priority: Major
>
> The "ST_UNION((<select geometry from dataset>))" statement is not working in the
master branch, but it works for the last release (version 0.9.4.1).
> The error I get in the master branch is as follows:
> ASX1079: Compilation error: st_union is a SQL-92 aggregate function. The SQL++ core aggregate
function array_st-union could potentially express the intent. (in line 1, at column 1) [CompilationException]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message