a11dev commented on issue #6800:
URL: https://github.com/apache/seatunnel/issues/6800#issuecomment-2186515460

   Hi Jia,
   I resumed my seatunnel tests.
   Still trying to sync mongo from oracle cdc.
   
   Firstly as written apache seatunnel documentation is pointing to a wrong
   maven repository.
   In the end I found the connector component manually navigating
   https://mvnrepository.com/artifact/org.apache.seatunnel.
   The plugin installer is throwing an exception because the maven repository
   is not available.
   Documentation, related to manual installation, doesn't mention other
   libraries needed mongodb-driver-sync-4.7.1 and mongodb-driver-core-4.7.1 as
   requested from the connector manifes.
   
   Btw this I achieved it.
   
   Now I'm able to run the documentation example but not a real scenario ,
   I've a big oracle table. I like to transform it into a document into a
   mongo collection, to make it simple I applied a transformation in the
   middle :
   [...]
   transform {
   Sql {
   source_table_name = "assignments"
   result_table_name = "mongoassignments"
   query = "select pkname from assignments"
   }
   }
   [...]
   
   MongoDB {
   source_table_name = ["mongoassignments"]
   uri = ***@***.***:27017/?authSource=dbname"
   database = "dbname"
   collection = "assignmentskeys"
   upsert-enable = true
   primary-key = ["  pkname   "]
   
       schema = {
         fields {
           _id = string
             pkname   = bigint
             }
       }
   }
   
   but it throws such an error:
   java: Caused by: com.mongodb.MongoBulkWriteException: Bulk write operation
   error on server XXXXXX:27017. Write errors: [BulkWriteError{index=0,
   code=2, message='$and/$or/$nor must be a nonempty array', details={}}].
   
   any idea?
   
   Do you think, might be possible to set up the denv env and try debugging it?
   
   thanks a lot
   Alessandro
   
   
   Il giorno mer 15 mag 2024 alle ore 04:14 Jia Fan ***@***.***>
   ha scritto:
   
   > cc @liugddx <https://github.com/liugddx>
   >
   > —
   > Reply to this email directly, view it on GitHub
   > <https://github.com/apache/seatunnel/issues/6800#issuecomment-2111454976>,
   > or unsubscribe
   > 
<https://github.com/notifications/unsubscribe-auth/AI2V566DX2V2W52QBLOUQCTZCLAIJAVCNFSM6AAAAABHI7W73CVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMJRGQ2TIOJXGY>
   > .
   > You are receiving this because you authored the thread.Message ID:
   > ***@***.***>
   >
   


-- 
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-unsubscr...@seatunnel.apache.org

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

Reply via email to