amazon-web-servicesamazon-redshiftamazon-redshift-spectrum

Trouble Partitioning my Amazon Spectrum Table


Getting this error in particular:

ERROR: Error when calling external catalog API: The number of partition keys do not match the number of partition values


Solution

  • Just posting this because googling that error turned nothing up. This can happen when you ALTER TABLE ADD PARTITION on an external table created without the PARTITIONED BY clause.

    Read this for details: CREATE EXTERNAL TABLE docs. In retrospect, you, like me, should have read this before trying this command.