Skip to main content
print this page

Failed to query Redshift views consisting of complex statements like CTE

· 2 min read
Fix Available
Fix Available
This bug has been fixed
Patch Available
Patch Available
This bug has a patch available for affected versions

There are couple of issues regarding views where users were unable to query Redshift views which contains complex statements like CTE.

Error: list index out of range

Affected Versions: 2.5.1 2.6 2.6.1

Fix Version: 2.5.1* 2.6* 2.6.1* 2.7

2.5.1* 2.6* 2.6.1*

Customers upgrading to these versions after Aug 09, 2024 does not require explicit patching as the fix will be part of the release artifacts.

Root cause(s)​

While making recent enhancements in 2.5.1 related to Hudi CORS functionality, Couple of validation placements resulted in these errors.

Impact​

After upgrading to 2.5.1/2.6/2.6.1, When users try to query any Redshift views which contains complex statements like CTE then query fails with the error message list index out of range instead of returning results.

Mitigation​

Fix available

Fix will be available in Amorphic version 2.7.

Patch available

Patch is available for Amorphic versions v2.5.1, 2.6, 2.6.1

Please contact amorphic-support@cloudwick.com to patch your application.

Timeline​

gantt
    title Timeline
    dateFormat YYYY-MM-DD
    tickInterval 7day
    axisFormat %b-%d
    todayMarker off
    section Tracker
        %% update the ticket number and date of bug report
        CLOUD-4833 : done, 2024-08-03, 0d
    section Identification
        Reported : crit, des1, 2024-08-04, 0d
    section Mitigation
        %% Update number of days took for each step below
        Bug Fixed: crit, done, 2024-08-05, 1d
    section Delivery
        %% update the date of each step below
        testing complete: milestone, 2024-08-07, 0d
        patch avaialble: milestone, 2024-08-07, 0d
  • 2024-08-03: Bug reported/identified (CLOUD-4833)
  • 2024-08-04: Bug triaged
  • 2024-08-05: Bug fixed
  • 2024-08-07: Testing of patch on v2.5.1, v2.6 and v2.6.1 has been completed
  • 2024-08-07: Patch for v2.5.1, v2.6 and v2.6.1 has been released