Support Questions
Find answers, ask questions, and share your expertise

uploading csc via superset give hive connectivity error

dear all,

i have installed hdp3 and setup hive and superset. my hive URL in the superset looks lilke below

mysql+pymysql://hive:XXXXXXXXXX@bigdata.hct.org:3306/hive

when i press the Test Connection button, it give all seems ok alert. and i can see my tables if i scroll down.

but when i try to upload a csv file through superset into my hive database, it give me the following error

(pymysql.err.OperationalError) (1045, "Access denied for user 
'hive'@'bigdata.hct.org' (using password: YES)") (Background on this 
error at: http://sqlalche.me/e/e3q8)

my superset page looks like below attached picture.

can somebody guide me what is wrong?

91637-capture.png

0 REPLIES 0