commit 25fc51b0c2148188c03cb43dd120e2618acacf0f
author Peeyush Gupta <peeyush.gupta@couchbase.com> Thu Mar 28 14:47:10 2024 -0700
committer Peeyush Gupta <peeyush.gupta@couchbase.com> Fri Mar 29 15:21:33 2024 +0000
tree 2833a2846698da30d0b7989bcaca6fddf50ce937
parent b5d6318a78d28bd21a20dee87dcba0ed6d66faaa

[ASTERIXDB-3371][TACO] Add median as supported function in tableau dialect

Change-Id: I75f8d5b2a98e3d0ce89d266199d810e6c94b0f5c
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb-clients/+/18213
Tested-by: Jenkins <jenkins@fulliautomatix.ics.uci.edu>
Reviewed-by: Peeyush Gupta <peeyush.gupta@couchbase.com>
Reviewed-by: Murtadha Hubail <mhubail@apache.org>

asterixdb-jdbc/asterix-jdbc-taco/src/main/taco/plugins/asterixdb_jdbc/dialect.tdd

diff --git a/asterixdb-jdbc/asterix-jdbc-taco/src/main/taco/plugins/asterixdb_jdbc/dialect.tdd b/asterixdb-jdbc/asterix-jdbc-taco/src/main/taco/plugins/asterixdb_jdbc/dialect.tdd
index bef055e..cff91e3 100644
--- a/asterixdb-jdbc/asterix-jdbc-taco/src/main/taco/plugins/asterixdb_jdbc/dialect.tdd
+++ b/asterixdb-jdbc/asterix-jdbc-taco/src/main/taco/plugins/asterixdb_jdbc/dialect.tdd
@@ -619,6 +619,11 @@
       <unagg-formula>%1</unagg-formula>
       <argument type='real' />
     </function>
+    <function group='aggregate' name='MEDIAN' return-type='real'>
+      <formula>MEDIAN(%1)</formula>
+      <unagg-formula>%1</unagg-formula>
+      <argument type='real' />
+    </function>
     <function group='aggregate' name='COUNT' return-type='int'>
       <formula>COUNT(%1)</formula>
       <unagg-formula>(CASE WHEN %1 IS UNKNOWN THEN 0 ELSE 1 END)</unagg-formula>
@@ -1386,6 +1391,7 @@
     <aggregation value='AGG_STDEVP'/>
     <aggregation value='AGG_VAR'/>
     <aggregation value='AGG_VARP'/>
+    <aggregation value='AGG_MEDIAN'/>
 
     <aggregation value='AGG_YEAR'/>
     <aggregation value='AGG_QTR'/>