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