[jira] [Commented] (TRAFODION-2434) Select * from hive table with long partitioning key returns 0 rows

["David Wayne Birdsall (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-2434?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15815663#comment-15815663 ] 

David Wayne Birdsall commented on TRAFODION-2434:
-------------------------------------------------

The following hive script creates and populates a table that demonstrates the problem:

drop database if exists Trafodion2434 cascade;
create database Trafodion2434;
use Trafodion2434;

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;

drop table ProblemTable;

create table ProblemTable (
Column01 int
) partitioned by (
Column02 string
) clustered by (Column01) sorted by (Column01) into 4 buckets row format delimited fields terminated by '|';

set hive.exec.dynamic.partition=false;
set hive.exec.dynamic.partition.mode=strict;

insert into ProblemTable 
partition (Column02='STR1abcdefabcdefghijabcdefghij0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789')      
values
(1);

insert into ProblemTable 
partition (Column02='STR2abcdefabcdefghijabcdefghij0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789')      
values
(2);

insert into ProblemTable 
partition (Column02='STR3abcdefabcdefghijabcdefghij0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789')      
values
(3);

insert into ProblemTable 
partition (Column02='STR4abcdefabcdefghijabcdefghij0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789')      
values
(4);

select * from ProblemTable;

exit;


If we now go into Trafodion sqlci, a select * from hive.Trafodion2434.ProblemTable returns 0 rows, when it should return 4 rows.

> Select * from hive table with long partitioning key returns 0 rows
> ------------------------------------------------------------------
>
>                 Key: TRAFODION-2434
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2434
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>    Affects Versions: 2.1-incubating
>         Environment: All
>            Reporter: David Wayne Birdsall
>            Assignee: David Wayne Birdsall
>
> If one creates and populates a Hive table that has a really long partitioning key, a select * from that table in Trafodion returns 0 rows.



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