SAP HANA SQL based calculation view issue

[Former Member]

Hi

I am trying to create a SQL script based calculation view with below sample query

select 10 top * from sales group by region, amount

If I execute this query in SQL editor it returns only 10 rows as expected

But if use the same query and create calculation view and use Data Preview option, it returns more rows e.g in my case 5000 as Max row count is set to 5000

Is this limitation in Calculation view or Max Row count has precedence over the row count returned in the query?

Thanks

[henrique_pinto · Accepted solution]

You could try to use SELECT * FROM TABLE LIMIT N [OFFSET M] syntax instead.

If necessary, use the ORDER BY statement (prior to the LIMIT statement) so you get the desired records.

Check the HANA reference for more details: http://help.sap.com/hana/html/sql_select.html

[Former Member · Accepted solution]

Thanks Henrique...this works