[jira] [Updated] (ASTERIXDB-3340) Incorrect assignment of runtime partition when mixing external-internal data scans with UNION ALL

["Ian Maxon (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ian Maxon updated ASTERIXDB-3340:
---------------------------------
    Labels: triaged  (was: )

> Incorrect assignment of runtime partition when mixing external-internal data scans with UNION ALL
> -------------------------------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-3340
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3340
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: EXT - External data
>            Reporter: Ali Alsuliman
>            Assignee: Ali Alsuliman
>            Priority: Major
>              Labels: triaged
>
> To reproduce:
> 1- Create an external link
> 2- Create an external dataset: ext_dataset
> 3- Create an internal dataset: int_dataset
> 4- Create the following view:
> {noformat}
> CREATE OR REPLACE VIEW `view1` (`city` STRING, `country` STRING, `lat` DOUBLE, `lon` DOUBLE, `name` STRING, `type` STRING)
> DEFAULT NULL PRIMARY KEY ( `name` ) NOT ENFORCED AS 
> SELECT name, city, country, geo.lat, geo.lon
> FROM ext_dataset
> WHERE `type` = "br" and geo.lat IS NOT NULL and geo.lon IS NOT NULL
> UNION ALL
> SELECT name, city, country, geo.lat, geo.lon
> FROM int_dataset
> {noformat}
> 5- run the following query:
> {noformat}
> SELECT *
> FROM view1 m, int_dataset h
> WHERE m.x /*+hash-bcast*/ = h.x
> {noformat}
> The query will fail with an internal error.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)