Complete data could not be retrieved using ResultSet API's when some of the input record column values are blank. ------------------------------------------------------------------------------------------------------------------
Key: HIVE-1957 URL: https://issues.apache.org/jira/browse/HIVE-1957 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 Complete data could not be retrieved using ResultSet API's when some of the input record column values are blank. In CLI mode, all the data is retrieved as expected. But with ResultSet.next(), all the data is not retrieved. Ex: create table emp(empno String,ename String,deptno int) row format delimited fields terminated by '@'; select aemp.empno from emp aemp; *Input Data* {noformat} 333@chinna@20 444@@40 @rao@50 555@lalam@40 666@jagan@78 {noformat} *Actual output* {noformat} 333 444 {noformat} *Expected output* {noformat} 333 444 555 666 {noformat} -- This message is automatically generated by JIRA. - For more information on JIRA, see: http://www.atlassian.com/software/jira