Schema Info
Schema Name: sfdl_prod_drivethru.molo_moloslipplacementstatusset
- created: 2023-10-17 02:01:30
- disabled: False
- format: raw
- id: 1775
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "molo_moloslipplacementstatusset" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717737
- created: 2026-04-17 03:08:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-17/1776412851'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-17/1776412851
- id: 1717737
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 162167741
- updated: 2026-04-17 03:09:09
-
Version 1716567
- created: 2026-04-16 03:14:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-16/1776326606'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-16/1776326606
- id: 1716567
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 162112027
- updated: 2026-04-16 03:14:17
-
Version 1715309
- created: 2026-04-15 03:09:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-15/1776240075'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-15/1776240075
- id: 1715309
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 162056096
- updated: 2026-04-15 03:09:42
-
Version 1714142
- created: 2026-04-14 03:10:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-14/1776153840'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-14/1776153840
- id: 1714142
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 162000662
- updated: 2026-04-14 03:11:08
-
Version 1712861
- created: 2026-04-13 03:01:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-13/1776067000'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-13/1776067000
- id: 1712861
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161941985
- updated: 2026-04-13 03:01:17
-
Version 1711651
- created: 2026-04-12 03:02:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-12/1775980710'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-12/1775980710
- id: 1711651
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161892952
- updated: 2026-04-12 03:02:52
-
Version 1710395
- created: 2026-04-11 03:04:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-11/1775894477'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-11/1775894477
- id: 1710395
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161841149
- updated: 2026-04-11 03:04:27
-
Version 1709211
- created: 2026-04-10 03:04:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-10/1775808237'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-10/1775808237
- id: 1709211
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161785893
- updated: 2026-04-10 03:05:04
-
Version 1708115
- created: 2026-04-09 03:02:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-09/1775721569'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-09/1775721569
- id: 1708115
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161730218
- updated: 2026-04-09 03:03:08
-
Version 1707021
- created: 2026-04-08 03:10:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-08/1775635397'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-08/1775635397
- id: 1707021
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161675685
- updated: 2026-04-08 03:10:28
-
Version 1705764
- created: 2026-04-07 02:59:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-07/1775548554'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-07/1775548554
- id: 1705764
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161618597
- updated: 2026-04-07 02:59:33
-
Version 1704607
- created: 2026-04-06 03:10:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-06/1775462514'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-06/1775462514
- id: 1704607
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161561751
- updated: 2026-04-06 03:10:42
-
Version 1703355
- created: 2026-04-05 03:07:21
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-05/1775376139'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-05/1775376139
- id: 1703355
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161514936
- updated: 2026-04-05 03:07:34
-
Version 1702241
- created: 2026-04-04 03:09:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-04/1775289623'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-04/1775289623
- id: 1702241
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161460533
- updated: 2026-04-04 03:09:35
-
Version 1701077
- created: 2026-04-03 03:17:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-03/1775203395'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-03/1775203395
- id: 1701077
- processed: 1
- raw_data:
{ "Id": 0, "Name": 1 } - schema_attributes:
{ "Id": "string", "Name": "string" } - schema_name_id: 1775
- schema_scan_id: 161402075
- updated: 2026-04-03 03:17:21
Schema Scans: 15
Last at 2026-04-17 03:08:55
-
Scan 162167741
- duration: 0:00:14.050444
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162167741
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-17/1776412851", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-17/1776412851/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9013340829126331151, "service_name": "drive-thru", "span_id": 7480905863299772731, "trace_id": 13089622900816075174 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-17 03:08:55
- success: True
- trace_id: 13089622900816075174
-
Scan 162112027
- duration: 0:00:11.630880
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162112027
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-16/1776326606", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-16/1776326606/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 288728037812832000, "service_name": "drive-thru", "span_id": 7722594576639264496, "trace_id": 8789863084865108548 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-16 03:14:06
- success: True
- trace_id: 8789863084865108548
-
Scan 162056096
- duration: 0:00:14.017615
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056096
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-15/1776240075", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-15/1776240075/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12962057178545268096, "service_name": "drive-thru", "span_id": 16103885724180746627, "trace_id": 77776444404727983 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-15 03:09:28
- success: True
- trace_id: 77776444404727983
-
Scan 162000662
- duration: 0:00:13.999465
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162000662
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-14/1776153840", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-14/1776153840/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7037296582773460531, "service_name": "drive-thru", "span_id": 3975559058761297552, "trace_id": 3980903581901434034 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-14 03:10:54
- success: True
- trace_id: 3980903581901434034
-
Scan 161941985
- duration: 0:00:14.014336
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161941985
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-13/1776067000", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-13/1776067000/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18328833522300636046, "service_name": "drive-thru", "span_id": 3719895542263103298, "trace_id": 1479042053063571373 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-13 03:01:03
- success: True
- trace_id: 1479042053063571373
-
Scan 161892952
- duration: 0:00:13.959147
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161892952
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-12/1775980710", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-12/1775980710/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17805843045181487279, "service_name": "drive-thru", "span_id": 5633517275476349852, "trace_id": 18341463100141414652 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-12 03:02:38
- success: True
- trace_id: 18341463100141414652
-
Scan 161841149
- duration: 0:00:11.683736
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161841149
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-11/1775894477", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-11/1775894477/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4750249714321130480, "service_name": "drive-thru", "span_id": 6124404236964658100, "trace_id": 15403817917624947138 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-11 03:04:15
- success: True
- trace_id: 15403817917624947138
-
Scan 161785893
- duration: 0:00:11.469534
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161785893
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-10/1775808237", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-10/1775808237/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13960909593859398387, "service_name": "drive-thru", "span_id": 11708795256898839407, "trace_id": 10156492792885799984 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-10 03:04:53
- success: True
- trace_id: 10156492792885799984
-
Scan 161730218
- duration: 0:00:14.261141
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161730218
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-09/1775721569", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-09/1775721569/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16827334440334678015, "service_name": "drive-thru", "span_id": 12009518599438423663, "trace_id": 18170778574129535898 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-09 03:02:54
- success: True
- trace_id: 18170778574129535898
-
Scan 161675685
- duration: 0:00:14.020796
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161675685
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-08/1775635397", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-08/1775635397/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 568342606624252859, "service_name": "drive-thru", "span_id": 12396111519161117984, "trace_id": 12794681555348383338 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-08 03:10:14
- success: True
- trace_id: 12794681555348383338
-
Scan 161618597
- duration: 0:00:11.465775
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161618597
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-07/1775548554", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-07/1775548554/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14827900529372978910, "service_name": "drive-thru", "span_id": 9466464702337035105, "trace_id": 12206262145338200752 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-07 02:59:22
- success: True
- trace_id: 12206262145338200752
-
Scan 161561751
- duration: 0:00:14.065953
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161561751
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-06/1775462514", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-06/1775462514/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10194739034330315755, "service_name": "drive-thru", "span_id": 6690543446412461487, "trace_id": 2603568475527965832 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-06 03:10:27
- success: True
- trace_id: 2603568475527965832
-
Scan 161514936
- duration: 0:00:14.073032
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161514936
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-05/1775376139", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-05/1775376139/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3939879919468641134, "service_name": "drive-thru", "span_id": 13330814498149384781, "trace_id": 15155838231630560177 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-05 03:07:20
- success: True
- trace_id: 15155838231630560177
-
Scan 161460533
- duration: 0:00:13.997475
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161460533
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-04/1775289623", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-04/1775289623/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17387169286704163126, "service_name": "drive-thru", "span_id": 12560589256978784458, "trace_id": 11383678949042003568 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-04 03:09:21
- success: True
- trace_id: 11383678949042003568
-
Scan 161402075
- duration: 0:00:14.108634
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161402075
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-03/1775203395", "key": "raw/molo_moloSlipPlacementStatusSet/2026-04-03/1775203395/SlipPlacementStatusSet.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.molo_moloSlipPlacementStatusSet", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17550960024484052369, "service_name": "drive-thru", "span_id": 2654837823800788830, "trace_id": 13673504669831804274 } } - running: False
- schema_name_id: 1775
- start_time: 2026-04-03 03:17:07
- success: True
- trace_id: 13673504669831804274
- attributes:
{ "Id": "string", "Name": "string" } - created: 2026-04-17 03:08:56
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-17/1776412851'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-10-17 02:01:30",
"disabled": false,
"format": "raw",
"id": 1775,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "molo_moloslipplacementstatusset"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"Id": "string",
"Name": "string"
},
"created": "2026-04-17 03:08:56",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloslipplacementstatusset`\n(\n `Id` string , `Name` 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-drivethrucsv-drivethru-prod/raw/molo_moloSlipPlacementStatusSet/2026-04-17/1776412851'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloslipplacementstatusset`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloslipplacementstatusset"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}