unable to visualize Heterogenous graph in sap hana . Getting error as "GRAPH_WORKSPACE_HETERO_NOT_SU

[sameerk20]

I have created a Heterogenous graph workspace in my sap hana cloud db . 
however when i try to visaulize the same from the UI i am getting this exception .

"an exception (error) occurred "GRAPH_WORKSPACE_HETERO_NOT_SUPPORTED" 

  

Following is the schema i have used 

 CREATE SCHEMA SK_GRAPH_SCHEMA2; SET SCHEMA SK_GRAPH_SCHEMA2; CREATE COLUMN TABLE user_table ( user_id INT PRIMARY KEY, name VARCHAR(255), age INT, location VARCHAR(255) ); CREATE COLUMN TABLE post_table ( post_id INT PRIMARY KEY, content VARCHAR(255), timestamp TIMESTAMP ); CREATE COLUMN TABLE comment_table ( comment_id INT PRIMARY KEY, content VARCHAR(255), timestamp TIMESTAMP ); CREATE COLUMN TABLE friend_table ( friendship_id INT PRIMARY KEY, user1_id INT NOT NULL, user2_id INT NOT NULL, since DATE ); CREATE COLUMN TABLE posted_table ( post_id INT PRIMARY KEY NOT NULL, user_id INT NOT NULL ); CREATE COLUMN TABLE commented_on_table ( comment_id INT PRIMARY KEY NOT NULL, post_id INT NOT NULL, user_id INT NOT NULL ); CREATE GRAPH WORKSPACE "social_network" EDGE TABLE friend_table KEY COLUMN "FRIENDSHIP_ID" SOURCE COLUMN "USER1_ID" REFERENCES "USER_TABLE" TARGET COLUMN "USER2_ID" REFERENCES "USER_TABLE" VERTEX TABLE "USER_TABLE" KEY COLUMN "USER_ID" EDGE TABLE "POSTED_TABLE" KEY COLUMN "POST_ID" SOURCE COLUMN "USER_ID" REFERENCES "POST_TABLE" TARGET COLUMN "POST_ID" REFERENCES "POST_TABLE" VERTEX TABLE "POST_TABLE" KEY COLUMN "POST_ID" EDGE TABLE "COMMENTED_ON_TABLE" KEY COLUMN "COMMENT_ID" SOURCE COLUMN "USER_ID" REFERENCES "COMMENT_TABLE" TARGET COLUMN "POST_ID" REFERENCES "COMMENT_TABLE" VERTEX TABLE "COMMENT_TABLE" KEY COLUMN "COMMENT_ID"; 

Please advise whether this kind of graph are supported in sap hana graph or what do i need to change?

[Vitaliy-R]

I do not see a screenshot attached. Could you pls check?

[sameerk20]

Hi @Vitaliy-R Unfortunately i am unable to add a screenshot due to policies.

[mfath]

As of Q1 2025, heterogenous property graphs are not supported by the Graph Viewer in Database Explorer. 

[Dennis_864]

Hi,
do you already know when it will be supported?
So it is still possible to build them, but visualization is the current problem am I right?

Thank you very much for your time!

[mfath]

There is currently no defined timeline on when visualization of heterogeneous graphs in Database Explorer will be supported. But sure you can create and work with these graphs.