Not getting complete query through output in .csv format

[former_member698004]

Hello All,

We are having HANA version 2.00.055.00.1615413201

The issue is whenever we are taking export of any query in .csv format through HANA Studio, the complete query is not getting captured.
Just few lines of the queries are coming up.

Is there any setting that needs to be changed in HANA Studio or any alternate way to get complete query output in .csv or any other format.

Thanks

Parag Jhade

[DotEiserman]

Hi Parag,

please confirm the functionality you're using to export to CSV.

Thanks

Dot

[dvankempen]

Hi Parag,

The question is not entirely clear to me. Have you checked the documentation and corresponding note?

• Expensive Statements Trace | SAP HANA Troubleshooting and Performance Analysis Guide
• 2180165 - FAQ: SAP HANA Expensive Statements Trace

[former_member698004]

Hello,

My query is if I want to take export of these 162 queries through HANA Studio in such a manner that complete query comes up so that I can share that with application team to tune these query.

At present, the complete queries are not getting captured through export . Just few lines of the queries are coming up.

Is there any setting that needs to be changed in HANA Studio or any alternate way to get complete query output in .csv or any other format

[dvankempen]

Hi Parag,

It could be a limitation of studio. Development stopped in 2016 with SPS12 and the tool is deprecated as of 2018 (SPS02). Except for the interactions with the sapstartsrv to start/stop the instance and to perform diagnostics, most interactions in studio are converted into SQL statement. You might be able to capture the content via the SQL Console, alternatively, if you cannot access the server directly via a terminal to copy the trace file.

Have you checked 2119087 - How-To: Configuring SAP HANA Traces?

[dvankempen]

Hi Parag,

Are you referring to the result set of the query?

This is configurable:

Studio > Preferences > SAP HANA > Runtime > Result > Maximum Number of Rows Displayed in Result

[former_member698004]

Hello,

This I am already aware.
My query is if I get 100+ queries from expensive statement trace then is there way that I can get all those exported to .csv format through HANA Studio.

As of now the complete queries are not getting captured. Just few lines of the queries are coming up.

Is there any setting that needs to be changed in HANA Studio or any alternate way to get complete query output in .csv or any other format.

[former_member698004]

Hi Dot,

I just need to share expensive statement trace to application team so I'm just executing query to get expensive statement trace and then exporting this result into .csv format through HANA studio.

Hope this answer your query
Is there any setting that needs to be changed in HANA Studio or any alternate way to get complete query output in .csv or any other format.

[DotEiserman]

Hi Parag,

The expensive statement trace is tricky to consume due to the format of the data, specifically the statement column, often commas and semi-colons are used in the actual statement, which makes it hard to consume in CSV format. I often export directly from the table M_EXPENSIVE_STATEMENTS and then either leave out the problematic columns or put them right at the end. Using a very obscure separator helps for e.g. ~

Thanks

Dot