KFAA30704-E


      
         The data type of the column aa....aa specified in the column
            definition of the CREATE FOREIGN TABLE statement is invalid.
            <SQLSTATE:42I91>

         
            
               aa....aa:

               
                  The column name that caused the error

               

            
            
               S:

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

               

            
            
               Action:

               
                  The following data type cannot be specified for the column definition
                     in the CREATE FOREIGN TABLE statement.

                  
                     
                        When PARQUET is specified for the foreign data
                           format specification^#1

                        
                           
                              TIME(0), TIME(12)

                           

                           
                              TIMESTAMP(0), TIMESTAMP(12)^#2

                           

                           
                              A STRUCT that includes one of the above
                                 as a field data type, or an ARRAY that
                                 includes one of the above as an element data type.

                           

                        

                     

                     
                        When CSV is specified for the foreign data
                           format specification

                        
                           
                              TIME(12)

                           

                           
                              TIMESTAMP(12)^#2

                           

                           
                              UUID

                           

                           
                              STRUCT

                           

                           
                              ARRAY

                           

                        

                     

                     
                        When JSON is specified for the foreign data
                           format specification

                        
                           
                              TIME(12)

                           

                           
                              TIMESTAMP(12)^#2

                           

                           
                              UUID

                           

                           
                              A STRUCT that includes one of the above
                                 as a field data type, or an ARRAY that
                                 includes one of the above as an element data type.

                           

                        

                     

                     
                        When ICEBERG is specified for the foreign data
                           format specification^#3

                        
                           
                              TIME(0), TIME(3), TIME(9), TIME(12)

                           

                           
                              TIMESTAMP(0), TIMESTAMP(3), TIMESTAMP(9), TIMESTAMP(12)^#2

                           

                           
                              A STRUCT that includes one of the above
                                 as a field data type, or an ARRAY that
                                 includes one of the above as an element data type.

                           

                        

                     

                  

                  Specify a fractional seconds precision other than the one
                     mentioned above or another data type. For details about the CREATE FOREIGN TABLE statement, see CREATE FOREIGN
                     TABLE (defining a foreign table) in the manual HADB SQL
                     Reference.

                  
                     
                        #1

                        
                           If the column definition specification is omitted, the HADB server
                              automatically generates the column definition. If the data type of the
                              generated column corresponds to a data type that cannot be specified
                              as described here, the CREATE FOREIGN TABLE
                              statement will result in an error.

                        

                     
                     
                        #2

                        
                           This applies to both TIMESTAMP WITHOUT TIME
                              ZONE type and TIMESTAMP WITH TIME ZONE
                              type.

                        

                     
                     
                        #3

                        
                           If ICEBERG is specified in the foreign data
                              format specification, the HADB server automatically generates the
                              column definition. If the data type of the generated column
                              corresponds to a data type that cannot be specified as described here,
                              the CREATE FOREIGN TABLE statement will
                              result in an error.