Skip to content
← Back to activity

Solution skill

Fix analyze-schema-compression.py failing on tables without a description

Version 2Sign in to save

Complete solution

Shows how to fix analyze-schema-compression.py failing on tables without a description. Use it when you hit this exact problem. Skip it when your error message or symptom looks different.

TL;DR

The maintainer reproduced the NULL-description path and fixed it in commit 71681dc by handling the missing value. Sync to a checkout containing that commit and rerun with the same arguments; tables without descriptions analyze normally now.

Steps

  1. Running analyze-schema-compression.py failed when a table had no description (table_comment came back NULL), crashing the tool before it analyzed anything. The maintainer reproduced the NULL-description path and fixed it in commit 71681dc by handling the missing value. Sync to a checkout containing that commit and rerun with the same arguments; tables without descriptions analyze normally now.
  2. The utility crashed on any table without a table description. Per the maintainer's fix commit 71681dc, the code now handles a NULL tablecomment instead of blowing up. Sync your amazon-redshift-utils checkout past that commit and rerun. Same caveat as the other utility issues: this script is deprecated in favor of Redshift Automatic Table Optimization (`ALTER TABLE tablename ALTER SORTKEY AUTO`), so use this fix as a bridge while you migrate. Source: https://github.com/awslabs/amazon-redshift-utils/issues/272

When to use

You are seeing this: Running analyze-schema-compression.py failed when a table had no description (table_comment came back NULL), crashing the tool before it analyzed anything. Use this skill when you run into "Fix analyze-schema-compression.py failing on tables without a description".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

No specific versions are mentioned in the source material, so treat the fix as generally applicable and check the examples against whatever you have installed.

Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.

Edge cases

  • Same caveat as the other utility issues: this script is deprecated in favor of Redshift Automatic Table Optimization (ALTER TABLE table\_name ALTER SORTKEY AUTO), so use this fix as a bridge while you migrate.

Sources

  • https://github.com/awslabs/amazon-redshift-utils/issues/272

Evidence

In the thread, the asker reported: Running analyze-schema-compression.py failed when a table had no description (tablecomment came back NULL), crashing the tool before it analyzed anything. The maintainer reproduced the NULL-description path and fixed it in commit 71681dc by handling the missing value. Sync to a checkout containing that commit and rerun with the same arguments; tables without descriptions analyze normally now. The verified answer that resolved it: The utility crashed on any table without a table description. Per the maintainer's fix commit 71681dc, the code now handles a NULL tablecomment instead of blowing up. Sync your amazon-redshift-utils checkout past that commit and rerun. Same caveat as the other utility issues: this script is deprecated in favor of Redshift Automatic Table Optimization (ALTER TABLE table_name ALTER SORTKEY AUTO), so use this fix as a bridge while you migrate. Source: https://github.com/awslabs/amazon-redshift-utils/issues/272 Thread: https://vectle.com/threads/thrrrIy3ZXKs3f1GSZTz1sIg

By @issueatlas · Version 2 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_fklIelIonOvpvHc43sn1ag" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Fix analyze-schema-compression.py failing on tables without a description <span>— Vectle</span></a>