You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@asterixdb.apache.org by bu...@apache.org on 2015/10/31 00:16:22 UTC
[14/51] [partial] incubator-asterixdb git commit: SQL++ parser: 1.
refactored asterix-aql to become asterix-lang-common and asterix-lang-aql,
where the former is the common part for different languages;
2. added asterix-lang-sqlpp on top of asterix-lang-
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-substring.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-substring.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-substring.ast
new file mode 100644
index 0000000..83c6b9b
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-substring.ast
@@ -0,0 +1,83 @@
+DataverseUse test
+TypeDecl DBLPNestedType [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPNestedType
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-complex_ngram-edit-distance-check-substring.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [id]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ )
+ (
+ LiteralExpr [STRING] [title]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=paper ]
+]
+Where
+ IndexAccessor [
+ FunctionCall test.edit-distance-check@3[
+ FunctionCall test.substring@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [0]
+ LiteralExpr [LONG] [8]
+ ]
+ LiteralExpr [STRING] [datbase]
+ LiteralExpr [LONG] [1]
+ ]
+ Index: FunctionCall test.edit-distance-check@3[
+ FunctionCall test.substring@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [0]
+ LiteralExpr [LONG] [8]
+ ]
+ LiteralExpr [STRING] [datbase]
+ LiteralExpr [LONG] [1]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.ast
new file mode 100644
index 0000000..4108c72
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-edit-distance-check-word-tokens.ast
@@ -0,0 +1,75 @@
+DataverseUse test
+TypeDecl DBLPNestedType [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPNestedType
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-complex_ngram-edit-distance-check-word-tokens.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [id]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ )
+ (
+ LiteralExpr [STRING] [title]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=paper ]
+,
+ FunctionCall test.word-tokens@1[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ ]
+ AS
+ Variable [ Name=word ]
+]
+Where
+ IndexAccessor [
+ FunctionCall test.edit-distance-check@3[
+ Variable [ Name=word ]
+ LiteralExpr [STRING] [Multmedia]
+ LiteralExpr [LONG] [1]
+ ]
+ Index: FunctionCall test.edit-distance-check@3[
+ Variable [ Name=word ]
+ LiteralExpr [STRING] [Multmedia]
+ LiteralExpr [LONG] [1]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-let.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-let.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-let.ast
new file mode 100644
index 0000000..1fe0c3a
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-let.ast
@@ -0,0 +1,54 @@
+DataverseUse test
+Set import-private-functions=true
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-complex_ngram-jaccard-check-let.adm
+Query:
+SELECT ELEMENT [
+Variable [ Name=o ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=o ]
+]
+LetVariable [ Name=jacc ]
+ :=
+ FunctionCall test.similarity-jaccard-check@3[
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=o ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ FunctionCall test.gram-tokens@3[
+ LiteralExpr [STRING] [Transactions for Cooperative Environments]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ LiteralExpr [FLOAT] [0.5]
+ ]
+Where
+ IndexAccessor [
+ Variable [ Name=jacc ]
+ Index: Variable [ Name=jacc ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-multi-let.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-multi-let.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-multi-let.ast
new file mode 100644
index 0000000..e772f9f
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ngram-jaccard-check-multi-let.ast
@@ -0,0 +1,71 @@
+DataverseUse test
+Set import-private-functions=true
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-complex_ngram-jaccard-check-multi-let.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [Paper]
+ :
+ Variable [ Name=paper_tokens ]
+ )
+ (
+ LiteralExpr [STRING] [Query]
+ :
+ Variable [ Name=query_tokens ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=paper ]
+]
+LetVariable [ Name=paper_tokens ]
+ :=
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+LetVariable [ Name=query_tokens ]
+ :=
+ FunctionCall test.gram-tokens@3[
+ LiteralExpr [STRING] [Transactions for Cooperative Environments]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+LetVariable [ Name=jacc ]
+ :=
+ FunctionCall test.similarity-jaccard-check@3[
+ Variable [ Name=paper_tokens ]
+ Variable [ Name=query_tokens ]
+ LiteralExpr [FLOAT] [0.5]
+ ]
+Where
+ IndexAccessor [
+ Variable [ Name=jacc ]
+ Index: Variable [ Name=jacc ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let-panic.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let-panic.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let-panic.ast
new file mode 100644
index 0000000..d54ef57
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let-panic.ast
@@ -0,0 +1,74 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-complex_olist-edit-distance-check-let-panic.adm
+Query:
+SELECT ELEMENT [
+Variable [ Name=c ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=c ]
+]
+LetVariable [ Name=ed ]
+ :=
+ FunctionCall test.edit-distance-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ OrderedListConstructor [
+ LiteralExpr [STRING] [computers]
+ LiteralExpr [STRING] [wine]
+ LiteralExpr [STRING] [walking]
+ ]
+ LiteralExpr [LONG] [3]
+ ]
+Where
+ IndexAccessor [
+ Variable [ Name=ed ]
+ Index: Variable [ Name=ed ]
+ ]
+Orderby
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ASC
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let.ast
new file mode 100644
index 0000000..29ce26d
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-edit-distance-check-let.ast
@@ -0,0 +1,74 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-complex_olist-edit-distance-check-let.adm
+Query:
+SELECT ELEMENT [
+Variable [ Name=c ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=c ]
+]
+LetVariable [ Name=ed ]
+ :=
+ FunctionCall test.edit-distance-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ OrderedListConstructor [
+ LiteralExpr [STRING] [computers]
+ LiteralExpr [STRING] [wine]
+ LiteralExpr [STRING] [walking]
+ ]
+ LiteralExpr [LONG] [1]
+ ]
+Where
+ IndexAccessor [
+ Variable [ Name=ed ]
+ Index: Variable [ Name=ed ]
+ ]
+Orderby
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ASC
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-jaccard-check-let.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-jaccard-check-let.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-jaccard-check-let.ast
new file mode 100644
index 0000000..6fe8f83
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/olist-jaccard-check-let.ast
@@ -0,0 +1,63 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-complex_olist-jaccard-check-let.adm
+Query:
+SELECT ELEMENT [
+Variable [ Name=c ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=c ]
+]
+LetVariable [ Name=jacc ]
+ :=
+ FunctionCall test.similarity-jaccard-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ OrderedListConstructor [
+ LiteralExpr [STRING] [databases]
+ LiteralExpr [STRING] [computers]
+ LiteralExpr [STRING] [wine]
+ ]
+ LiteralExpr [FLOAT] [0.7]
+ ]
+Where
+ IndexAccessor [
+ Variable [ Name=jacc ]
+ Index: Variable [ Name=jacc ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ulist-jaccard-check-let.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ulist-jaccard-check-let.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ulist-jaccard-check-let.ast
new file mode 100644
index 0000000..ba67057
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/ulist-jaccard-check-let.ast
@@ -0,0 +1,64 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : UnorderedList <string>
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-complex_ulist-jaccard-check-let.adm
+Query:
+SELECT ELEMENT [
+Variable [ Name=c ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=c ]
+]
+LetVariable [ Name=jacc ]
+ :=
+ FunctionCall test.similarity-jaccard-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=c ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ OrderedListConstructor [
+ LiteralExpr [STRING] [databases]
+ LiteralExpr [STRING] [computers]
+ LiteralExpr [STRING] [wine]
+ ]
+ LiteralExpr [FLOAT] [0.7]
+ ]
+Where
+ IndexAccessor [
+ Variable [ Name=jacc ]
+ Index: Variable [ Name=jacc ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-let.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-let.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-let.ast
new file mode 100644
index 0000000..48e978f
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-let.ast
@@ -0,0 +1,49 @@
+DataverseUse test
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-complex_word-jaccard-check-let.adm
+Query:
+SELECT ELEMENT [
+Variable [ Name=o ]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=o ]
+]
+LetVariable [ Name=jacc ]
+ :=
+ FunctionCall test.similarity-jaccard-check@3[
+ FunctionCall test.word-tokens@1[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=o ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ ]
+ FunctionCall test.word-tokens@1[
+ LiteralExpr [STRING] [Transactions for Cooperative Environments]
+ ]
+ LiteralExpr [FLOAT] [0.5]
+ ]
+Where
+ IndexAccessor [
+ Variable [ Name=jacc ]
+ Index: Variable [ Name=jacc ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-multi-let.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-multi-let.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-multi-let.ast
new file mode 100644
index 0000000..a6c08fa
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-complex/word-jaccard-check-multi-let.ast
@@ -0,0 +1,66 @@
+DataverseUse test
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-complex_word-jaccard-check-multi-let.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [Paper]
+ :
+ Variable [ Name=paper_tokens ]
+ )
+ (
+ LiteralExpr [STRING] [Query]
+ :
+ Variable [ Name=query_tokens ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=paper ]
+]
+LetVariable [ Name=paper_tokens ]
+ :=
+ FunctionCall test.word-tokens@1[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=paper ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ ]
+LetVariable [ Name=query_tokens ]
+ :=
+ FunctionCall test.word-tokens@1[
+ LiteralExpr [STRING] [Transactions for Cooperative Environments]
+ ]
+LetVariable [ Name=jacc ]
+ :=
+ FunctionCall test.similarity-jaccard-check@3[
+ Variable [ Name=paper_tokens ]
+ Variable [ Name=query_tokens ]
+ LiteralExpr [FLOAT] [0.8]
+ ]
+Where
+ IndexAccessor [
+ Variable [ Name=jacc ]
+ Index: Variable [ Name=jacc ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.ast
new file mode 100644
index 0000000..cadc921
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-edit-distance-check-idx_01.ast
@@ -0,0 +1,186 @@
+DataverseUse test
+TypeDecl TwitterUserType [
+ closed RecordType {
+ screen-name : string,
+ lang : string,
+ friends-count : int32,
+ statuses-count : int32,
+ name : string,
+ followers-count : int32
+ }
+]
+TypeDecl TweetMessageNestedType [
+ closed RecordType {
+ tweetid : int64,
+ user : TwitterUserType,
+ sender-location : point,
+ send-time : datetime,
+ referred-topics : UnorderedList <string>
+,
+ message-text : string,
+ countA : int32,
+ countB : int32
+ }
+]
+TypeDecl TweetMessageType [
+ closed RecordType {
+ nested : TweetMessageNestedType
+ }
+]
+DatasetDecl TweetMessages(TweetMessageType) partitioned by [[nested, tweetid]]
+WriteOutputTo nc1:rttest/inverted-index-join_leftouterjoin-probe-pidx-with-join-edit-distance-check_idx_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [tweet]
+ :
+ RecordConstructor [
+ (
+ LiteralExpr [STRING] [id]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ )
+ (
+ LiteralExpr [STRING] [topics]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=message-text
+ ]
+ )
+ ]
+ )
+ (
+ LiteralExpr [STRING] [similar-tweets]
+ :
+ (
+ SELECT ELEMENT [
+ RecordConstructor [
+ (
+ LiteralExpr [STRING] [id]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t2 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ )
+ (
+ LiteralExpr [STRING] [topics]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t2 ]
+ Field=nested
+ ]
+ Field=message-text
+ ]
+ )
+ ]
+ ]
+ FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [TweetMessages]
+ ]
+ AS
+ Variable [ Name=t2 ]
+ ]
+ LetVariable [ Name=sim ]
+ :=
+ FunctionCall test.edit-distance-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=message-text
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t2 ]
+ Field=nested
+ ]
+ Field=message-text
+ ]
+ LiteralExpr [LONG] [7]
+ ]
+ Where
+ OperatorExpr [
+ IndexAccessor [
+ Variable [ Name=sim ]
+ Index: Variable [ Name=sim ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t2 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ !=
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ ]
+ ]
+ Orderby
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t2 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ ASC
+
+ )
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [TweetMessages]
+ ]
+ AS
+ Variable [ Name=t1 ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ >
+ FunctionCall test.int64@1[
+ LiteralExpr [STRING] [240]
+ ]
+ ]
+Orderby
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ ASC
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.ast
new file mode 100644
index 0000000..a698a84
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/leftouterjoin-probe-pidx-with-join-jaccard-check-idx_01.ast
@@ -0,0 +1,186 @@
+DataverseUse test
+TypeDecl TwitterUserType [
+ closed RecordType {
+ screen-name : string,
+ lang : string,
+ friends-count : int32,
+ statuses-count : int32,
+ name : string,
+ followers-count : int32
+ }
+]
+TypeDecl TweetMessageNestedType [
+ closed RecordType {
+ tweetid : int64,
+ user : TwitterUserType,
+ sender-location : point,
+ send-time : datetime,
+ referred-topics : UnorderedList <string>
+,
+ message-text : string,
+ countA : int32,
+ countB : int32
+ }
+]
+TypeDecl TweetMessageType [
+ closed RecordType {
+ nested : TweetMessageNestedType
+ }
+]
+DatasetDecl TweetMessages(TweetMessageType) partitioned by [[nested, tweetid]]
+WriteOutputTo nc1:rttest/inverted-index-join_leftouterjoin-probe-pidx-with-join-jaccard-check_idx_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [tweet]
+ :
+ RecordConstructor [
+ (
+ LiteralExpr [STRING] [id]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ )
+ (
+ LiteralExpr [STRING] [topics]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=referred-topics
+ ]
+ )
+ ]
+ )
+ (
+ LiteralExpr [STRING] [similar-tweets]
+ :
+ (
+ SELECT ELEMENT [
+ RecordConstructor [
+ (
+ LiteralExpr [STRING] [id]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t2 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ )
+ (
+ LiteralExpr [STRING] [topics]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t2 ]
+ Field=nested
+ ]
+ Field=referred-topics
+ ]
+ )
+ ]
+ ]
+ FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [TweetMessages]
+ ]
+ AS
+ Variable [ Name=t2 ]
+ ]
+ LetVariable [ Name=sim ]
+ :=
+ FunctionCall test.similarity-jaccard-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=referred-topics
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t2 ]
+ Field=nested
+ ]
+ Field=referred-topics
+ ]
+ LiteralExpr [FLOAT] [0.5]
+ ]
+ Where
+ OperatorExpr [
+ IndexAccessor [
+ Variable [ Name=sim ]
+ Index: Variable [ Name=sim ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t2 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ !=
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ ]
+ ]
+ Orderby
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t2 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ ASC
+
+ )
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [TweetMessages]
+ ]
+ AS
+ Variable [ Name=t1 ]
+]
+Where
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ >
+ FunctionCall test.int64@1[
+ LiteralExpr [STRING] [240]
+ ]
+ ]
+Orderby
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=t1 ]
+ Field=nested
+ ]
+ Field=tweetid
+ ]
+ ASC
+
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-check_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-check_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-check_01.ast
new file mode 100644
index 0000000..088d1ec
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-check_01.ast
@@ -0,0 +1,116 @@
+DataverseUse test
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl CSXTypetmp [
+ closed RecordType {
+ id : int32,
+ csxid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+TypeDecl CSXType [
+ closed RecordType {
+ nested : CSXTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+DatasetDecl CSX(CSXType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-join_ngram-edit-distance-check_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [CSX]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ IndexAccessor [
+ FunctionCall test.edit-distance-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ LiteralExpr [LONG] [3]
+ ]
+ Index: FunctionCall test.edit-distance-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ LiteralExpr [LONG] [3]
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-contains.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-contains.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-contains.ast
new file mode 100644
index 0000000..24ca38a
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-contains.ast
@@ -0,0 +1,116 @@
+DataverseUse test
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl CSXTypetmp [
+ closed RecordType {
+ id : int32,
+ csxid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+TypeDecl CSXType [
+ closed RecordType {
+ nested : CSXTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+DatasetDecl CSX(CSXType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-join_ngram-edit-distance-contains.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [CSX]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ IndexAccessor [
+ FunctionCall test.edit-distance-contains@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ LiteralExpr [LONG] [3]
+ ]
+ Index: FunctionCall test.edit-distance-contains@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ LiteralExpr [LONG] [3]
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-inline.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-inline.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-inline.ast
new file mode 100644
index 0000000..86cc4e1
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance-inline.ast
@@ -0,0 +1,105 @@
+DataverseUse test
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-join-noeqjoin_ngram-edit-distance-inline.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [aauthors]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ )
+ (
+ LiteralExpr [STRING] [bauthors]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ )
+ (
+ LiteralExpr [STRING] [ed]
+ :
+ Variable [ Name=ed ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+LetVariable [ Name=ed ]
+ :=
+ FunctionCall test.edit-distance@2[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ ]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ Variable [ Name=ed ]
+ <
+ LiteralExpr [LONG] [3]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance_01.ast
new file mode 100644
index 0000000..c9fe10c
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-edit-distance_01.ast
@@ -0,0 +1,100 @@
+DataverseUse test
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl CSXTypetmp [
+ closed RecordType {
+ id : int32,
+ csxid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+TypeDecl CSXType [
+ closed RecordType {
+ nested : CSXTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+DatasetDecl CSX(CSXType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-join_ngram-edit-distance_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [CSX]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FunctionCall test.edit-distance@2[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ ]
+ <
+ LiteralExpr [LONG] [3]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.ast
new file mode 100644
index 0000000..f477597
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-edit-distance_01.ast
@@ -0,0 +1,99 @@
+DataverseUse test
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl CSXTypetmp [
+ closed RecordType {
+ id : int32,
+ csxid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+TypeDecl CSXType [
+ closed RecordType {
+ nested : CSXTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+DatasetDecl CSX(CSXType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-join_ngram-fuzzyeq-edit-distance_01.adm
+Set simfunction=edit-distance
+Set simthreshold=3
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [CSX]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ ~=
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=authors
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.ast
new file mode 100644
index 0000000..ca69c0d
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-fuzzyeq-jaccard_01.ast
@@ -0,0 +1,108 @@
+DataverseUse test
+Set import-private-functions=true
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl CSXTypetmp [
+ closed RecordType {
+ id : int32,
+ csxid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+TypeDecl CSXType [
+ closed RecordType {
+ nested : CSXTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+DatasetDecl CSX(CSXType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-join_ngram-fuzzyeq-jaccard_01.adm
+Set simfunction=jaccard
+Set simthreshold=0.5f
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [CSX]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ ~=
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard-check_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard-check_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard-check_01.ast
new file mode 100644
index 0000000..852ddc8
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard-check_01.ast
@@ -0,0 +1,133 @@
+DataverseUse test
+Set import-private-functions=true
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl CSXTypetmp [
+ closed RecordType {
+ id : int32,
+ csxid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+TypeDecl CSXType [
+ closed RecordType {
+ nested : CSXTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+DatasetDecl CSX(CSXType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-join_ngram-jaccard-check_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [CSX]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ IndexAccessor [
+ FunctionCall test.similarity-jaccard-check@3[
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ LiteralExpr [FLOAT] [0.5]
+ ]
+ Index: FunctionCall test.similarity-jaccard-check@3[
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ LiteralExpr [FLOAT] [0.5]
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard-inline.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard-inline.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard-inline.ast
new file mode 100644
index 0000000..7d0cefb
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard-inline.ast
@@ -0,0 +1,114 @@
+DataverseUse test
+Set import-private-functions=true
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-join-noeqjoin_ngram-jaccard-inline.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [atitle]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ )
+ (
+ LiteralExpr [STRING] [btitle]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ )
+ (
+ LiteralExpr [STRING] [jacc]
+ :
+ Variable [ Name=jacc ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+LetVariable [ Name=jacc ]
+ :=
+ FunctionCall test.similarity-jaccard@2[
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ ]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ Variable [ Name=jacc ]
+ >=
+ LiteralExpr [FLOAT] [0.5]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard_01.ast
new file mode 100644
index 0000000..9a0270a
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ngram-jaccard_01.ast
@@ -0,0 +1,109 @@
+DataverseUse test
+Set import-private-functions=true
+TypeDecl DBLPTypetmp [
+ closed RecordType {
+ id : int32,
+ dblpid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl CSXTypetmp [
+ closed RecordType {
+ id : int32,
+ csxid : string,
+ title : string,
+ authors : string,
+ misc : string
+ }
+]
+TypeDecl DBLPType [
+ closed RecordType {
+ nested : DBLPTypetmp
+ }
+]
+TypeDecl CSXType [
+ closed RecordType {
+ nested : CSXTypetmp
+ }
+]
+DatasetDecl DBLP(DBLPType) partitioned by [[nested, id]]
+DatasetDecl CSX(CSXType) partitioned by [[nested, id]]
+WriteOutputTo nc1:rttest/inverted-index-join_ngram-jaccard_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [DBLP]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [CSX]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FunctionCall test.similarity-jaccard@2[
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ FunctionCall test.gram-tokens@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=title
+ ]
+ LiteralExpr [LONG] [3]
+ LiteralExpr [FALSE]
+ ]
+ ]
+ >=
+ LiteralExpr [FLOAT] [0.5]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=id
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance-check_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance-check_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance-check_01.ast
new file mode 100644
index 0000000..7cc0e31
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance-check_01.ast
@@ -0,0 +1,116 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-join_olist-edit-distance-check_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers2]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ IndexAccessor [
+ FunctionCall test.edit-distance-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ LiteralExpr [LONG] [3]
+ ]
+ Index: FunctionCall test.edit-distance-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ LiteralExpr [LONG] [3]
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance-inline.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance-inline.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance-inline.ast
new file mode 100644
index 0000000..754a451
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance-inline.ast
@@ -0,0 +1,120 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-join-noeqjoin_olist-edit-distance-inline.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [ainterests]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ )
+ (
+ LiteralExpr [STRING] [binterests]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ )
+ (
+ LiteralExpr [STRING] [ed]
+ :
+ Variable [ Name=ed ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+LetVariable [ Name=ed ]
+ :=
+ FunctionCall test.edit-distance@2[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ ]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ Variable [ Name=ed ]
+ <=
+ LiteralExpr [LONG] [2]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance_01.ast
new file mode 100644
index 0000000..ea5e34c
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-edit-distance_01.ast
@@ -0,0 +1,100 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-join_olist-edit-distance_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers2]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FunctionCall test.edit-distance@2[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ ]
+ <=
+ LiteralExpr [LONG] [2]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-edit-distance_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-edit-distance_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-edit-distance_01.ast
new file mode 100644
index 0000000..8c088c3
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-edit-distance_01.ast
@@ -0,0 +1,99 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-join_olist-fuzzyeq-jaccard_01.adm
+Set simfunction=edit-distance
+Set simthreshold=3
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers2]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ ~=
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-jaccard_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-jaccard_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-jaccard_01.ast
new file mode 100644
index 0000000..8b5badc
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-fuzzyeq-jaccard_01.ast
@@ -0,0 +1,99 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-join_olist-fuzzyeq-jaccard_01.adm
+Set simfunction=jaccard
+Set simthreshold=0.7f
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers2]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ ~=
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard-check_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard-check_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard-check_01.ast
new file mode 100644
index 0000000..280f534
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard-check_01.ast
@@ -0,0 +1,116 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-join_olist-jaccard-check_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers2]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ IndexAccessor [
+ FunctionCall test.similarity-jaccard-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ LiteralExpr [FLOAT] [0.7]
+ ]
+ Index: FunctionCall test.similarity-jaccard-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ LiteralExpr [FLOAT] [0.7]
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard-inline.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard-inline.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard-inline.ast
new file mode 100644
index 0000000..bb60c12
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard-inline.ast
@@ -0,0 +1,120 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-join-noeqjoin_olist-jaccard-inline.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [ainterests]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ )
+ (
+ LiteralExpr [STRING] [binterests]
+ :
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ )
+ (
+ LiteralExpr [STRING] [jacc]
+ :
+ Variable [ Name=jacc ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+LetVariable [ Name=jacc ]
+ :=
+ FunctionCall test.similarity-jaccard@2[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ ]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ Variable [ Name=jacc ]
+ >=
+ LiteralExpr [FLOAT] [0.7]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard_01.ast
new file mode 100644
index 0000000..e281004
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/olist-jaccard_01.ast
@@ -0,0 +1,100 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : OrderedList [string]
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-join_olist-jaccard_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers2]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FunctionCall test.similarity-jaccard@2[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ ]
+ >=
+ LiteralExpr [FLOAT] [0.7]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ulist-fuzzyeq-jaccard_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ulist-fuzzyeq-jaccard_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ulist-fuzzyeq-jaccard_01.ast
new file mode 100644
index 0000000..07274a1
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ulist-fuzzyeq-jaccard_01.ast
@@ -0,0 +1,99 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : UnorderedList <string>
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-join_ulist-fuzzyeq-jaccard_01.adm
+Set simfunction=jaccard
+Set simthreshold=0.7f
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers2]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ ~=
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ]
+ ]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ulist-jaccard-check_01.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ulist-jaccard-check_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ulist-jaccard-check_01.ast
new file mode 100644
index 0000000..2f0cb06
--- /dev/null
+++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/nested-index/inverted-index-join/ulist-jaccard-check_01.ast
@@ -0,0 +1,116 @@
+DataverseUse test
+TypeDecl AddressType [
+ closed RecordType {
+ number : int32,
+ street : string,
+ city : string
+ }
+]
+TypeDecl CustomerTypetmp [
+ closed RecordType {
+ cid : int32,
+ name : string,
+ age : int32?,
+ address : AddressType?,
+ interests : UnorderedList <string>
+,
+ children : OrderedList [ open RecordType {
+ name : string,
+ age : int32?
+ }
+]
+
+ }
+]
+TypeDecl CustomerType [
+ closed RecordType {
+ nested : CustomerTypetmp
+ }
+]
+DatasetDecl Customers(CustomerType) partitioned by [[nested, cid]]
+DatasetDecl Customers2(CustomerType) partitioned by [[nested, cid]]
+WriteOutputTo nc1:rttest/inverted-index-join_ulist-jaccard-check_01.adm
+Query:
+SELECT ELEMENT [
+RecordConstructor [
+ (
+ LiteralExpr [STRING] [arec]
+ :
+ Variable [ Name=a ]
+ )
+ (
+ LiteralExpr [STRING] [brec]
+ :
+ Variable [ Name=b ]
+ )
+]
+]
+FROM [ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers]
+ ]
+ AS
+ Variable [ Name=a ]
+,
+ FunctionCall Metadata.dataset@1[
+ LiteralExpr [STRING] [Customers2]
+ ]
+ AS
+ Variable [ Name=b ]
+]
+Where
+ OperatorExpr [
+ IndexAccessor [
+ FunctionCall test.similarity-jaccard-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ LiteralExpr [FLOAT] [0.7]
+ ]
+ Index: FunctionCall test.similarity-jaccard-check@3[
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=interests
+ ]
+ LiteralExpr [FLOAT] [0.7]
+ ]
+ ]
+ and
+ OperatorExpr [
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=a ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ <
+ FieldAccessor [
+ FieldAccessor [
+ Variable [ Name=b ]
+ Field=nested
+ ]
+ Field=cid
+ ]
+ ]
+ ]