Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 3 of 58
Execution time while running a SQL query in HANA Studio
When a SQL query is executed, you can see the confirmation that the query is executed in time duration and also with server processing time. In this scenario, you can see the time taken by SAP HANA processor to create a new table in the HANA database as below −“Statement 'Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) )' successfully executed in 3 ms 117 µs (server processing time − 2 ms 458 µs) - Rows Affected − 0”
Read MoreCreate table SQL query in SAP HANA
In below SQL query, you can see a create table command in SQL editor to create a new table with name-“Demo_HANA” in schema name AA_HANA11 with column names- ID and NAME and corresponding data types. In the below example, we have defined ID as “Primary Key” which means it is unique and not null.Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) );
Read MoreViewing data in a table in SAP HANA database
When the data is entered, you can see the data in this row-based table by going to the Data Preview option. To see the data, right-click on table name → Open Data PreviewWhen you run Data Preview of a table, you can see full data under the Raw Data tab. You can also view distinct values and perform some analysis.
Read MoreUsing DSN name while using a remote source in SAP HANA
In below SQL statement you have to define orcl_DSN_Name −CREATE REMOTE SOURCE Source_Name ADAPTER “odbc” CONFIGURATION FILE ‘property_orcl.ini’ CONFIGURATION ‘DSN=oral_DSN_Name’ WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user=username;password=password′;In this SQL statement- can be as per remote data source and take these values- TDODBC, HIVEODBC, ASEODBC, IQODBC and ODBC.In above statement, is used to specify the connection information for data source where you need to mention the DSN name for your ODBC remote source system. You have to create a System DSN/User DSN to access the data source using ODBC connection. To create an ODBC DSN in system, you need to ...
Read MoreAuthentication options in SAP HANA while adding new system
There are different authentication methods that you can use −Authentication by Operating System UserAuthentication by database userConnect using SSL
Read MoreUsing an Aggregate function in SAP HANA
You can use an aggregate function to get the same. Common aggregation functions are −Average() − returns the average of the numeric values in a given columnSelect Average (Sales) from table_name where Column1=’ABC’;
Read MoreExecuting a table creation using UI in SAP HANA Studio
To execute the table creation, click on the green arrow mark on the top right corner. You will get a confirmation as below that a column table has been created in Schema AA_HANA11 with name DEMO_TABLE −Statement 'create column table "AA_HANA11"."DEMO_TABLE"( "CUST ID" INTEGER null, "CUST NAME" VARCHAR (10) null)' successfully executed Affected Rows:0 in 5 ms 884 µs.
Read MoreComponents in SAP HANA multi-system architecture
Each HANA system contains multiple serves inside, which are responsible to perform different functions. Index Server is heart of SAP HANA system which contains SQL/MDX processor for handling SQL statements. Key component includes −Index ServerPreprocessorName ServerStatistics ServerHANA XS EngineSAP Host AgentSAP Solution Manager Diagnostic AgentSAP HANA Studio + RepositorySAP HANA Software Update Manager SUM
Read MoreCreating virtual tables from remote source in SAP HANA
When a remote source is added, you can see all the existing tables under that data source in HANA Studio. Next is to create virtual table mapping to data in the remote data sources in SAP HANA Studio. This can be done using GUI option.To add a table as a virtual table, you need to navigate to remote data source → Schema name → Table name → Right-click and Add as Virtual TableBelow shows how you can add a table as a Virtual Table using HANA Studio.
Read MoreContent of property_orcl.ini file in SAP HANA Smart Data Access
When you create a new remote data source, SAP HANA Smart data access parse the respective property configuration file. With the use of config file- features, function mappings, data type mappings, and other properties will be linked together with the data source. This decides the communication between the SAP HANA and the data source.You can see part of the content of property_orcl.ini shown below −
Read More