SAP HANA Articles - Page 38 of 63

In SAP HANA, geospatial data types are not defined as such and you need to use scalar values like a.ST_X().You can create a table like this −CREATE COLUMN TABLE MYSCHEMA.SpatialShapes_GEOMETRIES (    ShapeID integer,    SHAPE1 ST_Point,    SHAPE2 ST_GEOMETRY );SAP provides a complete guide to handle Geospatial data in applications. You can refer this link for more details:https://help.sap.com/doc/PRODUCTION/9db42d044f8e415180d4a4475873b50a/2.0.00/en-US/SAP_HANA_Spatial_Reference_en.pdf

In SAP HANA, you don’t have a concept of creating multiple databases in one container. To create a separate container for your database objects, you can create the schema in HANA db.To create a schema, you can use below SQL query −CREATE SCHEMA schema nameYou can also define as owner name while defining a schema.CREATE SCHEMA [OWNED BY ]If it is not defined, the system takes the current user as the owner of the schema.

Note that an index not necessary to be NOT NULL. You can create an Index in SAP HANA database by using below query:CREATE INDEX IDX_MY_INDEX ON TABLE1 (MY_COLUMN);To know more about SAP HANA database, Modeling, and Administration features, you can refer our SAP HANA Text and Video tutorials:https://www.tutorialspoint.com/sap_hana/https://www.tutorialspoint.com/sap_hana_online_training/index.asp

Import and Export using a flat file is the easiest option. You can use CSV file if it is a onetime activity. However, If you think it is a repetitive activity then I would suggest you use HANA ETL options like HANA SLT replication, Smart Data access, etc.SAP HANA Replication allows migration of data from source systems to SAP HANA database. Simple way to move data from existing SAP system to HANA is by using various data replication techniques.System replication can be set up on the console via command line or by using HANA studio. The primary ECC or transaction ... Read More

Note that Eclipse Neon is not compatible tih SAP HANA Cloud platform. Refer the below compatibility document: https://tools.hana.ondemand.com/#hanatools

HANA consumes lot of space in system tables/views, statistics, caches. When you unload tables, these memory areas will not be released.Check SAP Notes https://launchpad.support.sap.com/#/notes/1969700

Note that you have to ensure that Port number 80+ should be open on network. Also URL you are using should be properly built. Below is correct path:server:port/repository_path/file_nameIn your case, you should be using:host: hanacloud port: 8000 (80 + instance_number) SAP HANA Repository tree: mdo ->    sap ->       sflight ->          test ->             test.xsjsSo your URL should be in this format:hanacloud:8000/mdo/sap/sflight/test/test.xsjs

You need to sign up a demo account for SAP Cloud platform. SAP SuccessFactors and SAP HANA Cloud Platform, you can easily get SAP Cloud Applications Partner center program. You have to perform some additional configuration for both.For more details, you can go through below link:https://blogs.sap.com/2013/11/25/get-your-hands-dirty-successfactors-api-access-for-hcp-based-extensions/With use of OData API, it provides with built on protocols like HTTP following the REST methodologies for data transfer. With OData API, you can make use of SuccessFactors in providing Restful integration services for HR data in SAP Cloud.SAP SuccessFactors uses OData API for extraction and still there is some crucial sets of data ... Read More

The code you are using \1+ just removes consecutive occurrences only. You can use the below code.SELECT REPLACE_REGEXPR('(.)(?=.*\1)' IN '22331122' WITH '' OCCURRENCE ALL)  FROM DUMMYThe output will come out to be “312”. This will remove all multiple occurrences and only last one will be kept.

You can try this method to convert time to date and hour format −select to_varchar(time, 'YYYY-MM-DD'), hour(time), sum(r_time) as r_time, sum(p_time) as p_time from t1 group by date(time), hour(time) order by to_varchar(time, 'YYYY-MM-DD'), hour(time);You can also try using Series_Round() with a group by clause.select SERIES_ROUND(time, 'INTERVAL 1 HOUR') as time, sum(r_time) as r_time, sum(p_time) as p_time from t1 group by SERIES_ROUND(time, 'INTERVAL 1 HOUR') order by SERIES_ROUND(time, 'INTERVAL 1 HOUR');