[GitHub] [incubator-seatunnel] zhilinli123 commented on issue #4748: Jdbc source中query的sql语句不支持函数

["zhilinli123 (via GitHub)" <gi...@apache.org>]

zhilinli123 commented on issue #4748:
URL: https://github.com/apache/incubator-seatunnel/issues/4748#issuecomment-1547114091

   ```
   env {
     execution.parallelism = 1
     job.mode = "BATCH"
   }
   
   source{
       jdbc{
           url = "jdbc:postgresql://localhost:5432/postgres"
           driver = "org.postgresql.Driver"
           user = "postgres"
           password = "12345678"
           query = " select * from public.tmp_function where  dt  between now()-interval '1 year' and now()"
       }
   }
   
   transform {
   }
   
   sink {
   Console{}
   }
   ```
   I had no problem just trying
   
   ```
          <dependency>
               <groupId>net.postgis</groupId>
               <artifactId>postgis-jdbc</artifactId>
               <version>2.5.1</version>
           </dependency>
   ```
   Make sure you have added the dependency package
   


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