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)