You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by as...@apache.org on 2018/09/14 18:05:33 UTC
[2/4] hive git commit: HIVE-20526: Add test case for HIVE-20489
(Janaki Lahorani, reviewed by Andrew Sherman)
http://git-wip-us.apache.org/repos/asf/hive/blob/1eec95dc/ql/src/test/queries/clientpositive/manyViewJoin.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/manyViewJoin.q b/ql/src/test/queries/clientpositive/manyViewJoin.q
new file mode 100644
index 0000000..55dca83
--- /dev/null
+++ b/ql/src/test/queries/clientpositive/manyViewJoin.q
@@ -0,0 +1,8522 @@
+-- this test creates a scenario where there will be a 47 view join, that will create a plan
+-- using map join and backup conditional tasks. this scenario is covered in hive-20489.
+
+drop table if exists test_hive_1035 purge;
+
+create table test_hive_1035
+(
+ test_hive_1018 string
+ ,test_hive_1004 string
+ ,test_hive_1025 string
+ ,test_hive_23 string
+ ,test_hive_27 string
+ ,test_hive_29 string
+ ,test_hive_30 string
+ ,test_hive_97 string
+ ,test_hive_96 string
+ ,test_hive_98 string
+ ,test_hive_101 string
+ ,test_hive_102 string
+ ,test_hive_109 string
+ ,test_hive_111 string
+ ,test_hive_112 string
+ ,test_hive_113 string
+ ,test_hive_114 string
+ ,test_hive_115 string
+ ,test_hive_78 string
+ ,test_hive_79 string
+ ,test_hive_24 string
+ ,test_hive_26 string
+ ,test_hive_110 string
+ ,test_hive_77 string
+ ,test_hive_87 string
+ ,test_hive_92 string
+ ,test_hive_90 string
+ ,test_hive_74 string
+ ,test_hive_85 string
+ ,test_hive_81 string
+ ,test_hive_82 string
+ ,test_hive_106 string
+ ,test_hive_107 string
+ ,test_hive_108 string
+ ,test_hive_75 string
+ ,test_hive_86 string
+ ,test_hive_76 string
+ ,test_hive_89 string
+ ,test_hive_88 string
+ ,test_hive_91 string
+ ,test_hive_71 string
+ ,test_hive_72 string
+ ,test_hive_73 string
+ ,test_hive_80 string
+ ,test_hive_103 string
+ ,test_hive_104 string
+ ,test_hive_1002 string
+ ,test_hive_1003 string
+ ,test_hive_25 string
+ ,test_hive_28 string
+ ,test_hive_93 string
+ ,test_hive_94 string
+ ,test_hive_95 string
+ ,test_hive_99 string
+ ,test_hive_105 string
+ ,test_hive_83 string
+ ,test_hive_84 string
+ ,test_hive_100 string
+ ,test_hive_1023 string
+ ,test_hive_1024 string
+ ,test_hive_1010 string
+ ,test_hive_1010_a_d string
+ ,test_hive_1010_a_g string
+ ,test_hive_1026 string
+ ,test_hive_1000 string
+ ,test_hive_1001 string
+ ,test_hive_1030 string
+ ,test_hive_1030_1 string
+ ,test_hive_1030_2 string
+ ,test_hive_1030_3 string
+ ,test_hive_1021 string
+ ,test_hive_1020 string
+ ,test_hive_1022 string
+ ,test_hive_1019 string
+ ,test_hive_1027 string
+ ,test_hive_1028 string
+ ,test_hive_1029 string
+ ,test_hive_1005 string
+ ,test_hive_1005_a_d string
+ ,test_hive_1005_psr string
+ ,test_hive_1005_psr_a_d string
+ ,test_hive_1005_psr_e string
+ ,test_hive_1013 string
+ ,test_hive_1013_a_d string
+ ,test_hive_1013_psr string
+ ,test_hive_1013_psr_a_d string
+ ,test_hive_1013_psr_e string
+ ,test_hive_1034 string
+)
+partitioned by (ds int, ts int)
+stored as parquet;
+
+create table if not exists test_hive_1038
+(
+ test_hive_1018 string
+ ,test_hive_1004 string
+ ,test_hive_1025 string
+ ,test_hive_23 string
+ ,test_hive_27 string
+ ,test_hive_29 string
+ ,test_hive_30 string
+ ,test_hive_97 string
+ ,test_hive_96 string
+ ,test_hive_98 string
+ ,test_hive_101 string
+ ,test_hive_102 string
+ ,test_hive_109 string
+ ,test_hive_111 string
+ ,test_hive_112 string
+ ,test_hive_113 string
+ ,test_hive_114 string
+ ,test_hive_115 string
+ ,test_hive_78 string
+ ,test_hive_79 string
+ ,test_hive_24 string
+ ,test_hive_26 string
+ ,test_hive_110 string
+ ,test_hive_77 string
+ ,test_hive_87 string
+ ,test_hive_92 string
+ ,test_hive_90 string
+ ,test_hive_74 string
+ ,test_hive_85 string
+ ,test_hive_81 string
+ ,test_hive_82 string
+ ,test_hive_106 string
+ ,test_hive_107 string
+ ,test_hive_108 string
+ ,test_hive_75 string
+ ,test_hive_86 string
+ ,test_hive_76 string
+ ,test_hive_89 string
+ ,test_hive_88 string
+ ,test_hive_91 string
+ ,test_hive_71 string
+ ,test_hive_72 string
+ ,test_hive_73 string
+ ,test_hive_80 string
+ ,test_hive_103 string
+ ,test_hive_104 string
+ ,test_hive_1002 string
+ ,test_hive_1003 string
+ ,test_hive_25 string
+ ,test_hive_28 string
+ ,test_hive_93 string
+ ,test_hive_94 string
+ ,test_hive_95 string
+ ,test_hive_99 string
+ ,test_hive_105 string
+ ,test_hive_83 string
+ ,test_hive_84 string
+ ,test_hive_100 string
+ ,test_hive_1023 string
+ ,test_hive_1024 string
+ ,test_hive_1010 string
+ ,test_hive_1010_a_d string
+ ,test_hive_1010_a_g string
+ ,test_hive_1026 string
+ ,test_hive_1000 string
+ ,test_hive_1001 string
+ ,test_hive_1030 string
+ ,test_hive_1030_1 string
+ ,test_hive_1030_2 string
+ ,test_hive_1030_3 string
+ ,test_hive_1021 string
+ ,test_hive_1020 string
+ ,test_hive_1022 string
+ ,test_hive_1019 string
+ ,test_hive_1027 string
+ ,test_hive_1028 string
+ ,test_hive_1029 string
+ ,test_hive_1005 string
+ ,test_hive_1005_a_d string
+ ,test_hive_1005_psr string
+ ,test_hive_1005_psr_a_d string
+ ,test_hive_1005_psr_e string
+ ,test_hive_1013 string
+ ,test_hive_1013_a_d string
+ ,test_hive_1013_psr string
+ ,test_hive_1013_psr_a_d string
+ ,test_hive_1013_psr_e string
+ ,test_hive_1034 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1037 purge;
+
+create table if not exists test_hive_1037
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1040;
+
+create view if not exists test_hive_1040
+as
+select
+ cast(test_hive_1018 as int) as test_hive_1018
+ ,cast(test_hive_1004 as int) as test_hive_1004
+ ,cast(test_hive_1025 as int) as test_hive_1025
+ ,cast(test_hive_23 as string) as test_hive_23
+ ,cast(test_hive_27 as string) as test_hive_27
+ ,cast(test_hive_29 as string) as test_hive_29
+ ,cast(test_hive_30 as string) as test_hive_30
+ ,cast(test_hive_97 as string) as test_hive_97
+ ,cast(test_hive_96 as string) as test_hive_96
+ ,cast(test_hive_98 as string) as test_hive_98
+ ,cast(test_hive_101 as string) as test_hive_101
+ ,cast(test_hive_102 as string) as test_hive_102
+ ,cast(test_hive_109 as string) as test_hive_109
+ ,cast(test_hive_111 as string) as test_hive_111
+ ,cast(test_hive_112 as string) as test_hive_112
+ ,cast(test_hive_113 as string) as test_hive_113
+ ,cast(test_hive_114 as string) as test_hive_114
+ ,cast(test_hive_115 as string) as test_hive_115
+ ,cast(test_hive_78 as string) as test_hive_78
+ ,cast(test_hive_79 as string) as test_hive_79
+ ,cast(test_hive_24 as string) as test_hive_24
+ ,cast(test_hive_26 as string) as test_hive_26
+ ,cast(test_hive_110 as string) as test_hive_110
+ ,cast(test_hive_77 as string) as test_hive_77
+ ,cast(test_hive_87 as string) as test_hive_87
+ ,cast(test_hive_92 as string) as test_hive_92
+ ,cast(test_hive_90 as string) as test_hive_90
+ ,cast(test_hive_74 as string) as test_hive_74
+ ,cast(test_hive_85 as string) as test_hive_85
+ ,cast(test_hive_81 as string) as test_hive_81
+ ,cast(test_hive_82 as string) as test_hive_82
+ ,cast(test_hive_106 as string) as test_hive_106
+ ,cast(test_hive_107 as string) as test_hive_107
+ ,cast(test_hive_108 as string) as test_hive_108
+ ,cast(test_hive_75 as string) as test_hive_75
+ ,cast(test_hive_86 as string) as test_hive_86
+ ,cast(test_hive_76 as string) as test_hive_76
+ ,cast(test_hive_89 as string) as test_hive_89
+ ,cast(test_hive_88 as string) as test_hive_88
+ ,cast(test_hive_91 as string) as test_hive_91
+ ,cast(test_hive_71 as string) as test_hive_71
+ ,cast(test_hive_72 as string) as test_hive_72
+ ,cast(test_hive_73 as string) as test_hive_73
+ ,cast(test_hive_80 as string) as test_hive_80
+ ,cast(test_hive_103 as string) as test_hive_103
+ ,cast(test_hive_104 as string) as test_hive_104
+ ,cast(test_hive_1002 as string) as test_hive_1002
+ ,cast(test_hive_1003 as string) as test_hive_1003
+ ,cast(from_unixtime(unix_timestamp(test_hive_25,'yyyymmdd'), 'yyyy-mm-dd') as timestamp) as test_hive_25
+ ,cast(test_hive_28 as string) as test_hive_28
+ ,cast(test_hive_93 as string) as test_hive_93
+ ,cast(test_hive_94 as string) as test_hive_94
+ ,cast(test_hive_95 as string) as test_hive_95
+ ,cast(test_hive_99 as string) as test_hive_99
+ ,cast(test_hive_105 as string) as test_hive_105
+ ,cast(test_hive_83 as string) as test_hive_83
+ ,cast(test_hive_84 as string) as test_hive_84
+ ,cast(test_hive_100 as string) as test_hive_100
+ ,cast(test_hive_1023 as int) as test_hive_1023
+ ,cast(test_hive_1024 as int) as test_hive_1024
+ ,cast(test_hive_1010 as int) as test_hive_1010
+ ,cast(test_hive_1010_a_d as int) as test_hive_1010_a_d
+ ,cast(test_hive_1010_a_g as int) as test_hive_1010_a_g
+ ,cast(test_hive_1026 as double) as test_hive_1026
+ ,cast(test_hive_1000 as double) as test_hive_1000
+ ,cast(test_hive_1001 as double) as test_hive_1001
+ ,cast(test_hive_1030 as int) as test_hive_1030
+ ,cast(test_hive_1030_1 as int) as test_hive_1030_1
+ ,cast(test_hive_1030_2 as int) as test_hive_1030_2
+ ,cast(test_hive_1030_3 as int) as test_hive_1030_3
+ ,cast(test_hive_1021 as double) as test_hive_1021
+ ,cast(test_hive_1020 as double) as test_hive_1020
+ ,cast(test_hive_1022 as int) as test_hive_1022
+ ,cast(test_hive_1019 as int) as test_hive_1019
+ ,cast(test_hive_1027 as double) as test_hive_1027
+ ,cast(test_hive_1028 as double) as test_hive_1028
+ ,cast(test_hive_1029 as double) as test_hive_1029
+ ,cast(test_hive_1005 as int) as test_hive_1005
+ ,cast(test_hive_1005_a_d as int) as test_hive_1005_a_d
+ ,cast(test_hive_1005_psr as int) as test_hive_1005_psr
+ ,cast(test_hive_1005_psr_a_d as int) as test_hive_1005_psr_a_d
+ ,cast(test_hive_1005_psr_e as int) as test_hive_1005_psr_e
+ ,cast(test_hive_1013 as int) as test_hive_1013
+ ,cast(test_hive_1013_a_d as int) as test_hive_1013_a_d
+ ,cast(test_hive_1013_psr as int) as test_hive_1013_psr
+ ,cast(test_hive_1013_psr_a_d as int) as test_hive_1013_psr_a_d
+ ,cast(test_hive_1013_psr_e as int) as test_hive_1013_psr_e
+ ,cast(from_unixtime(unix_timestamp(test_hive_1034,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1034
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1038
+;
+
+drop view if exists test_hive_1039;
+
+create view test_hive_1039
+as
+select
+ test_hive_1018 as test_hive_1018
+ ,test_hive_1004 as test_hive_1004
+ ,test_hive_1025 as test_hive_1025
+ ,test_hive_23 as test_hive_23
+ ,test_hive_27 as test_hive_27
+ ,test_hive_29 as test_hive_29
+ ,test_hive_30 as test_hive_30
+ ,test_hive_97 as test_hive_97
+ ,test_hive_96 as test_hive_96
+ ,test_hive_98 as test_hive_98
+ ,test_hive_101 as test_hive_101
+ ,test_hive_102 as test_hive_102
+ ,test_hive_109 as test_hive_109
+ ,test_hive_111 as test_hive_111
+ ,test_hive_112 as test_hive_112
+ ,test_hive_113 as test_hive_113
+ ,test_hive_114 as test_hive_114
+ ,test_hive_115 as test_hive_115
+ ,test_hive_78 as test_hive_78
+ ,test_hive_79 as test_hive_79
+ ,test_hive_24 as test_hive_24
+ ,test_hive_26 as test_hive_26
+ ,test_hive_110 as test_hive_110
+ ,test_hive_77 as test_hive_77
+ ,test_hive_87 as test_hive_87
+ ,test_hive_92 as test_hive_92
+ ,test_hive_90 as test_hive_90
+ ,test_hive_74 as test_hive_74
+ ,test_hive_85 as test_hive_85
+ ,test_hive_81 as test_hive_81
+ ,test_hive_82 as test_hive_82
+ ,test_hive_106 as test_hive_106
+ ,test_hive_107 as test_hive_107
+ ,test_hive_108 as test_hive_108
+ ,test_hive_75 as test_hive_75
+ ,test_hive_86 as test_hive_86
+ ,test_hive_76 as test_hive_76
+ ,test_hive_89 as test_hive_89
+ ,test_hive_88 as test_hive_88
+ ,test_hive_91 as test_hive_91
+ ,test_hive_71 as test_hive_71
+ ,test_hive_72 as test_hive_72
+ ,test_hive_73 as test_hive_73
+ ,test_hive_80 as test_hive_80
+ ,test_hive_103 as test_hive_103
+ ,test_hive_104 as test_hive_104
+ ,test_hive_1002 as test_hive_1002
+ ,test_hive_1003 as test_hive_1003
+ ,test_hive_25 as test_hive_25
+ ,test_hive_28 as test_hive_28
+ ,test_hive_93 as test_hive_93
+ ,test_hive_94 as test_hive_94
+ ,test_hive_95 as test_hive_95
+ ,test_hive_99 as test_hive_99
+ ,test_hive_105 as test_hive_105
+ ,test_hive_83 as test_hive_83
+ ,test_hive_84 as test_hive_84
+ ,test_hive_100 as test_hive_100
+ ,test_hive_1023 as test_hive_1023
+ ,test_hive_1024 as test_hive_1024
+ ,test_hive_1010 as test_hive_1010
+ ,test_hive_1010_a_d as test_hive_1010_a_d
+ ,test_hive_1010_a_g as test_hive_1010_a_g
+ ,test_hive_1026 as test_hive_1026
+ ,test_hive_1000 as test_hive_1000
+ ,test_hive_1001 as test_hive_1001
+ ,test_hive_1030 as test_hive_1030
+ ,test_hive_1030_1 as test_hive_1030_1
+ ,test_hive_1030_2 as test_hive_1030_2
+ ,test_hive_1030_3 as test_hive_1030_3
+ ,test_hive_1021 as test_hive_1021
+ ,test_hive_1020 as test_hive_1020
+ ,test_hive_1022 as test_hive_1022
+ ,test_hive_1019 as test_hive_1019
+ ,test_hive_1027 as test_hive_1027
+ ,test_hive_1028 as test_hive_1028
+ ,test_hive_1029 as test_hive_1029
+ ,test_hive_1005 as test_hive_1005
+ ,test_hive_1005_a_d as test_hive_1005_a_d
+ ,test_hive_1005_psr as test_hive_1005_psr
+ ,test_hive_1005_psr_a_d as test_hive_1005_psr_a_d
+ ,test_hive_1005_psr_e as test_hive_1005_psr_e
+ ,test_hive_1013 as test_hive_1013
+ ,test_hive_1013_a_d as test_hive_1013_a_d
+ ,test_hive_1013_psr as test_hive_1013_psr
+ ,test_hive_1013_psr_a_d as test_hive_1013_psr_a_d
+ ,test_hive_1013_psr_e as test_hive_1013_psr_e
+ ,test_hive_1034 as test_hive_1034
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1040 t1
+;
+
+drop view if exists test_hive_1036;
+
+create view test_hive_1036
+as
+select t1.*
+from test_hive_1039 t1
+inner join test_hive_1037 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1054 purge;
+
+create table test_hive_1054
+(
+ test_hive_1047 string
+ ,test_hive_1045 string
+ ,test_hive_1048 string
+ ,test_hive_132 string
+ ,test_hive_146 string
+ ,test_hive_1043 string
+ ,test_hive_149 string
+ ,test_hive_150 string
+ ,test_hive_119 string
+ ,test_hive_118 string
+ ,test_hive_120 string
+ ,test_hive_151 string
+ ,test_hive_116 string
+ ,test_hive_117 string
+ ,test_hive_121 string
+ ,test_hive_122 string
+ ,test_hive_152 string
+ ,test_hive_155 string
+ ,test_hive_159 string
+ ,test_hive_131 string
+ ,test_hive_140 string
+ ,test_hive_145 string
+ ,test_hive_143 string
+ ,test_hive_128 string
+ ,test_hive_138 string
+ ,test_hive_134 string
+ ,test_hive_135 string
+ ,test_hive_156 string
+ ,test_hive_157 string
+ ,test_hive_158 string
+ ,test_hive_129 string
+ ,test_hive_139 string
+ ,test_hive_130 string
+ ,test_hive_142 string
+ ,test_hive_141 string
+ ,test_hive_144 string
+ ,test_hive_125 string
+ ,test_hive_126 string
+ ,test_hive_127 string
+ ,test_hive_133 string
+ ,test_hive_154 string
+ ,test_hive_123 string
+ ,test_hive_160 string
+ ,test_hive_136 string
+ ,test_hive_137 string
+ ,test_hive_124 string
+ ,test_hive_153 string
+ ,test_hive_148 string
+ ,test_hive_147 string
+ ,test_hive_1052 string
+ ,test_hive_1051 string
+ ,test_hive_1041 string
+ ,test_hive_1042 string
+ ,test_hive_1044 string
+ ,test_hive_1046 string
+ ,test_hive_1050 string
+ ,test_hive_1049 string
+ ,test_hive_1053 string
+)
+partitioned by (ds int, ts int)
+row format delimited fields terminated by '31'
+tblproperties('serialization.null.format' = '');
+
+
+create table if not exists test_hive_1057
+(
+ test_hive_1047 string
+ ,test_hive_1045 string
+ ,test_hive_1048 string
+ ,test_hive_132 string
+ ,test_hive_146 string
+ ,test_hive_1043 string
+ ,test_hive_149 string
+ ,test_hive_150 string
+ ,test_hive_119 string
+ ,test_hive_118 string
+ ,test_hive_120 string
+ ,test_hive_151 string
+ ,test_hive_116 string
+ ,test_hive_117 string
+ ,test_hive_121 string
+ ,test_hive_122 string
+ ,test_hive_152 string
+ ,test_hive_155 string
+ ,test_hive_159 string
+ ,test_hive_131 string
+ ,test_hive_140 string
+ ,test_hive_145 string
+ ,test_hive_143 string
+ ,test_hive_128 string
+ ,test_hive_138 string
+ ,test_hive_134 string
+ ,test_hive_135 string
+ ,test_hive_156 string
+ ,test_hive_157 string
+ ,test_hive_158 string
+ ,test_hive_129 string
+ ,test_hive_139 string
+ ,test_hive_130 string
+ ,test_hive_142 string
+ ,test_hive_141 string
+ ,test_hive_144 string
+ ,test_hive_125 string
+ ,test_hive_126 string
+ ,test_hive_127 string
+ ,test_hive_133 string
+ ,test_hive_154 string
+ ,test_hive_123 string
+ ,test_hive_160 string
+ ,test_hive_136 string
+ ,test_hive_137 string
+ ,test_hive_124 string
+ ,test_hive_153 string
+ ,test_hive_148 string
+ ,test_hive_147 string
+ ,test_hive_1052 string
+ ,test_hive_1051 string
+ ,test_hive_1041 string
+ ,test_hive_1042 string
+ ,test_hive_1044 string
+ ,test_hive_1046 string
+ ,test_hive_1050 string
+ ,test_hive_1049 string
+ ,test_hive_1053 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1056 purge;
+
+create table if not exists test_hive_1056
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1059;
+
+create view if not exists test_hive_1059
+as
+select
+ cast(test_hive_1047 as int) as test_hive_1047
+ ,cast(test_hive_1045 as int) as test_hive_1045
+ ,cast(test_hive_1048 as int) as test_hive_1048
+ ,cast(test_hive_132 as string) as test_hive_132
+ ,cast(test_hive_146 as string) as test_hive_146
+ ,cast(test_hive_1043 as string) as test_hive_1043
+ ,cast(test_hive_149 as string) as test_hive_149
+ ,cast(test_hive_150 as string) as test_hive_150
+ ,cast(from_unixtime(unix_timestamp(test_hive_119,'yyyymmdd'), 'yyyy-mm-dd') as timestamp) as test_hive_119
+ ,cast(test_hive_118 as string) as test_hive_118
+ ,cast(test_hive_120 as string) as test_hive_120
+ ,cast(test_hive_151 as string) as test_hive_151
+ ,cast(test_hive_116 as string) as test_hive_116
+ ,cast(test_hive_117 as string) as test_hive_117
+ ,cast(test_hive_121 as string) as test_hive_121
+ ,cast(test_hive_122 as string) as test_hive_122
+ ,cast(test_hive_152 as string) as test_hive_152
+ ,cast(test_hive_155 as string) as test_hive_155
+ ,cast(test_hive_159 as string) as test_hive_159
+ ,cast(test_hive_131 as string) as test_hive_131
+ ,cast(test_hive_140 as string) as test_hive_140
+ ,cast(test_hive_145 as string) as test_hive_145
+ ,cast(test_hive_143 as string) as test_hive_143
+ ,cast(test_hive_128 as string) as test_hive_128
+ ,cast(test_hive_138 as string) as test_hive_138
+ ,cast(test_hive_134 as string) as test_hive_134
+ ,cast(test_hive_135 as string) as test_hive_135
+ ,cast(test_hive_156 as string) as test_hive_156
+ ,cast(test_hive_157 as string) as test_hive_157
+ ,cast(test_hive_158 as string) as test_hive_158
+ ,cast(test_hive_129 as string) as test_hive_129
+ ,cast(test_hive_139 as string) as test_hive_139
+ ,cast(test_hive_130 as string) as test_hive_130
+ ,cast(test_hive_142 as string) as test_hive_142
+ ,cast(test_hive_141 as string) as test_hive_141
+ ,cast(test_hive_144 as string) as test_hive_144
+ ,cast(test_hive_125 as string) as test_hive_125
+ ,cast(test_hive_126 as string) as test_hive_126
+ ,cast(test_hive_127 as string) as test_hive_127
+ ,cast(test_hive_133 as string) as test_hive_133
+ ,cast(test_hive_154 as string) as test_hive_154
+ ,cast(test_hive_123 as string) as test_hive_123
+ ,cast(test_hive_160 as string) as test_hive_160
+ ,cast(test_hive_136 as string) as test_hive_136
+ ,cast(test_hive_137 as string) as test_hive_137
+ ,cast(test_hive_124 as string) as test_hive_124
+ ,cast(test_hive_153 as string) as test_hive_153
+ ,cast(test_hive_148 as string) as test_hive_148
+ ,cast(test_hive_147 as string) as test_hive_147
+ ,cast(test_hive_1052 as int) as test_hive_1052
+ ,cast(test_hive_1051 as int) as test_hive_1051
+ ,cast(test_hive_1041 as int) as test_hive_1041
+ ,cast(test_hive_1042 as int) as test_hive_1042
+ ,cast(test_hive_1044 as int) as test_hive_1044
+ ,cast(test_hive_1046 as int) as test_hive_1046
+ ,cast(test_hive_1050 as int) as test_hive_1050
+ ,cast(test_hive_1049 as int) as test_hive_1049
+ ,cast(from_unixtime(unix_timestamp(test_hive_1053,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1053
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1057
+;
+
+drop view if exists test_hive_1058;
+
+create view test_hive_1058
+as
+select
+ test_hive_1047 as test_hive_1047
+ ,test_hive_1045 as test_hive_1045
+ ,test_hive_1048 as test_hive_1048
+ ,test_hive_132 as test_hive_132
+ ,test_hive_146 as test_hive_146
+ ,test_hive_1043 as test_hive_1043
+ ,test_hive_149 as test_hive_149
+ ,test_hive_150 as test_hive_150
+ ,test_hive_119 as test_hive_119
+ ,test_hive_118 as test_hive_118
+ ,test_hive_120 as test_hive_120
+ ,test_hive_151 as test_hive_151
+ ,test_hive_116 as test_hive_116
+ ,test_hive_117 as test_hive_117
+ ,test_hive_121 as test_hive_121
+ ,test_hive_122 as test_hive_122
+ ,test_hive_152 as test_hive_152
+ ,test_hive_155 as test_hive_155
+ ,test_hive_159 as test_hive_159
+ ,test_hive_131 as test_hive_131
+ ,test_hive_140 as test_hive_140
+ ,test_hive_145 as test_hive_145
+ ,test_hive_143 as test_hive_143
+ ,test_hive_128 as test_hive_128
+ ,test_hive_138 as test_hive_138
+ ,test_hive_134 as test_hive_134
+ ,test_hive_135 as test_hive_135
+ ,test_hive_156 as test_hive_156
+ ,test_hive_157 as test_hive_157
+ ,test_hive_158 as test_hive_158
+ ,test_hive_129 as test_hive_129
+ ,test_hive_139 as test_hive_139
+ ,test_hive_130 as test_hive_130
+ ,test_hive_142 as test_hive_142
+ ,test_hive_141 as test_hive_141
+ ,test_hive_144 as test_hive_144
+ ,test_hive_125 as test_hive_125
+ ,test_hive_126 as test_hive_126
+ ,test_hive_127 as test_hive_127
+ ,test_hive_133 as test_hive_133
+ ,test_hive_154 as test_hive_154
+ ,test_hive_123 as test_hive_123
+ ,test_hive_160 as test_hive_160
+ ,test_hive_136 as test_hive_136
+ ,test_hive_137 as test_hive_137
+ ,test_hive_124 as test_hive_124
+ ,test_hive_153 as test_hive_153
+ ,test_hive_148 as test_hive_148
+ ,test_hive_147 as test_hive_147
+ ,test_hive_1052 as test_hive_1052
+ ,test_hive_1051 as test_hive_1051
+ ,test_hive_1041 as test_hive_1041
+ ,test_hive_1042 as test_hive_1042
+ ,test_hive_1044 as test_hive_1044
+ ,test_hive_1046 as test_hive_1046
+ ,test_hive_1050 as test_hive_1050
+ ,test_hive_1049 as test_hive_1049
+ ,test_hive_1053 as test_hive_1053
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1059 t1
+;
+
+drop view if exists test_hive_1055;
+
+create view test_hive_1055
+as
+select t1.*
+from test_hive_1058 t1
+inner join test_hive_1056 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1083 purge;
+
+create table test_hive_1083
+(
+ test_hive_1072 string
+ ,test_hive_1065 string
+ ,test_hive_1073 string
+ ,test_hive_161 string
+ ,test_hive_162 string
+ ,test_hive_163 string
+ ,test_hive_164 string
+ ,test_hive_167 string
+ ,test_hive_168 string
+ ,test_hive_170 string
+ ,test_hive_197 string
+ ,test_hive_198 string
+ ,test_hive_200 string
+ ,test_hive_201 string
+ ,test_hive_202 string
+ ,test_hive_203 string
+ ,test_hive_205 string
+ ,test_hive_206 string
+ ,test_hive_212 string
+ ,test_hive_213 string
+ ,test_hive_178 string
+ ,test_hive_1060 string
+ ,test_hive_1061 string
+ ,test_hive_10612 string
+ ,test_hive_1063 string
+ ,test_hive_1064 string
+ ,test_hive_165 string
+ ,test_hive_166 string
+ ,test_hive_169 string
+ ,test_hive_193 string
+ ,test_hive_194 string
+ ,test_hive_195 string
+ ,test_hive_196 string
+ ,test_hive_204 string
+ ,test_hive_207 string
+ ,test_hive_208 string
+ ,test_hive_209 string
+ ,test_hive_210 string
+ ,test_hive_211 string
+ ,test_hive_171 string
+ ,test_hive_172 string
+ ,test_hive_173 string
+ ,test_hive_174 string
+ ,test_hive_175 string
+ ,test_hive_176 string
+ ,test_hive_177 string
+ ,test_hive_179 string
+ ,test_hive_180 string
+ ,test_hive_181 string
+ ,test_hive_182 string
+ ,test_hive_183 string
+ ,test_hive_184 string
+ ,test_hive_185 string
+ ,test_hive_186 string
+ ,test_hive_187 string
+ ,test_hive_188 string
+ ,test_hive_189 string
+ ,test_hive_190 string
+ ,test_hive_191 string
+ ,test_hive_192 string
+ ,test_hive_1067 string
+ ,test_hive_1067_a_g string
+ ,test_hive_1067_h string
+ ,test_hive_1066 string
+ ,test_hive_1070 string
+ ,test_hive_1070_a_d string
+ ,test_hive_1074 string
+ ,test_hive_1074_bp string
+ ,test_hive_1074_cont string
+ ,test_hive_1074_lag string
+ ,test_hive_1078 string
+ ,test_hive_1078_bp string
+ ,test_hive_1078_cont string
+ ,test_hive_1078_lag string
+ ,test_hive_199 string
+ ,test_hive_1082 string
+)
+partitioned by (ds int, ts int)
+row format delimited fields terminated by '31'
+tblproperties('serialization.null.format' = '');
+
+
+create table if not exists test_hive_1086
+(
+ test_hive_1072 string
+ ,test_hive_1065 string
+ ,test_hive_1073 string
+ ,test_hive_161 string
+ ,test_hive_162 string
+ ,test_hive_163 string
+ ,test_hive_164 string
+ ,test_hive_167 string
+ ,test_hive_168 string
+ ,test_hive_170 string
+ ,test_hive_197 string
+ ,test_hive_198 string
+ ,test_hive_200 string
+ ,test_hive_201 string
+ ,test_hive_202 string
+ ,test_hive_203 string
+ ,test_hive_205 string
+ ,test_hive_206 string
+ ,test_hive_212 string
+ ,test_hive_213 string
+ ,test_hive_178 string
+ ,test_hive_1060 string
+ ,test_hive_1061 string
+ ,test_hive_10612 string
+ ,test_hive_1063 string
+ ,test_hive_1064 string
+ ,test_hive_165 string
+ ,test_hive_166 string
+ ,test_hive_169 string
+ ,test_hive_193 string
+ ,test_hive_194 string
+ ,test_hive_195 string
+ ,test_hive_196 string
+ ,test_hive_204 string
+ ,test_hive_207 string
+ ,test_hive_208 string
+ ,test_hive_209 string
+ ,test_hive_210 string
+ ,test_hive_211 string
+ ,test_hive_171 string
+ ,test_hive_172 string
+ ,test_hive_173 string
+ ,test_hive_174 string
+ ,test_hive_175 string
+ ,test_hive_176 string
+ ,test_hive_177 string
+ ,test_hive_179 string
+ ,test_hive_180 string
+ ,test_hive_181 string
+ ,test_hive_182 string
+ ,test_hive_183 string
+ ,test_hive_184 string
+ ,test_hive_185 string
+ ,test_hive_186 string
+ ,test_hive_187 string
+ ,test_hive_188 string
+ ,test_hive_189 string
+ ,test_hive_190 string
+ ,test_hive_191 string
+ ,test_hive_192 string
+ ,test_hive_1067 string
+ ,test_hive_1067_a_g string
+ ,test_hive_1067_h string
+ ,test_hive_1066 string
+ ,test_hive_1070 string
+ ,test_hive_1070_a_d string
+ ,test_hive_1074 string
+ ,test_hive_1074_bp string
+ ,test_hive_1074_cont string
+ ,test_hive_1074_lag string
+ ,test_hive_1078 string
+ ,test_hive_1078_bp string
+ ,test_hive_1078_cont string
+ ,test_hive_1078_lag string
+ ,test_hive_199 string
+ ,test_hive_1082 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1085 purge;
+
+create table if not exists test_hive_1085
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1088;
+
+create view if not exists test_hive_1088
+as
+select
+ cast(test_hive_1072 as int) as test_hive_1072
+ ,cast(test_hive_1065 as int) as test_hive_1065
+ ,cast(test_hive_1073 as int) as test_hive_1073
+ ,cast(test_hive_161 as string) as test_hive_161
+ ,cast(test_hive_162 as string) as test_hive_162
+ ,cast(test_hive_163 as string) as test_hive_163
+ ,cast(test_hive_164 as string) as test_hive_164
+ ,cast(test_hive_167 as string) as test_hive_167
+ ,cast(test_hive_168 as string) as test_hive_168
+ ,cast(test_hive_170 as string) as test_hive_170
+ ,cast(test_hive_197 as string) as test_hive_197
+ ,cast(test_hive_198 as string) as test_hive_198
+ ,cast(test_hive_200 as string) as test_hive_200
+ ,cast(test_hive_201 as string) as test_hive_201
+ ,cast(test_hive_202 as string) as test_hive_202
+ ,cast(test_hive_203 as string) as test_hive_203
+ ,cast(test_hive_205 as string) as test_hive_205
+ ,cast(test_hive_206 as string) as test_hive_206
+ ,cast(test_hive_212 as string) as test_hive_212
+ ,cast(test_hive_213 as string) as test_hive_213
+ ,cast(test_hive_178 as string) as test_hive_178
+ ,cast(from_unixtime(unix_timestamp(test_hive_1060,'yyyymmdd'), 'yyyy-mm-dd') as timestamp) as test_hive_1060
+ ,cast(test_hive_1061 as string) as test_hive_1061
+ ,cast(test_hive_10612 as string) as test_hive_10612
+ ,cast(test_hive_1063 as string) as test_hive_1063
+ ,cast(test_hive_1064 as string) as test_hive_1064
+ ,cast(test_hive_165 as string) as test_hive_165
+ ,cast(test_hive_166 as string) as test_hive_166
+ ,cast(test_hive_169 as string) as test_hive_169
+ ,cast(test_hive_193 as string) as test_hive_193
+ ,cast(test_hive_194 as string) as test_hive_194
+ ,cast(test_hive_195 as string) as test_hive_195
+ ,cast(test_hive_196 as string) as test_hive_196
+ ,cast(test_hive_204 as string) as test_hive_204
+ ,cast(test_hive_207 as string) as test_hive_207
+ ,cast(test_hive_208 as string) as test_hive_208
+ ,cast(test_hive_209 as string) as test_hive_209
+ ,cast(test_hive_210 as string) as test_hive_210
+ ,cast(test_hive_211 as string) as test_hive_211
+ ,cast(test_hive_171 as string) as test_hive_171
+ ,cast(test_hive_172 as string) as test_hive_172
+ ,cast(test_hive_173 as string) as test_hive_173
+ ,cast(test_hive_174 as string) as test_hive_174
+ ,cast(test_hive_175 as string) as test_hive_175
+ ,cast(test_hive_176 as string) as test_hive_176
+ ,cast(test_hive_177 as string) as test_hive_177
+ ,cast(test_hive_179 as string) as test_hive_179
+ ,cast(test_hive_180 as string) as test_hive_180
+ ,cast(test_hive_181 as string) as test_hive_181
+ ,cast(test_hive_182 as string) as test_hive_182
+ ,cast(test_hive_183 as string) as test_hive_183
+ ,cast(test_hive_184 as string) as test_hive_184
+ ,cast(test_hive_185 as string) as test_hive_185
+ ,cast(test_hive_186 as string) as test_hive_186
+ ,cast(test_hive_187 as string) as test_hive_187
+ ,cast(test_hive_188 as string) as test_hive_188
+ ,cast(test_hive_189 as string) as test_hive_189
+ ,cast(test_hive_190 as string) as test_hive_190
+ ,cast(test_hive_191 as string) as test_hive_191
+ ,cast(test_hive_192 as string) as test_hive_192
+ ,cast(test_hive_1067 as int) as test_hive_1067
+ ,cast(test_hive_1067_a_g as int) as test_hive_1067_a_g
+ ,cast(test_hive_1067_h as int) as test_hive_1067_h
+ ,cast(test_hive_1066 as int) as test_hive_1066
+ ,cast(test_hive_1070 as int) as test_hive_1070
+ ,cast(test_hive_1070_a_d as int) as test_hive_1070_a_d
+ ,cast(test_hive_1074 as int) as test_hive_1074
+ ,cast(test_hive_1074_bp as int) as test_hive_1074_bp
+ ,cast(test_hive_1074_cont as int) as test_hive_1074_cont
+ ,cast(test_hive_1074_lag as int) as test_hive_1074_lag
+ ,cast(test_hive_1078 as int) as test_hive_1078
+ ,cast(test_hive_1078_bp as int) as test_hive_1078_bp
+ ,cast(test_hive_1078_cont as int) as test_hive_1078_cont
+ ,cast(test_hive_1078_lag as int) as test_hive_1078_lag
+ ,cast(test_hive_199 as string) as test_hive_199
+ ,cast(from_unixtime(unix_timestamp(test_hive_1082,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1082
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1086
+;
+
+drop view if exists test_hive_1087;
+
+create view test_hive_1087
+as
+select
+ test_hive_1072 as test_hive_1072
+ ,test_hive_1065 as test_hive_1065
+ ,test_hive_1073 as test_hive_1073
+ ,test_hive_161 as test_hive_161
+ ,test_hive_162 as test_hive_162
+ ,test_hive_163 as test_hive_163
+ ,test_hive_164 as test_hive_164
+ ,test_hive_167 as test_hive_167
+ ,test_hive_168 as test_hive_168
+ ,test_hive_170 as test_hive_170
+ ,test_hive_197 as test_hive_197
+ ,test_hive_198 as test_hive_198
+ ,test_hive_200 as test_hive_200
+ ,test_hive_201 as test_hive_201
+ ,test_hive_202 as test_hive_202
+ ,test_hive_203 as test_hive_203
+ ,test_hive_205 as test_hive_205
+ ,test_hive_206 as test_hive_206
+ ,test_hive_212 as test_hive_212
+ ,test_hive_213 as test_hive_213
+ ,test_hive_178 as test_hive_178
+ ,test_hive_1060 as test_hive_1060
+ ,test_hive_1061 as test_hive_1061
+ ,test_hive_10612 as test_hive_10612
+ ,test_hive_1063 as test_hive_1063
+ ,test_hive_1064 as test_hive_1064
+ ,test_hive_165 as test_hive_165
+ ,test_hive_166 as test_hive_166
+ ,test_hive_169 as test_hive_169
+ ,test_hive_193 as test_hive_193
+ ,test_hive_194 as test_hive_194
+ ,test_hive_195 as test_hive_195
+ ,test_hive_196 as test_hive_196
+ ,test_hive_204 as test_hive_204
+ ,test_hive_207 as test_hive_207
+ ,test_hive_208 as test_hive_208
+ ,test_hive_209 as test_hive_209
+ ,test_hive_210 as test_hive_210
+ ,test_hive_211 as test_hive_211
+ ,test_hive_171 as test_hive_171
+ ,test_hive_172 as test_hive_172
+ ,test_hive_173 as test_hive_173
+ ,test_hive_174 as test_hive_174
+ ,test_hive_175 as test_hive_175
+ ,test_hive_176 as test_hive_176
+ ,test_hive_177 as test_hive_177
+ ,test_hive_179 as test_hive_179
+ ,test_hive_180 as test_hive_180
+ ,test_hive_181 as test_hive_181
+ ,test_hive_182 as test_hive_182
+ ,test_hive_183 as test_hive_183
+ ,test_hive_184 as test_hive_184
+ ,test_hive_185 as test_hive_185
+ ,test_hive_186 as test_hive_186
+ ,test_hive_187 as test_hive_187
+ ,test_hive_188 as test_hive_188
+ ,test_hive_189 as test_hive_189
+ ,test_hive_190 as test_hive_190
+ ,test_hive_191 as test_hive_191
+ ,test_hive_192 as test_hive_192
+ ,test_hive_1067 as test_hive_1067
+ ,test_hive_1067_a_g as test_hive_1067_a_g
+ ,test_hive_1067_h as test_hive_1067_h
+ ,test_hive_1066 as test_hive_1066
+ ,test_hive_1070 as test_hive_1070
+ ,test_hive_1070_a_d as test_hive_1070_a_d
+ ,test_hive_1074 as test_hive_1074
+ ,test_hive_1074_bp as test_hive_1074_bp
+ ,test_hive_1074_cont as test_hive_1074_cont
+ ,test_hive_1074_lag as test_hive_1074_lag
+ ,test_hive_1078 as test_hive_1078
+ ,test_hive_1078_bp as test_hive_1078_bp
+ ,test_hive_1078_cont as test_hive_1078_cont
+ ,test_hive_1078_lag as test_hive_1078_lag
+ ,test_hive_199 as test_hive_199
+ ,test_hive_1082 as test_hive_1082
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1088 t1
+;
+
+drop view if exists test_hive_1084;
+
+create view test_hive_1084
+as
+select t1.*
+from test_hive_1087 t1
+inner join test_hive_1085 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1100 purge;
+
+create table test_hive_1100
+(
+ test_hive_1097 string
+ ,test_hive_1095 string
+ ,test_hive_1098 string
+ ,test_hive_1089 string
+ ,test_hive_1090 string
+ ,test_hive_10902 string
+ ,test_hive_1092 string
+ ,test_hive_1093 string
+ ,test_hive_244 string
+ ,test_hive_225 string
+ ,test_hive_214 string
+ ,test_hive_215 string
+ ,test_hive_216 string
+ ,test_hive_217 string
+ ,test_hive_240 string
+ ,test_hive_241 string
+ ,test_hive_242 string
+ ,test_hive_243 string
+ ,test_hive_245 string
+ ,test_hive_246 string
+ ,test_hive_247 string
+ ,test_hive_248 string
+ ,test_hive_249 string
+ ,test_hive_250 string
+ ,test_hive_218 string
+ ,test_hive_219 string
+ ,test_hive_220 string
+ ,test_hive_221 string
+ ,test_hive_222 string
+ ,test_hive_223 string
+ ,test_hive_224 string
+ ,test_hive_226 string
+ ,test_hive_227 string
+ ,test_hive_228 string
+ ,test_hive_229 string
+ ,test_hive_230 string
+ ,test_hive_231 string
+ ,test_hive_232 string
+ ,test_hive_233 string
+ ,test_hive_234 string
+ ,test_hive_235 string
+ ,test_hive_236 string
+ ,test_hive_237 string
+ ,test_hive_238 string
+ ,test_hive_239 string
+ ,test_hive_1094 string
+ ,test_hive_1096 string
+ ,test_hive_1099 string
+)
+partitioned by (ds int, ts int)
+row format delimited fields terminated by '31'
+tblproperties('serialization.null.format' = '');
+
+
+create table if not exists test_hive_1103
+(
+ test_hive_1097 string
+ ,test_hive_1095 string
+ ,test_hive_1098 string
+ ,test_hive_1089 string
+ ,test_hive_1090 string
+ ,test_hive_10902 string
+ ,test_hive_1092 string
+ ,test_hive_1093 string
+ ,test_hive_244 string
+ ,test_hive_225 string
+ ,test_hive_214 string
+ ,test_hive_215 string
+ ,test_hive_216 string
+ ,test_hive_217 string
+ ,test_hive_240 string
+ ,test_hive_241 string
+ ,test_hive_242 string
+ ,test_hive_243 string
+ ,test_hive_245 string
+ ,test_hive_246 string
+ ,test_hive_247 string
+ ,test_hive_248 string
+ ,test_hive_249 string
+ ,test_hive_250 string
+ ,test_hive_218 string
+ ,test_hive_219 string
+ ,test_hive_220 string
+ ,test_hive_221 string
+ ,test_hive_222 string
+ ,test_hive_223 string
+ ,test_hive_224 string
+ ,test_hive_226 string
+ ,test_hive_227 string
+ ,test_hive_228 string
+ ,test_hive_229 string
+ ,test_hive_230 string
+ ,test_hive_231 string
+ ,test_hive_232 string
+ ,test_hive_233 string
+ ,test_hive_234 string
+ ,test_hive_235 string
+ ,test_hive_236 string
+ ,test_hive_237 string
+ ,test_hive_238 string
+ ,test_hive_239 string
+ ,test_hive_1094 string
+ ,test_hive_1096 string
+ ,test_hive_1099 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1102 purge;
+
+create table if not exists test_hive_1102
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1105;
+
+create view if not exists test_hive_1105
+as
+select
+ cast(test_hive_1097 as int) as test_hive_1097
+ ,cast(test_hive_1095 as int) as test_hive_1095
+ ,cast(test_hive_1098 as int) as test_hive_1098
+ ,cast(from_unixtime(unix_timestamp(test_hive_1089,'yyyymmdd'), 'yyyy-mm-dd') as timestamp) as test_hive_1089
+ ,cast(test_hive_1090 as string) as test_hive_1090
+ ,cast(test_hive_10902 as string) as test_hive_10902
+ ,cast(test_hive_1092 as string) as test_hive_1092
+ ,cast(test_hive_1093 as string) as test_hive_1093
+ ,cast(test_hive_244 as string) as test_hive_244
+ ,cast(test_hive_225 as string) as test_hive_225
+ ,cast(test_hive_214 as string) as test_hive_214
+ ,cast(from_unixtime(unix_timestamp(test_hive_215,'yyyymmdd'), 'yyyy-mm-dd') as timestamp) as test_hive_215
+ ,cast(test_hive_216 as string) as test_hive_216
+ ,cast(test_hive_217 as string) as test_hive_217
+ ,cast(test_hive_240 as string) as test_hive_240
+ ,cast(test_hive_241 as string) as test_hive_241
+ ,cast(test_hive_242 as string) as test_hive_242
+ ,cast(test_hive_243 as string) as test_hive_243
+ ,cast(test_hive_245 as string) as test_hive_245
+ ,cast(test_hive_246 as string) as test_hive_246
+ ,cast(test_hive_247 as string) as test_hive_247
+ ,cast(test_hive_248 as string) as test_hive_248
+ ,cast(test_hive_249 as string) as test_hive_249
+ ,cast(test_hive_250 as string) as test_hive_250
+ ,cast(test_hive_218 as string) as test_hive_218
+ ,cast(test_hive_219 as string) as test_hive_219
+ ,cast(test_hive_220 as string) as test_hive_220
+ ,cast(test_hive_221 as string) as test_hive_221
+ ,cast(test_hive_222 as string) as test_hive_222
+ ,cast(test_hive_223 as string) as test_hive_223
+ ,cast(test_hive_224 as string) as test_hive_224
+ ,cast(test_hive_226 as string) as test_hive_226
+ ,cast(test_hive_227 as string) as test_hive_227
+ ,cast(test_hive_228 as string) as test_hive_228
+ ,cast(test_hive_229 as string) as test_hive_229
+ ,cast(test_hive_230 as string) as test_hive_230
+ ,cast(test_hive_231 as string) as test_hive_231
+ ,cast(test_hive_232 as string) as test_hive_232
+ ,cast(test_hive_233 as string) as test_hive_233
+ ,cast(test_hive_234 as string) as test_hive_234
+ ,cast(test_hive_235 as string) as test_hive_235
+ ,cast(test_hive_236 as string) as test_hive_236
+ ,cast(test_hive_237 as string) as test_hive_237
+ ,cast(test_hive_238 as string) as test_hive_238
+ ,cast(test_hive_239 as string) as test_hive_239
+ ,cast(test_hive_1094 as int) as test_hive_1094
+ ,cast(test_hive_1096 as int) as test_hive_1096
+ ,cast(from_unixtime(unix_timestamp(test_hive_1099,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1099
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1103
+;
+
+drop view if exists test_hive_1104;
+
+create view test_hive_1104
+as
+select
+ test_hive_1097 as test_hive_1097
+ ,test_hive_1095 as test_hive_1095
+ ,test_hive_1098 as test_hive_1098
+ ,test_hive_1089 as test_hive_1089
+ ,test_hive_1090 as test_hive_1090
+ ,test_hive_10902 as test_hive_10902
+ ,test_hive_1092 as test_hive_1092
+ ,test_hive_1093 as test_hive_1093
+ ,test_hive_244 as test_hive_244
+ ,test_hive_225 as test_hive_225
+ ,test_hive_214 as test_hive_214
+ ,test_hive_215 as test_hive_215
+ ,test_hive_216 as test_hive_216
+ ,test_hive_217 as test_hive_217
+ ,test_hive_240 as test_hive_240
+ ,test_hive_241 as test_hive_241
+ ,test_hive_242 as test_hive_242
+ ,test_hive_243 as test_hive_243
+ ,test_hive_245 as test_hive_245
+ ,test_hive_246 as test_hive_246
+ ,test_hive_247 as test_hive_247
+ ,test_hive_248 as test_hive_248
+ ,test_hive_249 as test_hive_249
+ ,test_hive_250 as test_hive_250
+ ,test_hive_218 as test_hive_218
+ ,test_hive_219 as test_hive_219
+ ,test_hive_220 as test_hive_220
+ ,test_hive_221 as test_hive_221
+ ,test_hive_222 as test_hive_222
+ ,test_hive_223 as test_hive_223
+ ,test_hive_224 as test_hive_224
+ ,test_hive_226 as test_hive_226
+ ,test_hive_227 as test_hive_227
+ ,test_hive_228 as test_hive_228
+ ,test_hive_229 as test_hive_229
+ ,test_hive_230 as test_hive_230
+ ,test_hive_231 as test_hive_231
+ ,test_hive_232 as test_hive_232
+ ,test_hive_233 as test_hive_233
+ ,test_hive_234 as test_hive_234
+ ,test_hive_235 as test_hive_235
+ ,test_hive_236 as test_hive_236
+ ,test_hive_237 as test_hive_237
+ ,test_hive_238 as test_hive_238
+ ,test_hive_239 as test_hive_239
+ ,test_hive_1094 as test_hive_1094
+ ,test_hive_1096 as test_hive_1096
+ ,test_hive_1099 as test_hive_1099
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1105 t1
+;
+
+drop view if exists test_hive_1101;
+
+create view test_hive_1101
+as
+select t1.*
+from test_hive_1104 t1
+inner join test_hive_1102 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1250 purge;
+
+create table test_hive_1250
+(
+ test_hive_1240 string
+ ,test_hive_1239 string
+ ,test_hive_1241 string
+ ,test_hive_300 string
+ ,test_hive_288 string
+ ,test_hive_294 string
+ ,test_hive_299 string
+ ,test_hive_297 string
+ ,test_hive_285 string
+ ,test_hive_292 string
+ ,test_hive_290 string
+ ,test_hive_291 string
+ ,test_hive_303 string
+ ,test_hive_304 string
+ ,test_hive_305 string
+ ,test_hive_286 string
+ ,test_hive_293 string
+ ,test_hive_287 string
+ ,test_hive_296 string
+ ,test_hive_295 string
+ ,test_hive_298 string
+ ,test_hive_282 string
+ ,test_hive_283 string
+ ,test_hive_284 string
+ ,test_hive_289 string
+ ,test_hive_302 string
+ ,test_hive_301 string
+ ,test_hive_281 string
+ ,test_hive_1233 string
+ ,test_hive_1234 string
+ ,test_hive_12342 string
+ ,test_hive_1236 string
+ ,test_hive_1237 string
+ ,test_hive_1238 string
+ ,test_hive_1243 string
+ ,test_hive_1243_lag string
+ ,test_hive_1242 string
+ ,test_hive_1232 string
+ ,test_hive_1243_bp string
+ ,test_hive_1243_lag_bp string
+ ,test_hive_1243_con string
+ ,test_hive_1243_lag_con string
+ ,test_hive_1249 string
+)
+partitioned by (ds int, ts int)
+row format delimited fields terminated by '31'
+tblproperties('serialization.null.format' = '');
+
+
+create table if not exists test_hive_1253
+(
+ test_hive_1240 string
+ ,test_hive_1239 string
+ ,test_hive_1241 string
+ ,test_hive_300 string
+ ,test_hive_288 string
+ ,test_hive_294 string
+ ,test_hive_299 string
+ ,test_hive_297 string
+ ,test_hive_285 string
+ ,test_hive_292 string
+ ,test_hive_290 string
+ ,test_hive_291 string
+ ,test_hive_303 string
+ ,test_hive_304 string
+ ,test_hive_305 string
+ ,test_hive_286 string
+ ,test_hive_293 string
+ ,test_hive_287 string
+ ,test_hive_296 string
+ ,test_hive_295 string
+ ,test_hive_298 string
+ ,test_hive_282 string
+ ,test_hive_283 string
+ ,test_hive_284 string
+ ,test_hive_289 string
+ ,test_hive_302 string
+ ,test_hive_301 string
+ ,test_hive_281 string
+ ,test_hive_1233 string
+ ,test_hive_1234 string
+ ,test_hive_12342 string
+ ,test_hive_1236 string
+ ,test_hive_1237 string
+ ,test_hive_1238 string
+ ,test_hive_1243 string
+ ,test_hive_1243_lag string
+ ,test_hive_1242 string
+ ,test_hive_1232 string
+ ,test_hive_1243_bp string
+ ,test_hive_1243_lag_bp string
+ ,test_hive_1243_con string
+ ,test_hive_1243_lag_con string
+ ,test_hive_1249 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1252 purge;
+
+create table if not exists test_hive_1252
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1255;
+
+create view if not exists test_hive_1255
+as
+select
+ cast(test_hive_1240 as int) as test_hive_1240
+ ,cast(test_hive_1239 as int) as test_hive_1239
+ ,cast(test_hive_1241 as int) as test_hive_1241
+ ,cast(test_hive_300 as string) as test_hive_300
+ ,cast(test_hive_288 as string) as test_hive_288
+ ,cast(test_hive_294 as string) as test_hive_294
+ ,cast(test_hive_299 as string) as test_hive_299
+ ,cast(test_hive_297 as string) as test_hive_297
+ ,cast(test_hive_285 as string) as test_hive_285
+ ,cast(test_hive_292 as string) as test_hive_292
+ ,cast(test_hive_290 as string) as test_hive_290
+ ,cast(test_hive_291 as string) as test_hive_291
+ ,cast(test_hive_303 as string) as test_hive_303
+ ,cast(test_hive_304 as string) as test_hive_304
+ ,cast(test_hive_305 as string) as test_hive_305
+ ,cast(test_hive_286 as string) as test_hive_286
+ ,cast(test_hive_293 as string) as test_hive_293
+ ,cast(test_hive_287 as string) as test_hive_287
+ ,cast(test_hive_296 as string) as test_hive_296
+ ,cast(test_hive_295 as string) as test_hive_295
+ ,cast(test_hive_298 as string) as test_hive_298
+ ,cast(test_hive_282 as string) as test_hive_282
+ ,cast(test_hive_283 as string) as test_hive_283
+ ,cast(test_hive_284 as string) as test_hive_284
+ ,cast(test_hive_289 as string) as test_hive_289
+ ,cast(test_hive_302 as string) as test_hive_302
+ ,cast(test_hive_301 as string) as test_hive_301
+ ,cast(test_hive_281 as string) as test_hive_281
+ ,cast(from_unixtime(unix_timestamp(test_hive_1233,'yyyymmdd'), 'yyyy-mm-dd') as timestamp) as test_hive_1233
+ ,cast(test_hive_1234 as string) as test_hive_1234
+ ,cast(test_hive_12342 as string) as test_hive_12342
+ ,cast(test_hive_1236 as string) as test_hive_1236
+ ,cast(test_hive_1237 as string) as test_hive_1237
+ ,cast(test_hive_1238 as string) as test_hive_1238
+ ,cast(test_hive_1243 as double) as test_hive_1243
+ ,cast(test_hive_1243_lag as double) as test_hive_1243_lag
+ ,cast(test_hive_1242 as double) as test_hive_1242
+ ,cast(test_hive_1232 as double) as test_hive_1232
+ ,cast(test_hive_1243_bp as double) as test_hive_1243_bp
+ ,cast(test_hive_1243_lag_bp as double) as test_hive_1243_lag_bp
+ ,cast(test_hive_1243_con as double) as test_hive_1243_con
+ ,cast(test_hive_1243_lag_con as double) as test_hive_1243_lag_con
+ ,cast(from_unixtime(unix_timestamp(test_hive_1249,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1249
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1253
+;
+
+drop view if exists test_hive_1254;
+
+create view test_hive_1254
+as
+select
+ test_hive_1240 as test_hive_1240
+ ,test_hive_1239 as test_hive_1239
+ ,test_hive_1241 as test_hive_1241
+ ,test_hive_300 as test_hive_300
+ ,test_hive_288 as test_hive_288
+ ,test_hive_294 as test_hive_294
+ ,test_hive_299 as test_hive_299
+ ,test_hive_297 as test_hive_297
+ ,test_hive_285 as test_hive_285
+ ,test_hive_292 as test_hive_292
+ ,test_hive_290 as test_hive_290
+ ,test_hive_291 as test_hive_291
+ ,test_hive_303 as test_hive_303
+ ,test_hive_304 as test_hive_304
+ ,test_hive_305 as test_hive_305
+ ,test_hive_286 as test_hive_286
+ ,test_hive_293 as test_hive_293
+ ,test_hive_287 as test_hive_287
+ ,test_hive_296 as test_hive_296
+ ,test_hive_295 as test_hive_295
+ ,test_hive_298 as test_hive_298
+ ,test_hive_282 as test_hive_282
+ ,test_hive_283 as test_hive_283
+ ,test_hive_284 as test_hive_284
+ ,test_hive_289 as test_hive_289
+ ,test_hive_302 as test_hive_302
+ ,test_hive_301 as test_hive_301
+ ,test_hive_281 as test_hive_281
+ ,test_hive_1233 as test_hive_1233
+ ,test_hive_1234 as test_hive_1234
+ ,test_hive_12342 as test_hive_12342
+ ,test_hive_1236 as test_hive_1236
+ ,test_hive_1237 as test_hive_1237
+ ,test_hive_1238 as test_hive_1238
+ ,test_hive_1243 as test_hive_1243
+ ,test_hive_1243_lag as test_hive_1243_lag
+ ,test_hive_1242 as test_hive_1242
+ ,test_hive_1232 as test_hive_1232
+ ,test_hive_1243_bp as test_hive_1243_bp
+ ,test_hive_1243_lag_bp as test_hive_1243_lag_bp
+ ,test_hive_1243_con as test_hive_1243_con
+ ,test_hive_1243_lag_con as test_hive_1243_lag_con
+ ,test_hive_1249 as test_hive_1249
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1255 t1
+;
+
+drop view if exists test_hive_1251;
+
+create view test_hive_1251
+as
+select t1.*
+from test_hive_1254 t1
+inner join test_hive_1252 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1373 purge;
+
+create table test_hive_1373
+(
+ test_hive_1370 string
+ ,test_hive_1367 string
+ ,test_hive_1371 string
+ ,test_hive_1366 string
+ ,test_hive_338 string
+ ,test_hive_338_txt string
+ ,test_hive_340 string
+ ,test_hive_345 string
+ ,test_hive_345_txt string
+ ,test_hive_347 string
+ ,test_hive_348 string
+ ,test_hive_370 string
+ ,test_hive_373 string
+ ,test_hive_357 string
+ ,test_hive_375 string
+ ,test_hive_359 string
+ ,test_hive_341 string
+ ,test_hive_1368 string
+ ,test_hive_1369 string
+ ,test_hive_367 string
+ ,test_hive_354 string
+ ,test_hive_360 string
+ ,test_hive_349 string
+ ,test_hive_368 string
+ ,test_hive_369 string
+ ,test_hive_355 string
+ ,test_hive_342 string
+ ,test_hive_372 string
+ ,test_hive_363 string
+ ,test_hive_351 string
+ ,test_hive_365 string
+ ,test_hive_352 string
+ ,test_hive_366 string
+ ,test_hive_353 string
+ ,test_hive_364 string
+ ,test_hive_1381 string
+ ,test_hive_358 string
+ ,test_hive_1379 string
+ ,test_hive_362 string
+ ,test_hive_1380 string
+ ,test_hive_361 string
+ ,test_hive_350 string
+ ,test_hive_374 string
+ ,test_hive_343 string
+ ,test_hive_343_txt string
+ ,test_hive_371 string
+ ,test_hive_356 string
+ ,test_hive_1372 string
+)
+partitioned by (ds int, ts int)
+row format delimited fields terminated by '31'
+tblproperties('serialization.null.format' = '');
+
+
+create table if not exists test_hive_1376
+(
+ test_hive_1370 string
+ ,test_hive_1367 string
+ ,test_hive_1371 string
+ ,test_hive_1366 string
+ ,test_hive_338 string
+ ,test_hive_338_txt string
+ ,test_hive_340 string
+ ,test_hive_345 string
+ ,test_hive_345_txt string
+ ,test_hive_347 string
+ ,test_hive_348 string
+ ,test_hive_370 string
+ ,test_hive_373 string
+ ,test_hive_357 string
+ ,test_hive_375 string
+ ,test_hive_359 string
+ ,test_hive_341 string
+ ,test_hive_1368 string
+ ,test_hive_1369 string
+ ,test_hive_367 string
+ ,test_hive_354 string
+ ,test_hive_360 string
+ ,test_hive_349 string
+ ,test_hive_368 string
+ ,test_hive_369 string
+ ,test_hive_355 string
+ ,test_hive_342 string
+ ,test_hive_372 string
+ ,test_hive_363 string
+ ,test_hive_351 string
+ ,test_hive_365 string
+ ,test_hive_352 string
+ ,test_hive_366 string
+ ,test_hive_353 string
+ ,test_hive_364 string
+ ,test_hive_1381 string
+ ,test_hive_358 string
+ ,test_hive_1379 string
+ ,test_hive_362 string
+ ,test_hive_1380 string
+ ,test_hive_361 string
+ ,test_hive_350 string
+ ,test_hive_374 string
+ ,test_hive_343 string
+ ,test_hive_343_txt string
+ ,test_hive_371 string
+ ,test_hive_356 string
+ ,test_hive_1372 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1375 purge;
+
+create table if not exists test_hive_1375
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1378;
+
+create view if not exists test_hive_1378
+as
+select
+ cast(test_hive_1370 as int) as test_hive_1370
+ ,cast(test_hive_1367 as int) as test_hive_1367
+ ,cast(test_hive_1371 as int) as test_hive_1371
+ ,cast(test_hive_1366 as string) as test_hive_1366
+ ,cast(test_hive_338 as string) as test_hive_338
+ ,cast(test_hive_338_txt as string) as test_hive_338_txt
+ ,cast(test_hive_340 as string) as test_hive_340
+ ,cast(test_hive_345 as string) as test_hive_345
+ ,cast(test_hive_345_txt as string) as test_hive_345_txt
+ ,cast(test_hive_347 as string) as test_hive_347
+ ,cast(test_hive_348 as string) as test_hive_348
+ ,cast(test_hive_370 as string) as test_hive_370
+ ,cast(test_hive_373 as string) as test_hive_373
+ ,cast(test_hive_357 as string) as test_hive_357
+ ,cast(test_hive_375 as string) as test_hive_375
+ ,cast(test_hive_359 as string) as test_hive_359
+ ,cast(test_hive_341 as string) as test_hive_341
+ ,cast(test_hive_1368 as int) as test_hive_1368
+ ,cast(test_hive_1369 as int) as test_hive_1369
+ ,cast(test_hive_367 as string) as test_hive_367
+ ,cast(test_hive_354 as string) as test_hive_354
+ ,cast(test_hive_360 as string) as test_hive_360
+ ,cast(test_hive_349 as string) as test_hive_349
+ ,cast(test_hive_368 as string) as test_hive_368
+ ,cast(test_hive_369 as string) as test_hive_369
+ ,cast(test_hive_355 as string) as test_hive_355
+ ,cast(from_unixtime(unix_timestamp(test_hive_342,'yyyymmdd'), 'yyyy-mm-dd') as timestamp) as test_hive_342
+ ,cast(test_hive_372 as string) as test_hive_372
+ ,cast(test_hive_363 as string) as test_hive_363
+ ,cast(test_hive_351 as string) as test_hive_351
+ ,cast(test_hive_365 as string) as test_hive_365
+ ,cast(test_hive_352 as string) as test_hive_352
+ ,cast(test_hive_366 as string) as test_hive_366
+ ,cast(test_hive_353 as string) as test_hive_353
+ ,cast(test_hive_364 as string) as test_hive_364
+ ,cast(test_hive_1381 as string) as test_hive_1381
+ ,cast(test_hive_358 as string) as test_hive_358
+ ,cast(test_hive_1379 as string) as test_hive_1379
+ ,cast(test_hive_362 as string) as test_hive_362
+ ,cast(test_hive_1380 as string) as test_hive_1380
+ ,cast(test_hive_361 as string) as test_hive_361
+ ,cast(test_hive_350 as string) as test_hive_350
+ ,cast(test_hive_374 as string) as test_hive_374
+ ,cast(test_hive_343 as string) as test_hive_343
+ ,cast(test_hive_343_txt as string) as test_hive_343_txt
+ ,cast(test_hive_371 as string) as test_hive_371
+ ,cast(test_hive_356 as string) as test_hive_356
+ ,cast(from_unixtime(unix_timestamp(test_hive_1372,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1372
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1376
+;
+
+drop view if exists test_hive_1377;
+
+create view test_hive_1377
+as
+select
+ test_hive_1370 as test_hive_1370
+ ,test_hive_1367 as test_hive_1367
+ ,test_hive_1371 as test_hive_1371
+ ,test_hive_1366 as test_hive_1366
+ ,test_hive_338 as test_hive_338
+ ,test_hive_338_txt as test_hive_338_txt
+ ,test_hive_340 as test_hive_340
+ ,test_hive_345 as test_hive_345
+ ,test_hive_345_txt as test_hive_345_txt
+ ,test_hive_347 as test_hive_347
+ ,test_hive_348 as test_hive_348
+ ,test_hive_370 as test_hive_370
+ ,test_hive_373 as test_hive_373
+ ,test_hive_357 as test_hive_357
+ ,test_hive_375 as test_hive_375
+ ,test_hive_359 as test_hive_359
+ ,test_hive_341 as test_hive_341
+ ,test_hive_1368 as test_hive_1368
+ ,test_hive_1369 as test_hive_1369
+ ,test_hive_367 as test_hive_367
+ ,test_hive_354 as test_hive_354
+ ,test_hive_360 as test_hive_360
+ ,test_hive_349 as test_hive_349
+ ,test_hive_368 as test_hive_368
+ ,test_hive_369 as test_hive_369
+ ,test_hive_355 as test_hive_355
+ ,test_hive_342 as test_hive_342
+ ,test_hive_372 as test_hive_372
+ ,test_hive_363 as test_hive_363
+ ,test_hive_351 as test_hive_351
+ ,test_hive_365 as test_hive_365
+ ,test_hive_352 as test_hive_352
+ ,test_hive_366 as test_hive_366
+ ,test_hive_353 as test_hive_353
+ ,test_hive_364 as test_hive_364
+ ,test_hive_1381 as test_hive_1381
+ ,test_hive_358 as test_hive_358
+ ,test_hive_1379 as test_hive_1379
+ ,test_hive_362 as test_hive_362
+ ,test_hive_1380 as test_hive_1380
+ ,test_hive_361 as test_hive_361
+ ,test_hive_350 as test_hive_350
+ ,test_hive_374 as test_hive_374
+ ,test_hive_343 as test_hive_343
+ ,test_hive_343_txt as test_hive_343_txt
+ ,test_hive_371 as test_hive_371
+ ,test_hive_356 as test_hive_356
+ ,test_hive_1372 as test_hive_1372
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1378 t1
+;
+
+drop view if exists test_hive_1374;
+
+create view test_hive_1374
+as
+select t1.*
+from test_hive_1377 t1
+inner join test_hive_1375 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1397 purge;
+
+create table test_hive_1397
+(
+ test_hive_1394 string
+ ,test_hive_1383 string
+ ,test_hive_1395 string
+ ,test_hive_1382 string
+ ,test_hive_407 string
+ ,test_hive_397 string
+ ,test_hive_379 string
+ ,test_hive_408 string
+ ,test_hive_1384 string
+ ,test_hive_1385 string
+ ,test_hive_1386 string
+ ,test_hive_1387 string
+ ,test_hive_1388 string
+ ,test_hive_1389 string
+ ,test_hive_1390 string
+ ,test_hive_1391 string
+ ,test_hive_1392 string
+ ,test_hive_1393 string
+ ,test_hive_400 string
+ ,test_hive_386 string
+ ,test_hive_409 string
+ ,test_hive_390 string
+ ,test_hive_381 string
+ ,test_hive_380 string
+ ,test_hive_382 string
+ ,test_hive_382_txt string
+ ,test_hive_410 string
+ ,test_hive_391 string
+ ,test_hive_403 string
+ ,test_hive_388 string
+ ,test_hive_405 string
+ ,test_hive_389 string
+ ,test_hive_393 string
+ ,test_hive_376 string
+ ,test_hive_394 string
+ ,test_hive_377 string
+ ,test_hive_395 string
+ ,test_hive_378 string
+ ,test_hive_406 string
+ ,test_hive_1406 string
+ ,test_hive_404 string
+ ,test_hive_1405 string
+ ,test_hive_396 string
+ ,test_hive_1403 string
+ ,test_hive_402 string
+ ,test_hive_1404 string
+ ,test_hive_398 string
+ ,test_hive_384 string
+ ,test_hive_399 string
+ ,test_hive_385 string
+ ,test_hive_411 string
+ ,test_hive_392 string
+ ,test_hive_401 string
+ ,test_hive_387 string
+ ,test_hive_1396 string
+)
+partitioned by (ds int, ts int)
+row format delimited fields terminated by '31'
+tblproperties('serialization.null.format' = '');
+
+
+create table if not exists test_hive_1400
+(
+ test_hive_1394 string
+ ,test_hive_1383 string
+ ,test_hive_1395 string
+ ,test_hive_1382 string
+ ,test_hive_407 string
+ ,test_hive_397 string
+ ,test_hive_379 string
+ ,test_hive_408 string
+ ,test_hive_1384 string
+ ,test_hive_1385 string
+ ,test_hive_1386 string
+ ,test_hive_1387 string
+ ,test_hive_1388 string
+ ,test_hive_1389 string
+ ,test_hive_1390 string
+ ,test_hive_1391 string
+ ,test_hive_1392 string
+ ,test_hive_1393 string
+ ,test_hive_400 string
+ ,test_hive_386 string
+ ,test_hive_409 string
+ ,test_hive_390 string
+ ,test_hive_381 string
+ ,test_hive_380 string
+ ,test_hive_382 string
+ ,test_hive_382_txt string
+ ,test_hive_410 string
+ ,test_hive_391 string
+ ,test_hive_403 string
+ ,test_hive_388 string
+ ,test_hive_405 string
+ ,test_hive_389 string
+ ,test_hive_393 string
+ ,test_hive_376 string
+ ,test_hive_394 string
+ ,test_hive_377 string
+ ,test_hive_395 string
+ ,test_hive_378 string
+ ,test_hive_406 string
+ ,test_hive_1406 string
+ ,test_hive_404 string
+ ,test_hive_1405 string
+ ,test_hive_396 string
+ ,test_hive_1403 string
+ ,test_hive_402 string
+ ,test_hive_1404 string
+ ,test_hive_398 string
+ ,test_hive_384 string
+ ,test_hive_399 string
+ ,test_hive_385 string
+ ,test_hive_411 string
+ ,test_hive_392 string
+ ,test_hive_401 string
+ ,test_hive_387 string
+ ,test_hive_1396 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1399 purge;
+
+create table if not exists test_hive_1399
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1402;
+
+create view if not exists test_hive_1402
+as
+select
+ cast(test_hive_1394 as int) as test_hive_1394
+ ,cast(test_hive_1383 as int) as test_hive_1383
+ ,cast(test_hive_1395 as int) as test_hive_1395
+ ,cast(test_hive_1382 as string) as test_hive_1382
+ ,cast(test_hive_407 as string) as test_hive_407
+ ,cast(test_hive_397 as string) as test_hive_397
+ ,cast(test_hive_379 as string) as test_hive_379
+ ,cast(test_hive_408 as string) as test_hive_408
+ ,cast(test_hive_1384 as int) as test_hive_1384
+ ,cast(test_hive_1385 as int) as test_hive_1385
+ ,cast(test_hive_1386 as int) as test_hive_1386
+ ,cast(test_hive_1387 as int) as test_hive_1387
+ ,cast(test_hive_1388 as int) as test_hive_1388
+ ,cast(test_hive_1389 as double) as test_hive_1389
+ ,cast(test_hive_1390 as double) as test_hive_1390
+ ,cast(test_hive_1391 as int) as test_hive_1391
+ ,cast(test_hive_1392 as int) as test_hive_1392
+ ,cast(test_hive_1393 as int) as test_hive_1393
+ ,cast(test_hive_400 as string) as test_hive_400
+ ,cast(test_hive_386 as string) as test_hive_386
+ ,cast(test_hive_409 as string) as test_hive_409
+ ,cast(test_hive_390 as string) as test_hive_390
+ ,cast(from_unixtime(unix_timestamp(test_hive_381,'yyyymmdd'), 'yyyy-mm-dd') as timestamp) as test_hive_381
+ ,cast(test_hive_380 as string) as test_hive_380
+ ,cast(test_hive_382 as string) as test_hive_382
+ ,cast(test_hive_382_txt as string) as test_hive_382_txt
+ ,cast(test_hive_410 as string) as test_hive_410
+ ,cast(test_hive_391 as string) as test_hive_391
+ ,cast(test_hive_403 as string) as test_hive_403
+ ,cast(test_hive_388 as string) as test_hive_388
+ ,cast(test_hive_405 as string) as test_hive_405
+ ,cast(test_hive_389 as string) as test_hive_389
+ ,cast(test_hive_393 as string) as test_hive_393
+ ,cast(test_hive_376 as string) as test_hive_376
+ ,cast(test_hive_394 as string) as test_hive_394
+ ,cast(test_hive_377 as string) as test_hive_377
+ ,cast(test_hive_395 as string) as test_hive_395
+ ,cast(test_hive_378 as string) as test_hive_378
+ ,cast(test_hive_406 as string) as test_hive_406
+ ,cast(test_hive_1406 as string) as test_hive_1406
+ ,cast(test_hive_404 as string) as test_hive_404
+ ,cast(test_hive_1405 as string) as test_hive_1405
+ ,cast(test_hive_396 as string) as test_hive_396
+ ,cast(test_hive_1403 as string) as test_hive_1403
+ ,cast(test_hive_402 as string) as test_hive_402
+ ,cast(test_hive_1404 as string) as test_hive_1404
+ ,cast(test_hive_398 as string) as test_hive_398
+ ,cast(test_hive_384 as string) as test_hive_384
+ ,cast(test_hive_399 as string) as test_hive_399
+ ,cast(test_hive_385 as string) as test_hive_385
+ ,cast(test_hive_411 as string) as test_hive_411
+ ,cast(test_hive_392 as string) as test_hive_392
+ ,cast(test_hive_401 as string) as test_hive_401
+ ,cast(test_hive_387 as string) as test_hive_387
+ ,cast(from_unixtime(unix_timestamp(test_hive_1396,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1396
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1400
+;
+
+drop view if exists test_hive_1401;
+
+create view test_hive_1401
+as
+select
+ test_hive_1394 as test_hive_1394
+ ,test_hive_1383 as test_hive_1383
+ ,test_hive_1395 as test_hive_1395
+ ,test_hive_1382 as test_hive_1382
+ ,test_hive_407 as test_hive_407
+ ,test_hive_397 as test_hive_397
+ ,test_hive_379 as test_hive_379
+ ,test_hive_408 as test_hive_408
+ ,test_hive_1384 as test_hive_1384
+ ,test_hive_1385 as test_hive_1385
+ ,test_hive_1386 as test_hive_1386
+ ,test_hive_1387 as test_hive_1387
+ ,test_hive_1388 as test_hive_1388
+ ,test_hive_1389 as test_hive_1389
+ ,test_hive_1390 as test_hive_1390
+ ,test_hive_1391 as test_hive_1391
+ ,test_hive_1392 as test_hive_1392
+ ,test_hive_1393 as test_hive_1393
+ ,test_hive_400 as test_hive_400
+ ,test_hive_386 as test_hive_386
+ ,test_hive_409 as test_hive_409
+ ,test_hive_390 as test_hive_390
+ ,test_hive_381 as test_hive_381
+ ,test_hive_380 as test_hive_380
+ ,test_hive_382 as test_hive_382
+ ,test_hive_382_txt as test_hive_382_txt
+ ,test_hive_410 as test_hive_410
+ ,test_hive_391 as test_hive_391
+ ,test_hive_403 as test_hive_403
+ ,test_hive_388 as test_hive_388
+ ,test_hive_405 as test_hive_405
+ ,test_hive_389 as test_hive_389
+ ,test_hive_393 as test_hive_393
+ ,test_hive_376 as test_hive_376
+ ,test_hive_394 as test_hive_394
+ ,test_hive_377 as test_hive_377
+ ,test_hive_395 as test_hive_395
+ ,test_hive_378 as test_hive_378
+ ,test_hive_406 as test_hive_406
+ ,test_hive_1406 as test_hive_1406
+ ,test_hive_404 as test_hive_404
+ ,test_hive_1405 as test_hive_1405
+ ,test_hive_396 as test_hive_396
+ ,test_hive_1403 as test_hive_1403
+ ,test_hive_402 as test_hive_402
+ ,test_hive_1404 as test_hive_1404
+ ,test_hive_398 as test_hive_398
+ ,test_hive_384 as test_hive_384
+ ,test_hive_399 as test_hive_399
+ ,test_hive_385 as test_hive_385
+ ,test_hive_411 as test_hive_411
+ ,test_hive_392 as test_hive_392
+ ,test_hive_401 as test_hive_401
+ ,test_hive_387 as test_hive_387
+ ,test_hive_1396 as test_hive_1396
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1402 t1
+;
+
+drop view if exists test_hive_1398;
+
+create view test_hive_1398
+as
+select t1.*
+from test_hive_1401 t1
+inner join test_hive_1399 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1417 purge;
+
+create table test_hive_1417
+(
+ test_hive_1411 string
+ ,test_hive_1407 string
+ ,test_hive_1412 string
+ ,test_hive_412 string
+ ,test_hive_1410 string
+ ,test_hive_1409 string
+ ,test_hive_1408 string
+ ,test_hive_1415 string
+ ,test_hive_1414 string
+ ,test_hive_1413 string
+ ,test_hive_1416 string
+)
+partitioned by (ds int, ts int)
+row format delimited fields terminated by '31'
+tblproperties('serialization.null.format' = '');
+
+
+create table if not exists test_hive_1420
+(
+ test_hive_1411 string
+ ,test_hive_1407 string
+ ,test_hive_1412 string
+ ,test_hive_412 string
+ ,test_hive_1410 string
+ ,test_hive_1409 string
+ ,test_hive_1408 string
+ ,test_hive_1415 string
+ ,test_hive_1414 string
+ ,test_hive_1413 string
+ ,test_hive_1416 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1419 purge;
+
+create table if not exists test_hive_1419
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1422;
+
+create view if not exists test_hive_1422
+as
+select
+ cast(test_hive_1411 as int) as test_hive_1411
+ ,cast(test_hive_1407 as int) as test_hive_1407
+ ,cast(test_hive_1412 as int) as test_hive_1412
+ ,cast(test_hive_412 as string) as test_hive_412
+ ,cast(test_hive_1410 as string) as test_hive_1410
+ ,cast(from_unixtime(unix_timestamp(test_hive_1409,'yyyymmdd'), 'yyyy-mm-dd') as timestamp) as test_hive_1409
+ ,cast(from_unixtime(unix_timestamp(test_hive_1408,'yyyymmdd'), 'yyyy-mm-dd') as timestamp) as test_hive_1408
+ ,cast(test_hive_1415 as string) as test_hive_1415
+ ,cast(test_hive_1414 as string) as test_hive_1414
+ ,cast(test_hive_1413 as string) as test_hive_1413
+ ,cast(from_unixtime(unix_timestamp(test_hive_1416,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1416
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1420
+;
+
+drop view if exists test_hive_1421;
+
+create view test_hive_1421
+as
+select
+ test_hive_1411 as test_hive_1411
+ ,test_hive_1407 as test_hive_1407
+ ,test_hive_1412 as test_hive_1412
+ ,test_hive_412 as test_hive_412
+ ,test_hive_1410 as test_hive_1410
+ ,test_hive_1409 as test_hive_1409
+ ,test_hive_1408 as test_hive_1408
+ ,test_hive_1415 as test_hive_1415
+ ,test_hive_1414 as test_hive_1414
+ ,test_hive_1413 as test_hive_1413
+ ,test_hive_1416 as test_hive_1416
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1422 t1
+;
+
+drop view if exists test_hive_1418;
+
+create view test_hive_1418
+as
+select t1.*
+from test_hive_1421 t1
+inner join test_hive_1419 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1114 purge;
+
+create table test_hive_1114
+(
+ test_hive_1108 string
+ ,test_hive_1106 string
+ ,test_hive_1109 string
+ ,test_hive_272 string
+ ,test_hive_1107 string
+ ,test_hive_1112 string
+ ,test_hive_1111 string
+ ,test_hive_1110 string
+ ,test_hive_1113 string
+)
+partitioned by (ds int, ts int)
+row format delimited fields terminated by '31'
+tblproperties('serialization.null.format' = '');
+
+
+create table if not exists test_hive_1117
+(
+ test_hive_1108 string
+ ,test_hive_1106 string
+ ,test_hive_1109 string
+ ,test_hive_272 string
+ ,test_hive_1107 string
+ ,test_hive_1112 string
+ ,test_hive_1111 string
+ ,test_hive_1110 string
+ ,test_hive_1113 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1116 purge;
+
+create table if not exists test_hive_1116
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1119;
+
+create view if not exists test_hive_1119
+as
+select
+ cast(test_hive_1108 as int) as test_hive_1108
+ ,cast(test_hive_1106 as int) as test_hive_1106
+ ,cast(test_hive_1109 as int) as test_hive_1109
+ ,cast(test_hive_272 as string) as test_hive_272
+ ,cast(test_hive_1107 as string) as test_hive_1107
+ ,cast(test_hive_1112 as string) as test_hive_1112
+ ,cast(test_hive_1111 as string) as test_hive_1111
+ ,cast(test_hive_1110 as string) as test_hive_1110
+ ,cast(from_unixtime(unix_timestamp(test_hive_1113,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1113
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1117
+;
+
+drop view if exists test_hive_1118;
+
+create view test_hive_1118
+as
+select
+ test_hive_1108 as test_hive_1108
+ ,test_hive_1106 as test_hive_1106
+ ,test_hive_1109 as test_hive_1109
+ ,test_hive_272 as test_hive_272
+ ,test_hive_1107 as test_hive_1107
+ ,test_hive_1112 as test_hive_1112
+ ,test_hive_1111 as test_hive_1111
+ ,test_hive_1110 as test_hive_1110
+ ,test_hive_1113 as test_hive_1113
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1119 t1
+;
+
+drop view if exists test_hive_1115;
+
+create view test_hive_1115
+as
+select t1.*
+from test_hive_1118 t1
+inner join test_hive_1116 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1128 purge;
+
+create table test_hive_1128
+(
+ test_hive_1122 string
+ ,test_hive_1120 string
+ ,test_hive_1123 string
+ ,test_hive_273 string
+ ,test_hive_1121 string
+ ,test_hive_1126 string
+ ,test_hive_1125 string
+ ,test_hive_1124 string
+ ,test_hive_1127 string
+)
+partitioned by (ds int, ts int)
+row format delimited fields terminated by '31'
+tblproperties('serialization.null.format' = '');
+
+
+create table if not exists test_hive_1131
+(
+ test_hive_1122 string
+ ,test_hive_1120 string
+ ,test_hive_1123 string
+ ,test_hive_273 string
+ ,test_hive_1121 string
+ ,test_hive_1126 string
+ ,test_hive_1125 string
+ ,test_hive_1124 string
+ ,test_hive_1127 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1130 purge;
+
+create table if not exists test_hive_1130
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1133;
+
+create view if not exists test_hive_1133
+as
+select
+ cast(test_hive_1122 as int) as test_hive_1122
+ ,cast(test_hive_1120 as int) as test_hive_1120
+ ,cast(test_hive_1123 as int) as test_hive_1123
+ ,cast(test_hive_273 as string) as test_hive_273
+ ,cast(test_hive_1121 as string) as test_hive_1121
+ ,cast(test_hive_1126 as string) as test_hive_1126
+ ,cast(test_hive_1125 as string) as test_hive_1125
+ ,cast(test_hive_1124 as string) as test_hive_1124
+ ,cast(from_unixtime(unix_timestamp(test_hive_1127,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1127
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1131
+;
+
+drop view if exists test_hive_1132;
+
+create view test_hive_1132
+as
+select
+ test_hive_1122 as test_hive_1122
+ ,test_hive_1120 as test_hive_1120
+ ,test_hive_1123 as test_hive_1123
+ ,test_hive_273 as test_hive_273
+ ,test_hive_1121 as test_hive_1121
+ ,test_hive_1126 as test_hive_1126
+ ,test_hive_1125 as test_hive_1125
+ ,test_hive_1124 as test_hive_1124
+ ,test_hive_1127 as test_hive_1127
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1133 t1
+;
+
+drop view if exists test_hive_1129;
+
+create view test_hive_1129
+as
+select t1.*
+from test_hive_1132 t1
+inner join test_hive_1130 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1142 purge;
+
+create table test_hive_1142
+(
+ test_hive_1136 string
+ ,test_hive_1134 string
+ ,test_hive_1137 string
+ ,test_hive_274 string
+ ,test_hive_1135 string
+ ,test_hive_1140 string
+ ,test_hive_1139 string
+ ,test_hive_1138 string
+ ,test_hive_1141 string
+)
+partitioned by (ds int, ts int)
+row format delimited fields terminated by '31'
+tblproperties('serialization.null.format' = '');
+
+
+create table if not exists test_hive_1145
+(
+ test_hive_1136 string
+ ,test_hive_1134 string
+ ,test_hive_1137 string
+ ,test_hive_274 string
+ ,test_hive_1135 string
+ ,test_hive_1140 string
+ ,test_hive_1139 string
+ ,test_hive_1138 string
+ ,test_hive_1141 string
+ ,source_file_name string
+ ,creation_date string
+ ,ds_ts bigint
+ ,ts int
+)
+partitioned by (ds int)
+stored as parquet;
+
+drop table if exists test_hive_1144 purge;
+
+create table if not exists test_hive_1144
+(
+max_partition bigint
+);
+
+drop view if exists test_hive_1147;
+
+create view if not exists test_hive_1147
+as
+select
+ cast(test_hive_1136 as int) as test_hive_1136
+ ,cast(test_hive_1134 as int) as test_hive_1134
+ ,cast(test_hive_1137 as int) as test_hive_1137
+ ,cast(test_hive_274 as string) as test_hive_274
+ ,cast(test_hive_1135 as string) as test_hive_1135
+ ,cast(test_hive_1140 as string) as test_hive_1140
+ ,cast(test_hive_1139 as string) as test_hive_1139
+ ,cast(test_hive_1138 as string) as test_hive_1138
+ ,cast(from_unixtime(unix_timestamp(test_hive_1141,'yyyymmddhhmmss'), 'yyyy-mm-dd hh:mm:ss') as timestamp) as test_hive_1141
+ ,source_file_name
+ ,cast(creation_date as timestamp) as creation_date
+ ,ds_ts
+ ,cast(ds as bigint) as ds
+ ,cast(ts as bigint) as ts
+from test_hive_1145
+;
+
+drop view if exists test_hive_1146;
+
+create view test_hive_1146
+as
+select
+ test_hive_1136 as test_hive_1136
+ ,test_hive_1134 as test_hive_1134
+ ,test_hive_1137 as test_hive_1137
+ ,test_hive_274 as test_hive_274
+ ,test_hive_1135 as test_hive_1135
+ ,test_hive_1140 as test_hive_1140
+ ,test_hive_1139 as test_hive_1139
+ ,test_hive_1138 as test_hive_1138
+ ,test_hive_1141 as test_hive_1141
+ ,source_file_name
+ ,creation_date
+ ,ds_ts
+ ,ts
+ ,ds
+from test_hive_1147 t1
+;
+
+drop view if exists test_hive_1143;
+
+create view test_hive_1143
+as
+select t1.*
+from test_hive_1146 t1
+inner join test_hive_1144 t2 on
+t1.ds_ts = t2.max_partition;
+drop table if exists test_hive_1158 purge;
+
+create table test_hive_1158
+(
+ test_hive_1152 string
+ ,test_hive_1148 string
+ ,test_hive_1153 string
+ ,test_hive_275 string
+ ,test_hive_1151 string
+ ,test_hive_1150 string
+ ,test_hive_1149 string
+ ,test_hive_1156 string
+ ,test_hive_1155 string
+ ,test_hive_1154 string
+ ,test_h
<TRUNCATED>