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

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Patch Available Patch Available Open Open
        1h 17m 2 Namit Jain 20/Nov/08 20:51
        Open Open Patch Available Patch Available
        1h 46m 3 Namit Jain 20/Nov/08 20:51
        Patch Available Patch Available Resolved Resolved
        2h 52m 1 dhruba borthakur 20/Nov/08 23:44
        Resolved Resolved Closed Closed
        1121d 24m 1 Carl Steinbach 17/Dec/11 00:09
        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 ]
        Hide
        dhruba borthakur added a comment -

        I just committed this. Thanks Namit!

        Show
        dhruba borthakur added a comment - I just committed this. Thanks Namit!
        Hide
        Raghotham Murthy added a comment -

        +1

        looks good

        Show
        Raghotham Murthy added a comment - +1 looks good
        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