Creating a Column View with Hierarchy, using SQL Editor

[gokul_jayaraman2]

Hi All,

I am trying to create a hierarchy view in SQL Editor but i am getting an error while doing it.

I use the following SQL

CREATE COLUMN VIEW H_MDG4 TYPE HIERARCHY WITH PARAMETERS (

'hierarchyDefinitionType' = 'select',

'hierarchyDefinition' = '{

"sourceType":"recursive",

"nodeType":"string",

"runtimeObjectType":"tree",

"multiParent":true,

"sourceQuery":"SELECT pred1, succ1 FROM h_mini_src3 " }' );

I am getting the below error

Could not execute 'CREATE COLUMN VIEW H_MDG5 TYPE HIERARCHY WITH PARAMETERS ( 'hierarchyDefinitionType' = 'select', ...' in 78 ms 511 µs .

SAP DBTech JDBC: [2048]: column store error: logical index creation error:  [2030] general configuration error; The hierarchy definition specifys a recursive hierarchy, but the source data indicates a leveled hierarchy or lacks the proper predecessor/successor columns.,object=USERNAME:H_MDG5en

Please let me know if i am missing any parameter ?

Thanks,

Gokul

[rindia]

Hi Gokul,

I'm able to create the same without any error.

My table structure is:

Check your table structure.

Regards

Raj