When you use a Text join in SAP HANA, following condition should be met −You should have Text table always on the right side in joinThere should be a Language columns definedBelow shows an example of Attribute join where Language column is used in text join −

To implement Text join, create a table −CREATE COLUMN TABLE TEST.P_INFO (PROD_ID BIGINT, P_CAT NVARCHAR(50)); INSERT INTO TEST.P_INFO VALUES (11, ’FURNITURE’); INSERT INTO TEST.P_INFO VALUES (14, ’ELECTRONICS’); INSERT INTO TEST.P_INFO VALUES (25, ’FURNITURE’); INSERT INTO TEST.P_INFO VALUES (76, ’ELECTRONICS’);2nd table −CREATE COLUMN TABLE TEST.PROD_DESC (PROD_ID BIGINT, LANGUAGE NVARCHAR(10), DESCR NVARCHAR(100)); INSERT INTO TEST.PROD_DESC VALUES (11, ’E’, ’Table’); INSERT INTO TEST.PROD_DESC VALUES (11, ’D’, ’Chair’); INSERT INTO TEST.PROD_DESC VALUES (14, ’E’, ’32 LED’); INSERT INTO TEST.PROD_DESC VALUES (14, ’D’, ’32 inch LCD’); INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25, ’E’, ’Comp Table’); INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25, ’E’, ’Mixer’);Note that it should have ... Read More

In SAP HANA, you can use Text join to fetch description based on user’s session language. When a text join is used, it finds out details in user’s preferred language.Text join can be applied on below modeling objects in SAP HANA −Attribute ViewAnalytic ViewCalculation View

You need to follow below steps to install a new license key in SAP HANA −Step 1 −In the SAP HANA studio, navigate to the properties page of the database for which you have requested the license key.Step 2 −On the properties page, choose the button for installing the license key.Steps 3 −Navigate to your license file and select it.Step 4 −After a successful confirmation, the properties page of the system is updated with the new license information if this is valid for the database.

A new license key is required in the following scenarios −When your current license key is about to expire.You have changed the hardware. As a result, the hardware key has changed. Your database continues to run with a temporary license key that was generated automatically.There is a change of the main memory amount.A change of the system ID of your existing SAP HANA database is planned, for example, due to recovery, copy, and/or renaming. A valid license key for the new system ID must be available for the change to avoid a system standstill.There is a change of the installation ... Read More

To export this details you first need to have INIFILE ADMIN system privilege. Following hdbsql command can be used −SELECT ROUND(SUM(INSTANCE_TOTAL_MEMORY_USED_SIZE) / 1024 / 1024 / 1024, 0) AS DATABASE_MEMORY_USED_IN_GIGABYTES FROM M_HOST_RESOURCE_UTILIZATION RU, M_LANDSCAPE_HOST_CONFIGURATION HC WHERE RU.HOST = HC.HOST AND HC.INDEXSERVER_ACTUAL_ROLE IN ('MASTER','SLAVE');You can also run this command in SQL editor to get this details −

You need to edit nameserver.ini file. Use the operating system user adm to edit the file /usr/sap//global/hdb/custom/config/nameserver.ini in the file system and add the following lines −[trace] licensing = debugOnce you edit the file → Restart the instance.Check the latest nameserver trace file nameserver_...trc, which is to be found under /usr/sap//HDB//trace/Check the end of that trace file to find the installation and system number in lines.Ex −Licensing    AbstractLicenseManager.cpp(00063) : Installation #  : "XXXX0XX234X"Licensing    AbstractLicenseManager.cpp(00063) : System #        : "XXXXXXXXXXXX4234523432434”You have to use this installation number and system number to request a new license key for ... Read More

A new permanent license key used to replace an expiring permanent license key must contain the same license identification data as are already installed. Only then it can be successfully installed. The license identification data consists of system ID, hardware key, installation number, and system number. Any difference in one of these four identifiers will result in the rejection of the license key. In most cases, this is the reason for the failure in license key installation.You can use Trace function to verify/identify the installation and system number of your database instance. If the current license key is still valid ... Read More

In a Single-Database system, proceed as follows to perform a system measurement of your SAP HANA system, which includes the system measurement of the SAP HANA database itself as well as of the relevant options and products −In the SAP HANA Studio, select your database in the navigator and choose Properties in the context menu of the system.Click on the "Export System Measurement" button. A File Browser dialog opens up allowing you to store the result of the system measurement, the measurement report, as an XML file to your local file system.Send this XML file to SAP as requestedThe XML ... Read More

Try executing the following SQL query −SELECT * FROM "SYS"."M_LICENSE";To get the hardware key, run the following SQL statement − SELECT HARDWARE_KEY, PRODUCT_NAME FROM M_LICENSE