You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2010/10/18 19:51:31 UTC

[jira] Commented: (HIVE-1724) The query in join_filters.q will failed if the table size is larger than 25000

    [ https://issues.apache.org/jira/browse/HIVE-1724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12922171#action_12922171 ] 

Namit Jain commented on HIVE-1724:
----------------------------------

Does it work with your patch for HIVE-1641 ?

> The query in join_filters.q will failed if the table size is larger than 25000
> ------------------------------------------------------------------------------
>
>                 Key: HIVE-1724
>                 URL: https://issues.apache.org/jira/browse/HIVE-1724
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Liyin Tang
>            Assignee: Liyin Tang
>             Fix For: 0.7.0
>
>
> In the test case join_filter.q, there is a query:
> SELECT /*+ MAPJOIN(a) */ * FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value;
> Right now the table of myinput is only 4 rows.
> I tried to create a new table and it has more than 25000 rows.
> Actually, this query will failed.

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