virtual schemas / local files

drumcircle
SQL-Fighter

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