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.6.0, 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.

Reply via email to