Skip to main content
Question

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

  • November 13, 2018
  • 2 replies
  • 14 views

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()'.

2 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • November 13, 2018

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
  • Author
  • New Participant
  • November 13, 2018

Spot on. Thanks.