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 2016/03/28 22:18:48 UTC
[21/51] [partial] incubator-asterixdb git commit: ASTERIXDB-1226:
implement SQL++ core group-by semantics and syntatic sugars.
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-btree/insert-with-secondary-btree.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-btree/insert-with-secondary-btree.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-btree/insert-with-secondary-btree.5.ast
index 698c900..5241dbb 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-btree/insert-with-secondary-btree.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-btree/insert-with-secondary-btree.5.ast
@@ -1,19 +1,19 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=m ]
+Variable [ Name=$m ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages2]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=author-id
]
=
@@ -22,7 +22,7 @@ Where
and
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
>
@@ -33,7 +33,7 @@ Where
and
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
<
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-inverted-ngram/insert-with-secondary-inverted-ngram.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-inverted-ngram/insert-with-secondary-inverted-ngram.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-inverted-ngram/insert-with-secondary-inverted-ngram.5.ast
index 307feb7..17c5ce7 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-inverted-ngram/insert-with-secondary-inverted-ngram.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-inverted-ngram/insert-with-secondary-inverted-ngram.5.ast
@@ -1,19 +1,19 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=m ]
+Variable [ Name=$m ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
FunctionCall test.contains@2[
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=message
]
LiteralExpr [STRING] [love]
@@ -21,7 +21,7 @@ Where
and
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
<
@@ -32,7 +32,7 @@ Where
]
Orderby
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-inverted-word/insert-with-secondary-inverted-word.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-inverted-word/insert-with-secondary-inverted-word.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-inverted-word/insert-with-secondary-inverted-word.5.ast
index b429922..1ab98c4 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-inverted-word/insert-with-secondary-inverted-word.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-inverted-word/insert-with-secondary-inverted-word.5.ast
@@ -1,13 +1,13 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=m ]
+Variable [ Name=$m ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
@@ -15,7 +15,7 @@ Where
FunctionCall test.similarity-jaccard@2[
FunctionCall test.word-tokens@1[
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=message
]
]
@@ -29,7 +29,7 @@ Where
and
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
<
@@ -40,7 +40,7 @@ Where
]
Orderby
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-rtree/insert-with-secondary-rtree.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-rtree/insert-with-secondary-rtree.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-rtree/insert-with-secondary-rtree.5.ast
index 3258cf9..647e3a8 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-rtree/insert-with-secondary-rtree.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert-with-secondary-rtree/insert-with-secondary-rtree.5.ast
@@ -1,19 +1,19 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=m ]
+Variable [ Name=$m ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
FunctionCall test.spatial-intersect@2[
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=sender-location
]
FunctionCall test.create-polygon@1[
@@ -32,7 +32,7 @@ Where
and
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
<
@@ -43,7 +43,7 @@ Where
]
Orderby
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert/insert.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert/insert.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert/insert.5.ast
index c4eb26a..52fc41d 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert/insert.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/insert/insert.5.ast
@@ -1,18 +1,18 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=m ]
+Variable [ Name=$m ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages2]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
>
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-btree/load-with-secondary-btree.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-btree/load-with-secondary-btree.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-btree/load-with-secondary-btree.5.ast
index b32e113..5071e45 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-btree/load-with-secondary-btree.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-btree/load-with-secondary-btree.5.ast
@@ -1,19 +1,19 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=m ]
+Variable [ Name=$m ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=author-id
]
=
@@ -22,7 +22,7 @@ Where
and
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
>
@@ -33,7 +33,7 @@ Where
and
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
<
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-inverted-ngram/load-with-secondary-inverted-ngram.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-inverted-ngram/load-with-secondary-inverted-ngram.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-inverted-ngram/load-with-secondary-inverted-ngram.5.ast
index 307feb7..17c5ce7 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-inverted-ngram/load-with-secondary-inverted-ngram.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-inverted-ngram/load-with-secondary-inverted-ngram.5.ast
@@ -1,19 +1,19 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=m ]
+Variable [ Name=$m ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
FunctionCall test.contains@2[
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=message
]
LiteralExpr [STRING] [love]
@@ -21,7 +21,7 @@ Where
and
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
<
@@ -32,7 +32,7 @@ Where
]
Orderby
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-inverted-word/load-with-secondary-inverted-word.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-inverted-word/load-with-secondary-inverted-word.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-inverted-word/load-with-secondary-inverted-word.5.ast
index b429922..1ab98c4 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-inverted-word/load-with-secondary-inverted-word.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-inverted-word/load-with-secondary-inverted-word.5.ast
@@ -1,13 +1,13 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=m ]
+Variable [ Name=$m ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
@@ -15,7 +15,7 @@ Where
FunctionCall test.similarity-jaccard@2[
FunctionCall test.word-tokens@1[
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=message
]
]
@@ -29,7 +29,7 @@ Where
and
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
<
@@ -40,7 +40,7 @@ Where
]
Orderby
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-rtree/load-with-secondary-rtree.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-rtree/load-with-secondary-rtree.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-rtree/load-with-secondary-rtree.5.ast
index 3258cf9..647e3a8 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-rtree/load-with-secondary-rtree.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load-with-secondary-rtree/load-with-secondary-rtree.5.ast
@@ -1,19 +1,19 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=m ]
+Variable [ Name=$m ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
FunctionCall test.spatial-intersect@2[
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=sender-location
]
FunctionCall test.create-polygon@1[
@@ -32,7 +32,7 @@ Where
and
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
<
@@ -43,7 +43,7 @@ Where
]
Orderby
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load/load.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load/load.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load/load.5.ast
index a033dff..aa484cd 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load/load.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/filters/load/load.5.ast
@@ -1,18 +1,18 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=m ]
+Variable [ Name=$m ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=send-time
]
>
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.3.ast
index 60a1d56..633ec16 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.3.ast
@@ -6,20 +6,20 @@ RecordConstructor [
LiteralExpr [STRING] [partkey]
:
FieldAccessor [
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
Field=partkey
]
)
(
LiteralExpr [STRING] [pid]
:
- Variable [ Name=p ]
+ Variable [ Name=$p ]
)
(
LiteralExpr [STRING] [shipdate]
:
FieldAccessor [
- Variable [ Name=j ]
+ Variable [ Name=$j ]
Field=l_shipdate
]
)
@@ -31,67 +31,71 @@ FROM [ (
(
LiteralExpr [STRING] [partkey]
:
- Variable [ Name=partkey ]
+ Variable [ Name=$partkey ]
)
(
LiteralExpr [STRING] [i]
:
- Variable [ Name=i ]
+ Variable [ Name=$i ]
)
]
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [LineItem]
]
AS
- Variable [ Name=l ]
+ Variable [ Name=$l ]
]
Orderby
FieldAccessor [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
Field=l_partkey
]
ASC
FieldAccessor [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
Field=l_shipdate
]
ASC
)
AS
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Groupby
- Variable [ Name=partkey ]
+ Variable [ Name=$partkey ]
:=
FieldAccessor [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
Field=l_partkey
]
- With
- Variable [ Name=i ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$i ]
+ AS i
+ )
)
AS
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
,
FieldAccessor [
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
Field=i
]
AS
- Variable [ Name=j ]
+ Variable [ Name=$j ]
AT
- Variable [ Name=p ]
+ Variable [ Name=$p ]
]
Where
OperatorExpr [
- Variable [ Name=p ]
+ Variable [ Name=$p ]
<
LiteralExpr [LONG] [4]
]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.4.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.4.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.4.ast
index 60a1d56..633ec16 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.4.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.4.ast
@@ -6,20 +6,20 @@ RecordConstructor [
LiteralExpr [STRING] [partkey]
:
FieldAccessor [
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
Field=partkey
]
)
(
LiteralExpr [STRING] [pid]
:
- Variable [ Name=p ]
+ Variable [ Name=$p ]
)
(
LiteralExpr [STRING] [shipdate]
:
FieldAccessor [
- Variable [ Name=j ]
+ Variable [ Name=$j ]
Field=l_shipdate
]
)
@@ -31,67 +31,71 @@ FROM [ (
(
LiteralExpr [STRING] [partkey]
:
- Variable [ Name=partkey ]
+ Variable [ Name=$partkey ]
)
(
LiteralExpr [STRING] [i]
:
- Variable [ Name=i ]
+ Variable [ Name=$i ]
)
]
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [LineItem]
]
AS
- Variable [ Name=l ]
+ Variable [ Name=$l ]
]
Orderby
FieldAccessor [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
Field=l_partkey
]
ASC
FieldAccessor [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
Field=l_shipdate
]
ASC
)
AS
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Groupby
- Variable [ Name=partkey ]
+ Variable [ Name=$partkey ]
:=
FieldAccessor [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
Field=l_partkey
]
- With
- Variable [ Name=i ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$i ]
+ AS i
+ )
)
AS
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
,
FieldAccessor [
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
Field=i
]
AS
- Variable [ Name=j ]
+ Variable [ Name=$j ]
AT
- Variable [ Name=p ]
+ Variable [ Name=$p ]
]
Where
OperatorExpr [
- Variable [ Name=p ]
+ Variable [ Name=$p ]
<
LiteralExpr [LONG] [4]
]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.5.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.5.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.5.ast
index 60a1d56..633ec16 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.5.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at00/at00.5.ast
@@ -6,20 +6,20 @@ RecordConstructor [
LiteralExpr [STRING] [partkey]
:
FieldAccessor [
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
Field=partkey
]
)
(
LiteralExpr [STRING] [pid]
:
- Variable [ Name=p ]
+ Variable [ Name=$p ]
)
(
LiteralExpr [STRING] [shipdate]
:
FieldAccessor [
- Variable [ Name=j ]
+ Variable [ Name=$j ]
Field=l_shipdate
]
)
@@ -31,67 +31,71 @@ FROM [ (
(
LiteralExpr [STRING] [partkey]
:
- Variable [ Name=partkey ]
+ Variable [ Name=$partkey ]
)
(
LiteralExpr [STRING] [i]
:
- Variable [ Name=i ]
+ Variable [ Name=$i ]
)
]
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [LineItem]
]
AS
- Variable [ Name=l ]
+ Variable [ Name=$l ]
]
Orderby
FieldAccessor [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
Field=l_partkey
]
ASC
FieldAccessor [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
Field=l_shipdate
]
ASC
)
AS
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Groupby
- Variable [ Name=partkey ]
+ Variable [ Name=$partkey ]
:=
FieldAccessor [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
Field=l_partkey
]
- With
- Variable [ Name=i ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$i ]
+ AS i
+ )
)
AS
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
,
FieldAccessor [
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
Field=i
]
AS
- Variable [ Name=j ]
+ Variable [ Name=$j ]
AT
- Variable [ Name=p ]
+ Variable [ Name=$p ]
]
Where
OperatorExpr [
- Variable [ Name=p ]
+ Variable [ Name=$p ]
<
LiteralExpr [LONG] [4]
]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at01/at01.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at01/at01.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at01/at01.3.ast
index 1aafc34..770fb09 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at01/at01.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at01/at01.3.ast
@@ -5,13 +5,13 @@ RecordConstructor [
(
LiteralExpr [STRING] [num]
:
- Variable [ Name=p ]
+ Variable [ Name=$p ]
)
(
LiteralExpr [STRING] [name]
:
FieldAccessor [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
Field=name
]
)
@@ -19,7 +19,7 @@ RecordConstructor [
LiteralExpr [STRING] [user-since]
:
FieldAccessor [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
Field=user-since
]
)
@@ -27,24 +27,24 @@ RecordConstructor [
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=fb ]
+ Variable [ Name=$fb ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookUsers]
]
AS
- Variable [ Name=fb ]
+ Variable [ Name=$fb ]
]
Orderby
FieldAccessor [
- Variable [ Name=fb ]
+ Variable [ Name=$fb ]
Field=name
]
ASC
)
AS
- Variable [ Name=i ]
+ Variable [ Name=$i ]
AT
- Variable [ Name=p ]
+ Variable [ Name=$p ]
]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at02/at02.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at02/at02.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at02/at02.3.ast
index d6863cd..fc41a3b 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at02/at02.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at02/at02.3.ast
@@ -5,7 +5,7 @@ RecordConstructor [
(
LiteralExpr [STRING] [group]
:
- Variable [ Name=g ]
+ Variable [ Name=$g ]
)
(
LiteralExpr [STRING] [item]
@@ -16,13 +16,13 @@ RecordConstructor [
(
LiteralExpr [STRING] [num]
:
- Variable [ Name=p ]
+ Variable [ Name=$p ]
)
(
LiteralExpr [STRING] [mid]
:
FieldAccessor [
- Variable [ Name=a ]
+ Variable [ Name=$a ]
Field=message-id
]
)
@@ -30,24 +30,24 @@ RecordConstructor [
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=ii ]
+ Variable [ Name=$ii ]
]
- FROM [ Variable [ Name=m ]
+ FROM [ Variable [ Name=$m ]
AS
- Variable [ Name=ii ]
+ Variable [ Name=$ii ]
]
Orderby
FieldAccessor [
- Variable [ Name=ii ]
+ Variable [ Name=$ii ]
Field=message-id
]
ASC
)
AS
- Variable [ Name=a ]
+ Variable [ Name=$a ]
AT
- Variable [ Name=p ]
+ Variable [ Name=$p ]
]
)
)
@@ -57,38 +57,43 @@ FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookUsers]
]
AS
- Variable [ Name=u ]
+ Variable [ Name=$u ]
,
FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookMessages]
]
AS
- Variable [ Name=m ]
+ Variable [ Name=$m ]
]
Where
OperatorExpr [
FieldAccessor [
- Variable [ Name=u ]
+ Variable [ Name=$u ]
Field=id
]
=
FieldAccessor [
- Variable [ Name=m ]
+ Variable [ Name=$m ]
Field=author-id
]
]
Groupby
- Variable [ Name=g ]
+ Variable [ Name=$g ]
:=
FieldAccessor [
- Variable [ Name=u ]
+ Variable [ Name=$u ]
Field=id
]
- With
- Variable [ Name=u ]
- Variable [ Name=m ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$m ]
+ AS m
+ Variable [ Name=$u ]
+ AS u
+ )
Orderby
- Variable [ Name=g ]
+ Variable [ Name=$g ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at03/at03.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at03/at03.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at03/at03.3.ast
index eda838d..d7e0dcc 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at03/at03.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at03/at03.3.ast
@@ -5,7 +5,7 @@ RecordConstructor [
(
LiteralExpr [STRING] [user-since]
:
- Variable [ Name=fus ]
+ Variable [ Name=$fus ]
)
(
LiteralExpr [STRING] [users]
@@ -16,13 +16,13 @@ RecordConstructor [
(
LiteralExpr [STRING] [num]
:
- Variable [ Name=ip ]
+ Variable [ Name=$ip ]
)
(
LiteralExpr [STRING] [name]
:
FieldAccessor [
- Variable [ Name=f ]
+ Variable [ Name=$f ]
Field=name
]
)
@@ -30,24 +30,24 @@ RecordConstructor [
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=i1 ]
+ Variable [ Name=$i1 ]
]
- FROM [ Variable [ Name=i ]
+ FROM [ Variable [ Name=$i ]
AS
- Variable [ Name=i1 ]
+ Variable [ Name=$i1 ]
]
Orderby
FieldAccessor [
- Variable [ Name=i1 ]
+ Variable [ Name=$i1 ]
Field=name
]
ASC
)
AS
- Variable [ Name=f ]
+ Variable [ Name=$f ]
AT
- Variable [ Name=ip ]
+ Variable [ Name=$ip ]
]
)
)
@@ -55,31 +55,35 @@ RecordConstructor [
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=fb ]
+ Variable [ Name=$fb ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [FacebookUsers]
]
AS
- Variable [ Name=fb ]
+ Variable [ Name=$fb ]
]
)
AS
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Groupby
- Variable [ Name=fus ]
+ Variable [ Name=$fus ]
:=
FunctionCall test.get-year@1[
FieldAccessor [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
Field=user-since
]
]
- With
- Variable [ Name=i ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$i ]
+ AS i
+ )
Orderby
- Variable [ Name=fus ]
+ Variable [ Name=$fus ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at04/at04.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at04/at04.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at04/at04.3.ast
index 0efaa7b..5286e9c 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at04/at04.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at04/at04.3.ast
@@ -5,7 +5,7 @@ RecordConstructor [
(
LiteralExpr [STRING] [o_custkey]
:
- Variable [ Name=ckey ]
+ Variable [ Name=$ckey ]
)
(
LiteralExpr [STRING] [users]
@@ -16,13 +16,13 @@ RecordConstructor [
(
LiteralExpr [STRING] [num]
:
- Variable [ Name=ip ]
+ Variable [ Name=$ip ]
)
(
LiteralExpr [STRING] [orderkey]
:
FieldAccessor [
- Variable [ Name=f ]
+ Variable [ Name=$f ]
Field=o_orderkey
]
)
@@ -30,24 +30,24 @@ RecordConstructor [
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=i1 ]
+ Variable [ Name=$i1 ]
]
- FROM [ Variable [ Name=i ]
+ FROM [ Variable [ Name=$i ]
AS
- Variable [ Name=i1 ]
+ Variable [ Name=$i1 ]
]
Orderby
FieldAccessor [
- Variable [ Name=i1 ]
+ Variable [ Name=$i1 ]
Field=o_orderkey
]
ASC
)
AS
- Variable [ Name=f ]
+ Variable [ Name=$f ]
AT
- Variable [ Name=ip ]
+ Variable [ Name=$ip ]
]
)
)
@@ -55,30 +55,34 @@ RecordConstructor [
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=o ]
+ Variable [ Name=$o ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [Orders]
]
AS
- Variable [ Name=o ]
+ Variable [ Name=$o ]
]
)
AS
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Groupby
- Variable [ Name=ckey ]
+ Variable [ Name=$ckey ]
:=
FieldAccessor [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
Field=o_custkey
]
- With
- Variable [ Name=i ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$i ]
+ AS i
+ )
Orderby
- Variable [ Name=ckey ]
+ Variable [ Name=$ckey ]
ASC
Limit
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at05/at05.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at05/at05.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at05/at05.3.ast
index a3d85c7..87ce40d 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at05/at05.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at05/at05.3.ast
@@ -1,7 +1,7 @@
DataverseUse test
Query:
SELECT ELEMENT [
-Variable [ Name=si ]
+Variable [ Name=$si ]
]
FROM [ (
SELECT ELEMENT [
@@ -9,17 +9,17 @@ FROM [ (
(
LiteralExpr [STRING] [xx]
:
- Variable [ Name=xx ]
+ Variable [ Name=$xx ]
)
(
LiteralExpr [STRING] [x]
:
- Variable [ Name=x ]
+ Variable [ Name=$x ]
)
(
LiteralExpr [STRING] [uid]
:
- Variable [ Name=uid ]
+ Variable [ Name=$uid ]
)
]
]
@@ -27,28 +27,32 @@ FROM [ (
LiteralExpr [STRING] [Orders]
]
AS
- Variable [ Name=x ]
+ Variable [ Name=$x ]
]
Where
OperatorExpr [
FieldAccessor [
- Variable [ Name=x ]
+ Variable [ Name=$x ]
Field=o_custkey
]
<
LiteralExpr [LONG] [4]
]
Groupby
- Variable [ Name=uid ]
+ Variable [ Name=$uid ]
:=
FieldAccessor [
- Variable [ Name=x ]
+ Variable [ Name=$x ]
Field=o_custkey
]
- With
- Variable [ Name=x ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$x ]
+ AS x
+ )
- LetVariable [ Name=xx ]
+ Let Variable [ Name=$xx ]
:=
(
SELECT ELEMENT [
@@ -56,18 +60,18 @@ FROM [ (
(
LiteralExpr [STRING] [uid]
:
- Variable [ Name=uid ]
+ Variable [ Name=$uid ]
)
(
LiteralExpr [STRING] [seq]
:
- Variable [ Name=i ]
+ Variable [ Name=$i ]
)
(
LiteralExpr [STRING] [item]
:
FieldAccessor [
- Variable [ Name=y ]
+ Variable [ Name=$y ]
Field=o_orderkey
]
)
@@ -75,38 +79,38 @@ FROM [ (
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=xxx ]
+ Variable [ Name=$xxx ]
]
- FROM [ Variable [ Name=x ]
+ FROM [ Variable [ Name=$x ]
AS
- Variable [ Name=xxx ]
+ Variable [ Name=$xxx ]
]
Orderby
FieldAccessor [
- Variable [ Name=xxx ]
+ Variable [ Name=$xxx ]
Field=o_orderkey
]
ASC
)
AS
- Variable [ Name=y ]
+ Variable [ Name=$y ]
AT
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
)
Orderby
- Variable [ Name=uid ]
+ Variable [ Name=$uid ]
ASC
)
AS
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
,
FieldAccessor [
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
Field=xx
]
AS
- Variable [ Name=si ]
+ Variable [ Name=$si ]
]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at06/at06.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at06/at06.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at06/at06.3.ast
index 1eed705..6fdea10 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at06/at06.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/at06/at06.3.ast
@@ -6,20 +6,20 @@ RecordConstructor [
LiteralExpr [STRING] [partkey]
:
FieldAccessor [
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
Field=partkey
]
)
(
LiteralExpr [STRING] [pid]
:
- Variable [ Name=p ]
+ Variable [ Name=$p ]
)
(
LiteralExpr [STRING] [shipdate]
:
FieldAccessor [
- Variable [ Name=j ]
+ Variable [ Name=$j ]
Field=l_shipdate
]
)
@@ -27,7 +27,7 @@ RecordConstructor [
LiteralExpr [STRING] [orderkey]
:
FieldAccessor [
- Variable [ Name=j ]
+ Variable [ Name=$j ]
Field=l_orderkey
]
)
@@ -39,77 +39,81 @@ FROM [ (
(
LiteralExpr [STRING] [i]
:
- Variable [ Name=i ]
+ Variable [ Name=$i ]
)
(
LiteralExpr [STRING] [partkey]
:
- Variable [ Name=partkey ]
+ Variable [ Name=$partkey ]
)
]
]
FROM [ (
SELECT ELEMENT [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [LineItem]
]
AS
- Variable [ Name=l ]
+ Variable [ Name=$l ]
]
Orderby
FieldAccessor [
- Variable [ Name=l ]
+ Variable [ Name=$l ]
Field=l_partkey
]
ASC
)
AS
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Groupby
- Variable [ Name=partkey ]
+ Variable [ Name=$partkey ]
:=
FieldAccessor [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
Field=l_partkey
]
- With
- Variable [ Name=i ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$i ]
+ AS i
+ )
)
AS
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
,
(
SELECT ELEMENT [
- Variable [ Name=ii ]
+ Variable [ Name=$ii ]
]
FROM [ FieldAccessor [
- Variable [ Name=gen0 ]
+ Variable [ Name=$gen0 ]
Field=i
]
AS
- Variable [ Name=ii ]
+ Variable [ Name=$ii ]
]
Orderby
FieldAccessor [
- Variable [ Name=ii ]
+ Variable [ Name=$ii ]
Field=l_shipdate
]
ASC
)
AS
- Variable [ Name=j ]
+ Variable [ Name=$j ]
AT
- Variable [ Name=p ]
+ Variable [ Name=$p ]
]
Where
OperatorExpr [
- Variable [ Name=p ]
+ Variable [ Name=$p ]
<
LiteralExpr [LONG] [4]
]
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/query-issue550/query-issue550.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/query-issue550/query-issue550.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/query-issue550/query-issue550.3.ast
index 416cf4e..7cf52e9 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/query-issue550/query-issue550.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/flwor/query-issue550/query-issue550.3.ast
@@ -1,5 +1,5 @@
Query:
-LetVariable [ Name=sample ]
+Let Variable [ Name=$sample ]
:=
UnorderedListConstructor [
RecordConstructor [
@@ -152,35 +152,40 @@ RecordConstructor [
(
LiteralExpr [STRING] [u]
:
- Variable [ Name=u ]
+ Variable [ Name=$u ]
)
(
LiteralExpr [STRING] [recs]
:
(
SELECT ELEMENT [
- Variable [ Name=srec ]
+ Variable [ Name=$srec ]
]
- FROM [ Variable [ Name=s ]
+ FROM [ Variable [ Name=$s ]
AS
- Variable [ Name=srec ]
+ Variable [ Name=$srec ]
]
)
)
]
]
-FROM [ Variable [ Name=sample ]
+FROM [ Variable [ Name=$sample ]
AS
- Variable [ Name=s ]
+ Variable [ Name=$s ]
]
Groupby
- Variable [ Name=u ]
+ Variable [ Name=$u ]
:=
FieldAccessor [
- Variable [ Name=s ]
+ Variable [ Name=$s ]
Field=uid
]
- With
- Variable [ Name=s ]
- Variable [ Name=sample ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$s ]
+ AS s
+ Variable [ Name=$sample ]
+ AS sample
+ )
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_1/dblp-1_1.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_1/dblp-1_1.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_1/dblp-1_1.3.ast
index eb3fed5..0e2d5bf 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_1/dblp-1_1.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_1/dblp-1_1.3.ast
@@ -2,36 +2,52 @@ DataverseUse fuzzyjoin
Set import-private-functions=true
Query:
SELECT ELEMENT [
-Variable [ Name=tokenGroupped ]
+Variable [ Name=$tokenGroupped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
Groupby
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=paper ]
- Variable [ Name=token ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=paper ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=paper
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2.1.1/dblp-1_2.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2.1.1/dblp-1_2.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2.1.1/dblp-1_2.3.ast
index 099a27b..191068a 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2.1.1/dblp-1_2.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2.1.1/dblp-1_2.3.ast
@@ -2,43 +2,60 @@ DataverseUse fuzzyjoin
Set import-private-functions=true
Query:
SELECT ELEMENT [
-Variable [ Name=tokenGroupped ]
+Variable [ Name=$tokenGroupped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
-LetVariable [ Name=id ]
+Let Variable [ Name=$id ]
:=
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=id
]
Groupby
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=id ]
- Variable [ Name=paper ]
- Variable [ Name=token ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$id ]
+ AS id
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=id ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=id
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2.1/dblp-1_2.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2.1/dblp-1_2.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2.1/dblp-1_2.3.ast
index 099a27b..191068a 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2.1/dblp-1_2.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2.1/dblp-1_2.3.ast
@@ -2,43 +2,60 @@ DataverseUse fuzzyjoin
Set import-private-functions=true
Query:
SELECT ELEMENT [
-Variable [ Name=tokenGroupped ]
+Variable [ Name=$tokenGroupped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
-LetVariable [ Name=id ]
+Let Variable [ Name=$id ]
:=
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=id
]
Groupby
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=id ]
- Variable [ Name=paper ]
- Variable [ Name=token ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$id ]
+ AS id
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=id ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=id
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2/dblp-1_2.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2/dblp-1_2.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2/dblp-1_2.3.ast
index c487f14..fa9ab5f 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2/dblp-1_2.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-1_2/dblp-1_2.3.ast
@@ -2,43 +2,60 @@ DataverseUse fuzzyjoin
Set import-private-functions=true
Query:
SELECT ELEMENT [
-Variable [ Name=tokenGroupped ]
+Variable [ Name=$tokenGroupped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
-LetVariable [ Name=paperid ]
+Let Variable [ Name=$paperid ]
:=
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=id
]
Groupby
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=paperid ]
- Variable [ Name=paper ]
- Variable [ Name=token ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$paperid ]
+ AS paperid
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=paperid ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=paperid
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2.1_5.3.1/dblp-2.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2.1_5.3.1/dblp-2.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2.1_5.3.1/dblp-2.3.ast
index db61b3e..315a705 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2.1_5.3.1/dblp-2.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2.1_5.3.1/dblp-2.3.ast
@@ -6,17 +6,17 @@ RecordConstructor [
(
LiteralExpr [STRING] [id]
:
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
)
(
LiteralExpr [STRING] [prefixToken]
:
- Variable [ Name=prefixTokenDBLP ]
+ Variable [ Name=$prefixTokenDBLP ]
)
(
LiteralExpr [STRING] [tokens]
:
- Variable [ Name=tokensDBLP ]
+ Variable [ Name=$tokensDBLP ]
)
]
]
@@ -24,7 +24,7 @@ FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
,
FunctionCall fuzzyjoin.subset-collection@3[
FunctionCall Metadata.dataset@1[
@@ -39,103 +39,126 @@ FROM [ FunctionCall Metadata.dataset@1[
]
]
AS
- Variable [ Name=prefixTokenDBLP ]
+ Variable [ Name=$prefixTokenDBLP ]
]
-LetVariable [ Name=idDBLP ]
+Let Variable [ Name=$idDBLP ]
:=
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=id
]
-LetVariable [ Name=tokensUnrankedDBLP ]
+Let Variable [ Name=$tokensUnrankedDBLP ]
:=
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=title
]
]
-LetVariable [ Name=lenDBLP ]
+Let Variable [ Name=$lenDBLP ]
:=
FunctionCall fuzzyjoin.len@1[
- Variable [ Name=tokensUnrankedDBLP ]
+ Variable [ Name=$tokensUnrankedDBLP ]
]
-LetVariable [ Name=tokensDBLP ]
+Let Variable [ Name=$tokensDBLP ]
:=
(
SELECT ELEMENT [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
- FROM [ Variable [ Name=tokensUnrankedDBLP ]
+ FROM [ Variable [ Name=$tokensUnrankedDBLP ]
AS
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
,
(
SELECT ELEMENT [
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
- LetVariable [ Name=id ]
+ Let Variable [ Name=$id ]
:=
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=id
]
Groupby
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=id ]
- Variable [ Name=paper ]
- Variable [ Name=token ]
- Variable [ Name=tokenUnranked ]
- Variable [ Name=lenDBLP ]
- Variable [ Name=tokensUnrankedDBLP ]
- Variable [ Name=idDBLP ]
- Variable [ Name=paperDBLP ]
- Variable [ Name=prefixTokenDBLP ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$id ]
+ AS id
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ Variable [ Name=$tokenUnranked ]
+ AS tokenUnranked
+ Variable [ Name=$lenDBLP ]
+ AS lenDBLP
+ Variable [ Name=$tokensUnrankedDBLP ]
+ AS tokensUnrankedDBLP
+ Variable [ Name=$idDBLP ]
+ AS idDBLP
+ Variable [ Name=$prefixTokenDBLP ]
+ AS prefixTokenDBLP
+ Variable [ Name=$paperDBLP ]
+ AS paperDBLP
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=id ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=id
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
ASC
)
AS
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
AT
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Where
OperatorExpr [
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
=
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
]
Orderby
- Variable [ Name=i ]
+ Variable [ Name=$i ]
ASC
)
Orderby
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2.2/dblp-2.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2.2/dblp-2.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2.2/dblp-2.3.ast
index 5fcb123..44a7325 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2.2/dblp-2.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2.2/dblp-2.3.ast
@@ -6,17 +6,17 @@ RecordConstructor [
(
LiteralExpr [STRING] [id]
:
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
)
(
LiteralExpr [STRING] [prefixToken]
:
- Variable [ Name=prefixTokenDBLP ]
+ Variable [ Name=$prefixTokenDBLP ]
)
(
LiteralExpr [STRING] [tokens]
:
- Variable [ Name=tokensDBLP ]
+ Variable [ Name=$tokensDBLP ]
)
]
]
@@ -24,7 +24,7 @@ FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
,
FunctionCall fuzzyjoin.subset-collection@3[
FunctionCall Metadata.dataset@1[
@@ -41,66 +41,66 @@ FROM [ FunctionCall Metadata.dataset@1[
]
]
AS
- Variable [ Name=prefixTokenDBLP ]
+ Variable [ Name=$prefixTokenDBLP ]
]
-LetVariable [ Name=idDBLP ]
+Let Variable [ Name=$idDBLP ]
:=
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=id
]
-LetVariable [ Name=tokensUnrankedDBLP ]
+Let Variable [ Name=$tokensUnrankedDBLP ]
:=
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=title
]
]
-LetVariable [ Name=lenDBLP ]
+Let Variable [ Name=$lenDBLP ]
:=
FunctionCall fuzzyjoin.len@1[
- Variable [ Name=tokensUnrankedDBLP ]
+ Variable [ Name=$tokensUnrankedDBLP ]
]
-LetVariable [ Name=tokensDBLP ]
+Let Variable [ Name=$tokensDBLP ]
:=
(
SELECT ELEMENT [
FieldAccessor [
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
Field=rank
]
]
- FROM [ Variable [ Name=tokensUnrankedDBLP ]
+ FROM [ Variable [ Name=$tokensUnrankedDBLP ]
AS
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
,
FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [TOKENSRANKEDADM]
]
AS
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
]
Where
OperatorExpr [
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
=
FieldAccessor [
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
Field=token
]
]
Orderby
FieldAccessor [
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
Field=rank
]
ASC
)
Orderby
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
ASC
- Variable [ Name=prefixTokenDBLP ]
+ Variable [ Name=$prefixTokenDBLP ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_1/dblp-2_1.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_1/dblp-2_1.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_1/dblp-2_1.3.ast
index 66dcb7b..8ea2c98 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_1/dblp-2_1.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_1/dblp-2_1.3.ast
@@ -7,14 +7,14 @@ RecordConstructor [
LiteralExpr [STRING] [id]
:
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=id
]
)
(
LiteralExpr [STRING] [tokens]
:
- Variable [ Name=tokensDBLP ]
+ Variable [ Name=$tokensDBLP ]
)
]
]
@@ -22,80 +22,98 @@ FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
]
-LetVariable [ Name=tokensDBLP ]
+Let Variable [ Name=$tokensDBLP ]
:=
(
SELECT ELEMENT [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
FROM [ FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=title
]
]
AS
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
,
(
SELECT ELEMENT [
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
Groupby
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=paper ]
- Variable [ Name=token ]
- Variable [ Name=tokenUnranked ]
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ Variable [ Name=$tokenUnranked ]
+ AS tokenUnranked
+ Variable [ Name=$paperDBLP ]
+ AS paperDBLP
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=paper ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=paper
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
ASC
)
AS
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
AT
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Where
OperatorExpr [
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
=
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
]
Orderby
- Variable [ Name=i ]
+ Variable [ Name=$i ]
ASC
)
Orderby
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=id
]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_2/dblp-2_2.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_2/dblp-2_2.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_2/dblp-2_2.3.ast
index 7f265d8..bdec735 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_2/dblp-2_2.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_2/dblp-2_2.3.ast
@@ -7,14 +7,14 @@ RecordConstructor [
LiteralExpr [STRING] [id]
:
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=id
]
)
(
LiteralExpr [STRING] [tokens]
:
- Variable [ Name=tokensDBLP ]
+ Variable [ Name=$tokensDBLP ]
)
]
]
@@ -22,87 +22,106 @@ FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
]
-LetVariable [ Name=tokensDBLP ]
+Let Variable [ Name=$tokensDBLP ]
:=
(
SELECT ELEMENT [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
FROM [ FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=title
]
]
AS
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
,
(
SELECT ELEMENT [
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
- LetVariable [ Name=id ]
+ Let Variable [ Name=$id ]
:=
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=id
]
Groupby
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=id ]
- Variable [ Name=paper ]
- Variable [ Name=token ]
- Variable [ Name=tokenUnranked ]
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$id ]
+ AS id
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ Variable [ Name=$tokenUnranked ]
+ AS tokenUnranked
+ Variable [ Name=$paperDBLP ]
+ AS paperDBLP
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=id ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=id
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
ASC
)
AS
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
AT
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Where
OperatorExpr [
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
=
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
]
Orderby
- Variable [ Name=i ]
+ Variable [ Name=$i ]
ASC
)
Orderby
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=id
]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_3/dblp-2_3.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_3/dblp-2_3.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_3/dblp-2_3.3.ast
index 136f460..3faf452 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_3/dblp-2_3.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_3/dblp-2_3.3.ast
@@ -6,12 +6,12 @@ RecordConstructor [
(
LiteralExpr [STRING] [id]
:
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
)
(
LiteralExpr [STRING] [tokens]
:
- Variable [ Name=tokensDBLP ]
+ Variable [ Name=$tokensDBLP ]
)
]
]
@@ -19,92 +19,112 @@ FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
]
-LetVariable [ Name=idDBLP ]
+Let Variable [ Name=$idDBLP ]
:=
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=id
]
-LetVariable [ Name=tokensDBLP ]
+Let Variable [ Name=$tokensDBLP ]
:=
(
SELECT ELEMENT [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
FROM [ FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=title
]
]
AS
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
,
(
SELECT ELEMENT [
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
- LetVariable [ Name=id ]
+ Let Variable [ Name=$id ]
:=
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=id
]
Groupby
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=id ]
- Variable [ Name=paper ]
- Variable [ Name=token ]
- Variable [ Name=tokenUnranked ]
- Variable [ Name=idDBLP ]
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$id ]
+ AS id
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ Variable [ Name=$tokenUnranked ]
+ AS tokenUnranked
+ Variable [ Name=$idDBLP ]
+ AS idDBLP
+ Variable [ Name=$paperDBLP ]
+ AS paperDBLP
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=id ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=id
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
ASC
)
AS
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
AT
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Where
OperatorExpr [
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
=
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
]
Orderby
- Variable [ Name=i ]
+ Variable [ Name=$i ]
ASC
)
Orderby
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_4/dblp-2_4.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_4/dblp-2_4.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_4/dblp-2_4.3.ast
index 7ea0932..6f085fc 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_4/dblp-2_4.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_4/dblp-2_4.3.ast
@@ -6,12 +6,12 @@ RecordConstructor [
(
LiteralExpr [STRING] [id]
:
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
)
(
LiteralExpr [STRING] [tokens]
:
- Variable [ Name=tokensDBLP ]
+ Variable [ Name=$tokensDBLP ]
)
]
]
@@ -19,96 +19,117 @@ FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
]
-LetVariable [ Name=idDBLP ]
+Let Variable [ Name=$idDBLP ]
:=
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=id
]
-LetVariable [ Name=tokensUnrankedDBLP ]
+Let Variable [ Name=$tokensUnrankedDBLP ]
:=
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=title
]
]
-LetVariable [ Name=tokensDBLP ]
+Let Variable [ Name=$tokensDBLP ]
:=
(
SELECT ELEMENT [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
- FROM [ Variable [ Name=tokensUnrankedDBLP ]
+ FROM [ Variable [ Name=$tokensUnrankedDBLP ]
AS
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
,
(
SELECT ELEMENT [
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
- LetVariable [ Name=id ]
+ Let Variable [ Name=$id ]
:=
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=id
]
Groupby
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=id ]
- Variable [ Name=paper ]
- Variable [ Name=token ]
- Variable [ Name=tokenUnranked ]
- Variable [ Name=tokensUnrankedDBLP ]
- Variable [ Name=idDBLP ]
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$id ]
+ AS id
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ Variable [ Name=$tokenUnranked ]
+ AS tokenUnranked
+ Variable [ Name=$tokensUnrankedDBLP ]
+ AS tokensUnrankedDBLP
+ Variable [ Name=$idDBLP ]
+ AS idDBLP
+ Variable [ Name=$paperDBLP ]
+ AS paperDBLP
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=id ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=id
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGroupped ]
+ Variable [ Name=$tokenGroupped ]
ASC
)
AS
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
AT
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Where
OperatorExpr [
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
=
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
]
Orderby
- Variable [ Name=i ]
+ Variable [ Name=$i ]
ASC
)
Orderby
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_5.1/dblp-2_5.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_5.1/dblp-2_5.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_5.1/dblp-2_5.3.ast
index 2fa4b09..460fb11 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_5.1/dblp-2_5.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_5.1/dblp-2_5.3.ast
@@ -6,17 +6,17 @@ RecordConstructor [
(
LiteralExpr [STRING] [id]
:
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
)
(
LiteralExpr [STRING] [len]
:
- Variable [ Name=lenDBLP ]
+ Variable [ Name=$lenDBLP ]
)
(
LiteralExpr [STRING] [tokens]
:
- Variable [ Name=tokensDBLP ]
+ Variable [ Name=$tokensDBLP ]
)
]
]
@@ -24,102 +24,124 @@ FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
]
-LetVariable [ Name=idDBLP ]
+Let Variable [ Name=$idDBLP ]
:=
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=id
]
-LetVariable [ Name=tokensUnrankedDBLP ]
+Let Variable [ Name=$tokensUnrankedDBLP ]
:=
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=title
]
]
-LetVariable [ Name=lenDBLP ]
+Let Variable [ Name=$lenDBLP ]
:=
FunctionCall fuzzyjoin.len@1[
- Variable [ Name=tokensUnrankedDBLP ]
+ Variable [ Name=$tokensUnrankedDBLP ]
]
-LetVariable [ Name=tokensDBLP ]
+Let Variable [ Name=$tokensDBLP ]
:=
(
SELECT ELEMENT [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
- FROM [ Variable [ Name=tokensUnrankedDBLP ]
+ FROM [ Variable [ Name=$tokensUnrankedDBLP ]
AS
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
,
(
SELECT ELEMENT [
- Variable [ Name=tokenGrouped ]
+ Variable [ Name=$tokenGrouped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
- LetVariable [ Name=id ]
+ Let Variable [ Name=$id ]
:=
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=id
]
Groupby
- Variable [ Name=tokenGrouped ]
+ Variable [ Name=$tokenGrouped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=id ]
- Variable [ Name=paper ]
- Variable [ Name=token ]
- Variable [ Name=tokenUnranked ]
- Variable [ Name=lenDBLP ]
- Variable [ Name=tokensUnrankedDBLP ]
- Variable [ Name=idDBLP ]
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$id ]
+ AS id
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ Variable [ Name=$tokenUnranked ]
+ AS tokenUnranked
+ Variable [ Name=$lenDBLP ]
+ AS lenDBLP
+ Variable [ Name=$tokensUnrankedDBLP ]
+ AS tokensUnrankedDBLP
+ Variable [ Name=$idDBLP ]
+ AS idDBLP
+ Variable [ Name=$paperDBLP ]
+ AS paperDBLP
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=id ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=id
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGrouped ]
+ Variable [ Name=$tokenGrouped ]
ASC
)
AS
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
AT
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Where
OperatorExpr [
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
=
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
]
Orderby
- Variable [ Name=i ]
+ Variable [ Name=$i ]
ASC
)
Orderby
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
ASC
http://git-wip-us.apache.org/repos/asf/incubator-asterixdb/blob/acc12a9b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_5.2/dblp-2_5.3.ast
----------------------------------------------------------------------
diff --git a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_5.2/dblp-2_5.3.ast b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_5.2/dblp-2_5.3.ast
index 2fa4b09..460fb11 100644
--- a/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_5.2/dblp-2_5.3.ast
+++ b/asterix-app/src/test/resources/runtimets/results_parser_sqlpp/fuzzyjoin/dblp-2_5.2/dblp-2_5.3.ast
@@ -6,17 +6,17 @@ RecordConstructor [
(
LiteralExpr [STRING] [id]
:
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
)
(
LiteralExpr [STRING] [len]
:
- Variable [ Name=lenDBLP ]
+ Variable [ Name=$lenDBLP ]
)
(
LiteralExpr [STRING] [tokens]
:
- Variable [ Name=tokensDBLP ]
+ Variable [ Name=$tokensDBLP ]
)
]
]
@@ -24,102 +24,124 @@ FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
]
-LetVariable [ Name=idDBLP ]
+Let Variable [ Name=$idDBLP ]
:=
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=id
]
-LetVariable [ Name=tokensUnrankedDBLP ]
+Let Variable [ Name=$tokensUnrankedDBLP ]
:=
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$paperDBLP ]
Field=title
]
]
-LetVariable [ Name=lenDBLP ]
+Let Variable [ Name=$lenDBLP ]
:=
FunctionCall fuzzyjoin.len@1[
- Variable [ Name=tokensUnrankedDBLP ]
+ Variable [ Name=$tokensUnrankedDBLP ]
]
-LetVariable [ Name=tokensDBLP ]
+Let Variable [ Name=$tokensDBLP ]
:=
(
SELECT ELEMENT [
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
- FROM [ Variable [ Name=tokensUnrankedDBLP ]
+ FROM [ Variable [ Name=$tokensUnrankedDBLP ]
AS
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
,
(
SELECT ELEMENT [
- Variable [ Name=tokenGrouped ]
+ Variable [ Name=$tokenGrouped ]
]
FROM [ FunctionCall Metadata.dataset@1[
LiteralExpr [STRING] [DBLP]
]
AS
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
,
FunctionCall fuzzyjoin.counthashed-word-tokens@1[
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=title
]
]
AS
- Variable [ Name=token ]
+ Variable [ Name=$token ]
]
- LetVariable [ Name=id ]
+ Let Variable [ Name=$id ]
:=
FieldAccessor [
- Variable [ Name=paper ]
+ Variable [ Name=$paper ]
Field=id
]
Groupby
- Variable [ Name=tokenGrouped ]
+ Variable [ Name=$tokenGrouped ]
:=
- Variable [ Name=token ]
- With
- Variable [ Name=id ]
- Variable [ Name=paper ]
- Variable [ Name=token ]
- Variable [ Name=tokenUnranked ]
- Variable [ Name=lenDBLP ]
- Variable [ Name=tokensUnrankedDBLP ]
- Variable [ Name=idDBLP ]
- Variable [ Name=paperDBLP ]
+ Variable [ Name=$token ]
+ GROUP AS
+ Variable [ Name=#1 ]
+ (
+ Variable [ Name=$id ]
+ AS id
+ Variable [ Name=$token ]
+ AS token
+ Variable [ Name=$paper ]
+ AS paper
+ Variable [ Name=$tokenUnranked ]
+ AS tokenUnranked
+ Variable [ Name=$lenDBLP ]
+ AS lenDBLP
+ Variable [ Name=$tokensUnrankedDBLP ]
+ AS tokensUnrankedDBLP
+ Variable [ Name=$idDBLP ]
+ AS idDBLP
+ Variable [ Name=$paperDBLP ]
+ AS paperDBLP
+ )
Orderby
FunctionCall fuzzyjoin.count@1[
- Variable [ Name=id ]
+ (
+ SELECT ELEMENT [
+ FieldAccessor [
+ Variable [ Name=#2 ]
+ Field=id
+ ]
+ ]
+ FROM [ Variable [ Name=#1 ]
+ AS
+ Variable [ Name=#2 ]
+ ]
+ )
]
ASC
- Variable [ Name=tokenGrouped ]
+ Variable [ Name=$tokenGrouped ]
ASC
)
AS
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
AT
- Variable [ Name=i ]
+ Variable [ Name=$i ]
]
Where
OperatorExpr [
- Variable [ Name=tokenUnranked ]
+ Variable [ Name=$tokenUnranked ]
=
- Variable [ Name=tokenRanked ]
+ Variable [ Name=$tokenRanked ]
]
Orderby
- Variable [ Name=i ]
+ Variable [ Name=$i ]
ASC
)
Orderby
- Variable [ Name=idDBLP ]
+ Variable [ Name=$idDBLP ]
ASC