Schema Info

Schema Name: sfdl_dev_rds.sparefoot_content

created: 2022-03-03 12:01:32
disabled: False
format: raw
id: 1724
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_dev_rds",
    "table": "sparefoot_content"
}

type: rds

Schema Versions: 5

Version 4689031

created: 2022-03-16 16:32:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_content`\n(\n`title`varchar(256),`meta_description`string,`meta_keywords`varchar(528),`head_title`varchar(256),`hireahelper_anchor`varchar(64),`publish`tinyint,`body`string,`content_template_id`int,`subtitle`varchar(256),`content_id`int,`location_id`int,`uri`varchar(64),`hireahelper_url`varchar(64)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/content/2022-03-16/1647466287'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/content/2022-03-16/1647466287
id: 4689031
processed: 1

raw_data:

{ "body": "

SpareFoot helps you find great deals on Midland self storage.

\n\nCompare Midland self storage in Texas. SpareFoot makes it easy to compare Midland storage facilities, prices, and reserve Midland self storage units on the spot. Find the best deals on the type of Midland storage you need, including boat storage, RV storage or car storage in Midland, Texas. Texas students and other young adults often need affordable self storage for the summer. With SpareFoot, Texas students and young professionals can search for exactly which type of Midland self storage they need within their specified budget. Now Texas students don't have to waste their time searching through all the Midland storage options to find what they need. Go Texas!

\n\n

Finding Midland self storage near you.

\n\nFind affordable Midland storage in your area. Compare Midland self storage facilities and save up to 50% with SpareFoot exclusive rates! SpareFoot has the best prices on Midland self storage. Guaranteed.\n", "content_id": 1033, "content_template_id": 1, "head_title": "Midland Storage - Compare Self Storage Prices! SpareFoot.com", "hireahelper_anchor": null, "hireahelper_url": null, "location_id": 32152, "meta_description": "Midland self storage units: Low-priced and affordable. Compare Midland storage units, size, location and price. Get great storage deals today", "meta_keywords": "self storage units, Midland self storage, TX storage", "publish": 1, "subtitle": "Get real time prices on storage units. Search over 4,000 self storage facilities to save time and money. Compare rates of Midland storage units and reserve online today!", "title": "Compare Midland Self Storage Facilities and Save up to 50%!", "uri": "Midland-TX-self-storage" }

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "tinyint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1724
schema_scan_id: 5904793
updated: 2022-03-16 16:32:13

Version 4688965

created: 2022-03-15 20:58:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_content`\n(\n`title`varchar(256),`meta_description`string,`meta_keywords`varchar(528),`hireahelper_url`varchar(64),`head_title`varchar(256),`hireahelper_anchor`varchar(64),`body`string,`content_template_id`int,`subtitle`varchar(256),`content_id`int,`location_id`int,`uri`varchar(64),`publish`tinyint\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/content/2022-03-15/1647395869'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/content/2022-03-15/1647395869
id: 4688965
processed: 1

raw_data:

{ "body": "

SpareFoot helps you find great deals on Midland self storage.

\n\n

Finding Midland self storage near you.

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "tinyint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1724
schema_scan_id: 5904350
updated: 2022-03-15 20:58:12

Version 4688847

created: 2022-03-14 16:16:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_content`\n(\n`title`varchar(256),`meta_description`string,`meta_keywords`varchar(528),`head_title`varchar(256),`hireahelper_anchor`varchar(64),`publish`tinyint,`body`string,`content_template_id`int,`subtitle`varchar(256),`content_id`int,`location_id`int,`uri`varchar(64),`hireahelper_url`varchar(64)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/content/2022-03-14/1647292540'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/content/2022-03-14/1647292540
id: 4688847
processed: 1

raw_data:

{ "body": "

SpareFoot helps you find great deals on Midland self storage.

\n\n

Finding Midland self storage near you.

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "tinyint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1724
schema_scan_id: 5903997
updated: 2022-03-14 16:16:15

Version 4688844

created: 2022-03-14 13:09:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_content`\n(\n`title`varchar(256),`meta_description`string,`meta_keywords`varchar(528),`hireahelper_url`varchar(64),`head_title`varchar(256),`hireahelper_anchor`varchar(64),`publish`tinyint,`body`string,`subtitle`varchar(256),`content_id`int,`location_id`int,`uri`varchar(64),`content_template_id`int\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/content/2022-03-14/1647281320'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/content/2022-03-14/1647281320
id: 4688844
processed: 1

raw_data:

{ "body": "

SpareFoot helps you find great deals on Midland self storage.

\n\n

Finding Midland self storage near you.

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "tinyint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1724
schema_scan_id: 5903946
updated: 2022-03-14 13:09:14

Version 4688842

created: 2022-03-14 12:34:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_content`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_content`\n(\n`content_id`int,`content_template_id`int,`uri`varchar(64),`head_title`varchar(256),`meta_description`string,`meta_keywords`varchar(528),`title`varchar(256),`subtitle`varchar(256),`body`string,`publish`tinyint,`location_id`int,`hireahelper_url`varchar(64),`hireahelper_anchor`varchar(64)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/content/2022-03-14/1647279226'\n",
    "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_content"
]

hive_path: s3://sfdl-rds-sparefoot-dev/raw/content/2022-03-14/1647279226
id: 4688842
processed: 1

raw_data:

{ "body": "

SpareFoot helps you find great deals on Midland self storage.

\n\n

Finding Midland self storage near you.

schema_attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "tinyint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

schema_name_id: 1724
schema_scan_id: 5903944
updated: 2022-03-14 12:34:24

Schema Scans: 5

Last at 2022-03-16 16:32:01

Scan 5904793

duration: 0:00:14.821990

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5904793

payload:

{
    "datatype_dict": {
        "body": "string",
        "content_id": "int",
        "content_template_id": "int",
        "head_title": "varchar(256)",
        "hireahelper_anchor": "varchar(64)",
        "hireahelper_url": "varchar(64)",
        "location_id": "int",
        "meta_description": "string",
        "meta_keywords": "varchar(528)",
        "publish": "tinyint",
        "subtitle": "varchar(256)",
        "title": "varchar(256)",
        "uri": "varchar(64)"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/content/2022-03-16/1647466287",
        "key": "raw/content/2022-03-16/1647466287/content-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 3341771534232836598,
        "service_name": "sparefoot",
        "span_id": 6052548528560655042,
        "trace_id": 3341771534232836598
    }
}

running: False
schema_name_id: 1724
start_time: 2022-03-16 16:32:01
success: True
trace_id: 3341771534232836598

Scan 5904350

duration: 0:00:14.871989

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5904350

payload:

{
    "datatype_dict": {
        "body": "string",
        "content_id": "int",
        "content_template_id": "int",
        "head_title": "varchar(256)",
        "hireahelper_anchor": "varchar(64)",
        "hireahelper_url": "varchar(64)",
        "location_id": "int",
        "meta_description": "string",
        "meta_keywords": "varchar(528)",
        "publish": "tinyint",
        "subtitle": "varchar(256)",
        "title": "varchar(256)",
        "uri": "varchar(64)"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/content/2022-03-15/1647395869",
        "key": "raw/content/2022-03-15/1647395869/data-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 15924188667557762582,
        "service_name": "sparefoot",
        "span_id": 6068821642803423597,
        "trace_id": 15924188667557762582
    }
}

running: False
schema_name_id: 1724
start_time: 2022-03-15 20:58:00
success: True
trace_id: 15924188667557762582

Scan 5903997

duration: 0:00:14.794708

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5903997

payload:

{
    "datatype_dict": {
        "body": "string",
        "content_id": "int",
        "content_template_id": "int",
        "head_title": "varchar(256)",
        "hireahelper_anchor": "varchar(64)",
        "hireahelper_url": "varchar(64)",
        "location_id": "int",
        "meta_description": "string",
        "meta_keywords": "varchar(528)",
        "publish": "tinyint",
        "subtitle": "varchar(256)",
        "title": "varchar(256)",
        "uri": "varchar(64)"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/content/2022-03-14/1647292540",
        "key": "raw/content/2022-03-14/1647292540/data-8.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 1106595424451902693,
        "service_name": "sparefoot",
        "span_id": 8199517365558052787,
        "trace_id": 1106595424451902693
    }
}

running: False
schema_name_id: 1724
start_time: 2022-03-14 16:16:03
success: True
trace_id: 1106595424451902693

Scan 5903946

duration: 0:00:14.716667

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5903946

payload:

{
    "datatype_dict": {
        "body": "string",
        "content_id": "int",
        "content_template_id": "int",
        "head_title": "varchar(256)",
        "hireahelper_anchor": "varchar(64)",
        "hireahelper_url": "varchar(64)",
        "location_id": "int",
        "meta_description": "string",
        "meta_keywords": "varchar(528)",
        "publish": "tinyint",
        "subtitle": "varchar(256)",
        "title": "varchar(256)",
        "uri": "varchar(64)"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/content/2022-03-14/1647281320",
        "key": "raw/content/2022-03-14/1647281320/content.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 10893433616116867284,
        "service_name": "sparefoot",
        "span_id": 3749119353088971401,
        "trace_id": 10893433616116867284
    }
}

running: False
schema_name_id: 1724
start_time: 2022-03-14 13:09:02
success: True
trace_id: 10893433616116867284

Scan 5903944

duration: 0:00:15.122523

exit_message:

{
    "ddl_changed": true,
    "ingested_partitions": 0,
    "partitions_applied": false,
    "success": true
}

id: 5903944

payload:

{
    "datatype_dict": {
        "body": "string",
        "content_id": "int",
        "content_template_id": "int",
        "head_title": "varchar(256)",
        "hireahelper_anchor": "varchar(64)",
        "hireahelper_url": "varchar(64)",
        "location_id": "int",
        "meta_description": "string",
        "meta_keywords": "varchar(528)",
        "publish": "tinyint",
        "subtitle": "varchar(256)",
        "title": "varchar(256)",
        "uri": "varchar(64)"
    },
    "file_format": "json",
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-rds-sparefoot-dev",
        "hive_path": "s3://sfdl-rds-sparefoot-dev/raw/content/2022-03-14/1647279226",
        "key": "raw/content/2022-03-14/1647279226/content.json.gz"
    },
    "schema": {
        "name": "sfdl_dev_rds.sparefoot_content",
        "type": "rds"
    },
    "trace_context": {
        "parent_id": 198985759873225387,
        "service_name": "sparefoot",
        "span_id": 17083406101514865601,
        "trace_id": 198985759873225387
    }
}

running: False
schema_name_id: 1724
start_time: 2022-03-14 12:34:11
success: True
trace_id: 198985759873225387

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "body": "string",
    "content_id": "int",
    "content_template_id": "int",
    "head_title": "string",
    "hireahelper_anchor": "string",
    "hireahelper_url": "string",
    "location_id": "int",
    "meta_description": "string",
    "meta_keywords": "string",
    "publish": "tinyint",
    "subtitle": "string",
    "title": "string",
    "uri": "string"
}

created: 2022-03-16 16:32:02

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_content`\n(\n`title`varchar(256),`meta_description`string,`meta_keywords`varchar(528),`head_title`varchar(256),`hireahelper_anchor`varchar(64),`publish`tinyint,`body`string,`content_template_id`int,`subtitle`varchar(256),`content_id`int,`location_id`int,`uri`varchar(64),`hireahelper_url`varchar(64)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/content/2022-03-16/1647466287'\n",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_content`",
    "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_content"
}

Server:

hostname: schemamanager-5447774fc6-4w58v
name: schema_manager
process_start: 2026-04-02 21:43:44
sf_env: dev
version: 2427328685

Raw:

{
    "name": {
        "created": "2022-03-03 12:01:32",
        "disabled": false,
        "format": "raw",
        "id": 1724,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_dev_rds",
            "table": "sparefoot_content"
        },
        "type": "rds"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "body": "string",
            "content_id": "int",
            "content_template_id": "int",
            "head_title": "string",
            "hireahelper_anchor": "string",
            "hireahelper_url": "string",
            "location_id": "int",
            "meta_description": "string",
            "meta_keywords": "string",
            "publish": "tinyint",
            "subtitle": "string",
            "title": "string",
            "uri": "string"
        },
        "created": "2022-03-16 16:32:02",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_rds`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_rds.sparefoot_content`\n(\n`title`varchar(256),`meta_description`string,`meta_keywords`varchar(528),`head_title`varchar(256),`hireahelper_anchor`varchar(64),`publish`tinyint,`body`string,`content_template_id`int,`subtitle`varchar(256),`content_id`int,`location_id`int,`uri`varchar(64),`hireahelper_url`varchar(64)\n)\nROW FORMAT SERDE\n'org.openx.data.jsonserde.JsonSerDe'\n \nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-rds-sparefoot-dev/raw/content/2022-03-16/1647466287'\n",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_rds.sparefoot_content`",
            "repair_table": "MSCK REPAIR TABLE sfdl_dev_rds.sparefoot_content"
        }
    },
    "server": {
        "hostname": "schemamanager-5447774fc6-4w58v",
        "name": "schema_manager",
        "process_start": "2026-04-02 21:43:44",
        "sf_env": "dev",
        "version": "2427328685"
    }
}