The Dataiku Frontrunner Awards are now accepting submissions until July 15 to recognize your achievements! ENTER YOUR SUBMISSION

Difference between a formula and an SQL expression.

Solved!
MJLEE
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 Solution
Clément_Stenac
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)

View solution in original post

0 Kudos
1 Reply
Clément_Stenac
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)

View solution in original post

0 Kudos
Labels (2)
A banner prompting to get Dataiku DSS
Public