KFAA31564-E

The specification method for aa....aa of the CREATE FOREIGN TABLE statement is invalid. <SQLSTATE:42I7C>

aa....aa: Location of invalid specification

• foreign data directory path string: Foreign data directory path string

• foreign table option: Foreign table option

• partition key column option specification: Optional partitioning key column specification

• partition key column specification: Partition key column specification

• attribute property: Property

• enumeration string: Enumeration string

• minimum value string or integer: Minimum value string or minimum value integer

• maximum value string or integer: Maximum value string or maximum value integer

• datetime format string: Date and time format string

• template directory path string: Template directory path string

• catalog type specification: Catalog type specification

• catalog URI specification: Catalog URI specification

• catalog namespace specification: Catalog namespace specification

• catalog region specification: Catalog region specification

• catalog ID specification: Catalog ID specification

• warehouse name specification: Warehouse name specification

• Iceberg option: Iceberg option

• token URI specification: Token URI specification

• client ID specification: Client ID specification

• client secret specification: Client secret specification

• allowed scope specification: Allowed scope specification

• column definition: Column definition

bb....bb: Cause of the error

Value of bb....bb	Description
's3://' or 'file://' is not specified at the beginning of the string	s3:// or file:// is not specified at the beginning of the string. If the storage location of the foreign data is object storage, the directory path string of the foreign data must start with s3://. If the storage location of the foreign data is file storage, the directory path string of the foreign data must start with file://.
'/' is not specified to the tail of string	/ is not specified at the tail of the string.
neither the foreign data format nor the foreign data directory path, or both, have been specified	The following two required specifications are not provided. Either both specifications are missing, or only one of the specifications is present: Specification of the data format for the foreign data Specification of the directory path for the foreign data
the option cannot be specified when the foreign data format is not CSV	The specified option can be specified only when the data format of the foreign data is CSV format.
the option can only be specified when the foreign data format is ICEBERG	The specified option can be specified only when ICEBERG is specified in the foreign data format specification.
the option cannot be specified when the foreign data format is ICEBERG	The specified option cannot be specified when ICEBERG is specified in the foreign data format specification.
an option that must be specified when the foreign data format is ICEBERG is not specified	An option that is required when ICEBERG is specified in the foreign data format specification has not been specified.
the partition key column must be specified when the partition key column option is specified	When specifying the optional partitioning key column specification, the partition key column specification must be specified.
the partition key column cannot be specified when the partition key column option is omitted	If the optional partitioning key column specification is omitted, the partition key column specification cannot be specified.
the same attribute property cannot be specified for the same column name	The same type of property cannot be specified for the same column name.
the column name specified in the attribute property must be the same as the column name of the partition key column	The column name specified for the property must be the same as the column name of the partition key column specification.
the combination of the attribute property is invalid	The combination of properties that can be specified is invalid.
an attribute property that must be specified is not specified	A property that needs to be specified is not specified.
the data length of the value that can be specified for the enumeration string exceeds the upper limit	Among the strings specified in the enumeration string, there are strings that exceed the maximum data length.
the number of values that can be specified for the enumeration string exceeds the upper limit	The number of strings specified in the enumeration string exceeds the limit.
the value of the minimum value string or integer is higher than the value of the maximum value string or integer	The value of the minimum value string is greater than the value of the maximum value string. Or, the minimum integer value is greater than the maximum integer value.
the minimum value string or maximum value string cannot be converted to a date-time value by using the datetime format string	Could not convert the minimum or maximum value string to a datetime value according to the specified datetime format string.
the header of the template directory path string must be the same as the foreign data directory path string	The beginning of the template directory path string must be the same as the foreign data directory path string.
the data type for the partition key column cannot be specified	A data type that cannot be specified for the data type of the partition key column is specified.
the data length is over	The maximum data length is exceeded.
the combination of the time unit and the specified value for the TYPE is invalid	The combination of the specified value of TYPE and the specified value of time unit is invalid.
values for each element in the enumeration string, minimum value integer, maximum value integer, a minimum value string or a maximum value string cannot be converted to the value for the data type of the partition key column	Each string in the enumerated string, the minimum integer, the maximum integer, the minimum value string, or the maximum value string could not be converted to the data type of the partition key column.
the variables for all partition key columns are not specified in the template directory path string	The variables corresponding to all partition key columns are not specified in the template directory path string.
a foreign server cannot be omitted when the foreign data directory path string is specified in S3 URI format (when external data is stored in object storage)	When the directory path string of foreign data is specified in S3 URI format (i.e., when the foreign data is stored in object storage), the foreign server must be specified.
a foreign server cannot be specified when the foreign data directory path string is specified in FILE URI format (when external data is stored in file storage)	When the directory path string of foreign data is specified in FILE URI format (i.e., when the foreign data is stored in file storage), the foreign server cannot be specified.
the string does not start with 'http://' or 'https://'	The string does not start with either http:// or https://.
the option cannot be specified when the catalog type is GLUE	An option that cannot be specified when GLUE is designated as the catalog type has been specified.
the Iceberg option that must be specified when the catalog type is GLUE is not specified	An Iceberg option that is required when GLUE is designated as the catalog type has not been specified.
the option cannot be specified when the catalog type is REST	An option that cannot be specified when REST is designated as the catalog type has been specified.
the Iceberg option that must be specified when the catalog type is REST is not specified	An Iceberg option that is required when REST is designated as the catalog type has not been specified.
the token URI specification, client ID specification, client secret specification, and allowed scope specification must be all specified or all omitted	Token URI specification, client ID specification, client secret specification, and allowed scope specification must either all be specified or all be omitted.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the SQL statement.