Comments (5)
Thank you very much for confirming it.
We got the negative values earlier and data on s3 is not changed. It seems odd that suddenly negative sign is missing. I will copy new set of files and retest it.
from cobrix.
Forget to mention running the ebcdic conversion in Databricks environment.
from cobrix.
Hi, @devoplib,
A couple of questions from my side:
- What is the definition of the field in the copybook?
- Could you give some examples of correct and incorrect values and their HEX representation in the corresponding '_debug' column?
- Is your input data EBCDIC or ASCII?
- Do I understand correctly that you started to have positive numbers for columns that were negative for the exactly the same data?
from cobrix.
Definition of the fields is PIC S9(9)V9(2) COMP-3
Input data is EBCDIC
EOD_METRICSCARD_TPD_SVER_AMT EOD_METRICSCARD_TPD_SVER_AMT_debug
367876.90 00036787690C ===> This should be 00036787690D
Initially the values are Negative and Suddenly getting POSITIVE values for example for all the SVER AMT columns should be NEGATIVE but getting POSITIVE now as shown above.
Please let me know If any additional information is needed.
from cobrix.
EOD_METRICSCARD_TPD_SVER_AMT_debug
shows exact bytes found in the file. From what I can see Cobrix parses BCD (COMP-3) numbers correctly. It seems the issue is at the place the source file is generated.
00036787690C
is indeed 367876.90
.
from cobrix.
Related Issues (20)
- BBBB in copybook HOT 3
- Is it possible to read a nested Binary Field? HOT 1
- Record length option is ignored when generate record id is turued on
- Add CI/CD for automatic releases
- Reading EBCDIC file with multiple structure HOT 1
- DataBricks Unity Catalog and Cobrix HOT 7
- Reading Variable Length File with OCCCURS DEPENDING HOT 12
- NoClassDefFoundError: Could not initialize class za.co.absa.cobrix.cobol.parser.decoders.FloatingPointDecoders$ HOT 3
- Not able to parse the content correctly when copybook has OCCURS X TIMES DEPENDING ON FIELD_NAME HOT 3
- Support for decimal scaling PV HOT 6
- Can't read multiple main headers defined in single copybook HOT 4
- Add support for parsing copybooks given Spark options
- How to read a pipe separated file with Cobrix HOT 3
- PIC S9(10)V USAGE COMP-3 is converted to long instead of Decimal(10,0) HOT 4
- comp-3 values parsing issues HOT 2
- Shade ANTLR runtime in the parser to avoid ANTLR potential incompatibility issues
- Under some circumstances Cobrix selects wrong record reader failing the Spark job
- Add a feature to collapse structs or the output data
- Add support for `_` for key generation
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 cobrix.