CODEWITHSUNDEEP
amazon-redshiftmicrostrategy
Sachiko
Sachiko

Reputation: 924

MicroStrategy Query for Redshift added Limit Clause unintendedly

We noticed MSTR Query for Redshift was added the limit clause at the end, like 'LIMIT 600001', without our intention. Not with all the query, but costly query tends to have it automatically.

We'd like to clarify what configure makes this at Redshift or MicroStrategy. If my memory serves me correctly, right after our migration to Redshift 8 months ago, we didn't notice such a limitation.

Any information would be highly appreciated.

Upvotes: 0

Views: 107

Answers (1)

Big brother
Big brother

Reputation: 31

Check the query in MSTR. If you see LIMIT this MSTR and you should check VLBD properties.

Upvotes: 1

Related Questions