Smart Acceleration Command Line Utility Options

You can perform various operations in the Arcadia Smart Acceleration™ Command Line Utility.

The following options are available in the Arcadia Smart Acceleration™ Command Line Utility:

--h, --help

Obtain help menu.

To provide a list of all options available in the utility, use the following command syntax, in either the long or short form:

./arcviz util recommendation --help
./arcviz util recommendation --h
--query

Specify a single query.

To get analytical view recommendations from one query, use the following command syntax:

./arcviz util recommendation --dcname=Recommendation --query=<QUERY>  
--Queries

Specify multiple queries.

To get analytical view recommendations from more than one query, use the following command syntax:

./arcviz util recommendation --dcname=<data_connection_name> --file=<file_path to the queries file> 
    --query=<QUERY> --query=<QUERY>  
--file=FILE

Get input from a file.

To get analytical view recommendations from a file, use the following command syntax:

./arcviz util recommendation --dcname=<data_connection_name> --file=<file_path to the queries file> 
--dcname=DCNAME

Specify a data connection name.

To add or change a data_connection_name, use the following command syntax:

./arcviz util recommendation --dcname=<data_connection_name> --file=<file_path to the queries file>
--user=USERNAME

Specify a username. Default is admin.

If you are not an administrator, you must specify your username to access the utility. Enter the following command syntax:

./arcviz util recommendation --dcname=<data_connection_name --file=<file_path to the queries file --user=<user_name>
--usage

Display instructions on how to use the utility.

To display instructions on how to use the utility, use the following command syntax:

./arcviz util recommendation --usage  
-r, --recommendation_only

Specify recommendation_only output mode. If you specify multiple output options in the command, for instance, -r and -v, the -r output mode is given the priority.

To view only the create statements of the recommended analytical views and syntax of the input query, use the following command syntax, in either the long or short form:

./arcviz util recommendation --dcname=<data_connection_name> --file=<file_path to the queries file> --recommendation_only

./arcviz util recommendation --dcname=<<data_connection_name> --file=<file_path> -r
-v, --verbose

Specify verbose output mode. If you specify multiple output options in the command, for instance, -r and -v, the -r output mode is given the priority.

To view detailed information on analytical view recommendations, syntax of the query, and statistics of the base tables, use the following command syntax, in either the long or short form:

./arcviz util recommendation --dcname=<data_connection_name> --file=<file_path to the queries file> --verbose
        
./arcviz util recommendation --dcname=<<data_connection_name> --file=<file_path to the queries file> -v