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:
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
Specify a single query.
To get analytical view recommendations from one query, use the following command syntax:
./arcviz util recommendation --dcname=Recommendation --query=<QUERY>
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>
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>
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>
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>
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
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
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