Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
To convert a Column store table to row store, you can use the following SQL statement −Alter table Table_Name row;
You have different ABAP and Java Perspectives to perform application development and to host applications on HANA system −ABAPABAP Connectivity and IntegrationABAP ProfilingJavaJava BrowsingJava EEJava Type HierarchyJava ScriptThese perspective can be opened by navigating to, navigate to Window option at the top → Perspective → Open Perspective → Other
You can use following SQL statement for this −CREATE VIRTUAL TABLE ExampleCREATE VIRTUAL TABLE ABC.test_VT AT “ORCL_11G_WIN”.”NULL”.”OUTLN”.”Dept”;In this SQL statement, ABC.test_VT is Virtual table name“ORCL_11G_WIN”.”NULL”.”OUTLN”.”Dept”;- Remote location for creating Virtual table
JShell can also provide an auto-completion feature when we partially type the name of an existing class, variable, or method by pressing the Tab key. If an item can't determine from what we entered, then possible options are provided.Pressing the Tab key in JShell performs one of the following tasks:If no other name matches what we have typed, JShell enters the rest of the name for us.If there are multiple names that begin with the same letters, then JShell displays a list of those names to help what to type next, then type the next letter(s) and press tab key again to complete the name.If no ... Read More
In SAP HANA system architecture, Name server is used to maintain topology of SAP HANA system. It details complete information about system landscape- all hosts in distributed environment, active components and services running on each component in a distributed system environment.You can check service start time, memory used, CPU used, Process Id, port number and other details for each service under each component in your environment.When you navigate to System Administration → Landscape tab of your HANA system, all the information provided there- Services, Hosts, Redistribution and System Replication information is relevant to landscape information.You can check the status of ... Read More
In Java 9, several factory methods have added to Collections API. By using these factory methods, we can create unmodifiable list, set and map collection objects to reduce the number of lines of code. The List.of(), Set.of(), Map.of() and Map.ofEntries() are the static factory methods that provide convenient way of creating immutable collections in Java 9.Benefits of Immutable CollectionsLess heap space: The space required to store a collection data is very less as compared with the traditional approach in earlier versions of java.Faster access to data: As the overhead to store data and wrap into Collections.unmodifiable is reduced, now data access becomes faster. It means that ... Read More
In SAP HANA system architecture, Name server is used to maintain topology of SAP HANA system. It details complete information about system landscape- all hosts in distributed environment, active components and services running on each component in a distributed system environment.Topology details of SAP HANA system is maintained.Name server holds the detail of each component and services running on each host and hence reduces the re-indexing time.
You can alter the view, then we can use the Alter View command to alter the view.ExampleAlter view View_EmpInfo as Select Emp_Details.Id, Emp_Details.EmplName, EmpProj.Projname from Emp_Details inner join EmpProjInfo on Emp_Details.Id=EmpProjInfo.Id;We have applied ALTER command to update an existing view with name- View_EmpInfo which is applying Inner Join on two tables on Id column to create a database view.
You can drop a view using Drop command like we drop a table. You can perform all the operations that you perform on a table on the database view.Drop view "AA_HANA11"."DEMO_TEST";
Following tabs are available under SAP HANA Administration Console −OverviewLandscapeAlertsPerformanceVolumesConfigurationSystem InformationDiagnosis FilesTrace Configuration