[teiid-issues] [JBoss JIRA] (TEIID-4441) Add FTP/SFTP based access to the File Resource Adapter

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13334152#comment-13334152 ] 

Ramesh Reddy edited comment on TEIID-4441 at 12/5/16 2:44 PM:
--------------------------------------------------------------

One suggestion I have is do not download the file from FTP server and create a temp file locally, consider that as a stream of data. The metadata exposed from file translator already returns either Clob or Blob, so use those interfaces to pass in the contents of a file. Consider, when we do the same with HDFS this could be multi GB data at best or even larger, we should not to be making copies of these files.

Also make sure VFS is not dragging in any dependencies other than what you are defining, these need to be concise.


was (Author: rareddy):
One suggestion I have is do not download the file from FTP server and create a temp file locally, consider that as a stream of data. The metadata exposed from file translator already returns either Clob or Blob, so use those interfaces to pass in the contents of a file. Consider, when we do the same with HDFS this could be multi GB data at best or even larger, we should not to be making copies of these files.

> Add FTP/SFTP based access to the File Resource Adapter
> ------------------------------------------------------
>
>                 Key: TEIID-4441
>                 URL: https://issues.jboss.org/browse/TEIID-4441
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>            Reporter: Ramesh Reddy
>            Assignee: Kylin Soong
>             Fix For: Open To Community, 9.2
>
>
> This has been requested few times in the community, it would be nice to give provide this functionality.  Using http://commons.apache.org/proper/commons-net/ seems to be right decision.



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)