[IMPALA-4021] qgen: random data gen: handle Oracle not having boolean types

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 2.8.0
• Component/s: Infrastructure
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Michael Brown
• Created: 25/Aug/16 17:27
• Updated: 13/Oct/17 22:17

Description

The random query generator uses data from the random data generator. The data generator can generate random data or migrate existing data. In the data generation case, the data generator has been coded to use types found both in Impala and PostgresQL, the most common reference data base.

When using the random query generator against a different reference database, like Oracle, care must be given to ensure the right types are being used. Oracle does not support Boolean types, for example. The data generator might be asked to generate random data, in which case right now, Boolean columns might be chosen. The data generator might also be asked to migrate existing data from Impala which may contain Boolean columns.

The data generator should either not allow Boolean columns or provide a workaround (like a 1-char char-based column).