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 Bug
    • Status: Closed
    • Priority: Major 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

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

        Activity

        No work has yet been logged on this issue.

          People

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

            Dates

            • Created:
              Updated:
              Resolved:

              Development