Comments (7)
dhalperi
commented on August 10, 2024
FYI @7andrew7
from myria-web.
domoritz
commented on August 10, 2024
Why not just write the case statement? It is not much longer and more readable. IMHO.
from myria-web.
dhalperi
commented on August 10, 2024
Our experiences with SQLShare have taught us that these language extensions
can be very useful for science users, when applied reasonably.
The CASE WHEN statement is definitely a less readable and more complex
construct. And it's even worse when you're applying the same logic in
parallel across n columns...
Daniel Halperin
Director of Research for Scalable Analytics
eScience Institute
University of Washington
On Thu, Mar 6, 2014 at 4:50 PM, Dominik Moritz [email protected]:
Why not just write the case statement? It is not much longer and more
readable. IMHO.Reply to this email directly or view it on GitHubhttps://github.com//issues/44#issuecomment-36956616
.
from myria-web.
domoritz
commented on August 10, 2024
Okay, I'm working on this.
from myria-web.
7andrew7
commented on August 10, 2024
Dan and I observed that Myrial functions can express this. Optional arguments are not supported, so we might need different flavors for this.
from myria-web.
domoritz
commented on August 10, 2024
Yes, I am currently working on a way to add a library of such functions that can be composed of expressions. If you are around, we could have a 5min chat about this.
from myria-web.
7andrew7
commented on August 10, 2024
DEF SaveDiv(n, d):
CASE WHEN d == 0 THEN 0 ELSE n / d END
from myria-web.
Related Issues (20)
- All results are listed on /datasets, making "real" datasets harder to locate HOT 1
- Add triangle query to list of examples
- Backend dropdown menu disappears on click HOT 1
- Lag when Waiting for Query Results HOT 2
- Wrong time selected
- Remove dependency on myria-python
- JSON dataset link on Results tab of query editor should open new tab/window HOT 2
- "Creating query" is not using https
- Consider sanitizing non-ASCII whitespace characters in queries HOT 1
- Remove unnecessary submodules HOT 3
- Replace raco submodule with install/develop HOT 2
- Move myria-web docs from myria-docs to myria-web HOT 1
- Expose MyriaX version in UI
- Travis is failing HOT 4
- Add a checkbox for push_sql groupby
- Refactor PerfEnforce Myria-Web Interface
- Move myria-web repo to uwdb org
- I'm not presently able to execute any of the data load data from the demo UI HOT 3
- Display informative error message when selected query language is mismatched with query
- Can't instantiate abstract class Fixpoint with abstract methods partitioning HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from myria-web.