How to change the maximum number of rows in SQL preview in HANA Studio
In HANA Studio (or eclipse) select the menu option Window -> Preferences and scroll on the list on the left pane to find ‘SAP HANA‘ and expand it to runtime → Result and click on it. Adjust the parameter Maximum number of Rows Displayed in Result, it is set to 1000 rows by default, as per SCN post “HANA is loading only 1000 records into my attribute table”