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

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

     [ https://issues.apache.org/jira/browse/TRAFODION-1499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Qifan Chen resolved TRAFODION-1499.
-----------------------------------
       Resolution: Fixed
    Fix Version/s: 1.2-incubating

> 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
>            Assignee: Qifan Chen
>             Fix For: 1.2-incubating
>
>
> 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)