Spatial features not available

[Former Member]

Hello,

I am trying to evaluate the Spatial capabilitys of HANA.

My Version is a CloudShare installation with the Version: 1.00.68.384084

Trying the following Statment fails with Error:

select new ST_POINT(3,4) from dummy;

Could not execute 'select new ST_POINT(3,4) from dummy' in 158 ms 283 µs .

SAP DBTech JDBC: [257] (at 12): sql syntax error: this feature cannot be supported: line 1 col 12 (at pos 12)

As I read here:

Spatial engine features not supported in HANA O... | SAP HANA

Spatial features are not "by default" supported.

So the following Statment does not work too:

alter table "My_Schema"."some_table" add (MY_LOCATION ST_POINT (4326));

... Same error ...

What are the steps to get the Spatial Features enabled?

Regards,

Mansur

[former_member182500]

Hi Mansur,

Take a look here:

http://scn.sap.com/thread/3512975

"I remember reading about "unlocking" the spatial engine in 6.x with ALTER SYTEM, a little of it is mentioned here, may be worth an attempt if you have a sandbox to play with."

SAP HANA One Spatial capabilities on AWS | SAP HANA

Hope it helps.

[Former Member]

Hi Jon-Paul,

thanks for the link. I found it allready.

In this thread they "suggest" to run the Alter Statement against:

indextserver.ini - System - Spatial ...

First i would like to know what this setting does exactly.

Looking into the HANA Configuration via HANA Developer I can't find this setting.

So I belive either this Parameter is something like "hidden", or it just does not exists on my System.

Even trying to search for any "spatial" entry in the Config Section does not return any result.

I found out that the SYS - Schema do contain ST_ related Views ST_GEOMETRY_COLUMNS, ST_SPATIAL_REFERENCE_SYSTEMS, ST_UNITS_OF_MEASURE) .

The Reference System and Unit Tables are filled correctly with they're Data but the Columns Table is empty.

As my System is not a Sandbox - its a Prototype Plattform - I am afraid to set an unknown Flag.

Any more details on this?

Mansur

PS: By the way ... I would suggest SAP to add some more Reference Systems to the basic installation. WGS84 is "not very much" of a catalog of Projections.

The EPSG List can be found here: Spatial Reference List -- Spatial Reference

[former_member182500]

Hi Mansur,

I'm afraid I don't have any more for you regarding spatial and rev68, I think spatial is still considered "niche" and there is very little info out there. As you are no doubt aware spatial only became GA as of SPS07, therefore I imagine implementations of spatial in rev68 would require SAP assistance for switching on etc.

As of SPS07 rev70 there are still some ST functions like ST_CONTAINS that do not work for WGS84 (fixed for 72 I believe), this may question the usability and feature set of rev68.

It may be worth a post in the to question current limited spatial reference sets and how that could be expanded.

Regards,

Jon-Paul.

[Former Member]

Ok ... I found this:

SAP HANA One Spatial capabilities on AWS | SAP HANA

They mention there the SAP Doc 1872108 which describes to contact SAP Sales.

So for the moment this evaluation is closed for me ... such a shame.

We will contact - probably - the Sales to ask them.

Anything else is just a experiment.

Mansur