How to write Spark DataFrame to salesforce table

2017-01-23 Thread Niraj Kumar
Hi I am trying to write a dataframe into salesforce table. facWriteBack.write.mode("append").jdbc(s"jdbc:salesforce:UseSandbox=True;User=;Password=;Security Token=;Timeout=0", "SFORCE.") Am I doing it correctly? And also suggest, how to upsert a record? Thanks in advance Niraj Disclaimer :

Query in SparkSQL

2016-12-12 Thread Niraj Kumar
tn) select accnt_call_id, prdct_cd, prdct_id, 32 from samples where PRDCT_CD = 2114515; Thanks and Regards, Niraj Kumar Disclaimer : This email communication may contain privileged and confidential information and is intended for the use of the addressee only. If you are not an intended recipie

SparkSQL

2016-12-09 Thread Niraj Kumar
tn) select accnt_call_id, prdct_cd, prdct_id, 32 from samples where PRDCT_CD = 2114515; delete from samples where PRDCT_CD in (2106861, 2114515); Thanks and Regards, Niraj Kumar Disclaimer : This email communication may contain privileged and confidential information and is intended for the use of the