Hi there!

I am learning Data Science form your wonderful academy, your magnificent videos and you amazing technology. Sincerely I do not have enough words to say thank you, because of this, I am trying to reach a new job on this great new world of Data Science.

Well, the thing is that I am very happy that for once in life, all software and everything needed I do not have to install it and this is great.

Because of this I need to ask you guys for a couple of little errors when I try to replicate the exercises from the video.

I am on the video:
https://courses.cognitiveclass.ai/courses/course-v1:CognitiveClass+DS0105EN+v2/courseware/89227024130b43f684d95376901b65c8/b1e5a1476871427faf54d47068399534/

and I am trying to do this:

registerTempTable(sdf, "cars")
highgearcars <- sql(sqlContext, "Select gear from cars where cyl >= 4 And cyl <=9")
SparkR::head(highgearcars)

And the result is:

registerTempTable(sdf, "cars")
Warning message:
'registerTempTable' is deprecated.
Use 'createOrReplaceTempView' instead.
See help("Deprecated")
highgearcars <- sql(sqlContext, "Select gear from cars where cyl >= 4 And cyl <=9")
Warning message:
'sql(sqlContext...)' is deprecated.
Use 'sql(sqlQuery)' instead.
See help("Deprecated")
SparkR::head(highgearcars)
gear
1 4
2 4
3 4
4 3
5 3
6 3

By the way, or its me or the results of the SELECT are wrong?

Thank you!

Regards,

Matu

PD: Sorry for my english, it is not my mother language.