[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>
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'/>