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

Row number issue in hive

    XMLWordPrintableJSON

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Critical
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: 0.9.0
    • Component/s: None
    • Labels:
      None

      Description

      I am converting the Netezza query in hive.How can i achieve following query in hive --> row_number() over (partition by record_id, event_id order by e_timestamp desc) as rnum

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              maya bhardwaj maya bhardwaj
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: