[jira] [Resolved] (ASTERIXDB-2907) New dashboard's query plan viewer dislikes SET statements

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

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

Ian Maxon resolved ASTERIXDB-2907.
----------------------------------
    Fix Version/s: 0.9.8
       Resolution: Fixed

> New dashboard's query plan viewer dislikes SET statements
> ---------------------------------------------------------
>
>                 Key: ASTERIXDB-2907
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2907
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: *DB - AsterixDB, DASH- Dashboard, UI - Web Interface
>    Affects Versions: 0.9.6, 0.9.7
>            Reporter: Michael J. Carey
>            Assignee: Miles Hong
>            Priority: Major
>             Fix For: 0.9.8
>
>
> Running this query:
> USE TinySocial; 
>  SET simfunction "jaccard";
>  SET simthreshold "0.3";
> EXPLAIN SELECT cm1 AS chirp,
>  (SELECT VALUE cm2.chirpId
>  FROM ChirpMessages cm2
>  WHERE cm2.referredTopics ~= cm1.referredTopics
>  AND cm2.chirpId > cm1.chirpId) AS similarChirps
>  FROM ChirpMessages cm1;
> Yields this error:
> {color:#ff8b00}ERROR: Code: 1 "ASX1001: Syntax error: EXPLAIN is not supported for this kind of statement (in line 1, at column 17)"{color}
> There is a decent workaround though - one can change the query to get the plan:
> *EXPLAIN* SELECT gbu.id AS id, gbu.name AS name,
>  (SELECT cm.user.screenName AS chirpScreenname,
>  cm.user.name AS chirpName
>  FROM ChirpMessages cm
>  WHERE cm.user.name ~= gbu.name) AS similarUsers
>  FROM GleambookUsers gbu;
>  



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