Default Output Mode

In the Command Line Utility, use the default output mode to view a brief summary of the analytical view recommendations.

In the default output mode, you can view a brief summary of the analytical view create statements, syntax of the input query, and the recommendaion status.

To view only the analytical view create statements and syntax of the input query, use the Recommendation-Only Output Mode.

For detailed information about the analytical view recommendations and the input query, including the information of the base tables, use the Verbose Output Mode.

To display analytical view recommendations in default mode, follow these steps:
Default Mode: Command Syntax and Output Form

To see the output in default mode, enter a command with the following syntax. See Smart Acceleration Command Line Utility Options.

./arcviz util recommendation --dcname=<data_connection_name> --file=<file_path to the queries file> 
Your output will have the following form:
Recommended Analytival Views:
-- <unique aview name 1> : <aview create statement>
-- <unique aview name 2> : <aview create statement>
.....
-- <unique aview name n> : <aview create statement>
-----------------------------------------------------
Recommendation Details:
  -- Q1: <input query 1>
  -- <Recommendation status [NO RECOMMENDATION or RECOMMENDATION: 
        <list of recommended aviews or already matching aviews names separated by |]
  -- Q2: <input query 2>
  -- <Recommendation status [NO RECOMMENDATION or RECOMMENDATION: 
        <list of recommended aviews or already matching aviews names seperated by |]
......
  -- Qn: <input query n>
  -- <Recommendation status [NO RECOMMENDATION or RECOMMENDATION: 
        <list of recommended aviews or already matching aviews names seperated by |]
-------------------------------------------------------------------------------------
Example: Output in Default Mode

In our example, name of the data connection is Recommendation and queries are accessed from the text.txt file.

The output has the following two sections:
  • Recommended Analytical Views section shows the recommended aviews with the CREATE ANALYTICAL VIEW statements, and has the following information:

    Table Name

    Name of the base table that appears in the form database_name.table_name. In our example, it is test.recom1.

    Recommended Aviews

    Names of the recommended aviews. In our example, it is recommended_aview_1

    File Format

    Format of the base table. In our example, it is PARQUET.

    Select query

    Syntax of the select query. In our example, it is SELECT avg(f), c, count(a), e FROM test.recom1 GROUP BY c, e;

  • Recommended Details section shows the queries executed and the recommended aviews with the following information:

    Q1

    Detail of each query that is executed. In our example, we only have one query, which is SELECT avg(f), c, count(a), e FROM test.recom1 GROUP BY c, e;.

    RECOMMENDATION

    Names of the recommended aviews. In our example, we only have one recommendation, recommended_aview_1.

./arcviz util recommendation --dcname=Recommendation --file=/var/lib/arcadia/test.txt

Recommended Analytival Views: 
-- recommended_aview_1 : 
   CREATE ANALYTICAL VIEW `test`.`recommended_aview_1` STORED AS PARQUET 
      AS SELECT avg(f), c, count(a), e FROM test.recom1 GROUP BY c, e;
-------------------------------------------------------------------------
Recommendation Details: 
-- Q1: select count(a), avg(f), c, e from test.recom1 group by 3,4; 
      -- RECOMMENDATION: recommended_aview_1
-- Q2: select count(a), avg(f), c, e from test.recom1 group by 3,4;
      -- RECOMMENDATION: recommended_aview_2
====================================================================