How to execute SAP HANA SQL Trace Analyzer Python tool?
You can call the Python script with different options as listed below:
python sqlTraceAnalyzer.py [-s <split-filename>] [-c <catalog-dir>] [-m <merge-stat-file>] [-u <user>] [-k <top k values to show>] [-disjunct] [-tr] <sqltrace-filename> [<sqldump-file>] [<tables-file>]
With the '-tr' option local temp table names can be replaced by the common placeholder "#<local-temp-table>". This is useful to generate accumulated statistics for statements on generated temp table names that only differ in the generated table name.
Examples:
python sqlTraceAnalyzer.py <sqltracefile>
python sqlTraceAnalyzer.py /usr/sap/<SID>/HDB00/host/trace/sqltrace_host_30003_000.py