痞子磊的博客

一、模型表表结构设计如下:DROP TABLE IF EXISTS t_mode_table;CREATE TABLE t_mode_table( id int8 NOT NULL, db_name VARCHAR(32) NOT NULL, table_name VARCHAR(32) NOT NULL, table_comment VARCHAR(32) NOT NULL, table_ddl VARCHAR(32), subject_id V

#!/bin/bashexport LNAG=zh_CN.UTF-8# 补数逻辑，pg => hdfs# -- --schema <name>connect=$1username=$2password=$3hdfs_path=$4query_condition=$5alias_time=$6tablename=$7queue=$8hdfs_path_tmp=${hdfs_path}_tmpquery_condition="${query_condition}

valotile关键字1、保证可见性2、不保证原子性3、禁止指令重排

DROP TABLE IF EXISTS t_presto_query_event; CREATE TABLE "presto"."t_presto_query_event" ( "id" int8 NOT NULL DEFAULT nextval('t_presto_query_event_id_seq'::regclass), "query_id" varchar(255) COLLATE "pg_catalog"."default" NOT NULL, "transaction..