Schema Info

Schema Name: sfdl_stage_csv.payrix_mms_fee_summary

created: 2024-07-08 15:32:29
disabled: False
format: raw
id: 2117
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_stage_csv",
    "table": "payrix_mms_fee_summary"
}

type: csv

Schema Versions: 15

Version 906711

created: 2026-04-17 09:39:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-17/1776436788'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-17/1776436788
id: 906711
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6415465
updated: 2026-04-17 09:40:12

Version 906476

created: 2026-04-16 09:32:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-16/1776349926'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-16/1776349926
id: 906476
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6414858
updated: 2026-04-16 09:32:30

Version 906271

created: 2026-04-15 09:33:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-15/1776263580'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-15/1776263580
id: 906271
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6414416
updated: 2026-04-15 09:33:15

Version 906068

created: 2026-04-14 09:42:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-14/1776177731'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-14/1776177731
id: 906068
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6413937
updated: 2026-04-14 09:42:30

Version 905828

created: 2026-04-13 09:27:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-13/1776090439'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-13/1776090439
id: 905828
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6413251
updated: 2026-04-13 09:27:58

Version 905652

created: 2026-04-12 09:45:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-12/1776005146'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-12/1776005146
id: 905652
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6412957
updated: 2026-04-12 09:46:02

Version 905436

created: 2026-04-11 09:32:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-11/1775917966'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-11/1775917966
id: 905436
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6412542
updated: 2026-04-11 09:33:03

Version 905226

created: 2026-04-10 09:41:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-10/1775832070'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-10/1775832070
id: 905226
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6412089
updated: 2026-04-10 09:41:26

Version 904996

created: 2026-04-09 09:26:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-09/1775744775'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-09/1775744775
id: 904996
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6411466
updated: 2026-04-09 09:26:41

Version 904809

created: 2026-04-08 09:44:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-08/1775659412'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-08/1775659412
id: 904809
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6411101
updated: 2026-04-08 09:44:37

Version 904578

created: 2026-04-07 09:38:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-07/1775572704'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-07/1775572704
id: 904578
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6410524
updated: 2026-04-07 09:38:51

Version 904374

created: 2026-04-06 09:35:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-06/1775486136'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-06/1775486136
id: 904374
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6410042
updated: 2026-04-06 09:35:56

Version 904177

created: 2026-04-05 09:51:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-05/1775400645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-05/1775400645
id: 904177
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6409625
updated: 2026-04-05 09:51:20

Version 903957

created: 2026-04-04 09:33:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-04/1775313182'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-04/1775313182
id: 903957
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6409139
updated: 2026-04-04 09:33:18

Version 903764

created: 2026-04-03 10:04:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-03/1775228644'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
]

hive_path: s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-03/1775228644
id: 903764
processed: 1

raw_data:

{
    "count": 4,
    "entity": 2,
    "month": 1,
    "sum": 5,
    "tag": 3,
    "year": 0
}

schema_attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

schema_name_id: 2117
schema_scan_id: 6408791
updated: 2026-04-03 10:04:21

Schema Scans: 15

Last at 2026-04-17 09:39:58

Scan 6415465

duration: 0:00:14.399777

exit_message:

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

id: 6415465

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-17/1776436788",
        "key": "raw/mms_fee_summary/2026-04-17/1776436788/59a317d4-9d87-48c8-b427-67f0863710da.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2473840875081232169,
        "service_name": "drive-thru",
        "span_id": 14306548258299347831,
        "trace_id": 15081406585277634800
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-17 09:39:58
success: True
trace_id: 15081406585277634800

Scan 6414858

duration: 0:00:11.972614

exit_message:

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

id: 6414858

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-16/1776349926",
        "key": "raw/mms_fee_summary/2026-04-16/1776349926/18fb9919-2c96-476e-b55a-b6f7f4cfb93e.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 13321313672779469751,
        "service_name": "drive-thru",
        "span_id": 3976418170696953775,
        "trace_id": 7128878968757264215
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-16 09:32:18
success: True
trace_id: 7128878968757264215

Scan 6414416

duration: 0:00:11.915695

exit_message:

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

id: 6414416

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-15/1776263580",
        "key": "raw/mms_fee_summary/2026-04-15/1776263580/af40d97e-ff8f-4cce-a4be-faeb7ce21dd3.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6102454739187821625,
        "service_name": "drive-thru",
        "span_id": 4307872084745875627,
        "trace_id": 2778287252781183530
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-15 09:33:04
success: True
trace_id: 2778287252781183530

Scan 6413937

duration: 0:00:14.450594

exit_message:

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

id: 6413937

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-14/1776177731",
        "key": "raw/mms_fee_summary/2026-04-14/1776177731/02724962-078c-4758-98c3-67e577f8bc8d.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 12586008796065207846,
        "service_name": "drive-thru",
        "span_id": 8279319683158137792,
        "trace_id": 3494185484133596823
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-14 09:42:16
success: True
trace_id: 3494185484133596823

Scan 6413251

duration: 0:00:14.486182

exit_message:

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

id: 6413251

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-13/1776090439",
        "key": "raw/mms_fee_summary/2026-04-13/1776090439/4eaf8547-0663-4ab3-a5f0-0f751cb2b792.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15424019295440742117,
        "service_name": "drive-thru",
        "span_id": 2481027899918518962,
        "trace_id": 606713877461271049
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-13 09:27:43
success: True
trace_id: 606713877461271049

Scan 6412957

duration: 0:00:11.785598

exit_message:

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

id: 6412957

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-12/1776005146",
        "key": "raw/mms_fee_summary/2026-04-12/1776005146/3b258a14-7100-476a-80c6-b53e26efe0c1.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 14938800937821405289,
        "service_name": "drive-thru",
        "span_id": 5747224506837246150,
        "trace_id": 8572724811644305253
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-12 09:45:50
success: True
trace_id: 8572724811644305253

Scan 6412542

duration: 0:00:14.383338

exit_message:

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

id: 6412542

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-11/1775917966",
        "key": "raw/mms_fee_summary/2026-04-11/1775917966/4016e826-a577-4d5a-847c-ecf9a63fdff1.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6427697144431122714,
        "service_name": "drive-thru",
        "span_id": 2794120215793940661,
        "trace_id": 12039046378884323376
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-11 09:32:49
success: True
trace_id: 12039046378884323376

Scan 6412089

duration: 0:00:12.113886

exit_message:

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

id: 6412089

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-10/1775832070",
        "key": "raw/mms_fee_summary/2026-04-10/1775832070/d62569ec-a39b-4784-8910-7c5d8fd57c5c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17180255652978949395,
        "service_name": "drive-thru",
        "span_id": 4859196758152410957,
        "trace_id": 16877720765516833523
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-10 09:41:14
success: True
trace_id: 16877720765516833523

Scan 6411466

duration: 0:00:14.491344

exit_message:

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

id: 6411466

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-09/1775744775",
        "key": "raw/mms_fee_summary/2026-04-09/1775744775/e06bb7d1-dae3-48f2-85b9-185f8b9cbb9c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 6903153616621154014,
        "service_name": "drive-thru",
        "span_id": 16931331082267493433,
        "trace_id": 10279448737816048146
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-09 09:26:27
success: True
trace_id: 10279448737816048146

Scan 6411101

duration: 0:00:11.916179

exit_message:

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

id: 6411101

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-08/1775659412",
        "key": "raw/mms_fee_summary/2026-04-08/1775659412/cdf9f17f-bb77-4a62-aaf1-3394cbe46d61.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 15518369277299175157,
        "service_name": "drive-thru",
        "span_id": 8034638417362613761,
        "trace_id": 13443104588130016391
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-08 09:44:25
success: True
trace_id: 13443104588130016391

Scan 6410524

duration: 0:00:14.427846

exit_message:

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

id: 6410524

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-07/1775572704",
        "key": "raw/mms_fee_summary/2026-04-07/1775572704/0af372bc-abdd-4c35-892e-dea2356fd762.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 7079397949177415987,
        "service_name": "drive-thru",
        "span_id": 17474147709769421407,
        "trace_id": 18265021124259208129
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-07 09:38:36
success: True
trace_id: 18265021124259208129

Scan 6410042

duration: 0:00:11.924457

exit_message:

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

id: 6410042

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-06/1775486136",
        "key": "raw/mms_fee_summary/2026-04-06/1775486136/f6d2a9d1-f9a2-42f2-9a57-9b3613cdcd08.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 17357720804559663735,
        "service_name": "drive-thru",
        "span_id": 1549158593679414508,
        "trace_id": 11847658580077821061
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-06 09:35:44
success: True
trace_id: 11847658580077821061

Scan 6409625

duration: 0:00:11.784087

exit_message:

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

id: 6409625

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-05/1775400645",
        "key": "raw/mms_fee_summary/2026-04-05/1775400645/f7bcceac-60ac-4f2c-9ba3-c973f9f05ed0.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 16982045905756094467,
        "service_name": "drive-thru",
        "span_id": 11727749355564670036,
        "trace_id": 1367223971064968947
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-05 09:51:08
success: True
trace_id: 1367223971064968947

Scan 6409139

duration: 0:00:11.762585

exit_message:

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

id: 6409139

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-04/1775313182",
        "key": "raw/mms_fee_summary/2026-04-04/1775313182/75f0feaa-2f16-4fa1-ac10-095044c0276c.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 8786477799475766135,
        "service_name": "drive-thru",
        "span_id": 3705196189662715287,
        "trace_id": 5777298043241666498
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-04 09:33:06
success: True
trace_id: 5777298043241666498

Scan 6408791

duration: 0:00:11.881134

exit_message:

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

id: 6408791

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-csv-payrix-stage",
        "hive_path": "s3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-03/1775228644",
        "key": "raw/mms_fee_summary/2026-04-03/1775228644/5fb9a2fb-b3be-4d59-8c85-114e5eeb7a7a.csv.gz"
    },
    "schema": {
        "name": "sfdl_stage_csv.payrix_mms_fee_summary",
        "type": "csv"
    },
    "trace_context": {
        "parent_id": 2237266531822443528,
        "service_name": "drive-thru",
        "span_id": 5305798497833760485,
        "trace_id": 206308853674989080
    }
}

running: False
schema_name_id: 2117
start_time: 2026-04-03 10:04:09
success: True
trace_id: 206308853674989080

Partitions:

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

Schema:

attributes:

{
    "count": "string",
    "entity": "string",
    "month": "string",
    "sum": "string",
    "tag": "string",
    "year": "string"
}

created: 2026-04-17 09:39:58

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-17/1776436788'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
    "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
}

Server:

hostname: schemamanager-5c55c886bf-h2ts4
name: schema_manager
process_start: 2025-10-21 13:03:27
sf_env: stage
version: 2112174301

Raw:

{
    "name": {
        "created": "2024-07-08 15:32:29",
        "disabled": false,
        "format": "raw",
        "id": 2117,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_stage_csv",
            "table": "payrix_mms_fee_summary"
        },
        "type": "csv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "count": "string",
            "entity": "string",
            "month": "string",
            "sum": "string",
            "tag": "string",
            "year": "string"
        },
        "created": "2026-04-17 09:39:58",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrix_mms_fee_summary`\n(\n `year`  string , `month`  string , `entity`  string , `tag`  string , `count`  string , `sum`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-csv-payrix-stage/raw/mms_fee_summary/2026-04-17/1776436788'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrix_mms_fee_summary`",
            "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrix_mms_fee_summary"
        }
    },
    "server": {
        "hostname": "schemamanager-5c55c886bf-h2ts4",
        "name": "schema_manager",
        "process_start": "2025-10-21 13:03:27",
        "sf_env": "stage",
        "version": "2112174301"
    }
}