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

["Qifan Chen (JIRA)" <ji...@apache.org>]

Qifan Chen created TRAFODION-1499:
-------------------------------------

             Summary: Error 3078 can be raised when max hive string length is reduced from the default value
                 Key: TRAFODION-1499
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1499
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmp
            Reporter: Qifan Chen


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. 






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)