Welcome to the Simplilearn Community

Want to join the rest of our members? Sign up right away!

Sign Up

Big Data Hadoop and Spark Developer | March 20th - May 1st | Deepak Garg

_85627

New Member
Hello,
I was trying to access SQL Database "BDHS_PROJECT" for working on BigData Hadoop project "Stock Exchange Data Analysis" however I am getting error "Access denied for user 'bimbamanjunathin'@'%' to database 'BDHS_PROJECT'".
Can you please let me know how I can resolve this?
Thanks
 
Hi Deepak,

Pls. advise if the code written for below mentioned is correct,
  1. Check the quality of customers by checking average balance, median balance of customers
bank_data.createOrReplaceTempView("datanewtable")
val median =spark.sql("SELECT percentile_approx(balance, 0.5)FROM datanewtable").show()

I am getting the following output,

1619970945369.png

Pls. confirm if I've missed anything.
 
I have tried one more command and got the following out put pls. confirm if this time I've done it right,

val median =spark.sql("SELECT percentile_approx(balance, 0.5)as median , avg(balance) average FROM datanewtable").show()

1619971459128.png
 

Mohan reddy_8

Administrator
Staff member
Simplilearn Support
Alumni
Trainer
Customer
Hi Hemant,

The source code provided by you stands right in both the cases.
BINGO!!

Go ahead!

Regards
Mohan Reddy
Simplilearn
 
Hello,
I was trying to access SQL Database "BDHS_PROJECT" for working on BigData Hadoop project "Stock Exchange Data Analysis" however I am getting error "Access denied for user 'bimbamanjunathin'@'%' to database 'BDHS_PROJECT'".
Can you please let me know how I can resolve this?
Thanks
I am getting same error. Let me know if you got any solution.
 
Top