5 Simple Steps to Migrate Data Warehouses from Redshift to Alibaba Cloud AnalyticDB for PG

Product Architecture Comparison

Comparison of ADB PG and Redshift

Key Syntax Comparison and Migration

Differences in Syntax for DDL Table Creation

Syntax Guide

DDL Conversion Example 1

CREATE TABLE schema1.table1(
filed1 VARCHAR(100) ENCODE lzo,
filed2 INTEGER DISTKEY,
filed3 INTEGER,
filed4 BIGINT ENCODE lzo,
filed5 INTEGER,)
INTERLEAVED SORTKEY (
filed1,
filed2);
CREATE TABLE schema1.table1
(
filed1 VARCHAR(100) ,
filed3 INTEGER,
filed5 INTEGER
)
WITH(APPENDONLY=true,ORIENTATION=column,COMPRESSTYPE=zlib)
DISTRIBUTED BY (filed2)
SORTKEY
(
filed1,
filed2
)

DDL Conversion Example 2

CREATE TABLE schema2.table2
(
filed1 VARCHAR(50) ENCODE lzo,
filed2 VARCHAR(50) ENCODE lzo,
filed3 VARCHAR(20) ENCODE lzo,
)
DISTSTYLE EVEN
INTERLEAVED SORTKEY
(
filed1
);
CREATE TABLE schema2.table2(
filed1 VARCHAR(50),
filed2 VARCHAR(50),
filed3 VARCHAR(20))
WITH(APPENDONLY=true, ORIENTATION=column, COMPRESSTYPE=zlib)
DISTRIBUTED randomly
SORTKEY
(
filed1
);

Data Migration

Original Source:

--

--

--

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

OTA Firmware Update on Arduino

Ansible Use Case

DevOps Open Source Popular Tools

GPT-3 & The Power of Prompts

Think Twice, Before Re-Inventing The Tech Wheel

Docker: Connecting Developers and DevOps

Install and Update Dark Country Game in a Few Clicks!💀

7 habits of highly effective C# developers

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alibaba Cloud

Alibaba Cloud

Follow me to keep abreast with the latest technology news, industry insights, and developer trends. Alibaba Cloud website:https://www.alibabacloud.com

More from Medium

Managing Logs for AWS Storage Infrastructure: S3, EBS, and EFS

AWS S3 Same Region Replication (SRR)

AWS S3 — Same Region Replication diagram

Building Event Driven Applications with Apache Flink, Apache Kafka and Amazon EMR — Part 2

Loading Data from PostgreSQL to AWS Redshift