Something went wrong error

Q&A
,
1

Hi,

I have got an error “Something went wrong error”, while running a large SQL query (853 rows) with lots of complex calculations. When I run it in a MySQL database, the final data loads without any problems.
What can be the reasons of this?

2

Hi @makc4us - Welcome to AWS Quick Sight and thanks for posting the questions. Couple of details require?

  1. How much time the query took when you executed in Mysql database? What is the data volume ( like number of rows or size of the data)
  2. In Quick Sight, are you using SPICE for loading the data to Cache first as custom sql may timedout.
  3. When you are executing the sql via Quick Sight, can you also check the my sql sessions, just to ensure whether Quick Sight is able to submit the query to mysql correctly or not.

I am not sure whether such lengthy query ( 853 lines) is support in custom sql or not. We can check with other experts, tagging @David_Wong @sagmukhe @Biswajit_1993 @duncan

On another note - is it possible to create a view where your complex logic will be select statement and just select all the data from the view in QS, this way it will be easy and simple and any changes in the query logic, you just need to do it at DB level

Regards - Sanjeeb

1 Like
3

Hi, @Sanjeeb2022!

  1. The query took 49 seconds to return the result. The main table is about 230 MB, but there are lots of subseries and calculations based on it, so the final weight of data can be much larger.

  2. I try to use both SPICE and Direct Query. No changes.

Kind regards,

1 Like
4

Hi @makc4us - Is it possible to create a view in database with the select statement ( with all logics and calculations) and take the data from the view like “select * from <>”

Regards - Sanjeeb

2 Likes