Creation of partitioned ORC data

Attention : This code requires administrator privileges.

This SAS^© script demonstrates the creation of ORC (Optimized Row Columnar) tables partitioned by the 'dealer' variable. It uses inline data (`cards;`) to populate the `mydblib.compare` and `mydblib.seqtab1` tables. The script also includes initial cleaning steps (`proc delete`) and verification of the created data (`proc print`). It is intended to be executed after submitting the `createLibname` program to establish the database connection via `mydblib`.

Data Analysis

Type : INTERNAL_CREATION

Data is defined directly in the script via a `cards;` clause in a DATA STEP. It is then used to create tables.

1 Code Block

PROC DELETE

Explanation :
Deletes existing `mydblib.seqtab1` and `mydblib.compare` tables in the `mydblib` library to ensure a clean environment before creating new data.

Copied!

1
2	PROC DELETE
3	DATA=mydblib.seqtab1;
4
5	RUN;
6	PROC DELETE
7	DATA=mydblib.compare;
8
9	RUN;
10

2 Code Block

DATA STEP Data

Explanation :
This DATA STEP creates three tables: `mydblib.compare`, `work.apd`, and `mydblib.seqtab1`. The `mydblib.seqtab1` table is configured to be an ORC table partitioned by the `dealer` column in the underlying database system (likely Hadoop). Data is read from the provided lines (`cards;`) and assigned to the specified variables.

Copied!

1	DATA mydblib.compare
2	work.apd
3	mydblib.seqtab1 (DBCREATE_TABLE_OPTS="PARTITIONED BY (dealer string)
4	STORED AS ORC");
5
6	INPUT car $ color $ dealer $ sales returns dest $;
7	CARDS;
8	Toyota Red Smith 10000 100 NC
9	Toyota Red Smith 15000 110 CT
10	Chevy Green Smith 17000 45 NJ
11	Ford Blue Smith 12000 0 CA
12	Toyota Red Jones 4000 20 NC
13	Ford Blue Finch 10000 400 NC
14	Toyota Red Smith 10000 100 NJ
15	Ford White Smith 15000 110 NC
16	Ford Blue Smith 12000 0 NJ
17	Toyota Green Jones 4000 20 NC
18	Toyota Black Jones 4000 20 FL
19	Toyota Red Jones 4000 20 NC
20	Ford Blue Finch 10000 400 AL
21	Chevy White Finch 10000 400 SC
22	Ford Black Finch 10000 400 SC
23	Chrysler Blue Finch 20000 400 NC
24	Chrysler Green Finch 20000 400 CT
25	Toyota Green Jones 10000 100 NC
26	Toyota Red Finch 15000 110 CT
27	Ford Green Smith 17000 45 NJ
28	;
29	RUN;

3 Code Block

PROC PRINT

Explanation :
Displays the content of the `mydblib.seqtab1` table using PROC PRINT, with a title 'PROC PRINT OF DBLIB.SEQTAB1' to identify it in the output.

Copied!

1	title1 '
2	PROC PRINT OF DBLIB.SEQTAB1';
3	PROC PRINT
4	DATA=mydblib.seqtab1;
5
6	RUN;
7

4 Code Block

PROC PRINT

Explanation :
Displays the content of the `mydblib.compare` table using PROC PRINT, with a title 'PROC PRINT OF DBLIB.COMPARE' to identify it in the output.

Copied!

1	title1 '
2	PROC PRINT OF DBLIB.COMPARE';
3	PROC PRINT
4	DATA=mydblib.compare;
5
6	RUN;
7

This material is provided "as is" by We Are Cas. There are no warranties, expressed or implied, as to merchantability or fitness for a particular purpose regarding the materials or code contained herein. We Are Cas is not responsible for errors in this material as it now exists or will exist, nor does We Are Cas provide technical support for it.

Retour à la liste