This is an automated email from the ASF dual-hosted git repository. imaxon pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/asterixdb-clients.git
commit 25fc51b0c2148188c03cb43dd120e2618acacf0f Author: Peeyush Gupta <[email protected]> AuthorDate: Thu Mar 28 14:47:10 2024 -0700 [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 <[email protected]> Reviewed-by: Peeyush Gupta <[email protected]> Reviewed-by: Murtadha Hubail <[email protected]> --- .../src/main/taco/plugins/asterixdb_jdbc/dialect.tdd | 6 ++++++ 1 file changed, 6 insertions(+) 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'/>
