beccon4 commented on issue #3759:
URL: https://github.com/apache/hop/issues/3759#issuecomment-2018686858
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.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
