AbsaOSS / AbsaOSS/cobrix

Cobol program using MS SQL Server as backend data base

Đang mở
#445 5 bình luận 0 reaction 0 người được giao Xem trên GitHub
question
Ngôn ngữ chính
Scala
Star
170
Fork
96
Merge trung bình
57 phút
Pull request đã merge (30 ngày)
2

Mô tả

## Background
I am currently working on a project where a Cobol based system is using a MS SQL Server instance as its back end.

I am able to connect to the SQL server database via a JDBC connection which returns the table into a Spark Dataframe, however it is still encoded with EBCDIC encoding, which is an obvious problem when using AWS GLUE and wanting to post the data into parquet files for down stream processes. I am also able to parse the copybook via your copybook parser.

However, these two structures are vastly different, which are posing limitations to the process that I would like to build. I would still want to use your package as I believe there are inherent synergies.

## Question
There are a few questions:
1. Is there any advise that you can give me with regards my use case and using your package?
2. Is there a way that I can just use your decoding technology while in flight, or after the data has landed in the dataframe?
3. Is there a way to flatten the schema structure once the parser has completed?

Your assistance would be greatly appreciated.

Hướng dẫn đóng góp

Chưa lập chỉ mục được hướng dẫn đóng góp cho kho mã nguồn này

Đánh giá

Issue này chưa được đánh giá.

Nhận issue mới trong hộp thư của bạn

Bản tóm tắt ngắn những issue GitHub phù hợp với người mới.