profile_header.json

{
  "clusterInfo": {
    "identity": {
      "identity": "428241a7-e337-4c09-ad65-9ccfb8f1f4ae",
      "serial": 0,
      "created": 1503947410787,
      "version": {
        "major": 1,
        "minor": 1,
        "patch": 0,
        "buildNumber": 0,
        "qualifier": "201708121825170680-436784e"
      }
    },
    "version": {
      "version": "1.1.0-201708121825170680-436784e"
    },
    "source": [
      {
        "name": "$scratch",
        "type": "UNKNOWN"
      },
      {
        "name": "__accelerator",
        "type": "UNKNOWN"
      },
      {
        "name": "__datasetDownload",
        "type": "UNKNOWN"
      },
      {
        "name": "__home",
        "type": "UNKNOWN"
      },
      {
        "name": "__jobResultsStore",
        "type": "UNKNOWN"
      },
      {
        "name": "__logs",
        "type": "UNKNOWN"
      },
      {
        "name": "__materialization",
        "type": "UNKNOWN"
      },
      {
        "name": "__support",
        "type": "UNKNOWN"
      },
      {
        "name": "elastic-prd",
        "type": "ELASTIC"
      },
      {
        "name": "Live MM",
        "type": "MYSQL"
      },
      {
        "name": "Samples",
        "type": "S3"
      }
    ],
    "node": [
      {
        "name": "10.10.2.185",
        "role": "executor"
      },
      {
        "name": "10.10.2.185",
        "role": "coordinator"
      }
    ],
    "javaVmVersion": "25.144-b01",
    "jreVersion": "1.8",
    "edition": "community"
  },
  "submission": {
    "first": "Allan",
    "last": "Sene",
    "email": "allan.sene@maxmilhas.com.br",
    "date": 1504035908628,
    "submissionId": "4f025af9-3451-408c-a331-e784db7e2b57"
  },
  "job": {
    "state": 2,
    "info": {
      "jobId": {
        "id": "265a3d78-964b-d735-b317-4e0e25fb7c00"
      },
      "sql": "SELECT idsearches, idtransactions \nFROM \"Live MM\".mm.transactions as trans\nINNER JOIN \"elastic-prd\".\"api-search-2017.08\".doc as doc\nON trans.idsearches = CONVERT_TO_INTEGER(doc.\"searchIntention\"['legacyId'], 1, 1, 0)\nWHERE idsearches = 38827627",
      "requestType": 7,
      "user": "allan.sene",
      "startTime": 1504035462809,
      "datasetPath": [
        "tmp",
        "UNTITLED"
      ],
      "datasetVersion": "0007077403846808",
      "parents": [
        {
          "datasetPath": [
            "Live MM",
            "mm",
            "transactions"
          ],
          "type": 2
        },
        {
          "datasetPath": [
            "elastic-prd",
            "api-search-2017.08",
            "doc"
          ],
          "type": 2
        }
      ],
      "queryType": 1,
      "fieldOrigins": [
        {
          "name": "idsearches",
          "origins": [
            {
              "table": [
                "Live MM",
                "mm",
                "transactions"
              ],
              "columnName": "idsearches",
              "derived": false
            }
          ]
        },
        {
          "name": "idtransactions",
          "origins": [
            {
              "table": [
                "Live MM",
                "mm",
                "transactions"
              ],
              "columnName": "idtransactions",
              "derived": false
            }
          ]
        }
      ],
      "joins": [
        {
          "leftTablePath": [
            "Live MM",
            "mm",
            "transactions"
          ],
          "joinType": 1,
          "rightTablePath": [
            "elastic-prd",
            "api-search-2017.08",
            "doc"
          ],
          "conditions": [
            {
              "tableA": [
                "Live MM",
                "mm",
                "transactions"
              ],
              "columnA": "idsearches",
              "tableB": [
                "elastic-prd",
                "api-search-2017.08",
                "doc"
              ],
              "columnB": "searchIntention"
            }
          ],
          "degreesOfSeparation": 0
        }
      ],
      "description": "SELECT idsearches, idtransactions \nFROM \"Live MM\".mm.transactions as trans\nINNER JOIN \"elastic-prd\".\"api-search-2017.08\".doc as doc\nON trans.idsearches = CONVERT_TO_INTEGER(doc.\"searchIntention\"['legacyId'], 1, 1, 0)\nWHERE idsearches = 38827627"
    },
    "stats": {
      "outputBytes": 0,
      "outputRecords": 0
    },
    "details": {
      "timeSpentInPlanning": 110,
      "dataVolume": 0,
      "outputRecords": 0
    },
    "attemptId": "265a3d78-964b-d735-b317-4e0e25fb7c00",
    "endpoint": {
      "address": "10.10.2.185",
      "userPort": 31010,
      "fabricPort": 45678,
      "roles": {
        "sqlQuery": true,
        "javaExecutor": true
      },
      "startTime": 1503948464140
    }
  }
}