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

        Carl Steinbach made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Carl Steinbach made changes -
        Fix Version/s 0.3.0 [ 12313637 ]
        Fix Version/s 0.6.0 [ 12314524 ]
        Component/s Query Processor [ 12312586 ]
        Zheng Shao made changes -
        Fix Version/s 0.6.0 [ 12314524 ]
        Fix Version/s 0.2.0 [ 12313565 ]
        dhruba borthakur made changes -
        Hadoop Flags [Reviewed]
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Fix Version/s 0.20.0 [ 12313506 ]
        Resolution Fixed [ 1 ]
        Namit Jain made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Namit Jain made changes -
        Attachment patch2.txt [ 12394368 ]
        Namit Jain made changes -
        Status Patch Available [ 10002 ] Open [ 1 ]
        Namit Jain made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Namit Jain made changes -
        Attachment patch1.txt [ 12394362 ]
        Namit Jain made changes -
        Status Patch Available [ 10002 ] Open [ 1 ]
        Namit Jain made changes -
        Field Original Value New Value
        Status Open [ 1 ] Patch Available [ 10002 ]
        Namit Jain created 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