cancel
Showing results for 
Search instead for 
Did you mean: 

Can I search all the tables in my schema for a particular word in SAP HANA?

Former Member
0 Kudos

I am new to HANA. If I create data schema in HANA, is there is way where I can search for a some keywords and return all the matching records in all the tables in my schema. Or should we use ElasticSearch or Solr for indexing the data in the HANA database tables and then perform the search in Solr/ElasticSearch.

Regards

Anil

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Theoretically you can use SQL: "HANA_Data_ColumnValueSearch_CommandGenerator" (SAP Note 1969700), but be careful: This is a simple SQL based approach that can generate huge SQL statements, which have to be executed in a second step and can consume significant amounts of CPU and memory resources. So please start slowly (e.g. by specifying a dedicated table in the TABLE_NAME input parameter in the "Modification section") and check if it works for you.