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

2021-06-18 Thread Anshul Kala
ace *tableName* with the equivalent SQL insert statement > > You will need JDBC driver for Oracle say ojdbc6.jar in > $SPARK_HOME/conf/spark-defaults.conf > > spark.driver.extraClassPath > /home/hduser/jars/jconn4.jar:/home/hduser/jars/ojdbc6.jar > > HTH > > > >

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

2021-06-18 Thread Anshul Kala
Hi All, I am using spark to ingest data from file to database Oracle table . For one of the fields , the value to be populated is generated from a function that is written in database . The input to the function is one of the fields of data frame I wanted to use spark.dbc.write to perform the op