GitHub user dosubot[bot] added a comment to the discussion: Help with hive+http data source
<!-- Greeting --> Hi @realtonyyoung! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team. <!-- Answer --> For Hive/Spark HTTP connections in Superset, you need to include an explicit authentication method in your connection string—this is required by PyHive and SQLAlchemy. The most common issue (and a source of empty error messages) is missing the `auth` parameter. Your URI should look like: ``` hive+http://admin:asdfa...@fusebox-session-cf778406-0bc7-4b92-9fbd-9f025d845c8d-thrift.d24f4h5g0hbtit2o55qg.cvdplucj4rec615u23cg.sites.dev.kurrent.cloud:80/default?auth=BASIC ``` Replace `default` with your database name if needed. Supported auth methods are `BASIC`, `NOSASL`, `KERBEROS`, and `NONE`—most Spark clusters use `BASIC` or `NONE` for HTTP transport. Extra parameters like `httpPath`, `transportMode`, or custom headers should be added as query parameters, for example: ``` hive+http://admin:asdfasdf@host:80/database?auth=BASIC&httpPath=fusebox&transportMode=http ``` There is no special handling required for port 80 in Superset or PyHive, as long as the port is open and reachable. If you still get empty errors, double-check that all required Python dependencies are installed in your container (`pyhive[hive]`, `thrift`, `thrift_sasl`, etc.)—missing these can also cause blank errors. For more details and examples, see [this discussion](https://github.com/apache/superset/issues/22316) and [dependency notes](https://github.com/apache/superset/issues/32324). If you want to debug further, enable debug logging in Superset and PyHive to get more detailed error output. If you continue to see empty errors, it usually means the underlying driver is not surfacing a message—double-check your connection string and dependencies. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/0bb4e5c5-cf44-45e8-9ab3-6654e2679f5c?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/0bb4e5c5-cf44-45e8-9ab3-6654e2679f5c?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/0bb4e5c5-cf44-45e8-9ab3-6654e2679f5c?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/0bb4e5c5-cf44-45e8-9ab3-6654e2679f5c?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/0bb4e5c5-cf44-45e8-9ab3-6654e2679f5c?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/0bb4e5c5-cf44-45e8-9ab3-6654e2679f5c?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/0bb4e5c5-cf44-45e8-9ab3-6654e2679f5c?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github)& nbsp;[](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/discussions/34404) GitHub link: https://github.com/apache/superset/discussions/34404#discussioncomment-13936774 ---- This is an automatically sent email for notifications@superset.apache.org. To unsubscribe, please send an email to: notifications-unsubscr...@superset.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
