温馨提示:本文翻译自stackoverflow.com,查看原文请点击:sql - How to deploy Column View artifact on CloudFoundry
hana sap sap-cloud-foundry sql

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

发布于 2020-04-24 17:21:37

我在sql过程中使用的SAP HANA 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还是现在有另一种方法来实现层次结构?

查看更多

提问者
john
被浏览
47
Lars Br. 2020-02-07 20:17

没错,列视图没有内容类型,因为它们是运行时对象。

您发布的列视图看起来像它属于一个层次结构视图,这是一种列视图。您可以在HANA 2 WebIDE中为层次结构函数建模,因此,我建议您在这里尝试一下。