loadExampleData() | Teradata R Package - loadExampleData() - Teradata Package for R

Teradata® Package for R User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for R
Release Number
17.20
Published
March 2024
ft:locale
en-US
ft:lastEdition
2024-04-09
dita:mapPath
efv1707506846369.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
nqx1518630623256
Product Category
Teradata Vantage

The loadExampleData() function helps users to load the sample datasets.

tdplyr offers various API's and each API provides some examples. To try the API's in these examples, you need the sample datasets loaded in Vantage. The loadExampleData() function enables the user to load these sample datasets.

This function can only be used in a restricted way. Function arguments can only accept predetermined values, which are found only in loadExampleData() function calls given in the examples provided in Teradata Package for R Function Reference and this User Guide.

  • If the table with the name provided in the function call already exists, this function skips creation and loading of the dataset.
  • This function creates a new table in Vantage. You must drop the table manually if required.

Example

  • Drop the table if it already exists.
    > try(db_drop_table(con, "computers_train1"), silent = TRUE)
  • Check table in Vantage.
    > db_has_table(con, "computers_train1")
    [1] FALSE
  • Load example dataset in Vantage.
    > loadExampleData("kmeans_example", "computers_train1")
    Loading:  ALICE.computers_train1 ....
  • Check table in Vantage again.
    > db_has_table(con, "computers_train1")
    [1] TRUE
  • Print the tbl_teradata of the table loaded to Vantage.
    > tbl(con, "computers_train1")
    # Source:   table<computers_train1> [?? x 6]
    # Database: [Teradata 16.20.50.01] [Teradata Native Driver 17.0.0.2] [TDAPUSER@server.labs.teradata.com/TDAPUSERDB]
          id price speed    hd   ram screen
       <int> <int> <int> <int> <int>  <int>
     1  6036  1445   100   528     4     14
     2  1407  2644    66   426     8     14
     3  1672  1944    50   107     2     14
     4   265  1899    50   120     4     14
     5   469  2599    50   405     8     14
     6  5832  1490    66   340     4     15
     7  3487  1999    33   420     8     15
     8  4221  1695    66   425     8     15
     9   938  2799    50   320     8     15
    10  4894  1739    33   212     4     17
    # ... with more rows
    >