Comments (1)
Further analysis shows that timestamp values cause the same errors
2024/03/25 18:26:09 - Row Preview - ERROR: org.apache.hop.core.exception.HopValueException:
2024/03/25 18:26:09 - Row Preview - create_time None : Unknown type 0 specified.
2024/03/25 18:26:09 - Row Preview -
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.core.row.value.ValueMetaBase.getString(ValueMetaBase.java:2133)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.ui.core.dialog.PreviewRowsDialog.getDataForRow(PreviewRowsDialog.java:373)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.ui.core.dialog.PreviewRowsDialog.lambda$getData$7(PreviewRowsDialog.java:342)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:40)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:132)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:5040)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4520)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.ui.core.dialog.BaseDialog.defaultShellHandling(BaseDialog.java:519)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.ui.core.dialog.PreviewRowsDialog.open(PreviewRowsDialog.java:244)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.pipeline.transforms.tableinput.TableInputDialog.preview(TableInputDialog.java:574)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.pipeline.transforms.tableinput.TableInputDialog.lambda$open$3(TableInputDialog.java:327)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.ui.core.dialog.BaseDialog.defaultShellHandling(BaseDialog.java:519)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.pipeline.transforms.tableinput.TableInputDialog.open(TableInputDialog.java:336)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.ui.hopgui.file.pipeline.delegates.HopGuiPipelineTransformDelegate.editTransform(HopGuiPipelineTransformDelegate.java:174)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.editTransform(HopGuiPipelineGraph.java:3400)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.ui.hopgui.file.pipeline.HopGuiPipelineGraph.mouseDoubleClick(HopGuiPipelineGraph.java:597)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:200)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:89)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Display.sendEvent(Display.java:5855)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1529)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:5065)
2024/03/25 18:26:09 - Row Preview - at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:4517)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.ui.hopgui.HopGui.open(HopGui.java:473)
2024/03/25 18:26:09 - Row Preview - at org.apache.hop.ui.hopgui.HopGui.main(HopGui.java:351)
... but not always. Retrieving data from a different MySQL Server works as expected (for datatime values at least)
The reason is the option "supports timestamp data type" in the "Relational Database Connection" setting, which is rather unintuitive as it deals with timestamp and we're reading datetime values from the table.
For me it is not clear what the option is for in the first place. Either MySQL/MariaDB supports these data types or not. And we're telling the "Relational Database Connection" which RDBMS we're connecting to. What would be the consequences of having this option selected and the RDBMS doesn't support timestamp?
So would you please either set this option by default or at least provide a more speaking error message. Thank you very much.
from hop.
Related Issues (20)
- [Bug]: Detach operation does not change target transform of a switch case transform
- [Bug]: Data Set Metadata format
- [Task]: Update java version to java 17 HOT 1
- [Bug]: Hop Gui - unable to insert a new Simple Mapping transform HOT 1
- [Feature Request]: An eventually consistent, cached, execution information file location
- [Feature Request]: extended metadata annotations for `@Transform`, `@Action` and `@HopMetadataProperty` HOT 1
- [Task]: Bump versions to 2.10.0-SNAPSHOT
- [Bug]: Move files - issues on working on sFTP files
- [Task]: Issue with Maven Builds: Assembly Creation Error and Rat Check Failure HOT 1
- [Task]: Fix typo for "Variable substitution" tool-tip
- [Task]: Azure Move Files - Support of tests against Azurite testcontainer or actual Azure on the cloud HOT 1
- [Task]: Bump jandex from 3.1.6 to 3.1.8
- [Bug]: Issue with tests in hop-plugins-misc-git on Windows
- [Bug]: RedshiftBulkLoaderMeta has an incorrect `groupKey` in the `@HopMetadataAttribute` for the database field. HOT 1
- [Task]: Weblate is not referenced anywhere on the site HOT 2
- [Bug]: Issue with hop-assemblies-samples HOT 4
- [Bug]: Table output insert statement does not quote field names in INSERT statement HOT 3
- [Task]: Update Documentation contribution guide
- [Task]: Bump org.eclipse.platform
- [Task]: Clean up of dialog constructors for actions and transforms
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 hop.