{
  "uuid": "2874cfc3-0872-4670-ba22-7c5e42fd1d3b",
  "last_modified": 1481697924259,
  "version": "1.6.0",
  "name": "a_clone",
  "model_name": "Google_textad_convtrack_click_5684612545",
  "description": "",
  "null_string": null,
  "dimensions": [
    {
      "name": "CAMPAIGNID",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "CAMPAIGNID",
      "derived": null
    },
    {
      "name": "ADGROUPID",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "ADGROUPID",
      "derived": null
    },
    {
      "name": "SOURCEURLID",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "SOURCEURLID",
      "derived": null
    },
    {
      "name": "DATESTATS",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "DATESTATS",
      "derived": null
    },
    {
      "name": "WEEKGROUP",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "WEEKGROUP",
      "derived": null
    },
    {
      "name": "MONTHGROUP",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "MONTHGROUP",
      "derived": null
    },
    {
      "name": "ADID",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "ADID",
      "derived": null
    },
    {
      "name": "COUNTRYID",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "COUNTRYID",
      "derived": null
    },
    {
      "name": "REGIONID",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "REGIONID",
      "derived": null
    },
    {
      "name": "CITYID",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "CITYID",
      "derived": null
    },
    {
      "name": "ISMOBILEDEVICE",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "ISMOBILEDEVICE",
      "derived": null
    },
    {
      "name": "LANGUAGEID",
      "table": "MTX_GOOGLE_5684612545.TBL_CONVTRACK_TEXTAD_CLICK_SUMMARY_ORC",
      "column": "LANGUAGEID",
      "derived": null
    },
    {
      "name": "TBL_GOOGLE_AD_ORC_DERIVED",
      "table": "MTX_GOOGLE_5684612545.TBL_GOOGLE_AD_ORC",
      "column": null,
      "derived": [
        "ADTYPE",
        "STATUS",
        "HEADLINE",
        "DESCRIPTION1",
        "DESCRIPTION2",
        "DISPLAYURL",
        "DEVICEPREFERENCE",
        "FINALURL",
        "MOBILEFINALURL",
        "APPFINALURL",
        "TRACKINGURLTEMPLATE",
        "URLCUSTOMPARAMETERS"
      ]
    },
    {
      "name": "TBL_GOOGLE_ADGROUP_ORC_DERIVED",
      "table": "MTX_GOOGLE_5684612545.TBL_GOOGLE_ADGROUP_ORC",
      "column": null,
      "derived": [
        "OPTIMIZATION",
        "STATUS",
        "STRATEGYTYPE",
        "NAME"
      ]
    },
    {
      "name": "TBL_GOOGLE_CAMPAIGN_ORC_DERIVED",
      "table": "MTX_GOOGLE_5684612545.TBL_GOOGLE_CAMPAIGN_ORC",
      "column": null,
      "derived": [
        "OPTIMIZATION",
        "NAME",
        "STATUS",
        "STRATEGYTYPE"
      ]
    },
    {
      "name": "TBL_MCM_COUNTRY_ORC_DERIVED",
      "table": "MTX_SYSTEM.TBL_MCM_COUNTRY_ORC",
      "column": null,
      "derived": [
        "COUNTRYNAME",
        "COUNTRYCODE"
      ]
    },
    {
      "name": "TBL_MCM_COUNTRY_REGION_ORC_DERIVED",
      "table": "MTX_SYSTEM.TBL_MCM_COUNTRY_REGION_ORC",
      "column": null,
      "derived": [
        "DISPLAYNAME"
      ]
    },
    {
      "name": "TBL_MCM_COUNTRY_CITY_ORC_DERIVED",
      "table": "MTX_SYSTEM.TBL_MCM_COUNTRY_CITY_ORC",
      "column": null,
      "derived": [
        "DISPLAYNAME"
      ]
    },
    {
      "name": "TBL_MCM_LANGUAGE_ORC_DERIVED",
      "table": "MTX_SYSTEM.TBL_MCM_LANGUAGE_ORC",
      "column": null,
      "derived": [
        "DISPLAYNAME"
      ]
    },
    {
      "name": "TBL_CONVTRACK_SITE_SOURCEURL_ORC_DERIVED",
      "table": "MTX_CONVTRACK_1011.TBL_CONVTRACK_SITE_SOURCEURL_ORC",
      "column": null,
      "derived": [
        "SOURCEURL"
      ]
    }
  ],
  "measures": [
    {
      "name": "_COUNT_",
      "function": {
        "expression": "COUNT",
        "parameter": {
          "type": "constant",
          "value": "1",
          "next_parameter": null
        },
        "returntype": "bigint"
      },
      "dependent_measure_ref": null
    },
    {
      "name": "SUM_CLICK",
      "function": {
        "expression": "SUM",
        "parameter": {
          "type": "column",
          "value": "CLICK",
          "next_parameter": null
        },
        "returntype": "bigint"
      },
      "dependent_measure_ref": null
    },
    {
      "name": "SUM_GOAL",
      "function": {
        "expression": "SUM",
        "parameter": {
          "type": "column",
          "value": "GOAL",
          "next_parameter": null
        },
        "returntype": "bigint"
      },
      "dependent_measure_ref": null
    },
    {
      "name": "SUM_CONVERSION",
      "function": {
        "expression": "SUM",
        "parameter": {
          "type": "column",
          "value": "CONVERSION",
          "next_parameter": null
        },
        "returntype": "bigint"
      },
      "dependent_measure_ref": null
    },
    {
      "name": "SUM_CONVERSIONVALUE",
      "function": {
        "expression": "SUM",
        "parameter": {
          "type": "column",
          "value": "CONVERSIONVALUE",
          "next_parameter": null
        },
        "returntype": "decimal"
      },
      "dependent_measure_ref": null
    },
    {
      "name": "SUM_QUANTITY",
      "function": {
        "expression": "SUM",
        "parameter": {
          "type": "column",
          "value": "QUANTITY",
          "next_parameter": null
        },
        "returntype": "bigint"
      },
      "dependent_measure_ref": null
    }
  ],
  "dictionaries": [],
  "rowkey": {
    "rowkey_columns": [
      {
        "column": "CAMPAIGNID",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "ADGROUPID",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "SOURCEURLID",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "DATESTATS",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "WEEKGROUP",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "MONTHGROUP",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "ADID",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "COUNTRYID",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "REGIONID",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "CITYID",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "ISMOBILEDEVICE",
        "encoding": "dict",
        "isShardBy": false
      },
      {
        "column": "LANGUAGEID",
        "encoding": "dict",
        "isShardBy": false
      }
    ]
  },
  "hbase_mapping": {
    "column_family": [
      {
        "name": "F1",
        "columns": [
          {
            "qualifier": "M",
            "measure_refs": [
              "_COUNT_",
              "SUM_CLICK",
              "SUM_GOAL",
              "SUM_CONVERSION",
              "SUM_CONVERSIONVALUE",
              "SUM_QUANTITY"
            ]
          }
        ]
      }
    ]
  },
  "aggregation_groups": [
    {
      "includes": [
        "CAMPAIGNID",
        "ADGROUPID",
        "SOURCEURLID",
        "DATESTATS",
        "WEEKGROUP",
        "MONTHGROUP",
        "ADID",
        "COUNTRYID",
        "REGIONID",
        "CITYID",
        "ISMOBILEDEVICE",
        "LANGUAGEID"
      ],
      "select_rule": {
        "hierarchy_dims": [],
        "mandatory_dims": [],
        "joint_dims": []
      }
    }
  ],
  "signature": "zO72U6jUKpXq2Bn0v2Co3w==",
  "notify_list": [],
  "status_need_notify": [
    "ERROR",
    "DISCARDED",
    "SUCCEED"
  ],
  "partition_date_start": 0,
  "partition_date_end": 3153600000000,
  "auto_merge_time_ranges": [],
  "retention_range": 0,
  "engine_type": 2,
  "storage_type": 2,
  "override_kylin_properties": {}
}