[jira] [Commented] (TRAFODION-3216) UDR libraries need to be stored in metadata table as a blob

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

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

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

GitHub user sandhyasun opened a pull request:

    https://github.com/apache/trafodion/pull/1721

    [TRAFODION-3216]UDR libraries need to be stored in metadata table as a blob

    
    Udr libraries that used to be on local directories will now be stored as Blobs n the Libraries metadata table. 
    There are changes in compile time and runtime components to make this work. See JIRA for details and attached document within JIRA for change details. 
    
    https://issues.apache.org/jira/browse/TRAFODION-3216
    
    This change also involves a change to a metadata table so it requires an upgrade. The version of metadata has been bumped from 2.1.0 to 2.1.1 

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/sandhyasun/trafodion traf_call_lib

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/trafodion/pull/1721.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1721
    
----
commit 9528f8c0d2c75bb7f783c4b1589d11b1d4b64869
Author: Sandhya Sundaresan <sa...@...>
Date:   2018-09-28T19:44:56Z

    Fixees to support stroring Udr libraries s Blobs.

----


> UDR libraries need to be stored in metadata table as a blob
> -----------------------------------------------------------
>
>                 Key: TRAFODION-3216
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-3216
>             Project: Apache Trafodion
>          Issue Type: Improvement
>          Components: sql-general
>    Affects Versions: 2.4
>            Reporter: Sandhya Sundaresan
>            Assignee: Sandhya Sundaresan
>            Priority: Major
>             Fix For: 2.4
>
>         Attachments: Support for LOB storage in metadata for UDR libraries.docx
>
>
> This is one of many  infrastructure changes for SPJs that was planned. 
>  * {color:#0070c0}Store UDR libraries in BLOBs   {color}
>  * {color:#0070c0}Add BLOB column to library metadata table{color}
>  * {color:#0070c0}Change CREATE LIBRARY command to store library in BLOB{color}
>  * {color:#0070c0}Change library file names to include the timestamp (so updating a library changes the name){color}
>  * {color:#0070c0}Add a cache for libraries (a new directory, $TRAF_HOME/udr/public/lib){color}
>  * {color:#0070c0}Change UDR code to read library from the metadata table when not in cache{color}
>  * {color:#0070c0}Upgrade support{color}
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)