How to add metadata query hints for SAP HANA data connection in a preference in Spotfire

How to add metadata query hints for SAP HANA data connection in a preference in Spotfire

book

Article ID: KB0070615

calendar_today

Updated On:

Products Versions
Spotfire Analyst 10.3.4. LTS HF-028,10.10.3 LTS HF-013,11.2.0 HF-001, v11.3.0 and later

Description

  • In some cases, we can increase metadata queries performance by providing hints to SAP HANA
  • HINTS is a feature in SAP HANA, with which you can include a WITH HINT clause in queries to guide how to get metadata. 
  • As the best set of hints may vary depending on customer requirements, these hints should be provided as settings initially.
Note: The hints will be used when retrieving metadata for information views, tables, views, and calculated views but not other database objects.
 

Issue/Introduction

How to add metadata query hints for SAP HANA data connection in a preference in Spotfire

Environment

All

Resolution

  • Configure Spotfire to add HINTS to metadata queries to SAP HANA. Use this preference setting:  Connectors > SAP HANA > MetadataQueryHints
User-added image
  • Specify the HINTS in an array, one HINT clause per line in the dialog:
Example,
hana_hint_1
hana_hint_2
  • The HINTS are included in a WITH HINT clause in the metadata queries to SAP HANA.
Example
[…] WITH HINT ( hana_hint_1, hana_hint_2 )
  • For information about how to use SAP HANA HINTS, see the official documentation for SAP HANA.

Additional Information

What's new in Spotfire 11.3 List of hotfixes for Spotfire® Clients (Analyst, Web Player (Consumer/Business Author) and Automation Services) Hint Syntax in SQL Statements, SAP Help Portal
Powered by Wolken Software