Return-Path: X-Original-To: apmail-asterixdb-commits-archive@minotaur.apache.org Delivered-To: apmail-asterixdb-commits-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4645B1832A for ; Fri, 30 Oct 2015 23:16:28 +0000 (UTC) Received: (qmail 92093 invoked by uid 500); 30 Oct 2015 23:16:28 -0000 Delivered-To: apmail-asterixdb-commits-archive@asterixdb.apache.org Received: (qmail 92059 invoked by uid 500); 30 Oct 2015 23:16:28 -0000 Mailing-List: contact commits-help@asterixdb.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@asterixdb.incubator.apache.org Delivered-To: mailing list commits@asterixdb.incubator.apache.org Received: (qmail 92047 invoked by uid 99); 30 Oct 2015 23:16:28 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Oct 2015 23:16:28 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 5B985180981 for ; Fri, 30 Oct 2015 23:16:27 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.77 X-Spam-Level: * X-Spam-Status: No, score=1.77 tagged_above=-999 required=6.31 tests=[KAM_ASCII_DIVIDERS=0.8, KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, T_RP_MATCHES_RCVD=-0.01] autolearn=disabled Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id joX6FCzcjGKk for ; Fri, 30 Oct 2015 23:16:14 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with SMTP id 59C8620F0B for ; Fri, 30 Oct 2015 23:16:10 +0000 (UTC) Received: (qmail 91262 invoked by uid 99); 30 Oct 2015 23:16:10 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Oct 2015 23:16:10 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 147A1E045F; Fri, 30 Oct 2015 23:16:10 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: buyingyi@apache.org To: commits@asterixdb.incubator.apache.org Date: Fri, 30 Oct 2015 23:16:13 -0000 Message-Id: <142cdaa194e04d818158914a41efb4d9@git.apache.org> In-Reply-To: References: X-Mailer: ASF-Git Admin Mailer Subject: [05/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/query-issue562.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue562.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue562.ast new file mode 100644 index 0000000..7f8f2d3 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue562.ast @@ -0,0 +1,304 @@ +DataverseUse tpch +TypeDecl LineItemType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32, + l_linenumber : int32, + l_quantity : int32, + l_extendedprice : double, + l_discount : double, + l_tax : double, + l_returnflag : string, + l_linestatus : string, + l_shipdate : string, + l_commitdate : string, + l_receiptdate : string, + l_shipinstruct : string, + l_shipmode : string, + l_comment : string + } +] +TypeDecl OrderType [ + closed RecordType { + o_orderkey : int32, + o_custkey : int32, + o_orderstatus : string, + o_totalprice : double, + o_orderdate : string, + o_orderpriority : string, + o_clerk : string, + o_shippriority : int32, + o_comment : string + } +] +TypeDecl CustomerType [ + closed RecordType { + c_custkey : int32, + c_name : string, + c_address : string, + c_nationkey : int32, + c_phone : string, + c_acctbal : double, + c_mktsegment : string, + c_comment : string + } +] +DatasetDecl Orders(OrderType) partitioned by [[o_orderkey]] +DatasetDecl Customer(CustomerType) partitioned by [[c_custkey]] +FunctionDecl q22_customer_tmp([]) { + ( + SELECT ELEMENT [ + RecordConstructor [ + ( + LiteralExpr [STRING] [c_acctbal] + : + FieldAccessor [ + Variable [ Name=c ] + Field=c_acctbal + ] + ) + ( + LiteralExpr [STRING] [c_custkey] + : + FieldAccessor [ + Variable [ Name=c ] + Field=c_custkey + ] + ) + ( + LiteralExpr [STRING] [cntrycode] + : + Variable [ Name=phone_substr ] + ) + ] + ] + FROM [ Variable [ Name=Customer ] + AS + Variable [ Name=c ] + ] + LetVariable [ Name=phone_substr ] + := + FunctionCall tpch.substring@3[ + FieldAccessor [ + Variable [ Name=c ] + Field=c_phone + ] + LiteralExpr [LONG] [1] + LiteralExpr [LONG] [2] + ] + Where + OperatorExpr [ + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [13] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [31] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [23] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [29] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [30] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [18] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [17] + ] + ] + ) +} + +Query: +LetVariable [ Name=avg ] + := + FunctionCall tpch.avg@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=c ] + Field=c_acctbal + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [Customer] + ] + AS + Variable [ Name=c ] + ] + LetVariable [ Name=phone_substr ] + := + FunctionCall tpch.substring@3[ + FieldAccessor [ + Variable [ Name=c ] + Field=c_phone + ] + LiteralExpr [LONG] [1] + LiteralExpr [LONG] [2] + ] + Where + OperatorExpr [ + OperatorExpr [ + FieldAccessor [ + Variable [ Name=c ] + Field=c_acctbal + ] + > + LiteralExpr [DOUBLE] [0.0] + ] + and + OperatorExpr [ + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [13] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [31] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [23] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [29] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [30] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [18] + ] + or + OperatorExpr [ + Variable [ Name=phone_substr ] + = + LiteralExpr [STRING] [17] + ] + ] + ] + ) + ] +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [cntrycode] + : + Variable [ Name=cntrycode ] + ) + ( + LiteralExpr [STRING] [numcust] + : + FunctionCall tpch.count@1[ + Variable [ Name=ct ] + ] + ) + ( + LiteralExpr [STRING] [totacctbal] + : + FunctionCall tpch.sum@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=i ] + Field=c_acctbal + ] + ] + FROM [ Variable [ Name=ct ] + AS + Variable [ Name=i ] + ] + ) + ] + ) +] +] +FROM [ FunctionCall tpch.q22_customer_tmp@0[ + ] + AS + Variable [ Name=ct ] +] +Where + OperatorExpr [ + FunctionCall tpch.count@1[ + ( + SELECT ELEMENT [ + Variable [ Name=o ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [Orders] + ] + AS + Variable [ Name=o ] + ] + Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=ct ] + Field=c_custkey + ] + = + FieldAccessor [ + Variable [ Name=o ] + Field=o_custkey + ] + ] + ) + ] + = + LiteralExpr [LONG] [0] + ] +Groupby + Variable [ Name=cntrycode ] + := + FieldAccessor [ + Variable [ Name=ct ] + Field=cntrycode + ] + With + Variable [ Name=ct ] + Variable [ Name=avg ] + +Orderby + Variable [ Name=cntrycode ] + ASC + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue601.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue601.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue601.ast new file mode 100644 index 0000000..fef8a60 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue601.ast @@ -0,0 +1,55 @@ +DataverseUse tpch +TypeDecl LineItemType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32, + l_linenumber : int32, + l_quantity : double, + l_extendedprice : double, + l_discount : double, + l_tax : double, + l_returnflag : string, + l_linestatus : string, + l_shipdate : string, + l_commitdate : string, + l_receiptdate : string, + l_shipinstruct : string, + l_shipmode : string, + l_comment : string + } +] +DatasetDecl LineItem(LineItemType) partitioned by [[l_orderkey], [l_linenumber]] +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [l_linenumber] + : + Variable [ Name=l_linenumber ] + ) + ( + LiteralExpr [STRING] [count_order] + : + FunctionCall tpch.count@1[ + Variable [ Name=l ] + ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=l ] +] +Groupby + Variable [ Name=l_linenumber ] + := + FieldAccessor [ + Variable [ Name=l ] + Field=l_linenumber + ] + With + Variable [ Name=l ] + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue697.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue697.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue697.ast new file mode 100644 index 0000000..1409681 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue697.ast @@ -0,0 +1,61 @@ +DataverseUse test +TypeDecl TestType [ + closed RecordType { + key1 : int32, + value : int32 + } +] +DatasetDecl test(TestType) partitioned by [[key1]] +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [gid] + : + Variable [ Name=aid ] + ) + ( + LiteralExpr [STRING] [avg] + : + FunctionCall test.avg@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=j ] + Field=value + ] + ] + FROM [ Variable [ Name=i ] + AS + Variable [ Name=j ] + ] + Where + FunctionCall test.not@1[ + FunctionCall test.is-null@1[ + FieldAccessor [ + Variable [ Name=j ] + Field=value + ] + ] + ] + ) + ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [test] + ] + AS + Variable [ Name=i ] +] +Groupby + Variable [ Name=aid ] + := + FieldAccessor [ + Variable [ Name=i ] + Field=key1 + ] + With + Variable [ Name=i ] + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue785.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue785.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue785.ast new file mode 100644 index 0000000..5b5cb9a --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue785.ast @@ -0,0 +1,272 @@ +DataverseUse tpch +TypeDecl OrderType [ + closed RecordType { + o_orderkey : int32, + o_custkey : int32, + o_orderstatus : string, + o_totalprice : double, + o_orderdate : string, + o_orderpriority : string, + o_clerk : string, + o_shippriority : int32, + o_comment : string + } +] +TypeDecl CustomerType [ + closed RecordType { + c_custkey : int32, + c_name : string, + c_address : string, + c_nationkey : int32, + c_phone : string, + c_acctbal : double, + c_mktsegment : string, + c_comment : string + } +] +TypeDecl SupplierType [ + closed RecordType { + s_suppkey : int32, + s_name : string, + s_address : string, + s_nationkey : int32, + s_phone : string, + s_acctbal : double, + s_comment : string + } +] +TypeDecl NationType [ + closed RecordType { + n_nationkey : int32, + n_name : string, + n_regionkey : int32, + n_comment : string + } +] +TypeDecl RegionType [ + closed RecordType { + r_regionkey : int32, + r_name : string, + r_comment : string + } +] +DatasetDecl Orders(OrderType) partitioned by [[o_orderkey]] +DatasetDecl Supplier(SupplierType) partitioned by [[s_suppkey]] +DatasetDecl Region(RegionType) partitioned by [[r_regionkey]] +DatasetDecl Nation(NationType) partitioned by [[n_nationkey]] +DatasetDecl Customer(CustomerType) partitioned by [[c_custkey]] +DatasetDecl SelectedNation(NationType) partitioned by [[n_nationkey]] +Query: +LetVariable [ Name=t ] + := + ( + SELECT ELEMENT [ + RecordConstructor [ + ( + LiteralExpr [STRING] [n_nationkey] + : + FieldAccessor [ + Variable [ Name=nation ] + Field=n_nationkey + ] + ) + ( + LiteralExpr [STRING] [n_name] + : + FieldAccessor [ + Variable [ Name=nation ] + Field=n_name + ] + ) + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [Nation] + ] + AS + Variable [ Name=nation ] +, + FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [SelectedNation] + ] + AS + Variable [ Name=sn ] + ] + Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=nation ] + Field=n_nationkey + ] + = + FieldAccessor [ + Variable [ Name=sn ] + Field=n_nationkey + ] + ] + ) +LetVariable [ Name=X ] + := + ( + SELECT ELEMENT [ + RecordConstructor [ + ( + LiteralExpr [STRING] [nation_key] + : + Variable [ Name=nation_key ] + ) + ( + LiteralExpr [STRING] [order_date] + : + Variable [ Name=orderdate ] + ) + ( + LiteralExpr [STRING] [sum_price] + : + Variable [ Name=sum ] + ) + ] + ] + FROM [ Variable [ Name=t ] + AS + Variable [ Name=n ] +, + FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [Customer] + ] + AS + Variable [ Name=customer ] +, + FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [Orders] + ] + AS + Variable [ Name=orders ] + ] + Where + OperatorExpr [ + OperatorExpr [ + FieldAccessor [ + Variable [ Name=orders ] + Field=o_custkey + ] + = + FieldAccessor [ + Variable [ Name=customer ] + Field=c_custkey + ] + ] + and + OperatorExpr [ + FieldAccessor [ + Variable [ Name=customer ] + Field=c_nationkey + ] + = + FieldAccessor [ + Variable [ Name=n ] + Field=n_nationkey + ] + ] + ] + Groupby + Variable [ Name=orderdate ] + := + FieldAccessor [ + Variable [ Name=orders ] + Field=o_orderdate + ] + Variable [ Name=nation_key ] + := + FieldAccessor [ + Variable [ Name=n ] + Field=n_nationkey + ] + With + Variable [ Name=orders ] + Variable [ Name=n ] + Variable [ Name=customer ] + Variable [ Name=X ] + Variable [ Name=t ] + + LetVariable [ Name=sum ] + := + FunctionCall tpch.sum@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=o ] + Field=o_totalprice + ] + ] + FROM [ Variable [ Name=orders ] + AS + Variable [ Name=o ] + ] + ) + ] + ) +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [nation_key] + : + Variable [ Name=nation_key ] + ) + ( + LiteralExpr [STRING] [sum_price] + : + ( + SELECT ELEMENT [ + RecordConstructor [ + ( + LiteralExpr [STRING] [orderdate] + : + FieldAccessor [ + Variable [ Name=y ] + Field=order_date + ] + ) + ( + LiteralExpr [STRING] [sum_price] + : + FieldAccessor [ + Variable [ Name=y ] + Field=sum_price + ] + ) + ] + ] + FROM [ Variable [ Name=x ] + AS + Variable [ Name=y ] + ] + Orderby + FieldAccessor [ + Variable [ Name=y ] + Field=sum_price + ] + DESC + + Limit + LiteralExpr [LONG] [3] + ) + ) +] +] +FROM [ Variable [ Name=X ] + AS + Variable [ Name=x ] +] +Groupby + Variable [ Name=nation_key ] + := + FieldAccessor [ + Variable [ Name=x ] + Field=nation_key + ] + With + Variable [ Name=x ] + Variable [ Name=X ] + Variable [ Name=t ] + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue810-2.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue810-2.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue810-2.ast new file mode 100644 index 0000000..1726c87 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue810-2.ast @@ -0,0 +1,204 @@ +DataverseUse tpch +TypeDecl LineItemType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32, + l_linenumber : int32, + l_quantity : double, + l_extendedprice : double, + l_discount : double, + l_tax : double, + l_returnflag : string, + l_linestatus : string, + l_shipdate : string, + l_commitdate : string, + l_receiptdate : string, + l_shipinstruct : string, + l_shipmode : string, + l_comment : string + } +] +DatasetDecl LineItem(LineItemType) partitioned by [[l_orderkey], [l_linenumber]] +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [l_returnflag] + : + Variable [ Name=l_returnflag ] + ) + ( + LiteralExpr [STRING] [l_linestatus] + : + Variable [ Name=l_linestatus ] + ) + ( + LiteralExpr [STRING] [count_cheaps] + : + FunctionCall tpch.count@1[ + Variable [ Name=cheaps ] + ] + ) + ( + LiteralExpr [STRING] [avg_expensive_discounts] + : + FunctionCall tpch.avg@1[ + Variable [ Name=expensives ] + ] + ) + ( + LiteralExpr [STRING] [sum_disc_prices] + : + FunctionCall tpch.sum@1[ + Variable [ Name=disc_prices ] + ] + ) + ( + LiteralExpr [STRING] [total_charges] + : + FunctionCall tpch.sum@1[ + Variable [ Name=charges ] + ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=l ] +] +Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=l ] + Field=l_shipdate + ] + <= + LiteralExpr [STRING] [1998-09-02] + ] +Groupby + Variable [ Name=l_returnflag ] + := + FieldAccessor [ + Variable [ Name=l ] + Field=l_returnflag + ] + Variable [ Name=l_linestatus ] + := + FieldAccessor [ + Variable [ Name=l ] + Field=l_linestatus + ] + With + Variable [ Name=l ] + +LetVariable [ Name=expensives ] + := + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_discount + ] + ] + FROM [ Variable [ Name=l ] + AS + Variable [ Name=i ] + ] + Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_discount + ] + <= + LiteralExpr [DOUBLE] [0.05] + ] + ) +LetVariable [ Name=cheaps ] + := + ( + SELECT ELEMENT [ + Variable [ Name=i ] + ] + FROM [ Variable [ Name=l ] + AS + Variable [ Name=i ] + ] + Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_discount + ] + > + LiteralExpr [DOUBLE] [0.05] + ] + ) +LetVariable [ Name=charges ] + := + ( + SELECT ELEMENT [ + OperatorExpr [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_extendedprice + ] + * + OperatorExpr [ + LiteralExpr [LONG] [1] + - + FieldAccessor [ + Variable [ Name=i ] + Field=l_discount + ] + ] + * + OperatorExpr [ + LiteralExpr [LONG] [1] + + + FieldAccessor [ + Variable [ Name=i ] + Field=l_tax + ] + ] + ] + ] + FROM [ Variable [ Name=l ] + AS + Variable [ Name=i ] + ] + ) +LetVariable [ Name=disc_prices ] + := + ( + SELECT ELEMENT [ + OperatorExpr [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_extendedprice + ] + * + OperatorExpr [ + LiteralExpr [LONG] [1] + - + FieldAccessor [ + Variable [ Name=i ] + Field=l_discount + ] + ] + ] + ] + FROM [ Variable [ Name=l ] + AS + Variable [ Name=i ] + ] + ) +Orderby + Variable [ Name=l_returnflag ] + ASC + Variable [ Name=l_linestatus ] + ASC + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue810.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue810.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue810.ast new file mode 100644 index 0000000..3be4f1c --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue810.ast @@ -0,0 +1,128 @@ +DataverseUse tpch +TypeDecl LineItemType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32, + l_linenumber : int32, + l_quantity : double, + l_extendedprice : double, + l_discount : double, + l_tax : double, + l_returnflag : string, + l_linestatus : string, + l_shipdate : string, + l_commitdate : string, + l_receiptdate : string, + l_shipinstruct : string, + l_shipmode : string, + l_comment : string + } +] +DatasetDecl LineItem(LineItemType) partitioned by [[l_orderkey], [l_linenumber]] +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [l_returnflag] + : + Variable [ Name=l_returnflag ] + ) + ( + LiteralExpr [STRING] [l_linestatus] + : + Variable [ Name=l_linestatus ] + ) + ( + LiteralExpr [STRING] [count_cheaps] + : + FunctionCall tpch.count@1[ + Variable [ Name=cheap ] + ] + ) + ( + LiteralExpr [STRING] [count_expensives] + : + FunctionCall tpch.count@1[ + Variable [ Name=expensive ] + ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=l ] +] +Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=l ] + Field=l_shipdate + ] + <= + LiteralExpr [STRING] [1998-09-02] + ] +Groupby + Variable [ Name=l_returnflag ] + := + FieldAccessor [ + Variable [ Name=l ] + Field=l_returnflag + ] + Variable [ Name=l_linestatus ] + := + FieldAccessor [ + Variable [ Name=l ] + Field=l_linestatus + ] + With + Variable [ Name=l ] + +LetVariable [ Name=cheap ] + := + ( + SELECT ELEMENT [ + Variable [ Name=m ] + ] + FROM [ Variable [ Name=l ] + AS + Variable [ Name=m ] + ] + Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=m ] + Field=l_discount + ] + > + LiteralExpr [DOUBLE] [0.05] + ] + ) +LetVariable [ Name=expensive ] + := + ( + SELECT ELEMENT [ + Variable [ Name=a ] + ] + FROM [ Variable [ Name=l ] + AS + Variable [ Name=a ] + ] + Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=a ] + Field=l_discount + ] + <= + LiteralExpr [DOUBLE] [0.05] + ] + ) +Orderby + Variable [ Name=l_returnflag ] + ASC + Variable [ Name=l_linestatus ] + ASC + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue827-2.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue827-2.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue827-2.ast new file mode 100644 index 0000000..56a8784 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query-issue827-2.ast @@ -0,0 +1,231 @@ +DataverseUse tpch +TypeDecl LineItemType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32, + l_linenumber : int32, + l_quantity : double, + l_extendedprice : double, + l_discount : double, + l_tax : double, + l_returnflag : string, + l_linestatus : string, + l_shipdate : string, + l_commitdate : string, + l_receiptdate : string, + l_shipinstruct : string, + l_shipmode : string, + l_comment : string + } +] +DatasetDecl LineItem(LineItemType) partitioned by [[l_orderkey], [l_linenumber]] +Query: +RecordConstructor [ + ( + LiteralExpr [STRING] [sum_qty_partial] + : + FunctionCall tpch.sum@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_quantity + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=i ] + ] + Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_shipdate + ] + <= + LiteralExpr [STRING] [1998-09-02] + ] + ) + ] + ) + ( + LiteralExpr [STRING] [sum_base_price] + : + FunctionCall tpch.sum@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_extendedprice + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=i ] + ] + ) + ] + ) + ( + LiteralExpr [STRING] [sum_disc_price] + : + FunctionCall tpch.sum@1[ + ( + SELECT ELEMENT [ + OperatorExpr [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_extendedprice + ] + * + OperatorExpr [ + LiteralExpr [LONG] [1] + - + FieldAccessor [ + Variable [ Name=i ] + Field=l_discount + ] + ] + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=i ] + ] + ) + ] + ) + ( + LiteralExpr [STRING] [sum_charge] + : + FunctionCall tpch.sum@1[ + ( + SELECT ELEMENT [ + OperatorExpr [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_extendedprice + ] + * + OperatorExpr [ + LiteralExpr [LONG] [1] + - + FieldAccessor [ + Variable [ Name=i ] + Field=l_discount + ] + ] + * + OperatorExpr [ + LiteralExpr [LONG] [1] + + + FieldAccessor [ + Variable [ Name=i ] + Field=l_tax + ] + ] + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=i ] + ] + ) + ] + ) + ( + LiteralExpr [STRING] [ave_qty] + : + FunctionCall tpch.avg@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_quantity + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=i ] + ] + Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_shipdate + ] + <= + LiteralExpr [STRING] [1998-09-02] + ] + ) + ] + ) + ( + LiteralExpr [STRING] [ave_price] + : + FunctionCall tpch.avg@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_extendedprice + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=i ] + ] + ) + ] + ) + ( + LiteralExpr [STRING] [ave_disc] + : + FunctionCall tpch.avg@1[ + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=i ] + Field=l_discount + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=i ] + ] + ) + ] + ) + ( + LiteralExpr [STRING] [count_order] + : + FunctionCall tpch.count@1[ + ( + SELECT ELEMENT [ + Variable [ Name=l ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [LineItem] + ] + AS + Variable [ Name=l ] + ] + ) + ] + ) +] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query_issue849-2.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query_issue849-2.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query_issue849-2.ast new file mode 100644 index 0000000..7a7b3f2 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query_issue849-2.ast @@ -0,0 +1,92 @@ +DataverseUse test +TypeDecl sType [ + closed RecordType { + b : int32 + } +] +DatasetDecl s(sType) partitioned by [[b]] +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [x] + : + Variable [ Name=x ] + ) + ( + LiteralExpr [STRING] [y] + : + Variable [ Name=y ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [s] + ] + AS + Variable [ Name=x ] +, + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=z ] + Field=c + ] + ] + FROM [ UnorderedListConstructor [ + RecordConstructor [ + ( + LiteralExpr [STRING] [a] + : + LiteralExpr [LONG] [1] + ) + ( + LiteralExpr [STRING] [c] + : + LiteralExpr [LONG] [1] + ) + ] + RecordConstructor [ + ( + LiteralExpr [STRING] [a] + : + LiteralExpr [LONG] [2] + ) + ( + LiteralExpr [STRING] [c] + : + LiteralExpr [LONG] [2] + ) + ] + RecordConstructor [ + ( + LiteralExpr [STRING] [a] + : + LiteralExpr [LONG] [1] + ) + ( + LiteralExpr [STRING] [c] + : + LiteralExpr [NULL] + ) + ] + ] + AS + Variable [ Name=z ] + ] + Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=x ] + Field=b + ] + = + FieldAccessor [ + Variable [ Name=z ] + Field=a + ] + ] + ) + AS + Variable [ Name=y ] +] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query_issue849.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query_issue849.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query_issue849.ast new file mode 100644 index 0000000..98b006e --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/query_issue849.ast @@ -0,0 +1,70 @@ +DataverseUse test +TypeDecl sType [ + closed RecordType { + b : int32 + } +] +DatasetDecl s(sType) partitioned by [[b]] +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [x] + : + Variable [ Name=x ] + ) + ( + LiteralExpr [STRING] [y] + : + Variable [ Name=y ] + ) +] +] +FROM [ UnorderedListConstructor [ + RecordConstructor [ + ( + LiteralExpr [STRING] [a] + : + LiteralExpr [LONG] [1] + ) + ] + RecordConstructor [ + ( + LiteralExpr [STRING] [a] + : + LiteralExpr [LONG] [2] + ) + ] + ] + AS + Variable [ Name=x ] +, + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=z ] + Field=b + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [s] + ] + AS + Variable [ Name=z ] + ] + Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=x ] + Field=a + ] + = + FieldAccessor [ + Variable [ Name=z ] + Field=b + ] + ] + ) + AS + Variable [ Name=y ] +] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-numeric-desc.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-numeric-desc.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-numeric-desc.ast new file mode 100644 index 0000000..576eeb7 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-numeric-desc.ast @@ -0,0 +1,29 @@ +DataverseUse TinySocial +TypeDecl TwitterUserType [ + open RecordType { + screen-name : string, + lang : string, + friends_count : int64, + statuses_count : int64, + name : string, + followers_count : int64 + } +] +DatasetDecl TwitterUsers(TwitterUserType) partitioned by [[screen-name]] +Query: +SELECT ELEMENT [ +Variable [ Name=user ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TwitterUsers] + ] + AS + Variable [ Name=user ] +] +Orderby + FieldAccessor [ + Variable [ Name=user ] + Field=friends_count + ] + DESC + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-numeric.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-numeric.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-numeric.ast new file mode 100644 index 0000000..ec49be3 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-numeric.ast @@ -0,0 +1,29 @@ +DataverseUse TinySocial +TypeDecl TwitterUserType [ + open RecordType { + screen-name : string, + lang : string, + friends_count : int64, + statuses_count : int64, + name : string, + followers_count : int64 + } +] +DatasetDecl TwitterUsers(TwitterUserType) partitioned by [[screen-name]] +Query: +SELECT ELEMENT [ +Variable [ Name=user ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TwitterUsers] + ] + AS + Variable [ Name=user ] +] +Orderby + FieldAccessor [ + Variable [ Name=user ] + Field=friends_count + ] + ASC + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-string-desc.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-string-desc.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-string-desc.ast new file mode 100644 index 0000000..aefabe9 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-string-desc.ast @@ -0,0 +1,29 @@ +DataverseUse TinySocial +TypeDecl TwitterUserType [ + open RecordType { + screen-name : string, + lang : string, + friends_count : int64, + statuses_count : int64, + name : string, + followers_count : int64 + } +] +DatasetDecl TwitterUsers(TwitterUserType) partitioned by [[screen-name]] +Query: +SELECT ELEMENT [ +Variable [ Name=user ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TwitterUsers] + ] + AS + Variable [ Name=user ] +] +Orderby + FieldAccessor [ + Variable [ Name=user ] + Field=screen-name + ] + DESC + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-string.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-string.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-string.ast new file mode 100644 index 0000000..28b636d --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/range-connector/sort-hint-on-closed-string.ast @@ -0,0 +1,29 @@ +DataverseUse TinySocial +TypeDecl TwitterUserType [ + open RecordType { + screen-name : string, + lang : string, + friends_count : int64, + statuses_count : int64, + name : string, + followers_count : int64 + } +] +DatasetDecl TwitterUsers(TwitterUserType) partitioned by [[screen-name]] +Query: +SELECT ELEMENT [ +Variable [ Name=user ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TwitterUsers] + ] + AS + Variable [ Name=user ] +] +Orderby + FieldAccessor [ + Variable [ Name=user ] + Field=screen-name + ] + ASC + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/record_access.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/record_access.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/record_access.ast new file mode 100644 index 0000000..013ea15 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/record_access.ast @@ -0,0 +1,13 @@ +DataverseUse test +WriteOutputTo nc1:/tmp/rec_access.adm +Query: +FieldAccessor [ + RecordConstructor [ + ( + LiteralExpr [STRING] [a] + : + LiteralExpr [LONG] [2] + ) + ] + Field=a +] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/issue730.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/issue730.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/issue730.ast new file mode 100644 index 0000000..e98418d --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/issue730.ast @@ -0,0 +1,102 @@ +DataverseUse test +TypeDecl TwitterUserType [ + open RecordType { + screen_name : string, + lang : string, + friends_count : int32, + statuses_count : int32, + name : string, + followers_count : int32 + } +] +TypeDecl TweetMessageType [ + open RecordType { + tweetid : int64, + user : TwitterUserType, + sender_location : point?, + send_time : datetime, + referred_topics : UnorderedList +, + message_text : string + } +] +DatasetDecl TweetMessages(TweetMessageType) partitioned by [[tweetid]] +WriteOutputTo nc1:rttest/rtree-index-join_issue730.adm +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [message] + : + FieldAccessor [ + Variable [ Name=t1 ] + Field=tweetid + ] + ) + ( + LiteralExpr [STRING] [nearby-message] + : + ( + SELECT ELEMENT [ + FieldAccessor [ + Variable [ Name=t2 ] + Field=tweetid + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TweetMessages] + ] + AS + Variable [ Name=t2 ] + ] + Where + FunctionCall test.spatial-intersect@2[ + FieldAccessor [ + Variable [ Name=t2 ] + Field=sender_location + ] + Variable [ Name=n ] + ] + ) + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TweetMessages] + ] + AS + Variable [ Name=t1 ] +] +LetVariable [ Name=n ] + := + FunctionCall test.create-circle@2[ + FieldAccessor [ + Variable [ Name=t1 ] + Field=sender_location + ] + LiteralExpr [DOUBLE] [5.0] + ] +Where + OperatorExpr [ + OperatorExpr [ + FieldAccessor [ + Variable [ Name=t1 ] + Field=send_time + ] + >= + FunctionCall test.datetime@1[ + LiteralExpr [STRING] [2011-06-18T14:10:17] + ] + ] + and + OperatorExpr [ + FieldAccessor [ + Variable [ Name=t1 ] + Field=send_time + ] + < + FunctionCall test.datetime@1[ + LiteralExpr [STRING] [2011-06-18T15:10:17] + ] + ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.ast new file mode 100644 index 0000000..1c45852 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_01.ast @@ -0,0 +1,127 @@ +DataverseUse test +TypeDecl TwitterUserType [ + closed RecordType { + screen-name : string, + lang : string, + friends-count : int32, + statuses-count : int32, + name : string, + followers-count : int32 + } +] +TypeDecl TweetMessageType [ + closed RecordType { + tweetid : int64, + user : TwitterUserType, + sender-location : point, + send-time : datetime, + referred-topics : UnorderedList +, + message-text : string, + countA : int32, + countB : int32 + } +] +DatasetDecl TweetMessages(TweetMessageType) partitioned by [[tweetid]] +WriteOutputTo nc1:rttest/rtree-index-join_leftouterjoin-probe-pidx-with-join-rtree-sidx_01.adm +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [tweetid1] + : + FieldAccessor [ + Variable [ Name=t1 ] + Field=tweetid + ] + ) + ( + LiteralExpr [STRING] [loc1] + : + FieldAccessor [ + Variable [ Name=t1 ] + Field=sender-location + ] + ) + ( + LiteralExpr [STRING] [nearby-message] + : + ( + SELECT ELEMENT [ + RecordConstructor [ + ( + LiteralExpr [STRING] [tweetid2] + : + FieldAccessor [ + Variable [ Name=t2 ] + Field=tweetid + ] + ) + ( + LiteralExpr [STRING] [loc2] + : + FieldAccessor [ + Variable [ Name=t2 ] + Field=sender-location + ] + ) + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TweetMessages] + ] + AS + Variable [ Name=t2 ] + ] + Where + FunctionCall test.spatial-intersect@2[ + FieldAccessor [ + Variable [ Name=t2 ] + Field=sender-location + ] + Variable [ Name=n ] + ] + Orderby + FieldAccessor [ + Variable [ Name=t2 ] + Field=tweetid + ] + ASC + + ) + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TweetMessages] + ] + AS + Variable [ Name=t1 ] +] +LetVariable [ Name=n ] + := + FunctionCall test.create-circle@2[ + FieldAccessor [ + Variable [ Name=t1 ] + Field=sender-location + ] + LiteralExpr [DOUBLE] [0.5] + ] +Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=t1 ] + Field=tweetid + ] + < + FunctionCall test.int64@1[ + LiteralExpr [STRING] [10] + ] + ] +Orderby + FieldAccessor [ + Variable [ Name=t1 ] + Field=tweetid + ] + ASC + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.ast new file mode 100644 index 0000000..628cc16 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/leftouterjoin-probe-pidx-with-join-rtree-sidx_02.ast @@ -0,0 +1,141 @@ +DataverseUse test +TypeDecl TwitterUserType [ + closed RecordType { + screen-name : string, + lang : string, + friends-count : int32, + statuses-count : int32, + name : string, + followers-count : int32 + } +] +TypeDecl TweetMessageType [ + closed RecordType { + tweetid : int64, + user : TwitterUserType, + sender-location : point, + send-time : datetime, + referred-topics : UnorderedList +, + message-text : string, + countA : int32, + countB : int32 + } +] +DatasetDecl TweetMessages(TweetMessageType) partitioned by [[tweetid]] +WriteOutputTo nc1:rttest/rtree-index-join_leftouterjoin-probe-pidx-with-join-rtree-sidx_02.adm +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [tweetid1] + : + FieldAccessor [ + Variable [ Name=t1 ] + Field=tweetid + ] + ) + ( + LiteralExpr [STRING] [loc1] + : + FieldAccessor [ + Variable [ Name=t1 ] + Field=sender-location + ] + ) + ( + LiteralExpr [STRING] [nearby-message] + : + ( + SELECT ELEMENT [ + RecordConstructor [ + ( + LiteralExpr [STRING] [tweetid2] + : + FieldAccessor [ + Variable [ Name=t2 ] + Field=tweetid + ] + ) + ( + LiteralExpr [STRING] [loc2] + : + FieldAccessor [ + Variable [ Name=t2 ] + Field=sender-location + ] + ) + ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TweetMessages] + ] + AS + Variable [ Name=t2 ] + ] + Where + OperatorExpr [ + FunctionCall test.spatial-intersect@2[ + FieldAccessor [ + Variable [ Name=t2 ] + Field=sender-location + ] + Variable [ Name=n ] + ] + and + OperatorExpr [ + FieldAccessor [ + Variable [ Name=t1 ] + Field=tweetid + ] + != + FieldAccessor [ + Variable [ Name=t2 ] + Field=tweetid + ] + ] + ] + Orderby + FieldAccessor [ + Variable [ Name=t2 ] + Field=tweetid + ] + ASC + + ) + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TweetMessages] + ] + AS + Variable [ Name=t1 ] +] +LetVariable [ Name=n ] + := + FunctionCall test.create-circle@2[ + FieldAccessor [ + Variable [ Name=t1 ] + Field=sender-location + ] + LiteralExpr [DOUBLE] [0.5] + ] +Where + OperatorExpr [ + FieldAccessor [ + Variable [ Name=t1 ] + Field=tweetid + ] + < + FunctionCall test.int64@1[ + LiteralExpr [STRING] [10] + ] + ] +Orderby + FieldAccessor [ + Variable [ Name=t1 ] + Field=tweetid + ] + ASC + http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/query-issue838.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/query-issue838.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/query-issue838.ast new file mode 100644 index 0000000..de3f414 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/query-issue838.ast @@ -0,0 +1,88 @@ +DataverseUse twitter +TypeDecl TweetMessageType [ + closed RecordType { + tweetid : int64, + sender-location : point, + text : string + } +] +TypeDecl TweetHistorySubscription [ + open RecordType { + subscription-id : int32, + location : point + } +] +DatasetDecl TweetHistorySubscriptions(TweetHistorySubscription) partitioned by [[subscription-id]] +DatasetDecl TweetMessages(TweetMessageType) partitioned by [[tweetid]] +WriteOutputTo nc1:rttest/query-issue838.adm +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [subscription-id] + : + FieldAccessor [ + Variable [ Name=sub ] + Field=subscription-id + ] + ) + ( + LiteralExpr [STRING] [changeSet] + : + LiteralExpr [LONG] [1] + ) + ( + LiteralExpr [STRING] [execution-time] + : + FunctionCall twitter.current-datetime@0[ + ] + ) + ( + LiteralExpr [STRING] [message-text] + : + Variable [ Name=text ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TweetHistorySubscriptions] + ] + AS + Variable [ Name=sub ] +, + ( + SELECT ELEMENT [ + Variable [ Name=tweet ] + ] + FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [TweetMessages] + ] + AS + Variable [ Name=tweet ] + ] + LetVariable [ Name=circle ] + := + FunctionCall twitter.create-circle@2[ + FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [location] + ] + LiteralExpr [DOUBLE] [30.0] + ] + Where + FunctionCall twitter.spatial-intersect@2[ + FieldAccessor [ + Variable [ Name=tweet ] + Field=sender-location + ] + Variable [ Name=circle ] + ] + ) + AS + Variable [ Name=text ] +] +LetVariable [ Name=location ] + := + FieldAccessor [ + Variable [ Name=sub ] + Field=location + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_01.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_01.ast new file mode 100644 index 0000000..f0bf3f7 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_01.ast @@ -0,0 +1,54 @@ +DataverseUse test +TypeDecl MyRecord [ + closed RecordType { + id : int32, + point : point, + kwds : string, + line1 : line, + line2 : line, + poly1 : polygon, + poly2 : polygon, + rec : rectangle + } +] +DatasetDecl MyData1(MyRecord) partitioned by [[id]] +DatasetDecl MyData2(MyRecord) partitioned by [[id]] +WriteOutputTo nc1:rttest/index-join_rtree-spatial-intersect-point.adm +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [a] + : + Variable [ Name=a ] + ) + ( + LiteralExpr [STRING] [b] + : + Variable [ Name=b ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [MyData1] + ] + AS + Variable [ Name=a ] +, + FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [MyData2] + ] + AS + Variable [ Name=b ] +] +Where + FunctionCall test.spatial-intersect@2[ + FieldAccessor [ + Variable [ Name=a ] + Field=point + ] + FieldAccessor [ + Variable [ Name=b ] + Field=point + ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_02.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_02.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_02.ast new file mode 100644 index 0000000..f6c641f --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_02.ast @@ -0,0 +1,54 @@ +DataverseUse test +TypeDecl MyRecord [ + closed RecordType { + id : int32, + point : point, + kwds : string, + line1 : line, + line2 : line, + poly1 : polygon, + poly2 : polygon, + rec : rectangle + } +] +DatasetDecl MyData1(MyRecord) partitioned by [[id]] +DatasetDecl MyData2(MyRecord) partitioned by [[id]] +WriteOutputTo nc1:rttest/rtree-index-join_spatial-intersect-point_02.adm +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [a] + : + Variable [ Name=a ] + ) + ( + LiteralExpr [STRING] [b] + : + Variable [ Name=b ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [MyData1] + ] + AS + Variable [ Name=a ] +, + FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [MyData2] + ] + AS + Variable [ Name=b ] +] +Where + FunctionCall test.spatial-intersect@2[ + FieldAccessor [ + Variable [ Name=a ] + Field=point + ] + FieldAccessor [ + Variable [ Name=b ] + Field=point + ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_03.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_03.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_03.ast new file mode 100644 index 0000000..4494871 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-index-join/spatial-intersect-point_03.ast @@ -0,0 +1,53 @@ +DataverseUse test +TypeDecl MyRecord [ + closed RecordType { + id : int32, + point : point, + kwds : string, + line1 : line, + line2 : line, + poly1 : polygon, + poly2 : polygon, + rec : rectangle + } +] +DatasetDecl MyData(MyRecord) partitioned by [[id]] +WriteOutputTo nc1:rttest/rtree-index-join_spatial-intersect-point_03.adm +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [a] + : + Variable [ Name=a ] + ) + ( + LiteralExpr [STRING] [b] + : + Variable [ Name=b ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [MyData] + ] + AS + Variable [ Name=a ] +, + FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [MyData] + ] + AS + Variable [ Name=b ] +] +Where + FunctionCall test.spatial-intersect@2[ + FieldAccessor [ + Variable [ Name=a ] + Field=point + ] + FieldAccessor [ + Variable [ Name=b ] + Field=point + ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-secondary-index-open.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-secondary-index-open.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-secondary-index-open.ast new file mode 100644 index 0000000..644a3b8 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-secondary-index-open.ast @@ -0,0 +1,54 @@ +DataverseUse test +TypeDecl MyRecord [ + open RecordType { + id : int32, + point : point, + kwds : string, + line1 : line, + line2 : line, + poly1 : polygon, + poly2 : polygon, + rec : rectangle, + circle : circle + } +] +DatasetDecl MyData(MyRecord) partitioned by [[id]] +WriteOutputTo nc1:rttest/index_rtree-secondary-index-open.adm +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [id] + : + FieldAccessor [ + Variable [ Name=o ] + Field=id + ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [MyData] + ] + AS + Variable [ Name=o ] +] +Where + FunctionCall test.spatial-intersect@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=point + ] + FunctionCall test.create-polygon@1[ + OrderedListConstructor [ + LiteralExpr [DOUBLE] [4.0] + LiteralExpr [DOUBLE] [1.0] + LiteralExpr [DOUBLE] [4.0] + LiteralExpr [DOUBLE] [4.0] + LiteralExpr [DOUBLE] [12.0] + LiteralExpr [DOUBLE] [4.0] + LiteralExpr [DOUBLE] [12.0] + LiteralExpr [DOUBLE] [1.0] + ] + ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-secondary-index.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-secondary-index.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-secondary-index.ast new file mode 100644 index 0000000..a283d04 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/rtree-secondary-index.ast @@ -0,0 +1,54 @@ +DataverseUse test +TypeDecl MyRecord [ + closed RecordType { + id : int32, + point : point, + kwds : string, + line1 : line, + line2 : line, + poly1 : polygon, + poly2 : polygon, + rec : rectangle, + circle : circle + } +] +DatasetDecl MyData(MyRecord) partitioned by [[id]] +WriteOutputTo nc1:rttest/index_rtree-secondary-index.adm +Query: +SELECT ELEMENT [ +RecordConstructor [ + ( + LiteralExpr [STRING] [id] + : + FieldAccessor [ + Variable [ Name=o ] + Field=id + ] + ) +] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [MyData] + ] + AS + Variable [ Name=o ] +] +Where + FunctionCall test.spatial-intersect@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=point + ] + FunctionCall test.create-polygon@1[ + OrderedListConstructor [ + LiteralExpr [DOUBLE] [4.0] + LiteralExpr [DOUBLE] [1.0] + LiteralExpr [DOUBLE] [4.0] + LiteralExpr [DOUBLE] [4.0] + LiteralExpr [DOUBLE] [12.0] + LiteralExpr [DOUBLE] [4.0] + LiteralExpr [DOUBLE] [12.0] + LiteralExpr [DOUBLE] [1.0] + ] + ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete-all.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete-all.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete-all.ast new file mode 100644 index 0000000..ef75bcb --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete-all.ast @@ -0,0 +1,30 @@ +DataverseUse tpch +TypeDecl LineItemType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32, + l_linenumber : int32, + l_quantity : double, + l_extendedprice : double, + l_discount : double, + l_tax : double, + l_returnflag : string, + l_linestatus : string, + l_shipdate : string, + l_commitdate : string, + l_receiptdate : string, + l_shipinstruct : string, + l_shipmode : string, + l_comment : string + } +] +TypeDecl LineIDType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32 + } +] +DatasetDecl LineItems_q1(LineItemType) partitioned by [[l_orderkey]] +DatasetDecl LineID(LineIDType) partitioned by [[l_orderkey]] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete-rtree-secondary-index.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete-rtree-secondary-index.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete-rtree-secondary-index.ast new file mode 100644 index 0000000..ab52c9a --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete-rtree-secondary-index.ast @@ -0,0 +1,15 @@ +DataverseUse test +TypeDecl MyRecord [ + closed RecordType { + id : int32, + point : point, + kwds : string, + line1 : line, + line2 : line, + poly1 : polygon, + poly2 : polygon, + rec : rectangle, + circle : circle + } +] +DatasetDecl MyData(MyRecord) partitioned by [[id]] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete.ast new file mode 100644 index 0000000..ef75bcb --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-delete.ast @@ -0,0 +1,30 @@ +DataverseUse tpch +TypeDecl LineItemType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32, + l_linenumber : int32, + l_quantity : double, + l_extendedprice : double, + l_discount : double, + l_tax : double, + l_returnflag : string, + l_linestatus : string, + l_shipdate : string, + l_commitdate : string, + l_receiptdate : string, + l_shipinstruct : string, + l_shipmode : string, + l_comment : string + } +] +TypeDecl LineIDType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32 + } +] +DatasetDecl LineItems_q1(LineItemType) partitioned by [[l_orderkey]] +DatasetDecl LineID(LineIDType) partitioned by [[l_orderkey]] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-insert-secondary-index.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-insert-secondary-index.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-insert-secondary-index.ast new file mode 100644 index 0000000..ef75bcb --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-insert-secondary-index.ast @@ -0,0 +1,30 @@ +DataverseUse tpch +TypeDecl LineItemType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32, + l_linenumber : int32, + l_quantity : double, + l_extendedprice : double, + l_discount : double, + l_tax : double, + l_returnflag : string, + l_linestatus : string, + l_shipdate : string, + l_commitdate : string, + l_receiptdate : string, + l_shipinstruct : string, + l_shipmode : string, + l_comment : string + } +] +TypeDecl LineIDType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32 + } +] +DatasetDecl LineItems_q1(LineItemType) partitioned by [[l_orderkey]] +DatasetDecl LineID(LineIDType) partitioned by [[l_orderkey]] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-insert.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-insert.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-insert.ast new file mode 100644 index 0000000..ef75bcb --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/scan-insert.ast @@ -0,0 +1,30 @@ +DataverseUse tpch +TypeDecl LineItemType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32, + l_linenumber : int32, + l_quantity : double, + l_extendedprice : double, + l_discount : double, + l_tax : double, + l_returnflag : string, + l_linestatus : string, + l_shipdate : string, + l_commitdate : string, + l_receiptdate : string, + l_shipinstruct : string, + l_shipmode : string, + l_comment : string + } +] +TypeDecl LineIDType [ + closed RecordType { + l_orderkey : int32, + l_partkey : int32, + l_suppkey : int32 + } +] +DatasetDecl LineItems_q1(LineItemType) partitioned by [[l_orderkey]] +DatasetDecl LineID(LineIDType) partitioned by [[l_orderkey]] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_01.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_01.ast new file mode 100644 index 0000000..9e0d9ac --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_01.ast @@ -0,0 +1,37 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-let-to-edit-distance-check_01.adm +Query: +SELECT ELEMENT [ +Variable [ Name=ed ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +LetVariable [ Name=ed ] + := + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] +Where + OperatorExpr [ + Variable [ Name=ed ] + <= + LiteralExpr [LONG] [2] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_02.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_02.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_02.ast new file mode 100644 index 0000000..9e04619 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_02.ast @@ -0,0 +1,37 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-let-to-edit-distance-check_02.adm +Query: +SELECT ELEMENT [ +Variable [ Name=ed ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +LetVariable [ Name=ed ] + := + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] +Where + OperatorExpr [ + LiteralExpr [LONG] [2] + >= + Variable [ Name=ed ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_03.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_03.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_03.ast new file mode 100644 index 0000000..8a045ac --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_03.ast @@ -0,0 +1,37 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-let-to-edit-distance-check_03.adm +Query: +SELECT ELEMENT [ +Variable [ Name=ed ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +LetVariable [ Name=ed ] + := + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] +Where + OperatorExpr [ + Variable [ Name=ed ] + < + LiteralExpr [LONG] [3] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_04.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_04.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_04.ast new file mode 100644 index 0000000..c79c629 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_04.ast @@ -0,0 +1,37 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-let-to-edit-distance-check_04.adm +Query: +SELECT ELEMENT [ +Variable [ Name=ed ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +LetVariable [ Name=ed ] + := + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] +Where + OperatorExpr [ + LiteralExpr [LONG] [3] + > + Variable [ Name=ed ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_05.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_05.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_05.ast new file mode 100644 index 0000000..080a508 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_05.ast @@ -0,0 +1,37 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-let-to-edit-distance-check_05.adm +Query: +SELECT ELEMENT [ +Variable [ Name=ed ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +LetVariable [ Name=ed ] + := + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] +Where + OperatorExpr [ + Variable [ Name=ed ] + >= + LiteralExpr [LONG] [2] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_06.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_06.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_06.ast new file mode 100644 index 0000000..9dfd7fa --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_06.ast @@ -0,0 +1,37 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-let-to-edit-distance-check_06.adm +Query: +SELECT ELEMENT [ +Variable [ Name=ed ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +LetVariable [ Name=ed ] + := + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] +Where + OperatorExpr [ + LiteralExpr [LONG] [2] + <= + Variable [ Name=ed ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_07.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_07.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_07.ast new file mode 100644 index 0000000..3595d15 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_07.ast @@ -0,0 +1,37 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-let-to-edit-distance-check_07.adm +Query: +SELECT ELEMENT [ +Variable [ Name=ed ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +LetVariable [ Name=ed ] + := + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] +Where + OperatorExpr [ + Variable [ Name=ed ] + > + LiteralExpr [LONG] [2] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_08.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_08.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_08.ast new file mode 100644 index 0000000..eb03e16 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-let-to-edit-distance-check_08.ast @@ -0,0 +1,37 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-let-to-edit-distance-check_08.adm +Query: +SELECT ELEMENT [ +Variable [ Name=ed ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +LetVariable [ Name=ed ] + := + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] +Where + OperatorExpr [ + LiteralExpr [LONG] [2] + < + Variable [ Name=ed ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_01.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_01.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_01.ast new file mode 100644 index 0000000..8b4917e --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_01.ast @@ -0,0 +1,34 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-to-edit-distance-check_01.adm +Query: +SELECT ELEMENT [ +Variable [ Name=o ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +Where + OperatorExpr [ + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] + <= + LiteralExpr [LONG] [2] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_02.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_02.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_02.ast new file mode 100644 index 0000000..0217bad --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_02.ast @@ -0,0 +1,34 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-to-edit-distance-check_02.adm +Query: +SELECT ELEMENT [ +Variable [ Name=o ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +Where + OperatorExpr [ + LiteralExpr [LONG] [2] + >= + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_03.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_03.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_03.ast new file mode 100644 index 0000000..fe8097c --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_03.ast @@ -0,0 +1,34 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-to-edit-distance-check_03.adm +Query: +SELECT ELEMENT [ +Variable [ Name=o ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +Where + OperatorExpr [ + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] + < + LiteralExpr [LONG] [3] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_04.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_04.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_04.ast new file mode 100644 index 0000000..684dc9c --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_04.ast @@ -0,0 +1,34 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-to-edit-distance-check_04.adm +Query: +SELECT ELEMENT [ +Variable [ Name=o ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +Where + OperatorExpr [ + LiteralExpr [LONG] [3] + > + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_05.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_05.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_05.ast new file mode 100644 index 0000000..5fc23b4 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_05.ast @@ -0,0 +1,34 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-to-edit-distance-check_05.adm +Query: +SELECT ELEMENT [ +Variable [ Name=o ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +Where + OperatorExpr [ + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] + >= + LiteralExpr [LONG] [2] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_06.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_06.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_06.ast new file mode 100644 index 0000000..9afcb14 --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_06.ast @@ -0,0 +1,34 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-to-edit-distance-check_06.adm +Query: +SELECT ELEMENT [ +Variable [ Name=o ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +Where + OperatorExpr [ + LiteralExpr [LONG] [2] + <= + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] + ] http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/391f09e5/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_07.ast ---------------------------------------------------------------------- diff --git a/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_07.ast b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_07.ast new file mode 100644 index 0000000..92b6dfd --- /dev/null +++ b/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/similarity/edit-distance-to-edit-distance-check_07.ast @@ -0,0 +1,34 @@ +DataverseUse test +TypeDecl DBLPType [ + closed RecordType { + id : int32, + dblpid : string, + title : string, + authors : string, + misc : string + } +] +DatasetDecl DBLP(DBLPType) partitioned by [[id]] +WriteOutputTo nc1:rttest/similarity_edit-distance-to-edit-distance-check_07.adm +Query: +SELECT ELEMENT [ +Variable [ Name=o ] +] +FROM [ FunctionCall Metadata.dataset@1[ + LiteralExpr [STRING] [DBLP] + ] + AS + Variable [ Name=o ] +] +Where + OperatorExpr [ + FunctionCall test.edit-distance@2[ + FieldAccessor [ + Variable [ Name=o ] + Field=authors + ] + LiteralExpr [STRING] [Michael J. Carey] + ] + > + LiteralExpr [LONG] [2] + ]