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

["Michael J. Carey (Jira)" <ji...@apache.org>]

Michael J. Carey created ASTERIXDB-2907:
-------------------------------------------

             Summary: 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
             Fix For: 0.9.7


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)