improvements for demo
- add demo cluster
- add example mugshot.com data and queries
- automatic configuration of a cluster
- set MANAGIX_HOME implicitly
- better AQL lexer error reporting
- better eror reporting in ADM parser
- fix and optimize construction of asterix zip for deployment
Change-Id: I9d80402cef72a15271766031b6f06c7220e4ad5a
Reviewed-on: http://fulliautomatix.ics.uci.edu:8443/95
Reviewed-by: Ian Maxon <imaxon@uci.edu>
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Raman Grover <ramang@uci.edu>
diff --git a/asterix-installer/src/main/resources/examples/mugshot/aql/join-group.aql b/asterix-installer/src/main/resources/examples/mugshot/aql/join-group.aql
new file mode 100644
index 0000000..bead5ac
--- /dev/null
+++ b/asterix-installer/src/main/resources/examples/mugshot/aql/join-group.aql
@@ -0,0 +1,14 @@
+use dataverse TinySocial;
+
+for $user in dataset MugshotUsers
+for $message in dataset MugshotMessages
+where $message.author-id = $user.id
+group by $name := $user.name with $message
+let $avglen := avg(for $m in $message
+ return string-length($m.message))
+order by $avglen desc
+limit 10
+return {
+ "uname" : $name,
+ "msg-length" : $avglen
+};