Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

uploading csc via superset give hive connectivity error

uploading csc via superset give hive connectivity error

New Contributor

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