Hi Mich, This is Scala's string interpolation which allow for replacing $-prefixed expressions with their values.
It's what cool kids use in Scala to do templating and concatenation 😁 Jacek On 23 Aug 2016 9:21 a.m., "Mich Talebzadeh" <mich.talebza...@gmail.com> wrote: > What is --> s below before the text of sql? > > *var* sales_order_sql_stmt =* s*"""SELECT ORDER_NUMBER , > INVENTORY_ITEM_ID, ORGANIZATION_ID, > > from_unixtime(unix_timestamp(SCHEDULE_SHIP_DATE,'yyyy-MM-dd'), > 'yyyy-MM-dd') AS schedule_date > > FROM sales_order_demand > > WHERE unix_timestamp(SCHEDULE_SHIP_DATE,'yyyy-MM-dd') >= $ > planning_start_date limit 10""" > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > *Disclaimer:* Use it at your own risk. Any and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising from > such loss, damage or destruction. > > > > On 23 August 2016 at 07:31, Deepak Sharma <deepakmc...@gmail.com> wrote: > >> >> On Tue, Aug 23, 2016 at 10:32 AM, Deepak Sharma <deepakmc...@gmail.com> >> wrote: >> >>> *val* *df** = **sales_demand**.**join**(**product_master**,* >>> *sales_demand**.$"INVENTORY_ITEM_ID" =**== **product_master* >>> *.$"INVENTORY_ITEM_ID",**"inner"**)* >> >> >> Ignore the last statement. >> It should look something like this: >> *val* *df** = **sales_demand**.**join**(**product_master**,$"* >> *sales_demand**.INVENTORY_ITEM_ID" =**== $"**product_master* >> *.INVENTORY_ITEM_ID",**"inner"**)* >> >> >> -- >> Thanks >> Deepak >> www.bigdatabig.com >> www.keosha.net >> > >