44 h             g  3 3 3 3 3 g : : : : : g g g      ()VCodeLineNumberTableLocalVariableTablethis'Lcom/artfess/dataShare/util/DorisUtils;getOdsTableSqlH(Ljava/lang/String;Ljava/lang/String;Ljava/util/List;)Ljava/lang/String;field:Lcom/artfess/dataShare/dataResource/ods/model/BizOdsField; attrLengthLjava/lang/Integer; decimalLenfieldSqlLjava/lang/String;iI tableName tableDescfieldsLjava/util/List; createSqlLjava/lang/StringBuffer; uniqueKeyLocalVariableTypeTableLLjava/util/List; StackMapTable  Signature(Ljava/lang/String;Ljava/lang/String;Ljava/util/List;)Ljava/lang/String; createTablet(Lorg/springframework/jdbc/core/JdbcTemplate;Ljava/lang/String;Ljava/lang/String;Ljava/util/List;)Ljava/lang/String;template,Lorg/springframework/jdbc/core/JdbcTemplate;(Lorg/springframework/jdbc/core/JdbcTemplate;Ljava/lang/String;Ljava/lang/String;Ljava/util/List;)Ljava/lang/String;getDWDWLTableSqlFLcom/artfess/dataShare/dataResource/dw/model/BizDwdCatalogsTableField;XLjava/util/List;(Ljava/lang/String;Ljava/lang/String;Ljava/util/List;)Ljava/lang/String; createDwTable(Lorg/springframework/jdbc/core/JdbcTemplate;Ljava/lang/String;Ljava/lang/String;Ljava/util/List;)Ljava/lang/String;getAPPTableSqlGLcom/artfess/dataShare/dataResource/app/model/BizAppCatalogsTableField;YLjava/util/List;(Ljava/lang/String;Ljava/lang/String;Ljava/util/List;)Ljava/lang/String;createAppTable(Lorg/springframework/jdbc/core/JdbcTemplate;Ljava/lang/String;Ljava/lang/String;Ljava/util/List;)Ljava/lang/String;S(Lorg/springframework/jdbc/core/JdbcTemplate;Ljava/lang/String;Ljava/lang/String;)VcreateDwdMainSqlcreateDwdDetailSqlqueryDwdMainSql8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;queryDwdDetailSqlqueryAppMainSqlqueryAppDetailSql SourceFileDorisUtils.java ijjava/lang/StringBufferCREATE TABLE IF NOT EXISTS ( 0 `id_` VARCHAR(64) NOT NULL COMMENT "主键id", id_  8com/artfess/dataShare/dataResource/ods/model/BizOdsFieldID_      java/lang/StringBuilder`  ` !" #$ NULL COMMENT " %" & , 1 ',)  ENGINE=OLAP  UNIQUE KEY() ( ) COMMENT '' & DISTRIBUTED BY HASH(`id_`) BUCKETS 16 PROPERTIES "replication_num" = "3" ) pq* +,- ./0 1/Dcom/artfess/dataShare/dataResource/dw/model/BizDwdCatalogsTableField 2 qEcom/artfess/dataShare/dataResource/app/model/BizAppCatalogsTableField q 3create table DWD_BIZ__DATA A ID_ VARCHAR(64) not null comment '主键ID', 8 USER_ID_ VARCHAR(64) comment '个人ID', I USER_NAME_ varchar(64) default NULL comment '个人姓名', H USER_SEX_ varchar(6) default NULL comment '个人性别', I USER_IDENTITY_CARD_ varchar(18) default NULL comment '身份证号', L USER_PHONE_ varchar(18) default NULL comment '移动手机号', g DATA_ID_ VARCHAR(32) comment '数据批次ID（同一条记录数据批次ID相同）', K TABLE_CODE_ VARCHAR(32) comment '数据资源明细项编码', K DATA_JSON_ VARCHAR(4000) comment '字段数据JSON组合串', E FIELD_VALUE_TIME_ datetime comment '字段数据所属时间', c VERSION VARCHAR(16) comment '数据版本号（同一批数据版本号相同）', F CREATE_BY_ VARCHAR(64) default NULL comment '创建人', I CREATE_ORG_ID_ VARCHAR(64) default NULL comment '创建单位', 9 CREATE_TIME_ datetime comment '创建时间', I UPDATE_BY_ VARCHAR(64) default NULL comment '修改人员', I UPDATE_ORG_ID_ VARCHAR(64) default NULL comment '修改单位', 9 UPDATE_TIME_ datetime comment '修改时间', D TENANT_ID_ VARCHAR(64) default NULL comment '租户ID' i/ UNIQUE KEY(`id_`) "replication_num" = "1" create table DWD__TABLE_RECORD Y ID_ VARCHAR(64) not null comment '主键ID（采用递增即可）', ^ FIELD_ID_ VARCHAR(32) default NULL comment '字段ID(所属字段定义表ID)', \ FIELD_CODE_ VARCHAR(32) comment '字段列名(所属字段定义表字段名)', M FIELD_VALUE_ varchar(2000) default NULL comment '字段值Value',  FIELD_UI_MODULE_ varchar(2) default NULL comment '字段控件（1手动输入2下拉组件3复选组件4单选组件5日期组件6数字组件）', create table APP_D_  COMMENT '_COLUMN %com/artfess/dataShare/util/DorisUtilsjava/lang/Objectjava/lang/Stringjava/lang/Integerjava/util/Listappend,(Ljava/lang/String;)Ljava/lang/StringBuffer;size()Iget(I)Ljava/lang/Object; getFieldName()Ljava/lang/String;equalsIgnoreCase(Ljava/lang/String;)Z getAttrLength()Ljava/lang/Integer;intValuevalueOf(I)Ljava/lang/Integer; getDecimalLen-(Ljava/lang/String;)Ljava/lang/StringBuilder; getDataType$com/artfess/dataShare/util/FieldUtil getColumnType)(Ljava/lang/String;III)Ljava/lang/String;getDesctoStringgetIsPartition com/artfess/base/util/StringUtil isNotEmptyjava/lang/SystemoutLjava/io/PrintStream;java/io/PrintStreamprintln(Ljava/lang/String;)V*org/springframework/jdbc/core/JdbcTemplateexecute getFieldCodeisEmpty!gh ijk/*l m no pqk YN-*W-W-W:6, ,  :   : :Y : , d- W- W !!Y" :-#W-$W-Y%&W+' -Y(+)W-*W-+W-W-,W--W-.lv!%3@MPi!"$*&1(8*V+],z./0123mf @rsituvuXwx (yz{x|x}~%}x }D (' GGj*O k+,-/:01*2l89:;m4{x|x}~x } qk UYN-*W-W-W6, , 3: 45 5:6 6:Y478:, d-W-W,-#W-$W+' -Y(+)W-*W-+W-W-,W--W-.lf@ABC!D/E<FIGLIeJ~KLMODRS UV-X4Y;ZB[I\P]m\ <retu~wvu-wx$yzU{xU|xU}~M U}; $' GGj1 k+,-9:01*2lbcdem4{x|x}~x } qk UYN-*W-W-W6, , :: ;< <:= =:Y;>?:, d-W-W,-#W-$W+' -Y(+)W-*W-+W-W-,W--W-.lfijkl!m/n<oIpLres~tuvxm{| ~-4;BIPm\ <retu~wvu-wx$yzU{xU|xU}~M U}; $' GGj1 k}+,-@:*2lm4{x|x}~ x } k{+,AN*-2+,B:*2l m4{x|xxx kk*CDYYE*FGHIJKLMNOPQRSTUVWXYM,#W,$W,ZW+' ,Y(+)W,*W,+W,W,[W,-W,.l: m {x|xa   kz*CDYY\*]^HIJKLMN_`abPQRSTUVWXYM,#W,$W,ZW+' ,Y(+)W,*W,+W,W,[W,-W,.l: m {x|xa   kk*CDYYc*dGHIJKLMNOPQRSTUVWXYM,#W,$W,ZW+' ,Ye+)W,*W,+W,W,[W,-W,.l:  !m {x|xa   kz*CDYYc*f^HIJKLMN_`abPQRSTUVWXYM,#W,$W,ZW+' ,Y(+)W,*W,+W,W,[W,-W,.l:%& (?@ABCEFGHIJm {x|xa