In SAS Enterprise Guide 8.4 on the SAS® Viya® platform, you can create a Query Builder that uses SAS® Cloud Analytics Services tables as the input and compute tables as the output. In this scenario, the Query Builder might fail with the following error:
ERROR: The maximum allowed bytes (104857600) of data have been fetched from Cloud Analytic Services. Use the DATALIMIT option to increase the maximum value.
This error might occur when you complete steps similar to the following:
1. Create a query step with the input table from the CASLIB PUBLIC library and the output table from the WORK library. (Note: The input table size is about 500mb.)
2. Run the Query Builder.
This error occurs because the CASDATALIMIT option is set to the default size “bytes (104857600)”.
28 PROC SQL;
29 CREATE TABLE WORK.QUERY_FOR_DATALIMIT_TEST AS
30 SELECT t1.column1,
31 t1.column2,
32 t1.column3,
33 t1.column4
34 FROM PUBLIC.DATALIMIT_TEST t1;
ERROR: The maximum allowed bytes (104857600) of data have been fetched from Cloud Analytic Services. Use the DATALIMIT option to
increase the maximum value.
Workaround
To avoid this error, complete the following steps:
1. In the list of input tables, select the input table.
2. Right-click Properties. A Table Properties dialog box opens inside the Query Builder.
3. Inside this panel, on the Options field, specify DATALIMIT=in, as shown in the image below:
Note: After adding this option to the table in the Query Builder, you will be able to execute the Query Builder without any errors.
28 PROC SQL;
29 CREATE TABLE WORK.QUERY_FOR_DATALIMIT_TEST AS
30 SELECT t1.column1,
31 t1.column2,
32 t1.column3,
33 t1.column4
34 FROM PUBLIC.DATALIMIT_TEST(DATALIMIT=400m) t1;
NOTE: Table WORK.QUERY_FOR_DATALIMIT_TEST created, with 507201 rows and 4 columns.
35 QUIT;
NOTE: PROCEDURE SQL used (Total process time):
real time 2.79 seconds
cpu time 1.09 seconds