[
https://issues.apache.org/jira/browse/BEAM-13609?focusedWorklogId=722356&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-722356
]
ASF GitHub Bot logged work on BEAM-13609:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 07/Feb/22 21:57
Start Date: 07/Feb/22 21:57
Worklog Time Spent: 10m
Work Description: pabloem commented on pull request #16451:
URL: https://github.com/apache/beam/pull/16451#issuecomment-1031972388
sorry about the delay - and thanks so much for the fix @vitaly-ivanov !
I don't see a lot of information regarding this issue, which is interesting.
I think your current fix may work for RAW, but may not work for e.g. COUNT(*),
which would return a BigInt (and what does that return as the
`columnDisplaySize`?)
I see this:
https://stackoverflow.com/questions/1410267/oracle-resultsetmetadata-getprecision-getscale
--
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]
Issue Time Tracking
-------------------
Worklog Id: (was: 722356)
Time Spent: 2h (was: 1h 50m)
> Not all variable length types works properly for Oracle DB
> ----------------------------------------------------------
>
> Key: BEAM-13609
> URL: https://issues.apache.org/jira/browse/BEAM-13609
> Project: Beam
> Issue Type: Bug
> Components: io-java-jdbc
> Affects Versions: 2.35.0
> Reporter: Vitaly Ivanov
> Assignee: Vitaly Ivanov
> Priority: P2
> Time Spent: 2h
> Remaining Estimate: 0h
>
> For example RAW(16) fails while comparing field length because the Oracle
> JDBC driver returns precision = 0 but columnDisplaySize = 16.
>
>
> {noformat}
> Exception in thread "main"
> org.apache.beam.sdk.Pipeline$PipelineExecutionException:
> java.lang.IllegalArgumentException
> at
> org.apache.beam.runners.direct.DirectRunner$DirectPipelineResult.waitUntilFinish(DirectRunner.java:373)
> at
> org.apache.beam.runners.direct.DirectRunner$DirectPipelineResult.waitUntilFinish(DirectRunner.java:341)
> at org.apache.beam.runners.direct.DirectRunner.run(DirectRunner.java:218)
> at org.apache.beam.runners.direct.DirectRunner.run(DirectRunner.java:67)
> at org.apache.beam.sdk.Pipeline.run(Pipeline.java:323)
> at org.apache.beam.sdk.Pipeline.run(Pipeline.java:309)
> at io.synthesized.testingsuite.SubsetterRunner.run(SubsetterRunner.kt:75)
> at
> io.synthesized.testingsuite.SubsetterRunnerKt.main(SubsetterRunner.kt:39)
> at io.synthesized.testingsuite.SubsetterRunnerKt.main(SubsetterRunner.kt)
> Caused by: java.lang.IllegalArgumentException
> at
> org.apache.beam.vendor.guava.v26_0_jre.com.google.common.base.Preconditions.checkArgument(Preconditions.java:127)
> at
> org.apache.beam.sdk.io.jdbc.LogicalTypes$VariableLengthBytes.toInputType(LogicalTypes.java:250)
> at
> org.apache.beam.sdk.io.jdbc.LogicalTypes$VariableLengthBytes.toInputType(LogicalTypes.java:236)
> at
> org.apache.beam.sdk.io.jdbc.SchemaUtil.lambda$createLogicalTypeExtractor$ca0ab2ec$1(SchemaUtil.java:308)
> at
> org.apache.beam.sdk.io.jdbc.SchemaUtil$BeamRowMapper.mapRow(SchemaUtil.java:378)
> at
> org.apache.beam.sdk.io.jdbc.SchemaUtil$BeamRowMapper.mapRow(SchemaUtil.java:356)
> at
> org.apache.beam.sdk.io.jdbc.JdbcIO$ReadFn.processElement(JdbcIO.java:1212)
> Process finished with exit code 137 (interrupted by signal 9:
> SIGKILL){noformat}
>
>
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
