You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Chinna Rao Lalam (JIRA)" <ji...@apache.org> on 2011/02/08 16:26:57 UTC

[jira] Created: (HIVE-1972) HiveResultset is always returning null for Array Data types in the select Query

HiveResultset is always returning null for Array Data types in the select Query
-------------------------------------------------------------------------------

                 Key: HIVE-1972
                 URL: https://issues.apache.org/jira/browse/HIVE-1972
             Project: Hive
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 0.5.0
         Environment: Hadoop 0.20.1, Hive0.5.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5).
            Reporter: Chinna Rao Lalam
            Assignee: Chinna Rao Lalam
            Priority: Minor


Execute the following Hive Queries 
{noformat}
1) create table samplearray(a int,b int,c array<int>)row format delimited fields terminated by '@' collection items terminated by '$' stored as textfile;

2) LOAD DATA INPATH '/user/dataloc/details3.txt' OVERWRITE INTO TABLE samplearray

3) Now execute the select statement "select c from emp;" using HiveStatement API

4) Now Iterate through the returned HiveResultSet, the array column is always null.
{noformat}

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Resolved: (HIVE-1972) HiveResultset is always returning null for Array Data types in the select Query

Posted by "Steven Wong (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1972?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Wong resolved HIVE-1972.
-------------------------------

    Resolution: Duplicate

Should have been fixed by HIVE-1378.

> HiveResultset is always returning null for Array Data types in the select Query
> -------------------------------------------------------------------------------
>
>                 Key: HIVE-1972
>                 URL: https://issues.apache.org/jira/browse/HIVE-1972
>             Project: Hive
>          Issue Type: Bug
>          Components: JDBC
>    Affects Versions: 0.5.0
>         Environment: Hadoop 0.20.1, Hive0.5.0 and SUSE Linux Enterprise Server 10 SP2 (i586) - Kernel 2.6.16.60-0.21-smp (5).
>            Reporter: Chinna Rao Lalam
>            Assignee: Chinna Rao Lalam
>            Priority: Minor
>
> Execute the following Hive Queries 
> {noformat}
> 1) create table samplearray(a int,b int,c array<int>)row format delimited fields terminated by '@' collection items terminated by '$' stored as textfile;
> 2) LOAD DATA INPATH '/user/dataloc/details3.txt' OVERWRITE INTO TABLE samplearray
> 3) Now execute the select statement "select c from emp;" using HiveStatement API
> 4) Now Iterate through the returned HiveResultSet, the array column is always null.
> {noformat}

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira