[jira] [Commented] (TRAFODION-2008) Support for external file LOBs in Trafodion

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-2008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15309224#comment-15309224 ] 

ASF GitHub Bot commented on TRAFODION-2008:
-------------------------------------------

Github user asfgit closed the pull request at:

    https://github.com/apache/incubator-trafodion/pull/507


> 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
>             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
(v6.3.4#6332)