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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.3
• Component/s: sql-exe
• Assignee: Sandhya Sundaresan
• Reporter: Sandhya Sundaresan
• Created: 03/Jan/18 06:40
• Updated: 05/Sep/18 21:40
• Resolved: 27/Mar/18 17:38

Description

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 .

Issue Links

• links to: GitHub Pull Request #1428