Input from a File

In the Command Line Utility, you can get analytical view recommendations from a file.

Enter the following command to get analytical view recommendations from a file. See Command Line Utility Options.

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

Input from a File

In this example, queries are accessed from the text.txt file. The output shows one analytical review recommendation.

./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
========================================================================

If the file is empty or the query has a syntax error, there are no recommended analytical views. To debug errors, view the statistics in Verbose Output Mode.

For instance, in the following example, you get an error because the word select is spelled incorrectly.

Syntax Error

Recommended Analytival Views:

----------------------------------------------------------------------
Recommendation Details:
 -- Q1: elect count(a), avg(f), c, e from test.recom1 group by 3,4;
 -- NO RECOMMENDATION
 =====================================================================