title: Need Hive query to parse Json file
body: <p>Sample JSON File is mentioned below from which i need version,overrideable,scenario,repairType,rank and notificationType</p>
  
  <p>Please suggest hive query without adding any new jar</p>
  
  <pre><code> {
      "channelOutcome": {
          "MG": {
              "repairStrategies": [
                  {
                      "scenario": "1",
                      "repairType": "ISR",
                      "rank": 1,
                      "notificationType": "Z5"
                  },
                  {
                      "scenario": "1",
                      "repairType": "SER",
                      "rank": 2,
                      "notificationType": "NO"
                  },
                  {
                      "scenario": "1",
                      "repairType": "ACC",
                      "rank": 3,
                      "notificationType": "Z5"
                  },
                  {
                      "scenario": "1",
                      "repairType": "SWP",
                      "rank": 4,
                      "notificationType": "Z5"
                  },
                  {
                      "scenario": "4",
                      "repairType": "RMS",
                      "rank": 5,
                      "notificationType": "Z8"
                  }
              ],
              "overrideable": false
          }
      },
      "keyValues": [],
      "version": 2.3
      }
  </code></pre>