You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Abhinav Gupta (JIRA)" <ji...@apache.org> on 2010/09/10 17:58:32 UTC

[jira] Created: (HIVE-1627) Hive Join returns incorrect results if the join is (bigint = string)

Hive Join returns incorrect results if the join is (bigint = string)
--------------------------------------------------------------------

                 Key: HIVE-1627
                 URL: https://issues.apache.org/jira/browse/HIVE-1627
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 0.5.0
            Reporter: Abhinav Gupta


I was running a query joining on bigint column with string column.

And, result was incorrect because only "16 bytes seemed to be compared". The length of value more than 16 bytes when represented as base-10. 

The problem was fixed once I changed the join to (bigint = cast (string as bigint))

Is the bug because of type conversion on join keys?


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[jira] Commented: (HIVE-1627) Hive Join returns incorrect results if the join is (bigint = string)

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1627?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12913310#action_12913310 ] 

John Sichi commented on HIVE-1627:
----------------------------------

To help verify this, could you provide a specific example?


> Hive Join returns incorrect results if the join is (bigint = string)
> --------------------------------------------------------------------
>
>                 Key: HIVE-1627
>                 URL: https://issues.apache.org/jira/browse/HIVE-1627
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.5.0
>            Reporter: Abhinav Gupta
>
> I was running a query joining on bigint column with string column.
> And, result was incorrect because only "16 bytes seemed to be compared". The length of value more than 16 bytes when represented as base-10. 
> The problem was fixed once I changed the join to (bigint = cast (string as bigint))
> Is the bug because of type conversion on join keys?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.