数据仓库工具方法-维度表同步 MySQL表结构同步到Hive
作者:数据库 来源:人工智能 浏览: 【大中小】 发布时间:2025-11-05 02:35:39 评论数:
复制SELECT CONCAT( create table ,数据 TABLE_NAME, (, substring( column_info, 1, length( column_info ) - 1 ), ), comment , ", TABLE_COMMENT, ", ; ) FROM ( SELECT TABLE_NAME, TABLE_COMMENT, group_concat( CONCAT( COLUMN_NAME, , DATA_TYPE, comment , ", COLUMN_COMMENT, " ) ) AS column_info FROM ( SELECT t1.TABLE_NAME, CASE WHEN t2.TABLE_COMMENT = NULLTHEN t1.TABLE_NAME ELSE t2.TABLE_COMMENT ENDAS TABLE_COMMENT, COLUMN_NAME, CASE WHEN DATA_TYPE = varcharTHEN string WHEN DATA_TYPE = intTHEN int WHEN DATA_TYPE = tinyintTHEN tinyint WHEN DATA_TYPE = decimalTHEN double WHEN DATA_TYPE = datetimeTHEN string WHEN DATA_TYPE = timestampTHEN string WHEN DATA_TYPE = floatTHEN double WHEN DATA_TYPE = doubleTHEN double WHEN DATA_TYPE = bigintTHEN bigint ENDAS DATA_TYPE, CASE WHEN COLUMN_COMMENT = NULLTHEN COLUMN_NAME ELSE COLUMN_COMMENT ENDAS COLUMN_COMMENT FROM COLUMNS t1 JOIN TABLES t2 ON t1.TABLE_NAME = t2.TABLE_NAME and t1.TABLE_SCHEMA = t2.TABLE_SCHEMA WHERE t1.TABLE_NAME = book_module_stenciland t1.TABLE_SCHEMA=yyb_test ) t3 GROUPBY TABLE_NAME, TABLE_COMMENT ) t4; 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.43.44.45.46.47.48.49.50.51.52.53.54.55.56.57.58.59.60.61.62.63.64.65.66.