7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
zuk1466006200888

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));