Added asterix project
git-svn-id: https://asterixdb.googlecode.com/svn/trunk/asterix@12 eaa15691-b419-025a-1212-ee371bd00084
diff --git a/asterix-app/src/test/resources/optimizerts/queries/fj-phase1.aql b/asterix-app/src/test/resources/optimizerts/queries/fj-phase1.aql
new file mode 100644
index 0000000..778232a
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/queries/fj-phase1.aql
@@ -0,0 +1,46 @@
+drop dataverse rares03 if exists;
+
+create dataverse rares03;
+
+use dataverse rares03;
+
+create type UserType as open {
+ uid: int32,
+ name: string,
+ lottery_numbers: {{int32}}
+}
+
+create type VisitorType as open {
+ vid: int32,
+ name: string,
+ lottery_numbers: {{int32}}
+}
+
+create nodegroup group1 if not exists on nc1, nc2;
+
+create dataset Users(UserType)
+ partitioned by key uid on group1;
+
+create dataset Visitors(VisitorType)
+ partitioned by key vid on group1;
+
+
+// set simfunction "jaccard";
+// set simthreshold ".8";
+
+write output to nc1:"/tmp/rares03.adm";
+
+for $user in dataset('Users')
+let $tokens :=
+ for $lottery_number in $user.lottery_numbers
+ for $token at $i in
+ for $user in dataset('Users')
+ for $lottery_number in $user.lottery_numbers
+ group by $item := $lottery_number with $user
+ let $count := count($user)
+ order by $count desc
+ return $item
+ where $lottery_number = $token
+ order by $token
+ return $i
+return {"uid": $user.uid, "tokens": $tokens}