About mfath

mfath · 08-12-2021

In this blog post I will show how to estimate the water load in a stormwater network and calculate the risk of an overload. Sure, I'm not a water network expert, but here is the idea: a stormwater network is a directed, (in our case mostly acyclic) g...

mfath · 07-27-2021

In SAP HANA Cloud, you find database objects like tables, views, procedure, functions etc. These objects do not "stand alone", but rather depend on each other. SQL views are built on tables, and are used in procedures. When migrating or changing data...

mfath · 07-21-2021

A lot of data science and machine learning work is done in Python. For this, the “Python machine learning client for SAP HANA” (hana-ml for short) provides easy access to SAP HANA tables in the form of Pandas compatible data-frames. However, with its...

mfath · 05-19-2021

In this blog post, I will show how to use some basic SAP HANA Graph functions to understand dependencies in a directed graph. The demo data describes python packages and their dependencies. Resolving package dependencies is required if a package mana...

mfath · 01-05-2021

In this blog post I will describe how to calculate drive time distances and isochrones on street network data. Isochrones are areas reachable within a certain time threshold. They are helpful in many transportation-related planning scenarios: retail ...

mfath · 07-10-2023

Hej Gowtham,I don't know if you can cluster routes (i.e. linestring geometries) in UI5/geomap controller.But in case you use SAP HANA to store your routes, you can take a look at the spatial clustering approach described in this TechEd session:https:...

mfath · 06-23-2023

Oh, since you were asking how to "extract the month in this function now() in SAP HANA", I thought you were looking for a solution in SQL/SQLScript. Looking at your sample code, it obviously runs "somewhere else", i.e. is not SQL. I can't help then. ...

mfath · 06-23-2023

Hej, I guess it would be helpful to post your function/procedure and the error message. Regards, Markus

mfath · 06-23-2023

Hej, I think SELECT extract_month(now()) FROM dummy; will do the trick. Regards, Markus

mfath · 12-20-2022

Hej Babu, right and wrong  HANA Cloud does support Cypher and in general provides many more graph features and better performance compared to HANA on-prem. But the HANA Database Explorer front-end still needs some adaptations to some technical chan...

User Statistics

User Activity

Mapping Risk in a Stormwater Network using SAP HANA Spatial and Graph

Database object lineage using SAP HANA Graph

Augment your Python Analysis with Multi-Model data in SAP HANA Cloud

Know Your Dependencies - Network Tracing with SAP HANA Graph

Calculating Isochrones using SAP HANA Graph and Spatial

Re: Geo Map Clustering on Routers

Re: Extracting Month in now() function in SAP HANA

Re: Extracting Month in now() function in SAP HANA

Re: Extracting Month in now() function in SAP HANA

Re: Graph algorithms in SAP HANA: on SFLIGHT and at TechEd