Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings
NotificationsYou must be signed in to change notification settings

yuhexiong/oracle-data-pipeline-spark-python

Repository files navigation

(also provided Traditional Chinese version documentREADME-CH.md.)

Data pipeline written by Spark to transfer Oracle to Doris.

Overview

  • Language: Python
  • Data Processing Framework: Spark v3.5.1

Run

Run Docker Container

edit filename in docker-compose.yaml

docker compose up -d

Entry

Oracle To Doris

Replace newline characters with an empty string.
FillRATING column NULL values with 0.

code refer to
(1)oracle_to_doris.py
(2) define schema in yamloracle_to_doris_yaml.py andoracle_to_doris.yaml

  • Oracle Table
| BOOKID  | TITLE               | AUTHOR              | PUBLICATIONYEAR  | GENRE           | RATING | STATUS      ||---------|---------------------|---------------------|------------------|-----------------|--------|-------------|| 1       | Dune                | Frank Herbert       | 1965             | SCIENCE FICTION | 4.5    | AVAILABLE   || 2       | 1984                | George Orwell       | 1949             | DYSTOPIAN       | 4.7    | CHECKED OUT || 3       | Pride and Prejudice | Jane Austen         | 1813             | ROMANCE         | 4.6    | AVAILABLE   || 4       | The Great Gatsby    | F. Scott Fitzgerald | 1925             | CLASSIC         | 4.4    | AVAILABLE   || 5       | The Hobbit          | J.R.R. Tolkien      | 1937             | FANTASY         | 4.8    | CHECKED OUT |
  • Doris Table
| book_id | title               | author              | publication_year | genre           | rating | status      ||---------|---------------------|---------------------|------------------|-----------------|--------|-------------|| 1       | Dune                | Frank Herbert       | 1965             | SCIENCE FICTION | 4.5    | AVAILABLE   || 2       | 1984                | George Orwell       | 1949             | DYSTOPIAN       | 4.7    | CHECKED OUT || 3       | Pride and Prejudice | Jane Austen         | 1813             | ROMANCE         | 4.6    | AVAILABLE   || 4       | The Great Gatsby    | F. Scott Fitzgerald | 1925             | CLASSIC         | 4.4    | AVAILABLE   || 5       | The Hobbit          | J.R.R. Tolkien      | 1937             | FANTASY         | 4.8    | CHECKED OUT |

About

No description or website provided.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published
[8]ページ先頭
©2009-2025 Movatter.jp