Hi Divya
Considering you are able to successfully load both tables testCond and test as
data frames.
As now taking your case:
when you do val condval = testCond.select(“Cond”) //Where Cond is a column
name, here condval is a DataFrame.Even if it has one row, it is still a data
frame
if you want
Hi,
//Loading all the DB Properties
val options1 = Map("url" ->
"jdbc:oracle:thin:@xx.xxx.xxx.xx:1521:dbname","user"->"username","password"->"password","dbtable"
-> "TESTCONDITIONS")
val testCond = sqlContext.load("jdbc",options1 )
val condval = testCond.select("Cond")
testCond.show()
val