How to change SQL output value of the HANA Studio

Many times we observed below log after running a select query, which has record count more than 1000. Query output getting restricted because of limitation of HANA Studio 

Its simple to resolve this issue. Please follow below few steps 

1: Open Hana Studio. 

2: Go to Window --> Preferences option as shown below 

3: New screen will open --> go to SAP HANA --> Runtime --> Result as shown below 

we can see in the above screen default value is 1000. we changed it to 5000 then click on Apply and Close option. 

4: Now output limitation it 5000. Which we can see on the below screen. 

 

Note: we learned how to get more output but changing the value of the result option. please note that setting a value more than 1000 might impact your database performance because queries needs memory for processing and fetching output from the database

Rupesh Chavan