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

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

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 :