如何在CloudFoundry上部署列视图工件

Question

我在SAP HANA SQL中有一个列视图，用于sql过程中。

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"}')

我试图将它部署到cf上，但现在我看到.hdiconfig文件没有任何列视图

{
    "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"
        }
    }
}

因此，我的问题是，我是否可以以某种方式添加列视图工件，以便将其推送到cf，或者现在有另一种实现层次结构的方法？

Answer 1

您说得对，列视图没有内容类型，因为它们是运行时对象。

您发布的列视图看起来像是属于层次结构视图，这是一种列视图。您可以在HANA 2 WebIDE中建模层次结构函数，所以我建议在这里进行尝试。