Schema Info
Schema Name: sfdl_dev_postgres.schemamanager_schema_types
- created: 2021-08-09 16:21:34
- disabled: False
- format: raw
- id: 1665
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_dev_postgres", "table": "schemamanager_schema_types" } - type: postgres
Schema Versions: 15
-
Version 4773375
- created: 2026-04-17 12:01:41
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-17/1776445252'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-17/1776445252
- id: 4773375
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6867838
- updated: 2026-04-17 12:01:54
-
Version 4773314
- created: 2026-04-16 12:01:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-16/1776358862'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-16/1776358862
- id: 4773314
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6867574
- updated: 2026-04-16 12:01:47
-
Version 4773250
- created: 2026-04-15 12:00:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-15/1776272438'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-15/1776272438
- id: 4773250
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6867310
- updated: 2026-04-15 12:01:09
-
Version 4773192
- created: 2026-04-14 12:20:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-14/1776187165'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-14/1776187165
- id: 4773192
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6867049
- updated: 2026-04-14 12:20:19
-
Version 4773129
- created: 2026-04-13 12:01:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-13/1776099671'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-13/1776099671
- id: 4773129
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6866781
- updated: 2026-04-13 12:01:50
-
Version 4773075
- created: 2026-04-12 12:01:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-12/1776013234'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-12/1776013234
- id: 4773075
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6866517
- updated: 2026-04-12 12:01:22
-
Version 4773025
- created: 2026-04-11 12:01:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-11/1775926834'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-11/1775926834
- id: 4773025
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6866344
- updated: 2026-04-11 12:01:20
-
Version 4772969
- created: 2026-04-10 12:16:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-10/1775841367'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-10/1775841367
- id: 4772969
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6866121
- updated: 2026-04-10 12:16:39
-
Version 4772908
- created: 2026-04-09 12:03:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-09/1775754169'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-09/1775754169
- id: 4772908
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6865848
- updated: 2026-04-09 12:03:20
-
Version 4772849
- created: 2026-04-08 12:01:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-08/1775667635'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-08/1775667635
- id: 4772849
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6865583
- updated: 2026-04-08 12:01:50
-
Version 4772788
- created: 2026-04-07 12:01:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-07/1775581237'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-07/1775581237
- id: 4772788
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6865313
- updated: 2026-04-07 12:01:31
-
Version 4772725
- created: 2026-04-06 12:00:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-06/1775494834'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-06/1775494834
- id: 4772725
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6865033
- updated: 2026-04-06 12:00:57
-
Version 4772670
- created: 2026-04-05 12:00:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-05/1775408434'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-05/1775408434
- id: 4772670
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6864768
- updated: 2026-04-05 12:00:57
-
Version 4772622
- created: 2026-04-04 12:01:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-04/1775322036'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-04/1775322036
- id: 4772622
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6864596
- updated: 2026-04-04 12:01:18
-
Version 4772569
- created: 2026-04-03 12:01:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-03/1775235635'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-03/1775235635
- id: 4772569
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - schema_name_id: 1665
- schema_scan_id: 6864380
- updated: 2026-04-03 12:01:38
Schema Scans: 15
Last at 2026-04-17 12:01:40
-
Scan 6867838
- duration: 0:00:14.373730
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6867838
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-17/1776445252", "key": "raw/schema_types/2026-04-17/1776445252/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 12091345202452998283, "service_name": "schema_manager", "span_id": 6749849420676263171, "trace_id": 12091345202452998283 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-17 12:01:40
- success: True
- trace_id: 12091345202452998283
-
Scan 6867574
- duration: 0:00:11.782284
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6867574
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-16/1776358862", "key": "raw/schema_types/2026-04-16/1776358862/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 2373545210472273961, "service_name": "schema_manager", "span_id": 10898160077131268499, "trace_id": 2373545210472273961 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-16 12:01:35
- success: True
- trace_id: 2373545210472273961
-
Scan 6867310
- duration: 0:00:11.724389
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6867310
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-15/1776272438", "key": "raw/schema_types/2026-04-15/1776272438/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 11700117071174953174, "service_name": "schema_manager", "span_id": 3926358170540097641, "trace_id": 11700117071174953174 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-15 12:00:57
- success: True
- trace_id: 11700117071174953174
-
Scan 6867049
- duration: 0:00:11.838290
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6867049
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-14/1776187165", "key": "raw/schema_types/2026-04-14/1776187165/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 15144930923322970386, "service_name": "schema_manager", "span_id": 2325656865775135602, "trace_id": 15144930923322970386 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-14 12:20:07
- success: True
- trace_id: 15144930923322970386
-
Scan 6866781
- duration: 0:00:14.251306
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866781
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-13/1776099671", "key": "raw/schema_types/2026-04-13/1776099671/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 15818913767894628668, "service_name": "schema_manager", "span_id": 2959109861687556977, "trace_id": 15818913767894628668 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-13 12:01:35
- success: True
- trace_id: 15818913767894628668
-
Scan 6866517
- duration: 0:00:14.459866
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866517
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-12/1776013234", "key": "raw/schema_types/2026-04-12/1776013234/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 9458111343416440743, "service_name": "schema_manager", "span_id": 12124732872982967031, "trace_id": 9458111343416440743 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-12 12:01:08
- success: True
- trace_id: 9458111343416440743
-
Scan 6866344
- duration: 0:00:14.202322
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866344
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-11/1775926834", "key": "raw/schema_types/2026-04-11/1775926834/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 18264190328098957794, "service_name": "schema_manager", "span_id": 18298478320946909404, "trace_id": 18264190328098957794 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-11 12:01:06
- success: True
- trace_id: 18264190328098957794
-
Scan 6866121
- duration: 0:00:11.756431
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6866121
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-10/1775841367", "key": "raw/schema_types/2026-04-10/1775841367/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 18053000150245836597, "service_name": "schema_manager", "span_id": 7868048011553431746, "trace_id": 18053000150245836597 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-10 12:16:27
- success: True
- trace_id: 18053000150245836597
-
Scan 6865848
- duration: 0:00:11.990284
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865848
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-09/1775754169", "key": "raw/schema_types/2026-04-09/1775754169/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 9911846173852556080, "service_name": "schema_manager", "span_id": 1744126606437950867, "trace_id": 9911846173852556080 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-09 12:03:08
- success: True
- trace_id: 9911846173852556080
-
Scan 6865583
- duration: 0:00:14.324450
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865583
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-08/1775667635", "key": "raw/schema_types/2026-04-08/1775667635/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 17170784106573512578, "service_name": "schema_manager", "span_id": 2851679010853126383, "trace_id": 17170784106573512578 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-08 12:01:36
- success: True
- trace_id: 17170784106573512578
-
Scan 6865313
- duration: 0:00:11.637804
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865313
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-07/1775581237", "key": "raw/schema_types/2026-04-07/1775581237/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 16356887795322446339, "service_name": "schema_manager", "span_id": 9838744080911369311, "trace_id": 16356887795322446339 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-07 12:01:20
- success: True
- trace_id: 16356887795322446339
-
Scan 6865033
- duration: 0:00:14.275740
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6865033
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-06/1775494834", "key": "raw/schema_types/2026-04-06/1775494834/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 3589328002692085151, "service_name": "schema_manager", "span_id": 7424193032761195160, "trace_id": 3589328002692085151 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-06 12:00:43
- success: True
- trace_id: 3589328002692085151
-
Scan 6864768
- duration: 0:00:11.746270
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864768
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-05/1775408434", "key": "raw/schema_types/2026-04-05/1775408434/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 12981450583412091710, "service_name": "schema_manager", "span_id": 12519923081218569380, "trace_id": 12981450583412091710 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-05 12:00:45
- success: True
- trace_id: 12981450583412091710
-
Scan 6864596
- duration: 0:00:11.740614
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864596
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-04/1775322036", "key": "raw/schema_types/2026-04-04/1775322036/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 7739569654306770795, "service_name": "schema_manager", "span_id": 9461566747077449799, "trace_id": 7739569654306770795 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-04 12:01:06
- success: True
- trace_id: 7739569654306770795
-
Scan 6864380
- duration: 0:00:11.682482
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6864380
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-dev", "hive_path": "s3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-03/1775235635", "key": "raw/schema_types/2026-04-03/1775235635/data_0.csv.gz" }, "schema": { "name": "sfdl_dev_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 12624644270852183365, "service_name": "schema_manager", "span_id": 16901305824716683981, "trace_id": 12624644270852183365 } } - running: False
- schema_name_id: 1665
- start_time: 2026-04-03 12:01:26
- success: True
- trace_id: 12624644270852183365
- attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "id_type_created_perform_parquet_extra": "string", "perform_parquet": "string", "type": "string" } - created: 2026-04-17 12:01:41
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-17/1776445252'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2021-08-09 16:21:34",
"disabled": false,
"format": "raw",
"id": 1665,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_dev_postgres",
"table": "schemamanager_schema_types"
},
"type": "postgres"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"created": "timestamp",
"extra": "string",
"id": "int",
"id_type_created_perform_parquet_extra": "string",
"perform_parquet": "string",
"type": "string"
},
"created": "2026-04-17 12:01:41",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_postgres`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-dev/raw/schema_types/2026-04-17/1776445252'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_postgres.schemamanager_schema_types`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_postgres.schemamanager_schema_types"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}