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

limit does not work if applied to outer most block and it is not a query

    Details

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

      Description

      limit does not work if applied to outer most block and it is not a query

      For eg

      insert into T1 select ... from T2 limit 10;

      will be executed as a map-job only.

      which means that the total number of rows in T1 is bounded by 10 * number of mappers.

      We need another map-reduce job to fix this or the move task needs to be modified.

      For now, the simpler fix of another map-reduce job should be ok, in future we can further optimize it by modifying the move task

        Attachments

        1. patch2.txt
          11 kB
          Namit Jain
        2. patch1.txt
          8 kB
          Namit Jain

          Activity

            People

            • Assignee:
              namit Namit Jain
              Reporter:
              namit Namit Jain
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: