[
https://issues.apache.org/jira/browse/TRAFODION-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16347361#comment-16347361
]
ASF GitHub Bot commented on TRAFODION-2874:
-------------------------------------------
GitHub user sandhyasun opened a pull request:
https://github.com/apache/trafodion/pull/1428
[TRAFODION-2874] New syntax to retrieve the LOB HDFS filename, offset for a
LOBhandle
for both external and internal LOBs . Also added syntax to return starting
offset of a particular LOB handle in the LOB Hdfs data file.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sandhyasun/trafodion traf_lob_global_fix
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1428.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 #1428
----
commit a96968e401666a99f36b1729597dab23dd87b74b
Author: Sandhya Sundaresan <sandhya@...>
Date: 2018-01-31T18:35:48Z
New syntax to retrieve the LOB HDFS filename for both external and internal
LOBs . Also added syntax to return starting offset of a particular LOB handle
in the LOB Hdfs data file.
----
> 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)
