7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

The input files, stored in AFS, are sample ArcGIS shapefiles. You can get these files from http://www.arcgis.com/home/item.html?id=b07a9393ecbd430795a6f6218443dccc.

  • states.dbf
  • states.prj
  • states.sbn
  • states.sbx
  • states.shp
  • states.shp.xml
  • states.shx

Install these files into AFS (Aster File Server) as follows. From the beehive=> prompt:

beehive=> \afs -mkdir /data

The following command moves the files from your local directory to the AFS. This example assumes that the files have been unzipped into a local directory /home/states.

\afs -put /home/states /data/

Confirm that all files have been uploaded. The correct list of files is:

beehive=> \afs -ls /data/states
Found 7 items
-rwxrwxrwx 2 db_superuser db_superuser 2846   2015-12-30 11:06 /data/states/states.dbf
-rwxrwxrwx 2 db_superuser db_superuser 167    2015-12-30 11:06 /data/states/states.prj
-rwxrwxrwx 2 db_superuser db_superuser 596    2015-12-30 11:06 /data/states/states.sbn
-rwxrwxrwx 2 db_superuser db_superuser 148    2015-12-30 11:06 /data/states/states.sbx
-rwxrwxrwx 2 db_superuser db_superuser 222392 2015-12-30 11:06 /data/states/states.shp
-rwxrwxrwx 2 db_superuser db_superuser 2842   2015-12-30 11:06 /data/states/states.shp.xml
-rwxrwxrwx 2 db_superuser db_superuser 508    2015-12-30 11:06 /data/states/states.shx

You must also create an empty table mr_driver, as follows:

DROP TABLE IF EXISTS mr_driver;
CREATE FACT TABLE mr_driver (id int, partition key (id));