[
https://issues.apache.org/jira/browse/ASTERIXDB-2907?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17384343#comment-17384343
]
ASF subversion and git services commented on ASTERIXDB-2907:
------------------------------------------------------------
Commit 01b65d4397ba0647408d081749d0638463ff4a7e in asterixdb's branch
refs/heads/master from mileshong1
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=01b65d4 ]
[ASTERIXDB-2907][DASHBOARD] Explain Fix and Docs Update
-user model changes: no
-storage format changes: no
-interface changes: yes
Details:
-Changed "explain" insertion to before first SELECT term
-Updated dashboard.md docs to match thesis paper
-Added 5 screenshots to the dashboard.md file
-Added JSONL view
-Moved JSON view to left most
Change-Id: I68bc6fa27374217c460640ad2cff34a41b2d9ea4
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/11946
Integration-Tests: Jenkins <[email protected]>
Contrib: Ian Maxon <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Ian Maxon <[email protected]>
> 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.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)
