7.00.02.01 - Creating Table in the Aster Database - Aster R

Teradata Aster® R User GuideUpdate 3

prodname
Aster R
vrm_release
7.00.02.01
created_date
December 2017
category
Programming Reference
User Guide
featnum
B700-1033-700K

Users can use the function ta.create() to create a table in the Aster Database based on an R data frame. The function takes the provided arguments, and generates a SQL query that creates a table in the Aster Database.

Users can start with verifying the content in the R dataset "women", available in the R package "dataset".

> women
     height    weight
1      58       115
2      59       117
3      60       120
4      61       123
5      62       126
6      63       129
7      64       132
8      65       135
9      66       139
10     67       142
11     68       146
12     69       150
13     70       154
14     71       159
15     72       164

> class(women)
[1] "data.frame"

This example uses the function ta.create() to create a table named "women_ht_wt" in the "public" schema of the Aster Database. The table contains the same data as the "women" dataset, and can be manipulated using Teradata Aster SQL-MapReduce® commands.

ta.create(women, 
table="women_ht_wt", 
schemaName="public", 
tableType="dimension", 
row.names=FALSE, 
colTypes=NULL 
)