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.

Superset fail at uploading a CSV file

Superset fail at uploading a CSV file

New Contributor

While trying to upload a csv file to Superset using the GUI I get the following

100423-capture.png

(pg.InternalError) FATAL: password authentication failed for user "superset" (Background on this error at: http://sqlalche.me/e/2j85)

You can check the photo attached.

Checked the link mentioned in issue and it wasn't helpful.

This is the first time I try uploading using the GUI, so it wasn't working before or anything.

HDP latest.

3 REPLIES 3
Highlighted

Re: Superset fail at uploading a CSV file

New Contributor

Have the same problem.

In my case the "problem" was caused by authentication method.

To "resolve" in my test environment I set authentication method from md5 into trust in pg_hba.conf in my Postgresql server on the database used for importing data.

Another authentication methods caused the same error.

I believe this is something like bug...

@Ali Alghamdi, please test and let me know.

Re: Superset fail at uploading a CSV file

New Contributor
Andriy,

That should work yeah, but it must be a security flaw to open the trust channel.

I hope we get an answer soon with clear instructions and clarifications.

Best regards,

Re: Superset fail at uploading a CSV file

New Contributor

@Ali Alghamdi

You can simply fix this problem https://github.com/apache/incubator-superset/issues/4285

So, change lines in file: /usr/hdp/current/superset/lib/python3.4/site-packages/superset/db_engine_specs.py

to follow:

line 137: 'con': create_engine(form.con.data.sqlalchemy_uri_decrypted, echo=False),

line 882: engine = create_engine(form.con.data.sqlalchemy_uri_decrypted)