[
https://issues.apache.org/jira/browse/TRAFODION-2008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sandhya Sundaresan closed TRAFODION-2008.
-----------------------------------------
> Support for external file LOBs in Trafodion
> -------------------------------------------
>
> Key: TRAFODION-2008
> URL: https://issues.apache.org/jira/browse/TRAFODION-2008
> Project: Apache Trafodion
> Issue Type: New Feature
> Components: sql-exe
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
> Priority: Major
> Fix For: 2.1-incubating
>
>
> Add support for a new lobtype and lob function (externaltolob) that will
> allow files to reside in HDFS outside o Trafodion. The file is not imported
> nor part of Trafodion but the file lcoator will be a part of the Trafodion
> column.
> Once a column is declared with the "external" attribute, it cannot contain an
> internal LOB type . All data that's part of that column will have to reside
> outside Trafodion. Similarly if a column is declared as a regular blob/clb,
> then an external file cannot be linked to that column using the externaltolob
> function.
> Also external file LOBs can be inserted or updated. They cannot be
> "appended". So each a particular LOB value in a column can be pointing to
> just one external file . It cannot point ot multiple files so append is not
> allowed.
> If an external LOB is updated or modified by the user outside Trafodion,t he
> user will need to do an "update" to update the information in the Trafodion
> LOB column. If not, the information in the Trafodion table will be stale.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
