Schema Info
Schema Name: sfdl_stage_csv.payrixess_mms_monthly_summary
- created: 2024-07-22 13:21:12
- disabled: False
- format: raw
- id: 2183
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_csv", "table": "payrixess_mms_monthly_summary" } - type: csv
Schema Versions: 15
-
Version 906712
- created: 2026-04-17 09:39:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-17/1776436782'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-17/1776436782
- id: 906712
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6415466
- updated: 2026-04-17 09:40:13
-
Version 906496
- created: 2026-04-16 09:47:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-16/1776350867'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-16/1776350867
- id: 906496
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6414941
- updated: 2026-04-16 09:48:03
-
Version 906287
- created: 2026-04-15 09:47:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-15/1776264449'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-15/1776264449
- id: 906287
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6414435
- updated: 2026-04-15 09:48:08
-
Version 906053
- created: 2026-04-14 09:32:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-14/1776177167'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-14/1776177167
- id: 906053
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6413902
- updated: 2026-04-14 09:33:03
-
Version 905838
- created: 2026-04-13 09:31:33
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-13/1776090683'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-13/1776090683
- id: 905838
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6413276
- updated: 2026-04-13 09:31:44
-
Version 905625
- created: 2026-04-12 09:28:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-12/1776004087'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-12/1776004087
- id: 905625
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6412840
- updated: 2026-04-12 09:28:25
-
Version 905443
- created: 2026-04-11 09:43:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-11/1775918617'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-11/1775918617
- id: 905443
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6412556
- updated: 2026-04-11 09:44:10
-
Version 905210
- created: 2026-04-10 09:27:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-10/1775831219'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-10/1775831219
- id: 905210
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6412000
- updated: 2026-04-10 09:27:20
-
Version 905014
- created: 2026-04-09 09:44:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-09/1775745843'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-09/1775745843
- id: 905014
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6411543
- updated: 2026-04-09 09:44:42
-
Version 904803
- created: 2026-04-08 09:43:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-08/1775659377'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-08/1775659377
- id: 904803
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6411095
- updated: 2026-04-08 09:43:37
-
Version 904570
- created: 2026-04-07 09:27:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-07/1775572058'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-07/1775572058
- id: 904570
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6410467
- updated: 2026-04-07 09:27:56
-
Version 904359
- created: 2026-04-06 09:31:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-06/1775485851'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-06/1775485851
- id: 904359
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6410001
- updated: 2026-04-06 09:31:22
-
Version 904174
- created: 2026-04-05 09:45:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-05/1775400353'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-05/1775400353
- id: 904174
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6409622
- updated: 2026-04-05 09:46:11
-
Version 903950
- created: 2026-04-04 09:28:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-04/1775312920'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-04/1775312920
- id: 903950
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6409113
- updated: 2026-04-04 09:29:06
-
Version 903758
- created: 2026-04-03 09:56:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-03/1775228206'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" ] - hive_path: s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-03/1775228206
- id: 903758
- processed: 1
- raw_data:
{ "base": 3, "count": 5, "entity": 2, "month": 1, "sum": 6, "tag": 4, "year": 0 } - schema_attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - schema_name_id: 2183
- schema_scan_id: 6408763
- updated: 2026-04-03 09:57:01
Schema Scans: 15
Last at 2026-04-17 09:39:59
-
Scan 6415466
- duration: 0:00:14.579361
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6415466
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-17/1776436782", "key": "raw/mms_monthly_summary/2026-04-17/1776436782/37b124a5-0ad3-4c6a-b3bf-c6dfae6a8066.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 434374168051036955, "service_name": "drive-thru", "span_id": 9557891163057392781, "trace_id": 3727247518956388992 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-17 09:39:59
- success: True
- trace_id: 3727247518956388992
-
Scan 6414941
- duration: 0:00:11.915148
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414941
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-16/1776350867", "key": "raw/mms_monthly_summary/2026-04-16/1776350867/e5bc2e58-0fda-4c67-8a26-debc80acdcda.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 7766868798863627957, "service_name": "drive-thru", "span_id": 17838756000862033783, "trace_id": 12466993025510383834 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-16 09:47:51
- success: True
- trace_id: 12466993025510383834
-
Scan 6414435
- duration: 0:00:14.473570
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414435
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-15/1776264449", "key": "raw/mms_monthly_summary/2026-04-15/1776264449/876690c9-36a5-4b91-9284-56cade2983c2.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 9803417530377420819, "service_name": "drive-thru", "span_id": 15646935107540270151, "trace_id": 6989744810931841403 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-15 09:47:53
- success: True
- trace_id: 6989744810931841403
-
Scan 6413902
- duration: 0:00:11.860519
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413902
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-14/1776177167", "key": "raw/mms_monthly_summary/2026-04-14/1776177167/2e79ceda-3421-4ac4-a4aa-700637824bf1.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 17326710242812112758, "service_name": "drive-thru", "span_id": 3371028296082349386, "trace_id": 11223796453920025940 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-14 09:32:52
- success: True
- trace_id: 11223796453920025940
-
Scan 6413276
- duration: 0:00:12.009098
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413276
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-13/1776090683", "key": "raw/mms_monthly_summary/2026-04-13/1776090683/84343b1c-f640-4932-b1c4-72d6104eeeba.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 5224841798018187995, "service_name": "drive-thru", "span_id": 14663002398779066313, "trace_id": 5991987038437080658 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-13 09:31:32
- success: True
- trace_id: 5991987038437080658
-
Scan 6412840
- duration: 0:00:14.285610
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412840
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-12/1776004087", "key": "raw/mms_monthly_summary/2026-04-12/1776004087/080f8d6b-7d31-4570-88f5-e02dbbcdef1c.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 4301539021587016066, "service_name": "drive-thru", "span_id": 48071340602968722, "trace_id": 2635117898481217088 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-12 09:28:11
- success: True
- trace_id: 2635117898481217088
-
Scan 6412556
- duration: 0:00:11.799670
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412556
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-11/1775918617", "key": "raw/mms_monthly_summary/2026-04-11/1775918617/338bad9d-be68-43f9-a20b-03eb166ed373.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 3952701962607835403, "service_name": "drive-thru", "span_id": 12203701684220235825, "trace_id": 4938588026160911805 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-11 09:43:58
- success: True
- trace_id: 4938588026160911805
-
Scan 6412000
- duration: 0:00:11.887564
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412000
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-10/1775831219", "key": "raw/mms_monthly_summary/2026-04-10/1775831219/55cfef13-75e9-4ad7-8eec-40a6999027cd.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 8757465901256702966, "service_name": "drive-thru", "span_id": 13798387379587204245, "trace_id": 1646735286288001745 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-10 09:27:08
- success: True
- trace_id: 1646735286288001745
-
Scan 6411543
- duration: 0:00:11.989346
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411543
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-09/1775745843", "key": "raw/mms_monthly_summary/2026-04-09/1775745843/57ef3b8d-7bfa-46ad-9722-52d5ead05d67.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 10520650175459665643, "service_name": "drive-thru", "span_id": 412631702475253567, "trace_id": 14299410939605508695 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-09 09:44:30
- success: True
- trace_id: 14299410939605508695
-
Scan 6411095
- duration: 0:00:29.800365
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411095
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-08/1775659377", "key": "raw/mms_monthly_summary/2026-04-08/1775659377/373be664-448c-425a-993e-8a7a041dd096.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 3932831140804943407, "service_name": "drive-thru", "span_id": 10670892856073427148, "trace_id": 15136597610500009288 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-08 09:43:07
- success: True
- trace_id: 15136597610500009288
-
Scan 6410467
- duration: 0:00:14.343988
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410467
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-07/1775572058", "key": "raw/mms_monthly_summary/2026-04-07/1775572058/0282c43f-725f-460c-b733-b9c0b5f0d9d1.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 5933833264089447420, "service_name": "drive-thru", "span_id": 9782725967916019996, "trace_id": 6202478953346059545 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-07 09:27:42
- success: True
- trace_id: 6202478953346059545
-
Scan 6410001
- duration: 0:00:14.306823
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410001
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-06/1775485851", "key": "raw/mms_monthly_summary/2026-04-06/1775485851/48ac4b71-8562-4d3b-94b8-6cc91c8c7fa2.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 16513489755727968098, "service_name": "drive-thru", "span_id": 5150124105769969246, "trace_id": 4478072683100077963 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-06 09:31:08
- success: True
- trace_id: 4478072683100077963
-
Scan 6409622
- duration: 0:00:14.419382
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409622
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-05/1775400353", "key": "raw/mms_monthly_summary/2026-04-05/1775400353/43a88a98-4668-4aa1-99d7-f648c708fcec.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 2070469444042910125, "service_name": "drive-thru", "span_id": 965807817758158779, "trace_id": 14610729616297384905 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-05 09:45:57
- success: True
- trace_id: 14610729616297384905
-
Scan 6409113
- duration: 0:00:11.712198
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409113
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-04/1775312920", "key": "raw/mms_monthly_summary/2026-04-04/1775312920/e86dca61-e542-4ca5-88b4-486df327e5f7.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 11405402676967602630, "service_name": "drive-thru", "span_id": 8070181956951840750, "trace_id": 13107369708829031979 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-04 09:28:54
- success: True
- trace_id: 13107369708829031979
-
Scan 6408763
- duration: 0:00:11.822829
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408763
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-csv-payrixess-stage", "hive_path": "s3://sfdl-csv-payrixess-stage/raw/mms_monthly_summary/2026-04-03/1775228206", "key": "raw/mms_monthly_summary/2026-04-03/1775228206/f0877ad9-24bf-4108-9db4-cb1c6c05542b.csv.gz" }, "schema": { "name": "sfdl_stage_csv.payrixess_mms_monthly_summary", "type": "csv" }, "trace_context": { "parent_id": 18425920152908624338, "service_name": "drive-thru", "span_id": 9320292954156980698, "trace_id": 7215881947236434151 } } - running: False
- schema_name_id: 2183
- start_time: 2026-04-03 09:56:50
- success: True
- trace_id: 7215881947236434151
- attributes:
{ "base": "string", "count": "string", "entity": "string", "month": "string", "sum": "string", "tag": "string", "year": "string" } - created: 2026-04-17 09:39:59
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-17/1776436782'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2024-07-22 13:21:12",
"disabled": false,
"format": "raw",
"id": 2183,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_csv",
"table": "payrixess_mms_monthly_summary"
},
"type": "csv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"base": "string",
"count": "string",
"entity": "string",
"month": "string",
"sum": "string",
"tag": "string",
"year": "string"
},
"created": "2026-04-17 09:39:59",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_csv.payrixess_mms_monthly_summary`\n(\n `year` string , `month` string , `entity` string , `base` 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-payrixess-stage/raw/mms_monthly_summary/2026-04-17/1776436782'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_csv.payrixess_mms_monthly_summary`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_csv.payrixess_mms_monthly_summary"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}