[
https://issues.apache.org/jira/browse/TRAFODION-1499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-1499 started by Qifan Chen.
---------------------------------------------
> 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
>
> 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)
