About mfath

mfath

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

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

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

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

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

oh, I see you are using a HANA Express (=HANA on-prem) as a remote source. Then you are right - spatial datatypes are not supported and you can workaround as you suggested via converting it to TEXT/WKT and back.

mfath

Hej, Virtual Tables do support spatial datatypes, but you can not create a virtual table AND the remote table with a spatial datatype in one statement.This works if the reomte table contains a spatial datatype:CREATE VIRTUAL TABLE "schema"."virtual t...

mfath

As the error message suggest, you can't use GROUP BY on LOB datatypes, eg (n)CLOB, BLOB. If you test is shorter than 5000 characters, use the (N)VARCHAR(5000) datatype.

mfath

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

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. ...

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: Do Virtual Tables support ST_POINT or ST_GEOMETRY

Re: Do Virtual Tables support ST_POINT or ST_GEOMETRY

Re: USERTEXT NCLOB datatype

Re: Geo Map Clustering on Routers

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