Try the following SQL query −UNSET SYSTEM LICENSE ALL

You can find this details in Properties pane of your HANA system. Select HANA system in Studio and right click → PropertiesWhen you navigate to License tab, you can find Hardware key.

To request a license key from SAP Marketplace, you require an S-ID and the “Request License Key” authorization for the installation number or customer number you require. To request your license key, you need to open SAP Service Marketplace −https://support.sap.com/en/my-support/keys.htmlNext is to launch license key application → It will prompt to enter SID and password again. Enter the credentials and you will reach to this page −To get license key from SAP Marketplace, you may need the following information −Provide the System IDProduct typeProduct VersionHostname of ServerSystem Usage TypeOperating System TypeTo proceed to the hardware data, choose “Continue”.Enter your hardware ... Read More

Note that the validity of your permanent License key is till predefined date and when it is expired, a temporary license key is issued, with a validity for only 28 days. During this period, you have to install a permanent License key again.

SAP HANA contains multiple components and it provides high computing power to HANA. Most important component of SAP HANA system is Index Server, which contains SQL/MDX processor to handle query statements for database.SAP HANA system also consists of Name Server, Preprocessor Server, Statistics Server and XS engine. XS engine is used to communicate and host small web applications and various other components on top of HANA database.

SAP HANA is an in-memory database so all data resides in memory all the time and hence all calculations and functions can happen directly and hence materialized aggregations are not required in SAP HANA database.With the use of column store, data is available vertically and hence operations on different columns can be easily performed.

In a Column store table, Data is stored vertically. So, similar data types come together as shown in the example above. It provides faster memory read and writes operations with help of In-Memory Computing Engine.In a conventional database, data is stored in Row based structure i.e. horizontally. SAP HANA stores data in both row and Column based structure. This provides Performance optimization, flexibility and data compression in HANA database.Storing Data in Columnar based table has following benefits −Data CompressionFaster read and write access to tables as compared to conventional Row based storageFlexibility & parallel processingPerform Aggregations and Calculations at higher ... Read More

Row based tables are used when only one record has to be processed at a time. Row based table doesn’t support aggregations and fast searching.When your application needs to access a complete record or a complete row it is recommended to use row based tables.

SAP HANA is not only a database but it is software and hardware innovation. You may get better result w.r.t Performance but HANA is not just a db with more memory.

Yes, you can set a variable on top of “Calculated column”. In the bottom box, you need to select the column on which you want to set a Variable.Click on Add and from the drop-down, you can select “Calculated column” as below: