You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2016/06/20 23:09:57 UTC
[jira] [Commented] (TRAFODION-2072) long char columns cause
non-deterministic behavior
[ https://issues.apache.org/jira/browse/TRAFODION-2072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15340634#comment-15340634 ]
ASF GitHub Bot commented on TRAFODION-2072:
-------------------------------------------
GitHub user anoopsharma00 opened a pull request:
https://github.com/apache/incubator-trafodion/pull/552
JIRA TRAFODION-2072 plus few more
-- long varchars (> 32K) are handled for traf (regular and aligned)
and hive tables
-- showddl for hive tables shows traf and hive definitions
-- traf external tables can optionally take columns attrs that would
overwrite corresponding hive col attrs
-- metadata is updated with info no whether col attrs were specified
-- 'repeat' function can optionally take a max length parameter
-- error is returned if an external table is created for non-hive
-- tests added to regress/seabase/TEST031 and hive/TEST009
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/anoopsharma00/incubator-trafodion ansharma_longvc_br
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/552.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #552
----
commit b39f7524104659a2ca14cb09ddf6cab817491211
Author: Anoop Sharma <an...@esgyn.com>
Date: 2016-06-20T23:07:19Z
JIRA TRAFODION-2072 plus few more
-- long varchars (> 32K) are handled for traf (regular and aligned)
and hive tables
-- showddl for hive tables shows traf and hive definitions
-- traf external tables can optionally take columns attrs that would
overwrite corresponding hive col attrs
-- metadata is updated with info no whether col attrs were specified
-- 'repeat' function can optionally take a max length parameter
-- error is returned if an external table is created for non-hive
-- tests added to regress/seabase/TEST031 and hive/TEST009
----
> long char columns cause non-deterministic behavior
> ---------------------------------------------------
>
> Key: TRAFODION-2072
> URL: https://issues.apache.org/jira/browse/TRAFODION-2072
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
>
> If a table has char/varchar columns that are more than 32K,
> they show non-deterministic behavior.
> This may show up for hbase format, aligned format or hive
> tables.
> Sometimes columns are truncated at 2-byte boundary,
> sometimes large columns may cause hangs or other issues.
> In the example below, the select hangs:
> >>cqd traf_max_character_col_length '1000000';
> --- SQL operation complete.
> >>create table tlvc2 (z int, b char(10), c varchar(100000), a varchar(1000000))
> +> attribute aligned format;
> --- SQL operation complete.
> >>
> >>insert into tlvc2 values (1, 'abc', repeat('a', 100000), repeat ('b', 100000));
> --- 1 row(s) inserted.
> >>
> >>select char_length(a) from tlvc2;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)