@Naresh P R Hi I tried for my scenario I am getting Also week must start with monday and end with sunday. select date_sub('2018-09-12',pmod(datediff('2018-09-12','1900-01-07),7)) 2018-09-09 I am getting sep 9 th which is Sunday. but for my scenario the week must start with sep 10 th monday select date_add('2018-09-12',7 - pmod(datediff('2018-09-12','1900-01-07'),7)); 2018-09-16 ... View more

@Ginta Thanks. As you suggested i M using spark now. Must i use MLIB ? I have a csv file in spark now. val mk = sc.textFile("hdfs:path filenmae.csv"); I have 4 string values and 3 double values. I need to calculate the outlier now and need to apply any prediction modelling with results in a visualized way. What can i use now? Any suggestions? Thanks. ... View more