KFAA31566-E


      
         An attempt to generate the column definitions for the foreign table failed. <SQLSTATE:42I7D>

         
               aa....aa:

               
                  Cause of the error

               
               S:

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

               
               Action:

               
                  Take the following action depending on the cause of error output to
                     aa....aa.

                  
                                 Value of aa....aa

                              
                                 Cause of the error

                              
                                 Corrective action to take

                              
                                 the foreign data format is not PARQUET or ICEBERG

                              
                                 A value other than PARQUET or ICEBERG is specified in the foreign data
                                    format specification.

                              
                                 Specify PARQUET or ICEBERG in the foreign
                                    data format specification in the CREATE FOREIGN TABLE statement.

                              
                                 the foreign data does not exist in
                                    the directory from which data is to be retrieved

                              
                                 The PARQUET format foreign data files do not exist under the
                                    target directory for foreign data search (including
                                    subdirectories).

                              
                                 Store the foreign data files under the target
                                    directory for foreign data search.

                              
                                 the column name in the foreign data is
                                    invalid

                              
                                       The column names of the foreign data do not meet the
                                          conditions of the naming rules for the columns of the
                                          foreign table.

                                    
                                       The column names included in the metadata of the
                                          Iceberg table^# do not meet the
                                          conditions of the naming rules for foreign tables.

                                    
                                 Make sure that the column names of the foreign data meet the
                                    following conditions. Also, check whether the
                                    column names included in the Iceberg table metadata meet the
                                    following conditions. If they do not, the CREATE FOREIGN TABLE statement will result
                                    in an error.

                                 
                                       The first character of the column name is a halfwidth
                                          uppercase letter (A
                                          to Z, #, @, \, _), halfwidth
                                          lowercase letter, halfwidth katakana character, or
                                          fullwidth character.

                                    
                                       Each character of the column name is a halfwidth uppercase
                                          letter (A to Z, #, @, \, _), digit, halfwidth lowercase
                                          letter, halfwidth katakana character,
                                          halfwidth space, hyphen, halfwidth
                                          vertical bar, or fullwidth character.

                                    
                                       The column name does not contain any fullwidth spaces.

                                    
                                       The length of the column name is 100 bytes or less.

                                    
                                 For details, see column-name in Rules for
                                    characters that can be used in names of Specifying
                                    names in the manual HADB SQL Reference.

                              
                                 the data type of the foreign data
                                    is not compatible with the data types supported by HADB

                              
                                       The data type of the foreign data column
                                          is not compatible with the HADB data type.

                                    
                                       The data type of the columns included in the
                                          Iceberg table^# metadata is not
                                          compatible with the HADB data type.

                                    
                                 Check whether the following conditions are met.

                                 Change the data type of the foreign data columns to a
                                    type compatible with the HADB data type. Alternatively, change
                                    the data type of the columns included in the Iceberg table
                                    metadata to a type compatible with the HADB data type.

                                 
                                       If the foreign data is of type DECIMAL(precision=m,
                                          scale=n), then
                                          m and n must satisfy
                                          1 ≤ m ≤ 38, 0 ≤ n ≤
                                          38, and n ≤ m.

                                    
                                       The data length of the binary data in the foreign data is
                                          between 1 and 32,000 bytes.

                                    
                                       The element data type of the LIST type in the foreign data specifies a data type
                                          that is compatible with the HADB data type.

                                    
                                       The maximum number of elements for the LIST type in the foreign data is
                                          between 2 and 30,000.

                                    
                                       The total number of fields contained in the STRUCT type of the foreign data is
                                          1,000 or less.

                                    
                                       If the elements of the LIST type
                                          in the foreign data are nested with STRUCT type, the repetition count of the LIST type and STRUCT type is 8 or less.

                                    
                                       If the elements of the STRUCT type in the foreign data are nested with STRUCT type or LIST type, the repetition
                                          count of the LIST type
                                          and STRUCT type is 8 or
                                          less.

                                    
                                 For details, see the following tables in
                                    Specification format and rules for the CREATE FOREIGN
                                    TABLE statement in the manual HADB SQL
                                    Reference:

                                 
                                       The table Correspondence between the data type of
                                          each column of foreign data in PARQUET format and the HADB
                                          data type in Rules

                                    
                                       The table Correspondence between the data types of
                                          the columns included in the metadata of the Iceberg table
                                          and the HADB data types in If ICEBERG is
                                          specified in the foreign data format specification
                                          under Rules for omitting the column definition
                                          specification

                                    
                                 unsupported foreign data was
                                    detected

                              
                                       There are columns in the foreign data with data
                                          types not supported by HADB. 

                                    
                                       There are columns in the Iceberg table^# metadata with data types not supported by
                                          HADB.

                                    
                                 Delete columns with data types not supported by HADB
                                    from the foreign data. 

                                 Alternatively, delete columns with data types not
                                    supported by HADB from the Iceberg table metadata.

                              
                                 the field name in the foreign data is
                                    invalid

                              
                                       The field names of the foreign data do not meet the
                                          conditions of the naming rules for the field names of the
                                          STRUCT type columns in the
                                          foreign table.

                                    
                                       The field names included in the metadata of the
                                          Iceberg table^# do not meet the
                                          conditions of the naming rules for the field names of STRUCT columns in the foreign
                                          table.

                                    
                                 Check whether the field names of the foreign data meet
                                    the following conditions. If they do not, the CREATE FOREIGN TABLE statement will result
                                    in an error.

                                 
                                       The first character of the field name is a halfwidth
                                          uppercase letter (A
                                          to Z, #, @, \, _), halfwidth
                                          lowercase letter, halfwidth katakana character, or
                                          fullwidth character.

                                    
                                       The characters in the field name include halfwidth
                                          uppercase letters (A to Z, #, @, \, _), digits, halfwidth lowercase letters,
                                          halfwidth katakana characters, halfwidth
                                          spaces, hyphens, halfwidth vertical bar,
                                          or fullwidth characters.

                                    
                                       The field name does not contain fullwidth spaces.

                                    
                                       The length of the field name is 100 bytes or less.

                                    
                                 For details, see field-name in Rules for
                                    characters that can be used in names of Specifying
                                    names in the manual HADB SQL Reference.

                              
                                 the number of columns in the table exceeds
                                    maximum number

                              
                                 The number of columns in the table exceeds the limit.

                              
                                       If this message is output when defining a foreign
                                          table

                                       When column definitions are omitted, the total number of
                                          columns in the referenced PARQUET format foreign data
                                          files and the number of partition key columns must be
                                          4,000 or less.

                                    
                                       If this message is output when retrieving a foreign
                                          table

                                       The total number of columns included in the metadata of
                                          the Iceberg table referenced by the foreign table to be
                                          retrieved must be 4,000 or less.

                                    
                        #

                        
                           If this message is output when retrieving a foreign table, there is a
                              problem with the columns or fields in the metadata of the Iceberg
                              table referenced by the foreign table to be retrieved. If a time
                              travel specification is used when retrieving the foreign table, there
                              is a problem with the columns or fields in the metadata at the
                              snapshot point.

Value of aa....aa	Cause of the error	Corrective action to take
the foreign data format is not PARQUET or ICEBERG	A value other than PARQUET or ICEBERG is specified in the foreign data format specification.	Specify PARQUET or ICEBERG in the foreign data format specification in the CREATE FOREIGN TABLE statement.
the foreign data does not exist in the directory from which data is to be retrieved	The PARQUET format foreign data files do not exist under the target directory for foreign data search (including subdirectories).	Store the foreign data files under the target directory for foreign data search.
the column name in the foreign data is invalid	The column names of the foreign data do not meet the conditions of the naming rules for the columns of the foreign table. The column names included in the metadata of the Iceberg table^# do not meet the conditions of the naming rules for foreign tables.	Make sure that the column names of the foreign data meet the following conditions. Also, check whether the column names included in the Iceberg table metadata meet the following conditions. If they do not, the CREATE FOREIGN TABLE statement will result in an error. The first character of the column name is a halfwidth uppercase letter (A to Z, #, @, \, _), halfwidth lowercase letter, halfwidth katakana character, or fullwidth character. Each character of the column name is a halfwidth uppercase letter (A to Z, #, @, \, _), digit, halfwidth lowercase letter, halfwidth katakana character, halfwidth space, hyphen, halfwidth vertical bar, or fullwidth character. The column name does not contain any fullwidth spaces. The length of the column name is 100 bytes or less. For details, see column-name in Rules for characters that can be used in names of Specifying names in the manual HADB SQL Reference.
the data type of the foreign data is not compatible with the data types supported by HADB	The data type of the foreign data column is not compatible with the HADB data type. The data type of the columns included in the Iceberg table^# metadata is not compatible with the HADB data type.	Check whether the following conditions are met. Change the data type of the foreign data columns to a type compatible with the HADB data type. Alternatively, change the data type of the columns included in the Iceberg table metadata to a type compatible with the HADB data type. If the foreign data is of type DECIMAL(precision=`m`, scale=`n`), then `m` and `n` must satisfy 1 ≤ `m` ≤ 38, 0 ≤ `n` ≤ 38, and `n` ≤ `m`. The data length of the binary data in the foreign data is between 1 and 32,000 bytes. The element data type of the LIST type in the foreign data specifies a data type that is compatible with the HADB data type. The maximum number of elements for the LIST type in the foreign data is between 2 and 30,000. The total number of fields contained in the STRUCT type of the foreign data is 1,000 or less. If the elements of the LIST type in the foreign data are nested with STRUCT type, the repetition count of the LIST type and STRUCT type is 8 or less. If the elements of the STRUCT type in the foreign data are nested with STRUCT type or LIST type, the repetition count of the LIST type and STRUCT type is 8 or less. For details, see the following tables in Specification format and rules for the CREATE FOREIGN TABLE statement in the manual HADB SQL Reference: The table Correspondence between the data type of each column of foreign data in PARQUET format and the HADB data type in Rules The table Correspondence between the data types of the columns included in the metadata of the Iceberg table and the HADB data types in If ICEBERG is specified in the foreign data format specification under Rules for omitting the column definition specification
unsupported foreign data was detected	There are columns in the foreign data with data types not supported by HADB. There are columns in the Iceberg table^# metadata with data types not supported by HADB.	Delete columns with data types not supported by HADB from the foreign data. Alternatively, delete columns with data types not supported by HADB from the Iceberg table metadata.
the field name in the foreign data is invalid	The field names of the foreign data do not meet the conditions of the naming rules for the field names of the STRUCT type columns in the foreign table. The field names included in the metadata of the Iceberg table^# do not meet the conditions of the naming rules for the field names of STRUCT columns in the foreign table.	Check whether the field names of the foreign data meet the following conditions. If they do not, the CREATE FOREIGN TABLE statement will result in an error. The first character of the field name is a halfwidth uppercase letter (A to Z, #, @, \, _), halfwidth lowercase letter, halfwidth katakana character, or fullwidth character. The characters in the field name include halfwidth uppercase letters (A to Z, #, @, \, _), digits, halfwidth lowercase letters, halfwidth katakana characters, halfwidth spaces, hyphens, halfwidth vertical bar, or fullwidth characters. The field name does not contain fullwidth spaces. The length of the field name is 100 bytes or less. For details, see field-name in Rules for characters that can be used in names of Specifying names in the manual HADB SQL Reference.
the number of columns in the table exceeds maximum number	The number of columns in the table exceeds the limit.	If this message is output when defining a foreign table When column definitions are omitted, the total number of columns in the referenced PARQUET format foreign data files and the number of partition key columns must be 4,000 or less. If this message is output when retrieving a foreign table The total number of columns included in the metadata of the Iceberg table referenced by the foreign table to be retrieved must be 4,000 or less.