Calculated field
ASIN([score])
Sample data
| id | amount | units | score | other |
|---|---|---|---|---|
| 1 | -2.5 | 2 | -0.8 | 3 |
| 2 | 0 | 0 | 0 | 4 |
| 3 | 1.5 | 3 | 0.25 | 2 |
| 4 | 4 | 4 | 0.5 | 8 |
| 5 | 9 | 5 | 0.8 | 11 |
| 6 | 16 | 6 | 1 | 14 |
| 7 | null | 7 | null | 9 |
| 8 | 4 | 8 | -0.5 | null |
The same calculation as SQL
SELECT asin(score) AS result FROM input ORDER BY id
Runs the example above.
SELECT asin(score) AS result FROM input ORDER BY id
Written for this dialect; not run here.
SELECT asin(score) AS result FROM input ORDER BY id
Written for this dialect; not run here.
Result
| id | amount | units | score | result |
|---|---|---|---|---|
| 1 | -2.5 | 2 | -0.8 | -0.927295 |
| 2 | 0 | 0 | 0 | 0 |
| 3 | 1.5 | 3 | 0.25 | 0.25268 |
| 4 | 4 | 4 | 0.5 | 0.523599 |
| 5 | 9 | 5 | 0.8 | 0.927295 |
| 6 | 16 | 6 | 1 | 1.5708 |
| 7 | null | 7 | null | null |
| 8 | 4 | 8 | -0.5 | -0.523599 |
Same rows from the calculation and from the SQL in DuckDB.
Where a naive translation goes wrong
- Replacing null results with zero changes missing-value semantics.
Naive SQL
SELECT coalesce((asin(score)),0) AS result FROM input ORDER BY id
id amount units score result 1 -2.5 2 -0.8 -0.927295 2 0 0 0 0 3 1.5 3 0.25 0.25268 4 4 4 0.5 0.523599 5 9 5 0.8 0.927295 6 16 6 1 1.5708 7 null 7 null 0 8 4 8 -0.5 -0.523599 Matches the calculation
SELECT asin(score) AS result FROM input ORDER BY id
id amount units score result 1 -2.5 2 -0.8 -0.927295 2 0 0 0 0 3 1.5 3 0.25 0.25268 4 4 4 0.5 0.523599 5 9 5 0.8 0.927295 6 16 6 1 1.5708 7 null 7 null null 8 4 8 -0.5 -0.523599
Signature
ASIN(number)