[jira] [Commented] (TRAFODION-2874) LOB: Add syntax to return filename of a LOB data file for external LOBs.

["Sandhya Sundaresan (JIRA)" <ji...@apache.org>]

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

Sandhya Sundaresan commented on TRAFODION-2874:
-----------------------------------------------

Added syntax to return both filename and offset. The offset of a particular lobhandle within the LOB hdfs data file may help with UDF parallelization. We could colocate ESPs on the same node where the lobhandle offset is stored for efficient reading/streaming. 

> LOB: Add syntax to return filename  of a LOB data file for external LOBs.
> -------------------------------------------------------------------------
>
>                 Key: TRAFODION-2874
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2874
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>    Affects Versions: 2.3
>            Reporter: Sandhya Sundaresan
>            Assignee: Sandhya Sundaresan
>            Priority: Major
>
> For external LOBs,  Trafodion does not save the LOB data in it's internal trafodion namespace. It saves only the LOB  handle information and the actual LOB data remains outside in users namespace in HDFS.    So inserts are very eifficient. During extract from an external LOB today, we extract the LOB data from the external file and return it to the user. Need to extend the Extract syntax to also be able to return the external LOB data filename alone . 



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