Warm tip: This article is reproduced from stackoverflow.com, please click
hana sap sap-cloud-foundry sql

How to deploy Column View artifact on CloudFoundry

发布于 2020-04-23 10:54:44

I have a Column View in SAP HANA SQL that is used in a sql procedure

CREATE COLUMN VIEW "ABC_COLUMN_VIEW" TYPE hierarchy WITH PARAMETERS ( 
'hierarchyDefinition'='{
"MULTIPARENT":true,
"NODETYPE":"STRING",
"NODETYPE_INFERRED":"STRING",
"RUNTIMEOBJECTTYPE":"tree",
"SOURCEQUERY":"SELECT "A_COLUMN", "B_COLUMN" FROM "ABC_TABLE"",
"SOURCEQUERYSCHEMA":"ABC_SCHEMA",
"SOURCETYPE":"RECURSIVE"}')

and im trying to deploy it on cf but now i see that the .hdiconfig file doesnt have anything about column views

{
    "plugin_version" : "2.0.0.0",
    "file_suffixes" : {
        "hdbsynonym" : {
            "plugin_name" : "com.sap.hana.di.synonym"
        },
        "hdbsynonymconfig" : {
            "plugin_name" : "com.sap.hana.di.synonym.config"
        },
        "hdbtable" : {
            "plugin_name" : "com.sap.hana.di.table"
        },
        "hdbdropcreatetable" : {
            "plugin_name" : "com.sap.hana.di.dropcreatetable"
        },
        "hdbvirtualtable" : {
            "plugin_name" : "com.sap.hana.di.virtualtable"
        },
        "hdbvirtualtableconfig" : {
            "plugin_name" : "com.sap.hana.di.virtualtable.config"
        },
        "hdbindex" : {
            "plugin_name" : "com.sap.hana.di.index"
        },
        "hdbfulltextindex" : {
            "plugin_name" : "com.sap.hana.di.fulltextindex"
        },
        "hdbconstraint" : {
            "plugin_name" : "com.sap.hana.di.constraint"
        },
        "hdbtrigger" : {
            "plugin_name" : "com.sap.hana.di.trigger"
        },
        "hdbstatistics" : {
            "plugin_name" : "com.sap.hana.di.statistics"
        },
        "hdbview" : {
            "plugin_name" : "com.sap.hana.di.view"
        },
        "hdbcalculationview" : {
            "plugin_name" : "com.sap.hana.di.calculationview"
        },
        "hdbprojectionview" : {
            "plugin_name" : "com.sap.hana.di.projectionview"
        },
        "hdbprojectionviewconfig" : {
            "plugin_name" : "com.sap.hana.di.projectionview.config"
        },
        "hdbresultcache" : {
            "plugin_name" : "com.sap.hana.di.resultcache"
        },
        "hdbcds" : {
            "plugin_name" : "com.sap.hana.di.cds"
        },
        "hdbfunction" : {
            "plugin_name" : "com.sap.hana.di.function"
        },
        "hdbvirtualfunction" : {
            "plugin_name" : "com.sap.hana.di.virtualfunction"
        },
        "hdbvirtualfunctionconfig" : {
            "plugin_name" : "com.sap.hana.di.virtualfunction.config"
        },
        "hdbhadoopmrjob" : {
            "plugin_name" : "com.sap.hana.di.virtualfunctionpackage.hadoop"
        },
        "jar" : {
            "plugin_name" : "com.sap.hana.di.virtualfunctionpackage.hadoop"
        },
        "hdbtabletype" : {
            "plugin_name" : "com.sap.hana.di.tabletype"
        },
        "hdbprocedure" : {
            "plugin_name" : "com.sap.hana.di.procedure"
        },
        "hdbvirtualprocedure" : {
            "plugin_name" : "com.sap.hana.di.virtualprocedure"
        },
        "hdbvirtualprocedureconfig" : {
            "plugin_name" : "com.sap.hana.di.virtualprocedure.config"
        },
        "hdbafllangprocedure" : {
            "plugin_name" : "com.sap.hana.di.afllangprocedure"
        },
        "hdblibrary" : {
            "plugin_name" : "com.sap.hana.di.library"
        },
        "hdbsequence" : {
            "plugin_name" : "com.sap.hana.di.sequence"
        },
        "hdbrole" : {
            "plugin_name" : "com.sap.hana.di.role"
        },
        "hdbroleconfig" : {
            "plugin_name" : "com.sap.hana.di.role.config"
        },
        "hdbstructuredprivilege" : {
            "plugin_name" : "com.sap.hana.di.structuredprivilege"
        },
        "hdbanalyticprivilege" : {
            "plugin_name" : "com.sap.hana.di.analyticprivilege"
        },
        "hdbtabledata" : {
            "plugin_name" : "com.sap.hana.di.tabledata"
        },
        "csv" : {
            "plugin_name" : "com.sap.hana.di.tabledata.source"
        },
        "properties" : {
            "plugin_name" : "com.sap.hana.di.tabledata.properties"
        },
        "tags" : {
            "plugin_name" : "com.sap.hana.di.tabledata.properties"
        },
        "hdbgraphworkspace" : {
            "plugin_name" : "com.sap.hana.di.graphworkspace"
        },
        "hdbflowgraph" : {
            "plugin_name" : "com.sap.hana.di.flowgraph"
        },
        "hdbreptask" : {
            "plugin_name" : "com.sap.hana.di.reptask"
        },
        "hdbsearchruleset" : {
            "plugin_name" : "com.sap.hana.di.searchruleset"
        },
        "hdbtextconfig" : {
            "plugin_name" : "com.sap.hana.di.textconfig"
        },
        "hdbtextdict" : {
            "plugin_name" : "com.sap.hana.di.textdictionary"
        },
        "hdbtextrule" : {
            "plugin_name" : "com.sap.hana.di.textrule"
        },
        "hdbtextinclude" : {
            "plugin_name" : "com.sap.hana.di.textrule.include"
        },
        "hdbtextlexicon" : {
            "plugin_name" : "com.sap.hana.di.textrule.lexicon"
        },
        "hdbtextminingconfig" : {
            "plugin_name" : "com.sap.hana.di.textminingconfig"
        },
        "txt" : {
            "plugin_name" : "com.sap.hana.di.copyonly"
        }
    }
}

So my problem is can i add a column view artifact somehow so i can push to cf or there is another way now to implement hierarchy?

Questioner
john
Viewed
70
Lars Br. 2020-02-07 20:17

You’re right, there isn’t a content type for column views because these are runtime objects.

The column view you posted looks like it belongs to a hierarchy view, which is a kind of column view. You can model hierarchy functions in HANA 2 WebIDE, so that’s what I’d recommend to try here.