Why would I receive s3() function does not exist.

hoosierbigdata

I am using version 9.1.1-4 from the AWS marketplace. Using the copy table syntax for loading from s3, I get an error that the s3() function does not exist, or I do not have permission to use it. I am running this as the superuser. I can however complete the load using 'from s3://' as opposed to failure when I use 'source s3()'.

Jim_Knicely

The S3 UDSource feature was deprecated in Vertica 9.1 and removed in Vertica 9.1.1

See:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/NewFeatures/_VersionIndependent/DeprecatedandRetiredFunctionality.htm

And:
https://www.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkLoadCOPY/AWSLibrary/importAWSlibrary.htm

Specifically: "Important: The S3 UDSource described in this topic has been removed. Instead, use S3 URLs in COPY FROM as described in Specifying COPY FROM Options."

hoosierbigdata

Spot on. Thanks.