virtual schemas / local files

drumcircle
Single Node Master

Can virtual schema write local files (temp files?)

 

What are the limitations in terms of size?

Would they be wiped out with every invocation (new container)?

 

1 ACCEPTED SOLUTION

exa-SebastianB
Team Exasol
Team Exasol

VS have no direct access to the local file system. You can however use HTTP to r/w from BucketFS.

Alternatively you could in theory write the content to tables. Be aware of locking in that case. Also the size of an Exasol VARCHAR is limited to 2 million characters. 30% less if you Base64 encode binaries.

View solution in original post

1 REPLY 1

exa-SebastianB
Team Exasol
Team Exasol

VS have no direct access to the local file system. You can however use HTTP to r/w from BucketFS.

Alternatively you could in theory write the content to tables. Be aware of locking in that case. Also the size of an Exasol VARCHAR is limited to 2 million characters. 30% less if you Base64 encode binaries.

View solution in original post