Calling a procedure in MySQL ETL flow
I'm trying to create a pivot table output using a stored procedure, but I'm getting an error while call the procedure.
when I to execute the procudure, I'm getting the error as:
Let me know what wrong I'm doing here.
Thanks in Advance,
Srinivas V
Best Answer
-
i would start by paring back my stored proc to ensure that i had the proper syntax for CREATE-ing and calling a stored proc. keep in mind we're on mysql v 5.6 i believe.
THEN i would take a really close look at the error message.
it says <number> FROM.
I would guess that you have values in your table that contain spaces so SQL is 'mininterpreting' how to handle table creation, OR you're not properly separating the values as column names in your GROUP_CONCAT statement in a way that SQL can interpret into separate columns.
Try taking your SQL statement out of the Stored PROC and running it as a straight SELECT statement. Make sure the results are as you expect.
LASTLY, MySQL is not strong at Pivot Statements. Consider using MagicETL. I know it's a pain to setup and ideally you don't want to have to maintain code, but long term it will probably be more performant than SQL.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Answers
-
i would start by paring back my stored proc to ensure that i had the proper syntax for CREATE-ing and calling a stored proc. keep in mind we're on mysql v 5.6 i believe.
THEN i would take a really close look at the error message.
it says <number> FROM.
I would guess that you have values in your table that contain spaces so SQL is 'mininterpreting' how to handle table creation, OR you're not properly separating the values as column names in your GROUP_CONCAT statement in a way that SQL can interpret into separate columns.
Try taking your SQL statement out of the Stored PROC and running it as a straight SELECT statement. Make sure the results are as you expect.
LASTLY, MySQL is not strong at Pivot Statements. Consider using MagicETL. I know it's a pain to setup and ideally you don't want to have to maintain code, but long term it will probably be more performant than SQL.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks.
As you correctly mentioned, The column names were not getting populated correctly from the procedure. Executed the code manually and found that out.
0
Categories
- All Categories
- 1.5K Product Ideas
- 1.5K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 90 SQL DataFlows
- 563 Datasets
- 2K Magic ETL
- 3.4K Visualize
- 2.3K Charting
- 592 Beast Mode
- 13 App Studio
- 28 Variables
- 588 Automate
- 143 Apps
- 417 APIs & Domo Developer
- 27 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 361 Distribute
- 99 Domo Everywhere
- 260 Scheduled Reports
- 2 Software Integrations
- 94 Manage
- 91 Governance & Security
- 10 Product Releases
- Community Forums
- 37 Getting Started
- 28 Community Member Introductions
- 90 Community Announcements
- 4.8K Archive