[ https://issues.apache.org/jira/browse/HIVE-5302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13780663#comment-13780663 ]
Edward Capriolo commented on HIVE-5302: --------------------------------------- [~busbey] {noformat} hive> SELECT * FROM episodes_partitioned WHERE doctor_pt > 6 ORDER BY air_date; Total MapReduce jobs = 1 Launching Job 1 out of 1 Number of reduce tasks determined at compile time: 1 In order to change the average load for a reducer (in bytes): set hive.exec.reducers.bytes.per.reducer=<number> In order to limit the maximum number of reducers: set hive.exec.reducers.max=<number> In order to set a constant number of reducers: set mapred.reduce.tasks=<number> Execution log at: /tmp/edward/.log Job running in-process (local Hadoop) Hadoop job information for null: number of mappers: 0; number of reducers: 0 2013-09-27 22:52:03,525 null map = 100%, reduce = 100% Ended Job = job_local_0001 Execution completed successfully Mapred Local Task Succeeded . Convert the Join into MapJoin OK The Doctor's Wife 14 May 2011 11 11 Rose 26 March 2005 9 9 The Eleventh Hour 3 April 2010 11 11 Time taken: 4.121 seconds, Fetched: 3 row(s) hive> show partitions episodes_partitioned; {noformat} I also confirmed this is working hive-trunk -> hadoop 0.20.2 outside unit tests. Do you think this is still an issue. If it is not an issue we can just commit the .q file to ensure there is no regressions. > PartitionPruner fails on Avro non-partitioned data > -------------------------------------------------- > > Key: HIVE-5302 > URL: https://issues.apache.org/jira/browse/HIVE-5302 > Project: Hive > Issue Type: Bug > Components: Serializers/Deserializers > Affects Versions: 0.11.0 > Reporter: Sean Busbey > Assignee: Sean Busbey > Priority: Blocker > Labels: avro > Attachments: HIVE-5302.1-branch-0.12.patch.txt, > HIVE-5302.1.patch.txt, HIVE-5302.1.patch.txt > > > While updating HIVE-3585 I found a test case that causes the failure in the > MetaStoreUtils partition retrieval from back in HIVE-4789. > in this case, the failure is triggered when the partition pruner is handed a > non-partitioned table and has to construct a pseudo-partition. > e.g. > {code} > INSERT OVERWRITE TABLE partitioned_table PARTITION(col) SELECT id, foo, col > FROM non_partitioned_table WHERE col <= 9; > {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira