[Amazon](500310] SQL reparse error

[makotong]

getting this error after putting an advanced and elongated CTE. Does this mean I need to simplify query? Works fine when running on other query processors (redshift Datagrip)

[Biswajit_1993]

Hi @makotong,

First of all, welcome to the QuickSight Community!

As per my understanding, this error occurs when there is an issue with the datatype parsing in your query.

Please check this link for further assistance with your problem

Quicksight can not parse Date from dataset

Hi Community! I am a new user of Quicksight. I use it to visualize my dynamoDB data with Athena Connector. I have LatestDate field which is initially a string and 99.99% of rows have format yyyy-MM-dd'T'HH:mm:ss.SSSSSS+SS:SS. And sometimes there are rows that have yyyy-MM-dd'T'HH:mm:ss+SS:SS format. I don’t mind skipping them, so I just changed the data type for LatestDate to Date with yyyy-MM-dd'T'HH:mm:ss.SSSSSS+SS:SS. And as far as I understand Quicksight will drop invalid rows. But then …

Thanks & Regards
Biswajit Dash

[Xclipse]

Hi @makotong

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

[Xclipse]

Hi @makotong

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!