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/left-outer-join-aggr.aql b/asterix-installer/src/main/resources/examples/mugshot/aql/left-outer-join-aggr.aql
new file mode 100644
index 0000000..0f5a3b2
--- /dev/null
+++ b/asterix-installer/src/main/resources/examples/mugshot/aql/left-outer-join-aggr.aql
@@ -0,0 +1,14 @@
+use dataverse TinySocial;
+
+for $user in dataset MugshotUsers
+let $result := {
+ "uname" : $user.name,
+ "msg-length" : avg(
+ for $message in dataset MugshotMessages
+ where $message.author-id = $user.id
+ return string-length($message.message)
+ )
+ }
+order by $result.msg-length desc
+limit 10
+return $result;