0:00:00.000,0:00:04.799
Hi this is Tom with Coherent Logic and

0:00:02.639,0:00:07.770
today I'm going to walk you through a

0:00:04.799,0:00:10.230
quick example where we retrieve Brent

0:00:07.770,0:00:12.809
Crude Futures Continuous Contract data

0:00:10.230,0:00:15.780
from Quandl and then convert it

0:00:12.809,0:00:17.760
directly into an Apache Spark Dataset so let's jump

0:00:15.780,0:00:19.430
right in. I'm going to paste the following script

0:00:17.760,0:00:22.800
and execute it.

0:00:19.430,0:00:28.340
There's our script -- I'll go ahead and run this.

0:00:22.800,0:00:32.160
There you have our result.

0:00:28.340,0:00:33.930
So what's the script do in this case? Due

0:00:32.160,0:00:35.370
to the way the Quandl web services are

0:00:33.930,0:00:39.989
written we need to do a bit of

0:00:35.370,0:00:43.460
work on our end. We create an instance

0:00:39.989,0:00:45.600
of CMR which is used to execute

0:00:43.460,0:00:49.110
different calls against different web

0:00:45.600,0:00:51.360
services and then we create a case class

0:00:49.110,0:00:54.890
which will have our result. In this case

0:00:51.360,0:00:59.039
we want to take the date, open, high, and

0:00:54.890,0:01:01.980
low values and so then all we do is to

0:00:59.039,0:01:05.460
map those values accordingly and then,

0:01:01.980,0:01:08.729
finally, here on this line we can

0:01:05.460,0:01:11.369
actually execute the call; what this

0:01:08.729,0:01:14.010
does is it makes a request to Quandl for

0:01:11.369,0:01:16.350
data. Quandl returns of data as XML and

0:01:14.010,0:01:19.170
then the resultant XML is converted into

0:01:16.350,0:01:23.280
a Dataset and we can see the result

0:01:19.170,0:01:24.750
here. So that's it for this example. If

0:01:23.280,0:01:26.400
you liked the video please give it a

0:01:24.750,0:01:28.860
thumbs-up; if you have questions or

0:01:26.400,0:01:30.390
comments leave them below and I'll get

0:01:28.860,0:01:33.030
your response as soon as I can.

0:01:30.390,0:01:34.500
Last but not least if you like this

0:01:33.030,0:01:38.329
video please subscribe to the channel.

0:01:34.500,0:01:38.329
That's all for now.