vbarua commented on code in PR #12875:
URL: https://github.com/apache/datafusion/pull/12875#discussion_r1797369736


##########
datafusion/substrait/tests/testdata/test_plans/aggregate_no_project.substrait.json:
##########
@@ -0,0 +1,97 @@
+{
+  "extensionUris": [
+    {
+      "uri": 
"https://github.com/substrait-io/substrait/blob/main/extensions/functions_aggregate_generic.yaml";
+    }
+  ],
+  "extensions": [
+    {
+      "extensionFunction": {
+        "functionAnchor": 185,
+        "name": "count:any"
+      }
+    }
+  ],
+  "relations": [
+    {
+      "root": {
+        "input": {
+          "aggregate": {
+            "input": {
+              "read": {
+                "common": {
+                  "direct": {}
+                },
+                "baseSchema": {
+                  "names": [
+                    "a"
+                  ],
+                  "struct": {
+                    "types": [
+                      {
+                        "i64": {
+                          "nullability": "NULLABILITY_NULLABLE"
+                        }
+                      }
+                    ],
+                    "nullability": "NULLABILITY_NULLABLE"
+                  }
+                },
+                "namedTable": {
+                  "names": [
+                    "data"
+                  ]
+                }
+              }
+            },
+            "groupings": [
+              {
+                "groupingExpressions": [
+                  {
+                    "selection": {
+                      "directReference": {
+                        "structField": {}
+                      },
+                      "rootReference": {}
+                    }
+                  }
+                ]
+              }
+            ],
+            "measures": [
+              {
+                "measure": {
+                  "functionReference": 185,
+                  "phase": "AGGREGATION_PHASE_INITIAL_TO_RESULT",
+                  "outputType": {
+                    "i64": {}
+                  },
+                  "arguments": [
+                    {
+                      "value": {
+                        "selection": {
+                          "directReference": {
+                            "structField": {}
+                          },
+                          "rootReference": {}
+                        }
+                      }
+                    }
+                  ]
+                }
+              }
+            ]
+          }
+        },
+        "names": [
+          "a",
+          "countA"
+        ]
+      }
+    }
+  ],
+  "version": {
+    "minorNumber": 54,
+    "producer": "subframe"

Review Comment:
   Is this a publicly available producer? It's useful to know how the plans 
where generated, in case we ever need to regenerate them to pull in updates 
from the producers.
   
   The plan itself is perfectly valid and fine as-is.
   
   If we ever want/need to generate an equivalent plan we can use 
https://github.com/substrait-io/substrait-java/tree/main/isthmus-cli with a 
query like:
   ```
   ./isthmus --create "CREATE TABLE data(a INT)" "SELECT a, COUNT(*) AS c FROM 
data GROUP BY a"
   ```
   
   



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to