a11dev commented on issue #6800: URL: https://github.com/apache/seatunnel/issues/6800#issuecomment-2186565101
Sorry... I did! the basic transfer is working now, no help needed on this topic. Sorry I disturbed you! Is there a way to update a collection in order to perform a dernomalization along the oracle to mongo sync? Ale Il giorno lun 24 giu 2024 alle ore 14:54 Alessandro Leonardi < ***@***.***> ha scritto: > 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
