Commands
Amberstone commands are found in the $AMBERSTONE_HOME/bin directory. Inside this directory there is a Unix shell script and Windows batch file for each command.
The aggregate command builds the aggregations.
Command structure:
aggregate [partition] [aggregators config] [startYYYYMMDD] [endYYYYMMDD]
Unix syntax:
$AMBESTONE_HOME/bin/aggregate.sh sample basic.xml 20120601 20120630
Windows syntax:
%AMBERSTONE_HOME%\bin\aggregate sample basic.xml 20120601 20120630
The example above builds the aggregates for the sample partition, using the configuration file $AMBERSTONE_HOME/aggregates/conf/basic.xml, for the date range
of 06/01/2012 - 06/30/2012.
The archive command moves the load units in a partition's load-queue into the load-archive. The files are placed into a directory structure with three
levels: year, month and day_of_month.
Command structure:
archive [partition]
Unix syntax:
$AMBERSTONE_HOME/bin/archive.sh sample
Windows syntax:
%AMBERSTONE_HOME\bin\archive sample
The example above runs the archive command for the sample partition.
The delete function deletes data from the fact table in a specific partition, leaving dictionaries intact.
Command structure:
delete [partition] [startYYYYMMDD] [endYYYYMMDD]
Unix syntax:
$AMBESTONE_HOME/bin/delete.sh sample 20120601 20120630
Windows syntax:
%AMBERSTONE_HOME%\bin\delete sample 20120601 20120630
The example above deletes data from the fact table sample partition for the date range
of 06/01/2012 - 06/30/2012.
The drop command either drops an entire partition or a column in the fact table depending on the parameters provided.
Command structure:
drop [partition]
If the column is not provided the entire partition is dropped. If the column is provided the column is dopped from the fact table.
Unix syntax:
$AMBESTONE_HOME/bin/drop.sh sample url
Windows syntax:
%AMBERSTONE_HOME%\bin\drop sample url
The example above drops the url column from the fact table in the sample partition.
The export command exports the data from a partition's fact table based on it's parameters.
Command structure:
export [partition] [select function] [startYYYYMMDD] [endYYYYMMDD]
Unix syntax:
$AMBESTONE_HOME/bin/export.sh sample "select('.*')" 20120601 20120630
Windows syntax:
%AMBERSTONE_HOME%\bin\export sample "select('.*')" 20120601 20120630
The example above exports all the columns in sample partition's fact table for the date range 06/01/2012 - 06/30/2012.
The exported data will be writtin to files in the $AMBERSTONE_HOME/storage/[partition name]/export directory and conform to the specification for load units.
The load command loads data into a partition's fact table.
Command structure:
load [partition] <'archive'>
Unix syntax:
$AMBERSTONE_HOME/bin/load.sh sample
Windows syntax:
%AMBERSTONE_HOME%\bin\load sample
The example above loads the load units located in the sample partition's load-queue into the partition's fact table.
The loader uses the loader configuration, in $AMBERSTONE_HOME/storage/[partition name]/conf/partition.xml, to map the data from the raw data into the table.
If the the optional 'archive' parameter is used, data is loaded in from the load partitions load archive.
The load command always appends to the table. To reload part of the data, first use the delete command to remove the data in the table.
To reload the entire table, first use the trunc command.
The merge command merges cubes, formats them for loading into a database, and writes them to the merged directory where they can be picked up and loaded int a database.
Command structure:
merge
Unix syntax:
$AMBERSTONE_HOME/bin/merge.sh
Windows syntax:
%AMBERSTONE_HOME\bin\merge
The example above runs the merge command.
The read command displays the data in a single partition's fact table based on it's parameters.
Command structure:
read [partition] [select function] [startYYYYMMDD] [endYYYYMMDD]
Unix syntax:
$AMBESTONE_HOME/bin/read.sh sample "select('.*')" 20120601 20120630
Windows syntax:
%AMBERSTONE_HOME%\bin\read sample "select('.*')" 20120601 20120630
The example above displays all the columns in the sample partition's fact table for the date range 06/01/2012 - 06/30/2012.
The rollup command rolls up hourly aggregates into daily aggregates. This command should be executed prior to issuing the merge command.
Command structure:
rollup
Unix syntax:
$AMBERSTONE_HOME/bin/rollup.sh
Windows syntax:
%AMBERSTONE_HOME\bin\rollup
The example above runs the rollup command.
The stat command provides information about a partition.
Command structure:
stat [partition]
Unix syntax:
$AMBESTONE_HOME/bin/stat.sh sample
Windows syntax:
%AMBERSTONE_HOME%\bin\stat sample
The example displays information about the sample partition.
The trunc command deletes all the data from a partitions fact table. The dictionaries are left intact.
Command structure:
trunc [partition]
Unix syntax:
$AMBESTONE_HOME/bin/trunc.sh sample
Windows syntax:
%AMBERSTONE_HOME%\bin\trunc sample
The example truncates the fact table in the sample partition.