7.00.02.01 - Loading Data to Aster - 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.push() to load data from R into an existing Aster virtual data frame.

For example:

> class(tadf_women)
[1] "ta.data.frame" 

> new_row<-cbind(73,169)
> new_row
     [,1] [,2]
[1,]   73  169 

> ta.push(tadf_women, new_row)
> tadf_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
16     73       169
Warning message:
In ta.show(tadf, maxRows) :   
Printing rows in random order since base table/view is neither ordered nor have row_names column.

Users can use the function ta.load.csv() to load data from a file in .csv format to an Aster virtual data frame.

For example:

> ta.load.csv(tadf_women, file="new_row_57_112.csv", header=FALSE)
> tadf_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
16     73       169
17     57       112
Warning message:
In ta.show(tadf, maxRows) :   
Printing rows in random order since base table/view is neither ordered nor have row_names column.
The "Warning message" in the output is an explanatory note to the user.