Do MySQL dataflows support the use of the WITH clause?
I'm trying to use a WITH clause as outlined here:
in one of my MySQL dataflows.
But I keep getting this error:
"The database reported a syntax error. You have an error in your SQL syntax"
My (very simple) code is:
WITH test AS (SELECT`EmaiName` FROM transform_data_2)
SELECT `EmaiName` FROM test
As far as I can tell that should be correct - is this just a matter of Domo not supporting WITH?
Not a big deal either way, but it would be nice to know.
I had the same issue some time ago. And could not find a solution or documentation on DOMO about this.
My workaround was to use a transform for each Common Table Expression and then reference them in another transform or output.
Technically it's not the same but it serves the needs.
Hope this helps.
**You can say "Thank you" by clicking the thumbs up in the post that helped you.1
I ended up doing the same thing. Sounds like WITH probably just isn't available in Domo then.
Thanks for your input0
If @RGranada reply addressed your question please marked it as solved.
Also you can suggest this as an enhancement in our Ideas Exhange.
Would be nice to know what other standard mySQL features arent supported by DOMO. the With statement is commonly used. Do we need to request an enhancement for every feature in mySQL that DOMO doesnt support? Perhaps some doc would be nice to tell the end user "mySQL is not the actual mySQL, but a limited set of its abilities. DOMO currently does not support the following mySQL functions/features...."
WITH is probably been around for many versions.0
To those reading this thread years later: When I looked into this, it is because the version of MySQL that Domo is running does not support WITH. You can check the version by running this command: SELECT VERSION(). That command outputs 5.6.37-82.2-82.2, however WITH and Common Table Expressions weren't added to MySQL until version 8.0. Based on this other thread, https://dojo.domo.com/discussion/51065/mysql-version, it seems like Domo may update it eventually but so far no dice.0
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 82 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive