You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by GitBox <gi...@apache.org> on 2020/07/30 08:27:08 UTC

[GitHub] [flink] lessonone1 opened a new pull request #13026: fixFlinkSqlInsertQuerySinkFieldNotMatch

lessonone1 opened a new pull request #13026:
URL: https://github.com/apache/flink/pull/13026


   ## problem 
    sql insert  into column size not equal to the size defined in DDL
    throw exception (Field types of query result and registered TableSink)
   
   FOR EXAMPLE:  
   
   DDL student (id, name, age)
   DDL stuout(id, name, age)
   
   insert into stuout( name, age ) select name, age from student ;
   
   throw ValidationException: Field types of query result and registered TableSink
   for jdbc catalog or self defined catalog that get ddl from database meta it is a problem
   
   ## how to solve 
   use insert into column to rebuild TableSchema before create TableSink
   
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #13026: fixFlinkSqlInsertQuerySinkFieldNotMatch

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #13026:
URL: https://github.com/apache/flink/pull/13026#issuecomment-666214858


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "72e43b9673509b0d5c3b4f5a035546a2fbce8f0d",
       "status" : "PENDING",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=5041",
       "triggerID" : "72e43b9673509b0d5c3b4f5a035546a2fbce8f0d",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * 72e43b9673509b0d5c3b4f5a035546a2fbce8f0d Azure: [PENDING](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=5041) 
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] lessonone1 closed pull request #13026: fixFlinkSqlInsertQuerySinkFieldNotMatch

Posted by GitBox <gi...@apache.org>.
lessonone1 closed pull request #13026:
URL: https://github.com/apache/flink/pull/13026


   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #13026: fixFlinkSqlInsertQuerySinkFieldNotMatch

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #13026:
URL: https://github.com/apache/flink/pull/13026#issuecomment-666214858


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "72e43b9673509b0d5c3b4f5a035546a2fbce8f0d",
       "status" : "PENDING",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=5041",
       "triggerID" : "72e43b9673509b0d5c3b4f5a035546a2fbce8f0d",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * 72e43b9673509b0d5c3b4f5a035546a2fbce8f0d Azure: [PENDING](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=5041) 
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot commented on pull request #13026: fixFlinkSqlInsertQuerySinkFieldNotMatch

Posted by GitBox <gi...@apache.org>.
flinkbot commented on pull request #13026:
URL: https://github.com/apache/flink/pull/13026#issuecomment-666205553






----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] flinkbot edited a comment on pull request #13026: fixFlinkSqlInsertQuerySinkFieldNotMatch

Posted by GitBox <gi...@apache.org>.
flinkbot edited a comment on pull request #13026:
URL: https://github.com/apache/flink/pull/13026#issuecomment-666214858


   <!--
   Meta data
   {
     "version" : 1,
     "metaDataEntries" : [ {
       "hash" : "72e43b9673509b0d5c3b4f5a035546a2fbce8f0d",
       "status" : "FAILURE",
       "url" : "https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=5041",
       "triggerID" : "72e43b9673509b0d5c3b4f5a035546a2fbce8f0d",
       "triggerType" : "PUSH"
     } ]
   }-->
   ## CI report:
   
   * 72e43b9673509b0d5c3b4f5a035546a2fbce8f0d Azure: [FAILURE](https://dev.azure.com/apache-flink/98463496-1af2-4620-8eab-a2ecc1a2e6fe/_build/results?buildId=5041) 
   
   <details>
   <summary>Bot commands</summary>
     The @flinkbot bot supports the following commands:
   
    - `@flinkbot run travis` re-run the last Travis build
    - `@flinkbot run azure` re-run the last Azure build
   </details>


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [flink] lessonone1 commented on pull request #13026: fixFlinkSqlInsertQuerySinkFieldNotMatch

Posted by GitBox <gi...@apache.org>.
lessonone1 commented on pull request #13026:
URL: https://github.com/apache/flink/pull/13026#issuecomment-745020893


   bad way 


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org