Cloudera Community
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
TF123
user rank
New Contributor
My Accepted Solutions
Show All

Re: pass parameters to file with sql statement usi...

by New Contributor in Support Questions
‎03-07-2019 05:55 AM
‎03-07-2019 05:55 AM
This worked at the end..   val FromDate = "2019-02-25" val sqlfile = fromFile("sql3.py").getLines.mkString val sqlfil2= sqlfile.replace("${From_timeStamp}",From_timeStamp) val result = sqlContext.sql(sqlfile2) On the file I have: Select col1, col2 from table1 where transdate = '${FromDate}' ... View more

pass parameters to file with sql statement using S...

by New Contributor in Support Questions
‎03-01-2019 03:13 AM
‎03-01-2019 03:13 AM
I am using Scala on data science workbench and I have file with sql stataement would like to make it dynamic sql by passing argument to parameters. I then would like to pass it  sqlContext.sql(string) .   This is what I have tried but does not work. val FromDate = "2019-02-25" val sqlfile = fromFile("sql3.py").getLines.mkString val result = sqlContext.sql(sqlfile) On the file I have: Select col1, col2 from table1 where transdate = '${FromDate}'   Any help would be appreciated.    Thanks ... View more
Contact Me
Online
Offline
Last Visited
‎03-12-2019 10:36 AM
Community Statistics
Member Since ‎03-01-2019 02:51 AM
Last Visited ‎03-12-2019 10:36 AM
Posts 2