unsubscribe

Sandeep Varma Principal ZS Associates India Pvt. Ltd. World Trade Center, Tower 3, Kharadi, Pune 411014, Maharashtra, India T | +91 20 6739 5224 M | +91 97 6633 0103 www.zs.com ZS Impact where it matters. Notice: This message,

Re: Insert into table with one the value is derived from DB function using spark

Another option is to just use plain jdbc (if in java) in a foreachPartition call on the dataframe/dataset then you get full control of the insert statement but need to open the connection/transaction yourself On Sat, 19 Jun 2021 at 19:33, Mich Talebzadeh wrote: > Hi, > > I did some research on

Re: Insert into table with one the value is derived from DB function using spark

Hi, I did some research on this. The only way one can write to Oracle from Spark is through JDBC (excluding other options outside of Spark). The challenge here is that you have a column based on function get_function() column that Spark needs to insert. Currently there is no way of inserting

Re: Insert into table with one the value is derived from DB function using spark

Hi Why this can be done by oracle insert trigger? Or even a view? On Sat, 19 Jun 2021 at 7:17 am, Mich Talebzadeh wrote: > Well the challenge is that Spark is best suited to insert a dataframe into > the Oracle table, i.e. a bulk insert > > that insert into table (column list) values (..) is

Unsubscribe