Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-1328

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

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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';

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: