Meet DSS user Ben Powis, Data Science Manager at UK retail company MandM Direct Read More

Difference between a formula and an SQL expression.

Level 1
Difference between a formula and an SQL expression.
Hello, I have a question about difference between a formula and an SQL expression.

1. There are "a formula" and an "an SQL expression" options in a few recipe and processors. In case of "a formula", I think I need to refer to the link as follows "https://doc.dataiku.com/dss/latest/advanced/formula.html" offered by Dataiku, and in case of "an SQL expression", I may refer to here "http://www.h2database.com/html/functions.html#difference". Is my understanding right?

2. In terms of custom aggregations in GROUP recipe, is it only possible to use SQL?
0 Kudos
1 Reply
Dataiker
Dataiker
For filters, the "SQL expression" depends on the kind of database you are using. It is only meaningful if the input is a SQL database (unfortunately, we always show the selector, even if it is meaningless)

For custom aggregations, they can indeed only be SQL (DSS formula only does line-per-line evaluation, not aggregation). The SQL dialect to use is either the one of your input database (if any), or H2 (if the input is not database nor HDFS)
0 Kudos
Labels (2)