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 )