You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@seatunnel.apache.org by "yzeng1618 (via GitHub)" <gi...@apache.org> on 2025/06/18 07:25:08 UTC

[I] [Bug] [Connector-Iceberg] Fix Time Zone Issue for Iceberg Timestamp Type [seatunnel]

yzeng1618 opened a new issue, #9457:
URL: https://github.com/apache/seatunnel/issues/9457

   ### Search before asking
   
   - [x] I had searched in the [issues](https://github.com/apache/seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues.
   
   
   ### What happened
   
   During the synchronization process from MySQL to Iceberg, the synchronization is shown as successful, but the timestamp type time is found to differ from the source by 8 hours.
   
   ### SeaTunnel Version
   
   2.3.9
   
   ### SeaTunnel Config
   
   ```conf
   {
     env {
       execution.parallelism = 1
       job.mode = "BATCH"
       job.name = "seatunnel_batch_job"
     }
     # source配置
     source {
       JDBC {
         url = "xxxx"
         driver = "xxxxx"
         user = "xxxx"
         password = "xxxx"
         query = "xxxxx"
         split.size = 5000
         fetch_size = 2000      
       }
     }
     # sink配置
     sink {
       Iceberg {
         catalog_name= "default"
         iceberg.catalog.config={
           "type"= "xxxx"
           "uri" = "xxxx"
           "warehouse"= "xxxx"
         }
         namespace= "xxxxx"
         table= "xxxxx"
         iceberg.table.write-props={
           write.format.default="xxxx"
           write.target-file-size-bytes=536870912
           write.parquet.compression-codec="xxxx"
         }
         iceberg.hadoop-conf-path = "xxxxx"
         iceberg.table.upsert-mode-enabled = false
         iceberg.table.schema-evolution-enabled=true
         case_sensitive=true      
       }
     }
   }
   ```
   
   ### Running Command
   
   ```shell
   ./bin/start-seatunnel-flink-15-connector-v2.sh --config mysql2iceberg.conf --deploy-mode run-application --target yarn-application --name mysql2iceberg
   ```
   
   ### Error Exception
   
   ```log
   The value of the datetime type at the MySQL source end is 2020-06-08 15:21:15, and after successful synchronization, the value of the corresponding field is 2020-06-08 23:21:15.000.
   ```
   
   ### Zeta or Flink or Spark Version
   
   flink 1.16
   
   ### Java or Scala Version
   
   java 8
   
   ### Screenshots
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [x] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org.apache.org

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


Re: [I] [Bug] [Connector-Iceberg] Fix Time Zone Issue for Iceberg Timestamp Type [seatunnel]

Posted by "yzeng1618 (via GitHub)" <gi...@apache.org>.
yzeng1618 closed issue #9457: [Bug] [Connector-Iceberg] Fix Time Zone Issue for Iceberg Timestamp Type
URL: https://github.com/apache/seatunnel/issues/9457


-- 
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.

To unsubscribe, e-mail: commits-unsubscribe@seatunnel.apache.org

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