[ https://issues.apache.org/jira/browse/HIVE-9050?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14983555#comment-14983555 ]
Takahiko Saito commented on HIVE-9050: -------------------------------------- I tried with hive-0.14.0 and the issue was not reproduced, either. > NULL values for empty strings when joining with ORC table > --------------------------------------------------------- > > Key: HIVE-9050 > URL: https://issues.apache.org/jira/browse/HIVE-9050 > Project: Hive > Issue Type: Bug > Components: SQL > Affects Versions: 0.13.0 > Environment: CentOS release 6.4 (Final), Hortonworks 2.1, Tez > Hive 0.13.0.2.1.3.0-563 > Subversion > git://ip-10-0-0-91/grid/0/jenkins/workspace/BIGTOP-HDP_RPM_REPO-baikal-GA-centos6/bigtop/build/hive/rpm/BUILD/h > ive-0.13.0.2.1.3.0 -r a738a76c72d6d9dd304691faada57a94429256bc > Compiled by jenkins on Thu Jun 26 18:28:50 EDT 2014 > From source with checksum 4dbd99dd254f0c521ad8ab072045325d > Reporter: Usein Faradzhev > > When ORC table contains an empty strings and the SQL query contains at least > one join a hive returns NULL instead of empty values. -- This message was sent by Atlassian JIRA (v6.3.4#6332)