This image shows the partial "HDFS and Oracle Database Data Analysis" note and the two newly created paragraphs at the top of the note: "Load Data from Oracle Database Table" and "Count Number of Students". 



The "Load Data from Oracle Database Table" paragraph is displayed at the top of the note. It contains the following lines of code:


Line 1: val jdbcDF = sqlContext.read
.format("jdbc")
.options(


Line 2:     Map(    

Line 3:         "url" -> "jdbc:oracle:thin:@//blurred", 

Line 4: 
        "dbtable" -> "BDM_DEMO.USERS",


Line 5: 	"user" -> ""

,


Line 6: 	"password" -> "",

Line 7:         "Driver" -> "oracle.jdbc.OracleDriver"
        

Line 8: 	)
    

Line 9: 	   ).load()

Line 10: jdbcDF.registerTempTable("USERS")    





The "Count Number of Students" paragraph is displayed below the "Load Data from Oracle Database Table" paragraph. It contains the following lines of code:

Line 1: %sql  

Line 2: select count(*) from `USERS`