AbsaOSS / AbsaOSS/cobrix

Cobol program using MS SQL Server as backend data base

オープン
#445 コメント 5 件 リアクション 0 件 担当者 0 名 GitHub で見る
question
主要言語
Scala
スター
170
フォーク
96
平均マージ
57分
マージ済み PR(30日)
2

説明

## 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.

コントリビューションガイド

このリポジトリのコントリビューションガイドは索引されていません

評価

この issue はまだ評価されていません。

新しい issue をメールで受け取る

初心者向けの GitHub issue を短くまとめたダイジェスト。