Internal error: parallel query failed, please retry

Question & Answer
,
1

Hi,

I’m trying to update a dataset from MySQL Aurora and I received this error ““Internal error: parallel query failed, please retry”” ¿What type of error is this? I have similar queries and I don’t have any problem related to that.

Thanks

2

Hi @KLIKIN - Can you please give more details so that it will be easy to understand this.

  1. Do you have any calculated field in the data set? If yes, please verify them.
  2. Create a simple new dataset without any calculated field and point to same table and see whether you are able to see sample data or not. If yes, then there is NO issues with table and there are some issues to the specific data set.
  3. Is there any structure or data type changes to the table, please cross verify this.
  4. If you are not able to see the sample data from QuickSight for that table, please check whether the table is locked or any issues with that at database end.

Regards - Sanjeeb

1 Like
3

Thanks for your answer. About the mentioned points:

  1. No, there is no calculated field
  2. I created a new dataset
  3. Yes, there is a where clause date like ‘%2022%’. If I use: "date like ‘%2023%’ " works correctly. It even works if I don’t use the clause and calculate all the dates (from 2018 to 2023)
    I tried to remove date like ‘%2022%’ and use the filter dataset with the same date range and it’s working but slower.
1 Like
4

Hi @KLIKIN - Can you share the exact where clause statement?

Regards - Sanjeeb

1 Like
5

WHERE payments.date LIKE '%2022%

6

Hi @KLIKIN - Can you change the where clause by below way

WHERE `payments.date` LIKE '%2022%'

Regards - Sanjeeb

1 Like
7

Unknown column

I don’t know if it’s a problem with the marks

8

can you please try this and make a double quote

WHERE "payments.date" LIKE '%2022%'

The real issue date should not be a field name as it is a data type.

Regards - Sanjeeb

1 Like
9

It’s not working, it cannot ingest any row

10

Hi @KLIKIN - The below statement is working fine for me . See the below screenshot. What is your source database, is it my sql or any other database.

select * from test where `date` like '%2020%'

image
image1116×679 23.7 KB

Regards - Sanjeeb

1 Like