DATETIME field with NULL value
I am running into an issue where when I load up some data via workbench there is a table that has a DATETIME field where the default value is NULL. When workbench is querying that, it absolutely does not like that there is a NULL value in that field. It takes about 20+ hours to run the entire process. I removed the column to test it out and the entire process finished executing in around 6 minutes. Is there anyone else handling something similar to this? If so, how are you able to allow workbench to do this without a hiccup.
Thanks
Answers
-
Is it the querying that's taking a long time or the data upload to Domo that's taking a long time?
Are you joining to another table causing the null values? If so when you removed the null column did you only exclude the field from the query itself, uncheck the columns to upload in the schema or remove the table join as well?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
It is the querying. The portion before the process monitor says:
"[07.14.22 2:57:53 PM] Finished reading XXX,XXX data rows." and so on
There is no join as far as I know, and when I removed the column I simply excluded it from the query itself.
0 -
@Jmoreno, Did you find an answer to this? We're having some issues related to null DATETIME values, wondering if you ever discovered the root cause..
0 -
We have identified that the major issue that is causing this is if you have the timezone conversion activated on the workbench job. We removed it, ran a replace of the whole dataset, then re-added it back in and it seemed to have fixed itself.... for now. We have been running into quite a few issues regarding DATETIME fields recently after their daylight savings update.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive