Details
-
Improvement
-
Resolution: Fixed
-
Major
-
None
-
1
-
CX Sprint 258, CX Sprint 259
Description
Copy of ASTERIXDB-2921.
The following query should be optimized, but currently isn't:
SET `compiler.arrayindex` "true"; |
|
DROP DATAVERSE TestYelp IF EXISTS;
|
CREATE DATAVERSE TestYelp;
|
USE TestYelp;
|
|
CREATE TYPE CheckinType AS { checkin_id: uuid };
|
CREATE TYPE CheckinDatesToMarkersType AS { marker: string };
|
|
CREATE DATASET YelpCheckin(CheckinType) PRIMARY KEY checkin_id AUTOGENERATED;
|
CREATE DATASET YelpCheckinDateMarkers (CheckinDatesToMarkersType) PRIMARY KEY marker;
|
CREATE INDEX IdxYelpCheckinDates ON YelpCheckin (UNNEST dates : string);
|
|
FROM YelpCheckinDateMarkers M, YelpCheckin C
|
WHERE TO_STRING(M.datetime) /*+ indexnl */ IN C.dates AND |
C.business_id = "--Ni3oJ4VOqfOEu7Sj2Vzg" |
SELECT COUNT(*);
|