Hello! I encountered a problem with field type not being supported ltee, how can I fix this?
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Hint: You will need to rewrite or cast the expression.
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Position: 584 Call getNextException to see other errors in the batch.
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: org.postgresql.util.PSQLException: ERROR: column “parent_hiera” is of type ltree but expression is of type character varying
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Hint: You will need to rewrite or cast the expression.
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Position: 584
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: org.postgresql.util.PSQLException: ERROR: column “parent_hi” is of type ltree but expression is of type character varying
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Hint: You will need to rewrite or cast the expression.
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: Position: 584
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at io.confluent.connect.jdbc.sink.JdbcSinkTask.put(JdbcSinkTask.java:118)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerSinkTask.deliverMessages(WorkerSinkTask.java:601)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerSinkTask.poll(WorkerSinkTask.java:350)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerSinkTask.iteration(WorkerSinkTask.java:250)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerSinkTask.execute(WorkerSinkTask.java:219)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerTask.doRun(WorkerTask.java:204)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.WorkerTask.run(WorkerTask.java:259)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at org.apache.kafka.connect.runtime.isolation.Plugins.lambda$withClassLoader$1(Plugins.java:236)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
Feb 26 00:19:55 dbase-1 connect-standalone.sh[83230]: at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)