Row size is wider than MySql supports. Please reduce the row size or number of columns.
OK so I have this one dataflow, DataFlow A, that feeds into other dataflows, DataFlow B and DataFlow C, that works perfectly fine until I try and add this one additional column to it called Lead Source. When I add this column to DataFlow A it runs just fine, however, DataFlow B and C then fail due to this reason: "Row size is wider than MySql supports. Please reduce the row size or number of columns."
In DataFlow A, I have tried the following but neither have worked:
1) CAST(a.`LeadSource` as CHAR(1000)) as LeadSource
2) ALTER TABLE `agreements2` MODIFY COLUMN `LeadSource` VARCHAR(100)
Then when trying to edit DataFlow B and C, I can't even load the table to remove the column since its not needed for those dataflows.
Is there something else I can try? Please help!
Best Answer
-
I have run into this issue in mySQL dataflows and my workaround was to run the table through an ETL dataflow first as that does not appear to have a column limit. The ETL would exclude any extra columns not required.
-----------------
Chris3
Answers
-
I have run into this issue in mySQL dataflows and my workaround was to run the table through an ETL dataflow first as that does not appear to have a column limit. The ETL would exclude any extra columns not required.
-----------------
Chris3 -
Thanks. I just created a copy of the same dataflow and removed the one column. I fed this new dataflow into the other dataflows and all seems to be working correctly now. Thanks for the idea! Just wish there was another fix instead of created an additioanl dataflow.
0 -
I had one and flipped it to RedShift. There was a regex expression (probably why it was not redshift to begin with) so I had to convert that to redshift syntax. to me, much easier that "re-writing" in magic ETL...
0
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 646 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 75 App Studio
- 43 Variables
- 728 Automate
- 186 Apps
- 467 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 112 Community Announcements
- 4.8K Archive