Required suggestion in creating the AV's

HI All,

I have a below query, i’m using the CS (given by Shaun) which will capture my username and i have created a materialized table/logical view within Arcadia.

select abc, sal, a.username from test2 inner join (select xyz, username from test where username in (’<user:"">’)) a on a.abc= ent_test2.xyz

I have configured the CS in the visual so that my username will be captured

below is the visual query

SELECT TA_0.abc as abc, sum((TA_0.sal)) as sum(sal)
FROM (select abc, sal, A.username from test2 inner join (select xyz, username from test where username in (‘my_user_name’)) A on A.abc = test2.xyz) TA_0
GROUP BY 1
LIMIT 100

when i’m trying to create AV, below is the query which is getting generated and Arcadia smart acceleration engine is not suggesting for AV’s though i have aggregation and grouping and getting the below error

The (sub) query does not have aggregation, grouping or distinct operation, recommendation is not provided.

SELECT ta_0.username AS username,
sum((ta_0.sal)) AS sum(sal)
FROM
(SELECT abc,
sal,
a.username
FROM test2
INNER JOIN
(SELECT xyz,
username
FROM test
WHERE username IN (’""’)) a ON a.xyz= test2.abc) ta_0
GROUP BY 1
LIMIT 100

kindly need your suggestion, so that i can proceed further

Need your suggestion