Input - Aster Analytics

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