I have created an analytical view which uses aggregation as NDV on a column.
create analytical view testdb.testAV AS select bucketdate, username, ndv(questionid) as noofquestionsasked from testdb.testsourceA group by bucketdate, username;
When I am trying to read data from the above analytical view using a select query, the measure column “noofquestionsasked” shows random symbols.
I need to execute a query on this analytical view as below:
select bucketdate, username, sum(noofquestionsasked) from testdb.testAV group by bucketdate, username;
This gives the error as below:
Kindly let me know if any other information is needed.