>From Peeyush Gupta <[email protected]>:
Peeyush Gupta has uploaded this change for review. (
https://asterix-gerrit.ics.uci.edu/c/asterixdb-clients/+/18213 )
Change subject: [ASTERIXDB-3371][TACO] Add median as supported function in
tableau dialect
......................................................................
[ASTERIXDB-3371][TACO] Add median as supported function in tableau dialect
Change-Id: I75f8d5b2a98e3d0ce89d266199d810e6c94b0f5c
---
M
asterixdb-jdbc/asterix-jdbc-taco/src/main/taco/plugins/asterixdb_jdbc/dialect.tdd
1 file changed, 15 insertions(+), 0 deletions(-)
git pull ssh://asterix-gerrit.ics.uci.edu:29418/asterixdb-clients
refs/changes/13/18213/1
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'/>
--
To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb-clients/+/18213
To unsubscribe, or for help writing mail filters, visit
https://asterix-gerrit.ics.uci.edu/settings
Gerrit-Project: asterixdb-clients
Gerrit-Branch: master
Gerrit-Change-Id: I75f8d5b2a98e3d0ce89d266199d810e6c94b0f5c
Gerrit-Change-Number: 18213
Gerrit-PatchSet: 1
Gerrit-Owner: Peeyush Gupta <[email protected]>
Gerrit-MessageType: newchange
