KFAA31268-E


      
         The specification method of aa....aa of the COPY statement is invalid. <SQLSTATE: 427MB>

         
            
               aa....aa: Position of error

               
                  
                     
                        output location string: Output location
                           string

                     

                     
                        COPY option: COPY option

                     

                     
                        delimiter character specification: Delimiter character specification

                     

                     
                        header specification: Header specification

                     

                     
                        output data compression format specification: Output data compression format specification

                     

                     
                        the column derived from the result of the query expression body: The column derived from the result of the query expression body

                     

                  

               

            
            
               bb....bb: Cause of the error

               
                  
                     
                        '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 data output destination is object storage, the output
                           location string must start with s3://.

                        If the data output destination is file storage, the output
                           location string must start with file://.

                     

                     
                        the specification cannot be specified when the output data format is CSV

                        Cannot be specified if the output data format is CSV
                           format.

                     

                     
                        the specification cannot be specified when the output data format is not CSV

                        The specification cannot be specified when the output data format is not CSV.

                     

                     
                        the data type of the derived column is invalid

                        The data type of the derived column is invalid.

                     

                     
                        a foreign server cannot be specified when the output
                           location string is specified in FILE URI format (when the output
                           destination of the file is file storage)

                        When the output location string is specified in FILE URI format (i.e.,
                           when the data output destination is file storage), the foreign server
                           cannot be specified.

                     

                     
                        a foreign server cannot be omitted when the output
                           location string is specified in S3 URI format (when the output
                           destination of the file is object storage)

                        When the output location string is specified in S3 URI format (i.e., when
                           the data output destination is object storage), the foreign server must
                           be specified.

                     

                  

               

            
            
               S:

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

               

            
            
               Action:

               
                  Correct the SQL statement.

                  If bb....bb is the data type of the derived column is invalid, then the column derived from the result of the query expression body of the COPY statement corresponds to one of the following data types. Therefore, the COPY statement resulted in an error.

                  
                     
                        When the output data format is PARQUET format

                        
                           
                              TIME(0)

                           

                           
                              TIME(12)

                           

                           
                              TIMESTAMP(0)^#

                           

                           
                              TIMESTAMP(12)^#

                           

                           
                              An ARRAY type with one of the above data
                                 types specified as the element data type, or a STRUCT type with one of the above data types specified as the
                                 field data type.

                           

                        

                     

                     
                        When the output data format is CSV format

                        
                           
                              TIME(12)

                           

                           
                              TIMESTAMP(12)^#

                           

                           
                              UUID

                           

                           
                              ARRAY

                           

                           
                              STRUCT

                           

                        

                     

                  

                  Correct the query expression body of the COPY statement so that the column derived from the result of the COPY statement query expression body is of a data type other than the above.

                  
                     
                        #

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