error: database error or network error/ why sql query can't use union to connect two sql statement

[shqcheng]

Bug description

In sql lab, when use "union" to connect two sql statement and run the sql query, there is an error "database error"/"network error".
by the way, when using "sysdate" in sql query, the error is the same.

the database connection parameters is below:

superset version is 4.1.1

does anyone encounter it and solve it? Thanks for help!

Screenshots/recordings

No response

Superset version

4.1.1

Python version

3.10

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[dosubot]

Hey there, @shqcheng! I'm here to help you with any bugs, questions, or contributions you have for Superset. Let's get to the bottom of this together!

I found a similar closed issue related to Oracle database errors in Apache Superset. The issue titled "SQL Lab: Oracle Error (cx_Oracle.DatabaseError) ORA-12505: TNS:listener does not currently know of SID given in connect descriptor" did not have a solution found in the comments ^[1].

For your specific issue with the UNION operation and the use of SYSDATE resulting in "Database error" or "Network error," common causes could include:

1. Database Errors:

   • SYNTAX_ERROR: There might be a syntax error in the SQL query.
   • CONNECTION_INVALID_HOSTNAME_ERROR: The hostname provided can't be resolved.
   • CONNECTION_PORT_CLOSED_ERROR: The port is closed.
   • CONNECTION_HOST_DOWN_ERROR: The host might be down, and can't be reached on the provided port.

2. Network Errors:

   • FRONTEND_NETWORK_ERROR: General network error on the frontend.
   • FRONTEND_TIMEOUT_ERROR: The frontend request timed out.
   • BACKEND_TIMEOUT_ERROR: The backend request timed out.

These errors are mapped to specific issue codes that provide more detailed descriptions of the problems encountered ^[2][3].

You might want to check the database connection settings, ensure that the database server is reachable, and verify that there are no syntax errors in your SQL queries.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}

[shqcheng]

Thanks for your response.@dosu

Sorry it's not the mentioned cause as i don't use union, the sql query can run correctly.

[hainenber]

hi there, what database do you use for these erroneous queries?

[shqcheng]

oracle.   走走停停 ***@***.***  

…

------------------ 原始邮件 ------------------ 发件人: "Đỗ Trọng ***@***.***>; 发送时间: 2025年2月15日(星期六) 中午12:08 收件人: ***@***.***>; 抄送: ***@***.***>; ***@***.***>; 主题: Re: [apache/superset] error: database error or network error/ why sql query can't use union to connect two sql statement (Issue #32258) hi there, what database do you use for these erroneous queries? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: ***@***.***> hainenber left a comment (apache/superset#32258) hi there, what database do you use for these erroneous queries? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you were mentioned.Message ID: ***@***.***>