[TRAFODION-1499] Error 3078 can be raised when max hive string length is reduced from the default value

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2-incubating
• Component/s: sql-cmp
• Assignee: Qifan Chen
• Reporter: Qifan Chen
• Created: 25/Sep/15 14:59
• Updated: 15/Sep/18 07:32
• Resolved: 25/Sep/15 19:15

Description

One example is for the following simple test from TEST002 (core).

set schema hive.hive;

cqd HIVE_MAX_STRING_LENGTH '20' ;

cqd mode_seahive 'ON';

select count from customer ; <== raise 3078

The reason that the compiler emits 3078 is because the CQD sets the internal length of all string column of the native table to be 20. However, if the external table pre-exists for the native table and the column length is set without the CQD, the length is 32000. Since 20 != 32000, we raise 3078. If no such external table exists, then the check will not be performed and there is no error 3078.