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

   ### 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
   
   If the source is oracle, the numeric data in the parquet file appears 
strangely.
   Integer type data also appears with numerous zeros after the decimal point.
   
   ### SeaTunnel Version
   
   2.3.3 or 2.3.4
   
   ### SeaTunnel Config
   
   ```conf
   env {
       job.mode = "BATCH"
   }
   
   source {
       Jdbc {
           url = "jdbc:oracle:thin:@//IP:PORT/DB"
           driver = "oracle.jdbc.OracleDriver"
           user = "USER"
           password = "PASSWORD"
           query = "select * from oracle_table"
       }
   }
   
   transform {
   }
   
   sink {
       LocalFile {
            path = "./"
            file_format_type="parquet"
       }
   }
   ```
   
   
   ### Running Command
   
   ```shell
   sh bin/seatunnel.sh --config ./config/oracle_to_parquet.template -e local
   ```
   
   
   ### Error Exception
   
   ```log
   If the column type of the oracle table is numeric, when querying the parquet 
schema, FIXED_LEN_BYTE_ARRAY Decimal(precision=38, scale=18) appears, and the 
actual value appears as 123.00000000
   If the source is mysql, this issue does not occur.
   ```
   
   
   ### Zeta or Flink or Spark Version
   
   zeta
   
   ### Java or Scala Version
   
   java : 1.8.0_181
   
   
   ### Screenshots
   
   
![image](https://github.com/apache/seatunnel/assets/7941368/d70d548e-93e2-4599-9367-5adf6e12f3fe)
   
![image](https://github.com/apache/seatunnel/assets/7941368/9f0640ae-1267-4ea9-a080-d4fb2e78755a)
   
   
   ### Are you willing to submit PR?
   
   - [ ] 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to