[jira] [Created] (FLINK-20481) java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer

[Shang Yuanchun (Jira)]

zhisheng created FLINK-20481:
--------------------------------

             Summary: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
                 Key: FLINK-20481
                 URL: https://issues.apache.org/jira/browse/FLINK-20481
             Project: Flink
          Issue Type: Bug
          Components: Connectors / JDBC, Table SQL / Ecosystem
    Affects Versions: 1.12.0
            Reporter: zhisheng
         Attachments: image-2020-12-04-15-24-08-732.png, image-2020-12-04-15-26-49-307.png

MySQL table sql :
{code:java}
DROP TABLE IF EXISTS `yarn_app_logs_count`;

CREATE TABLE `yarn_app_logs_count` (  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,  `app_id` varchar(50) DEFAULT NULL,  `count` bigint(11) DEFAULT NULL,  PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `yarn_app_logs_count` (`id`, `app_id`, `count`)VALUES  (1,'application_1575453055442_3188',2);
{code}
Flink SQL DDL：
{code:java}
CREATE TABLE yarn_app_logs_count (
  id INT,
  app_id STRING,
  `count` BIGINT
) WITH (
   'connector' = 'jdbc',
   'url' = 'jdbc:mysql://localhost:3306/zhisheng',
   'table-name' = 'yarn_app_logs_count',
   'username' = 'root',
   'password' = '123456'
);select * from yarn_app_logs_count;
{code}
 

if id type is INT, it has an exception:
{code:java}
2020-12-04 15:15:23org.apache.flink.runtime.JobException: Recovery is suppressed by NoRestartBackoffTimeStrategy    at org.apache.flink.runtime.executiongraph.failover.flip1.ExecutionFailureHandler.handleFailure(ExecutionFailureHandler.java:116)    at org.apache.flink.runtime.executiongraph.failover.flip1.ExecutionFailureHandler.getFailureHandlingResult(ExecutionFailureHandler.java:78)    at org.apache.flink.runtime.scheduler.DefaultScheduler.handleTaskFailure(DefaultScheduler.java:224)    at org.apache.flink.runtime.scheduler.DefaultScheduler.maybeHandleTaskFailure(DefaultScheduler.java:217)    at org.apache.flink.runtime.scheduler.DefaultScheduler.updateTaskExecutionStateInternal(DefaultScheduler.java:208)    at org.apache.flink.runtime.scheduler.SchedulerBase.updateTaskExecutionState(SchedulerBase.java:533)    at org.apache.flink.runtime.scheduler.SchedulerNG.updateTaskExecutionState(SchedulerNG.java:89)    at org.apache.flink.runtime.jobmaster.JobMaster.updateTaskExecutionState(JobMaster.java:419)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at java.lang.reflect.Method.invoke(Method.java:498)    at org.apache.flink.runtime.rpc.akka.AkkaRpcActor.handleRpcInvocation(AkkaRpcActor.java:286)    at org.apache.flink.runtime.rpc.akka.AkkaRpcActor.handleRpcMessage(AkkaRpcActor.java:201)    at org.apache.flink.runtime.rpc.akka.FencedAkkaRpcActor.handleRpcMessage(FencedAkkaRpcActor.java:74)    at org.apache.flink.runtime.rpc.akka.AkkaRpcActor.handleMessage(AkkaRpcActor.java:154)    at akka.japi.pf.UnitCaseStatement.apply(CaseStatements.scala:26)    at akka.japi.pf.UnitCaseStatement.apply(CaseStatements.scala:21)    at scala.PartialFunction$class.applyOrElse(PartialFunction.scala:123)    at akka.japi.pf.UnitCaseStatement.applyOrElse(CaseStatements.scala:21)    at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:170)    at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:171)    at scala.PartialFunction$OrElse.applyOrElse(PartialFunction.scala:171)    at akka.actor.Actor$class.aroundReceive(Actor.scala:517)    at akka.actor.AbstractActor.aroundReceive(AbstractActor.scala:225)    at akka.actor.ActorCell.receiveMessage(ActorCell.scala:592)    at akka.actor.ActorCell.invoke(ActorCell.scala:561)    at akka.dispatch.Mailbox.processMailbox(Mailbox.scala:258)    at akka.dispatch.Mailbox.run(Mailbox.scala:225)    at akka.dispatch.Mailbox.exec(Mailbox.scala:235)    at akka.dispatch.forkjoin.ForkJoinTask.doExec(ForkJoinTask.java:260)    at akka.dispatch.forkjoin.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1339)    at akka.dispatch.forkjoin.ForkJoinPool.runWorker(ForkJoinPool.java:1979)    at akka.dispatch.forkjoin.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:107)Caused by: java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer    at org.apache.flink.table.data.GenericRowData.getInt(GenericRowData.java:149)    at org.apache.flink.table.data.RowData.lambda$createFieldGetter$245ca7d1$6(RowData.java:267)    at org.apache.flink.table.data.RowData.lambda$createFieldGetter$25774257$1(RowData.java:317)    at org.apache.flink.table.runtime.typeutils.RowDataSerializer.copyRowData(RowDataSerializer.java:166)    at org.apache.flink.table.runtime.typeutils.RowDataSerializer.copy(RowDataSerializer.java:129)    at org.apache.flink.table.runtime.typeutils.RowDataSerializer.copy(RowDataSerializer.java:50)    at org.apache.flink.streaming.runtime.tasks.CopyingChainingOutput.pushToOperator(CopyingChainingOutput.java:69)    at org.apache.flink.streaming.runtime.tasks.CopyingChainingOutput.collect(CopyingChainingOutput.java:46)    at org.apache.flink.streaming.runtime.tasks.CopyingChainingOutput.collect(CopyingChainingOutput.java:26)    at org.apache.flink.streaming.api.operators.CountingOutput.collect(CountingOutput.java:52)    at org.apache.flink.streaming.api.operators.CountingOutput.collect(CountingOutput.java:30)    at org.apache.flink.streaming.api.operators.StreamSourceContexts$ManualWatermarkContext.processAndCollect(StreamSourceContexts.java:305)    at org.apache.flink.streaming.api.operators.StreamSourceContexts$WatermarkContext.collect(StreamSourceContexts.java:394)    at org.apache.flink.streaming.api.functions.source.InputFormatSourceFunction.run(InputFormatSourceFunction.java:93)    at org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:100)    at org.apache.flink.streaming.api.operators.StreamSource.run(StreamSource.java:63)    at org.apache.flink.streaming.runtime.tasks.SourceStreamTask$LegacySourceFunctionThread.run(SourceStreamTask.java:215)

{code}
 

!image-2020-12-04-15-24-08-732.png!

when i set id type is BIGINT, it works well. but My MySQL table id is define INT, i see the Data Type Mapping ([https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/connectors/jdbc.html#data-type-mapping)|https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/connectors/jdbc.html#data-type-mapping),]

!image-2020-12-04-15-26-49-307.png|width=622,height=421!

 

 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)