Hive
  1. Hive
  2. HIVE-1328

make mapred.input.dir.recursive work for select *

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.6.0
    • Fix Version/s: 0.6.0
    • Component/s: Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      For the script below, we would like the behavior from MAPREDUCE-1501 to apply so that the select * returns two rows instead of none.

      create table fact_daily(x int)
      partitioned by (ds string);

      create table fact_tz(x int)
      partitioned by (ds string, hr string, gmtoffset string);

      alter table fact_tz
      add partition (ds='2010-01-03', hr='1', gmtoffset='-8');
      insert overwrite table fact_tz
      partition (ds='2010-01-03', hr='1', gmtoffset='-8')
      select key+11 from src where key=484;

      alter table fact_tz
      add partition (ds='2010-01-03', hr='2', gmtoffset='-7');
      insert overwrite table fact_tz
      partition (ds='2010-01-03', hr='2', gmtoffset='-7')
      select key+12 from src where key=484;

      alter table fact_daily
      set tblproperties('EXTERNAL'='TRUE');

      alter table fact_daily
      add partition (ds='2010-01-03')
      location '/user/hive/warehouse/fact_tz/ds=2010-01-03';

      set mapred.input.dir.recursive=true;
      select * from fact_daily where ds='2010-01-03';

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              John Sichi
              Reporter:
              John Sichi
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development