Repository: hive Updated Branches: refs/heads/master 10f4eadd5 -> 7ae4a2c81
HIVE-20833: package.jdo needs to be updated to conform with HIVE-20221 changes (Vineet Garg, reviewed by Jason Dere) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/7ae4a2c8 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/7ae4a2c8 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/7ae4a2c8 Branch: refs/heads/master Commit: 7ae4a2c81a7a3a22ab2df2c5f75638e3f5e580f0 Parents: 10f4ead Author: Vineet Garg <vg...@apache.org> Authored: Fri Nov 9 14:11:51 2018 -0800 Committer: Vineet Garg <vg...@apache.org> Committed: Fri Nov 9 14:11:51 2018 -0800 ---------------------------------------------------------------------- .../test/resources/testconfiguration.properties | 1 + .../clientpositive/alter_partition_change_col.q | 169 +++ .../alter_partition_change_col.q.out | 343 ++++++ .../llap/alter_partition_change_col.q.out | 1111 ++++++++++++++++++ .../hive/metastore/MetastoreDirectSqlUtils.java | 4 +- .../hadoop/hive/metastore/txn/TxnDbUtil.java | 2 +- .../src/main/resources/package.jdo | 2 +- 7 files changed, 1628 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/7ae4a2c8/itests/src/test/resources/testconfiguration.properties ---------------------------------------------------------------------- diff --git a/itests/src/test/resources/testconfiguration.properties b/itests/src/test/resources/testconfiguration.properties index eeca1c9..ab60213 100644 --- a/itests/src/test/resources/testconfiguration.properties +++ b/itests/src/test/resources/testconfiguration.properties @@ -432,6 +432,7 @@ minillaplocal.query.files=\ acid_vectorization_missing_cols.q,\ acid_vectorization_original.q,\ alter_merge_stats_orc.q,\ + alter_partition_change_col,\ authorization_view_8.q,\ auto_join30.q,\ auto_join_filters.q,\ http://git-wip-us.apache.org/repos/asf/hive/blob/7ae4a2c8/ql/src/test/queries/clientpositive/alter_partition_change_col.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/alter_partition_change_col.q b/ql/src/test/queries/clientpositive/alter_partition_change_col.q index fe95176..c207731 100644 --- a/ql/src/test/queries/clientpositive/alter_partition_change_col.q +++ b/ql/src/test/queries/clientpositive/alter_partition_change_col.q @@ -79,3 +79,172 @@ describe alter_partition_change_col1 partition (p1='abc', p2='123'); describe alter_partition_change_col1 partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123'); select * from alter_partition_change_col1 where p1='abc'; select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__'; + +CREATE TABLE `alterPartTbl`( +col_1col_1col_1col_1col_1col_11 string, +col_1col_1col_1col_1col_1col_12 string, +col_1col_1col_1col_1col_1col_13 string, +col_1col_1col_1col_1col_1col_14 string, +col_1col_1col_1col_1col_1col_15 string, +col_1col_1col_1col_1col_1col_16 string, +col_1col_1col_1col_1col_1col_17 string, +col_1col_1col_1col_1col_1col_18 string, +col_1col_1col_1col_1col_1col_19 string, +col_1col_1col_1col_1col_1col_110 string, +col_1col_1col_1col_1col_1col_111 string, +col_1col_1col_1col_1col_1col_112 string, +col_1col_1col_1col_1col_1col_113 string, +col_1col_1col_1col_1col_1col_114 string, +col_1col_1col_1col_1col_1col_115 string, +col_1col_1col_1col_1col_1col_116 string, +col_1col_1col_1col_1col_1col_117 string, +col_1col_1col_1col_1col_1col_118 string, +col_1col_1col_1col_1col_1col_119 string, +col_1col_1col_1col_1col_1col_120 string, +col_1col_1col_1col_1col_1col_121 string, +col_1col_1col_1col_1col_1col_122 string, +col_1col_1col_1col_1col_1col_123 string, +col_1col_1col_1col_1col_1col_124 string, +col_1col_1col_1col_1col_1col_125 string, +col_1col_1col_1col_1col_1col_126 string, +col_1col_1col_1col_1col_1col_127 string, +col_1col_1col_1col_1col_1col_128 string, +col_1col_1col_1col_1col_1col_129 string, +col_1col_1col_1col_1col_1col_130 string, +col_1col_1col_1col_1col_1col_131 string, +col_1col_1col_1col_1col_1col_132 string, +col_1col_1col_1col_1col_1col_133 string, +col_1col_1col_1col_1col_1col_134 string, +col_1col_1col_1col_1col_1col_135 string, +col_1col_1col_1col_1col_1col_136 string, +col_1col_1col_1col_1col_1col_137 string, +col_1col_1col_1col_1col_1col_138 string, +col_1col_1col_1col_1col_1col_139 string, +col_1col_1col_1col_1col_1col_140 string, +col_1col_1col_1col_1col_1col_141 string, +col_1col_1col_1col_1col_1col_142 string, +col_1col_1col_1col_1col_1col_143 string, +col_1col_1col_1col_1col_1col_144 string, +col_1col_1col_1col_1col_1col_145 string, +col_1col_1col_1col_1col_1col_146 string, +col_1col_1col_1col_1col_1col_147 string, +col_1col_1col_1col_1col_1col_148 string, +col_1col_1col_1col_1col_1col_149 string, +col_1col_1col_1col_1col_1col_150 string, +col_1col_1col_1col_1col_1col_151 string, +col_1col_1col_1col_1col_1col_152 string, +col_1col_1col_1col_1col_1col_153 string, +col_1col_1col_1col_1col_1col_154 string, +col_1col_1col_1col_1col_1col_155 string, +col_1col_1col_1col_1col_1col_156 string, +col_1col_1col_1col_1col_1col_157 string, +col_1col_1col_1col_1col_1col_158 string, +col_1col_1col_1col_1col_1col_159 string, +col_1col_1col_1col_1col_1col_160 string, +col_1col_1col_1col_1col_1col_161 string, +col_1col_1col_1col_1col_1col_162 string, +col_1col_1col_1col_1col_1col_163 string, +col_1col_1col_1col_1col_1col_164 string, +col_1col_1col_1col_1col_1col_165 string, +col_1col_1col_1col_1col_1col_166 string, +col_1col_1col_1col_1col_1col_167 string, +col_1col_1col_1col_1col_1col_168 string, +col_1col_1col_1col_1col_1col_169 string, +col_1col_1col_1col_1col_1col_170 string, +col_1col_1col_1col_1col_1col_171 string, +col_1col_1col_1col_1col_1col_172 string, +col_1col_1col_1col_1col_1col_173 string, +col_1col_1col_1col_1col_1col_174 string, +col_1col_1col_1col_1col_1col_175 string, +col_1col_1col_1col_1col_1col_176 string, +col_1col_1col_1col_1col_1col_177 string, +col_1col_1col_1col_1col_1col_178 string, +col_1col_1col_1col_1col_1col_179 string, +col_1col_1col_1col_1col_1col_180 string, +col_1col_1col_1col_1col_1col_181 string, +col_1col_1col_1col_1col_1col_182 string, +col_1col_1col_1col_1col_1col_183 string, +col_1col_1col_1col_1col_1col_184 string, +col_1col_1col_1col_1col_1col_185 string, +col_1col_1col_1col_1col_1col_186 string, +col_1col_1col_1col_1col_1col_187 string, +col_1col_1col_1col_1col_1col_188 string, +col_1col_1col_1col_1col_1col_189 string, +col_1col_1col_1col_1col_1col_190 string, +col_1col_1col_1col_1col_1col_191 string, +col_1col_1col_1col_1col_1col_192 string, +col_1col_1col_1col_1col_1col_193 string, +col_1col_1col_1col_1col_1col_194 string, +col_1col_1col_1col_1col_1col_195 string, +col_1col_1col_1col_1col_1col_196 string, +col_1col_1col_1col_1col_1col_197 string, +col_1col_1col_1col_1col_1col_198 string, +col_1col_1col_1col_1col_1col_199 string, +col_1col_1col_1col_1col_1col_1100 string, +col_1col_1col_1col_1col_1col_1101 string, +col_1col_1col_1col_1col_1col_1102 string, +col_1col_1col_1col_1col_1col_1103 string, +col_1col_1col_1col_1col_1col_1104 string, +col_1col_1col_1col_1col_1col_1105 string, +col_1col_1col_1col_1col_1col_1106 string, +col_1col_1col_1col_1col_1col_1107 string, +col_1col_1col_1col_1col_1col_1108 string, +col_1col_1col_1col_1col_1col_1109 string, +col_1col_1col_1col_1col_1col_1110 string, +col_1col_1col_1col_1col_1col_1111 string, +col_1col_1col_1col_1col_1col_1112 string, +col_1col_1col_1col_1col_1col_1113 string, +col_1col_1col_1col_1col_1col_1114 string, +col_1col_1col_1col_1col_1col_1115 string, +col_1col_1col_1col_1col_1col_1116 string, +col_1col_1col_1col_1col_1col_1117 string, +col_1col_1col_1col_1col_1col_1118 string, +col_1col_1col_1col_1col_1col_1119 string, +col_1col_1col_1col_1col_1col_1120 string, +col_1col_1col_1col_1col_1col_1121 string, +col_1col_1col_1col_1col_1col_1122 string, +col_1col_1col_1col_1col_1col_1123 string, +col_1col_1col_1col_1col_1col_1124 string, +col_1col_1col_1col_1col_1col_1125 string, +col_1col_1col_1col_1col_1col_1126 string, +col_1col_1col_1col_1col_1col_1127 string, +col_1col_1col_1col_1col_1col_1128 string, +col_1col_1col_1col_1col_1col_1129 string, +col_1col_1col_1col_1col_1col_1130 string, +col_1col_1col_1col_1col_1col_1131 string, +col_1col_1col_1col_1col_1col_1132 string, +col_1col_1col_1col_1col_1col_1133 string, +col_1col_1col_1col_1col_1col_1134 string, +col_1col_1col_1col_1col_1col_1135 string, +col_1col_1col_1col_1col_1col_1136 string, +col_1col_1col_1col_1col_1col_1137 string, +col_1col_1col_1col_1col_1col_1138 string, +col_1col_1col_1col_1col_1col_1139 string, +col_1col_1col_1col_1col_1col_1140 string, +col_1col_1col_1col_1col_1col_1141 string, +col_1col_1col_1col_1col_1col_1142 string, +col_1col_1col_1col_1col_1col_1143 string, +col_1col_1col_1col_1col_1col_1144 string, +col_1col_1col_1col_1col_1col_1145 string, +col_1col_1col_1col_1col_1col_1146 string, +col_1col_1col_1col_1col_1col_1147 string, +col_1col_1col_1col_1col_1col_1148 string, +col_1col_1col_1col_1col_1col_1149 string, +col_1col_1col_1col_1col_1col_1150 string, +col_1col_1col_1col_1col_1col_1151 string, +col_1col_1col_1col_1col_1col_1152 string, +col_1col_1col_1col_1col_1col_1153 string, +col_1col_1col_1col_1col_1col_1154 string, +col_1col_1col_1col_1col_1col_1155 string, +col_1col_1col_1col_1col_1col_1156 string, +col_1col_1col_1col_1col_1col_1157 string, +col_1col_1col_1col_1col_1col_1158 string) + PARTITIONED BY ( + `partition_col` string); + +alter table alterPartTbl add partition(partition_col='CCL'); + +drop table alterPartTbl; + + + http://git-wip-us.apache.org/repos/asf/hive/blob/7ae4a2c8/ql/src/test/results/clientpositive/alter_partition_change_col.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/alter_partition_change_col.q.out b/ql/src/test/results/clientpositive/alter_partition_change_col.q.out index 7e2864b..d330026 100644 --- a/ql/src/test/results/clientpositive/alter_partition_change_col.q.out +++ b/ql/src/test/results/clientpositive/alter_partition_change_col.q.out @@ -766,3 +766,346 @@ Snow 56.0000 __HIVE_DEFAULT_PARTITION__ 123 Tom -12.0000 __HIVE_DEFAULT_PARTITION__ 123 Tom 19.0000 __HIVE_DEFAULT_PARTITION__ 123 Tom 235.0000 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: CREATE TABLE `alterPartTbl`( +col_1col_1col_1col_1col_1col_11 string, +col_1col_1col_1col_1col_1col_12 string, +col_1col_1col_1col_1col_1col_13 string, +col_1col_1col_1col_1col_1col_14 string, +col_1col_1col_1col_1col_1col_15 string, +col_1col_1col_1col_1col_1col_16 string, +col_1col_1col_1col_1col_1col_17 string, +col_1col_1col_1col_1col_1col_18 string, +col_1col_1col_1col_1col_1col_19 string, +col_1col_1col_1col_1col_1col_110 string, +col_1col_1col_1col_1col_1col_111 string, +col_1col_1col_1col_1col_1col_112 string, +col_1col_1col_1col_1col_1col_113 string, +col_1col_1col_1col_1col_1col_114 string, +col_1col_1col_1col_1col_1col_115 string, +col_1col_1col_1col_1col_1col_116 string, +col_1col_1col_1col_1col_1col_117 string, +col_1col_1col_1col_1col_1col_118 string, +col_1col_1col_1col_1col_1col_119 string, +col_1col_1col_1col_1col_1col_120 string, +col_1col_1col_1col_1col_1col_121 string, +col_1col_1col_1col_1col_1col_122 string, +col_1col_1col_1col_1col_1col_123 string, +col_1col_1col_1col_1col_1col_124 string, +col_1col_1col_1col_1col_1col_125 string, +col_1col_1col_1col_1col_1col_126 string, +col_1col_1col_1col_1col_1col_127 string, +col_1col_1col_1col_1col_1col_128 string, +col_1col_1col_1col_1col_1col_129 string, +col_1col_1col_1col_1col_1col_130 string, +col_1col_1col_1col_1col_1col_131 string, +col_1col_1col_1col_1col_1col_132 string, +col_1col_1col_1col_1col_1col_133 string, +col_1col_1col_1col_1col_1col_134 string, +col_1col_1col_1col_1col_1col_135 string, +col_1col_1col_1col_1col_1col_136 string, +col_1col_1col_1col_1col_1col_137 string, +col_1col_1col_1col_1col_1col_138 string, +col_1col_1col_1col_1col_1col_139 string, +col_1col_1col_1col_1col_1col_140 string, +col_1col_1col_1col_1col_1col_141 string, +col_1col_1col_1col_1col_1col_142 string, +col_1col_1col_1col_1col_1col_143 string, +col_1col_1col_1col_1col_1col_144 string, +col_1col_1col_1col_1col_1col_145 string, +col_1col_1col_1col_1col_1col_146 string, +col_1col_1col_1col_1col_1col_147 string, +col_1col_1col_1col_1col_1col_148 string, +col_1col_1col_1col_1col_1col_149 string, +col_1col_1col_1col_1col_1col_150 string, +col_1col_1col_1col_1col_1col_151 string, +col_1col_1col_1col_1col_1col_152 string, +col_1col_1col_1col_1col_1col_153 string, +col_1col_1col_1col_1col_1col_154 string, +col_1col_1col_1col_1col_1col_155 string, +col_1col_1col_1col_1col_1col_156 string, +col_1col_1col_1col_1col_1col_157 string, +col_1col_1col_1col_1col_1col_158 string, +col_1col_1col_1col_1col_1col_159 string, +col_1col_1col_1col_1col_1col_160 string, +col_1col_1col_1col_1col_1col_161 string, +col_1col_1col_1col_1col_1col_162 string, +col_1col_1col_1col_1col_1col_163 string, +col_1col_1col_1col_1col_1col_164 string, +col_1col_1col_1col_1col_1col_165 string, +col_1col_1col_1col_1col_1col_166 string, +col_1col_1col_1col_1col_1col_167 string, +col_1col_1col_1col_1col_1col_168 string, +col_1col_1col_1col_1col_1col_169 string, +col_1col_1col_1col_1col_1col_170 string, +col_1col_1col_1col_1col_1col_171 string, +col_1col_1col_1col_1col_1col_172 string, +col_1col_1col_1col_1col_1col_173 string, +col_1col_1col_1col_1col_1col_174 string, +col_1col_1col_1col_1col_1col_175 string, +col_1col_1col_1col_1col_1col_176 string, +col_1col_1col_1col_1col_1col_177 string, +col_1col_1col_1col_1col_1col_178 string, +col_1col_1col_1col_1col_1col_179 string, +col_1col_1col_1col_1col_1col_180 string, +col_1col_1col_1col_1col_1col_181 string, +col_1col_1col_1col_1col_1col_182 string, +col_1col_1col_1col_1col_1col_183 string, +col_1col_1col_1col_1col_1col_184 string, +col_1col_1col_1col_1col_1col_185 string, +col_1col_1col_1col_1col_1col_186 string, +col_1col_1col_1col_1col_1col_187 string, +col_1col_1col_1col_1col_1col_188 string, +col_1col_1col_1col_1col_1col_189 string, +col_1col_1col_1col_1col_1col_190 string, +col_1col_1col_1col_1col_1col_191 string, +col_1col_1col_1col_1col_1col_192 string, +col_1col_1col_1col_1col_1col_193 string, +col_1col_1col_1col_1col_1col_194 string, +col_1col_1col_1col_1col_1col_195 string, +col_1col_1col_1col_1col_1col_196 string, +col_1col_1col_1col_1col_1col_197 string, +col_1col_1col_1col_1col_1col_198 string, +col_1col_1col_1col_1col_1col_199 string, +col_1col_1col_1col_1col_1col_1100 string, +col_1col_1col_1col_1col_1col_1101 string, +col_1col_1col_1col_1col_1col_1102 string, +col_1col_1col_1col_1col_1col_1103 string, +col_1col_1col_1col_1col_1col_1104 string, +col_1col_1col_1col_1col_1col_1105 string, +col_1col_1col_1col_1col_1col_1106 string, +col_1col_1col_1col_1col_1col_1107 string, +col_1col_1col_1col_1col_1col_1108 string, +col_1col_1col_1col_1col_1col_1109 string, +col_1col_1col_1col_1col_1col_1110 string, +col_1col_1col_1col_1col_1col_1111 string, +col_1col_1col_1col_1col_1col_1112 string, +col_1col_1col_1col_1col_1col_1113 string, +col_1col_1col_1col_1col_1col_1114 string, +col_1col_1col_1col_1col_1col_1115 string, +col_1col_1col_1col_1col_1col_1116 string, +col_1col_1col_1col_1col_1col_1117 string, +col_1col_1col_1col_1col_1col_1118 string, +col_1col_1col_1col_1col_1col_1119 string, +col_1col_1col_1col_1col_1col_1120 string, +col_1col_1col_1col_1col_1col_1121 string, +col_1col_1col_1col_1col_1col_1122 string, +col_1col_1col_1col_1col_1col_1123 string, +col_1col_1col_1col_1col_1col_1124 string, +col_1col_1col_1col_1col_1col_1125 string, +col_1col_1col_1col_1col_1col_1126 string, +col_1col_1col_1col_1col_1col_1127 string, +col_1col_1col_1col_1col_1col_1128 string, +col_1col_1col_1col_1col_1col_1129 string, +col_1col_1col_1col_1col_1col_1130 string, +col_1col_1col_1col_1col_1col_1131 string, +col_1col_1col_1col_1col_1col_1132 string, +col_1col_1col_1col_1col_1col_1133 string, +col_1col_1col_1col_1col_1col_1134 string, +col_1col_1col_1col_1col_1col_1135 string, +col_1col_1col_1col_1col_1col_1136 string, +col_1col_1col_1col_1col_1col_1137 string, +col_1col_1col_1col_1col_1col_1138 string, +col_1col_1col_1col_1col_1col_1139 string, +col_1col_1col_1col_1col_1col_1140 string, +col_1col_1col_1col_1col_1col_1141 string, +col_1col_1col_1col_1col_1col_1142 string, +col_1col_1col_1col_1col_1col_1143 string, +col_1col_1col_1col_1col_1col_1144 string, +col_1col_1col_1col_1col_1col_1145 string, +col_1col_1col_1col_1col_1col_1146 string, +col_1col_1col_1col_1col_1col_1147 string, +col_1col_1col_1col_1col_1col_1148 string, +col_1col_1col_1col_1col_1col_1149 string, +col_1col_1col_1col_1col_1col_1150 string, +col_1col_1col_1col_1col_1col_1151 string, +col_1col_1col_1col_1col_1col_1152 string, +col_1col_1col_1col_1col_1col_1153 string, +col_1col_1col_1col_1col_1col_1154 string, +col_1col_1col_1col_1col_1col_1155 string, +col_1col_1col_1col_1col_1col_1156 string, +col_1col_1col_1col_1col_1col_1157 string, +col_1col_1col_1col_1col_1col_1158 string) + PARTITIONED BY ( + `partition_col` string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@alterPartTbl +POSTHOOK: query: CREATE TABLE `alterPartTbl`( +col_1col_1col_1col_1col_1col_11 string, +col_1col_1col_1col_1col_1col_12 string, +col_1col_1col_1col_1col_1col_13 string, +col_1col_1col_1col_1col_1col_14 string, +col_1col_1col_1col_1col_1col_15 string, +col_1col_1col_1col_1col_1col_16 string, +col_1col_1col_1col_1col_1col_17 string, +col_1col_1col_1col_1col_1col_18 string, +col_1col_1col_1col_1col_1col_19 string, +col_1col_1col_1col_1col_1col_110 string, +col_1col_1col_1col_1col_1col_111 string, +col_1col_1col_1col_1col_1col_112 string, +col_1col_1col_1col_1col_1col_113 string, +col_1col_1col_1col_1col_1col_114 string, +col_1col_1col_1col_1col_1col_115 string, +col_1col_1col_1col_1col_1col_116 string, +col_1col_1col_1col_1col_1col_117 string, +col_1col_1col_1col_1col_1col_118 string, +col_1col_1col_1col_1col_1col_119 string, +col_1col_1col_1col_1col_1col_120 string, +col_1col_1col_1col_1col_1col_121 string, +col_1col_1col_1col_1col_1col_122 string, +col_1col_1col_1col_1col_1col_123 string, +col_1col_1col_1col_1col_1col_124 string, +col_1col_1col_1col_1col_1col_125 string, +col_1col_1col_1col_1col_1col_126 string, +col_1col_1col_1col_1col_1col_127 string, +col_1col_1col_1col_1col_1col_128 string, +col_1col_1col_1col_1col_1col_129 string, +col_1col_1col_1col_1col_1col_130 string, +col_1col_1col_1col_1col_1col_131 string, +col_1col_1col_1col_1col_1col_132 string, +col_1col_1col_1col_1col_1col_133 string, +col_1col_1col_1col_1col_1col_134 string, +col_1col_1col_1col_1col_1col_135 string, +col_1col_1col_1col_1col_1col_136 string, +col_1col_1col_1col_1col_1col_137 string, +col_1col_1col_1col_1col_1col_138 string, +col_1col_1col_1col_1col_1col_139 string, +col_1col_1col_1col_1col_1col_140 string, +col_1col_1col_1col_1col_1col_141 string, +col_1col_1col_1col_1col_1col_142 string, +col_1col_1col_1col_1col_1col_143 string, +col_1col_1col_1col_1col_1col_144 string, +col_1col_1col_1col_1col_1col_145 string, +col_1col_1col_1col_1col_1col_146 string, +col_1col_1col_1col_1col_1col_147 string, +col_1col_1col_1col_1col_1col_148 string, +col_1col_1col_1col_1col_1col_149 string, +col_1col_1col_1col_1col_1col_150 string, +col_1col_1col_1col_1col_1col_151 string, +col_1col_1col_1col_1col_1col_152 string, +col_1col_1col_1col_1col_1col_153 string, +col_1col_1col_1col_1col_1col_154 string, +col_1col_1col_1col_1col_1col_155 string, +col_1col_1col_1col_1col_1col_156 string, +col_1col_1col_1col_1col_1col_157 string, +col_1col_1col_1col_1col_1col_158 string, +col_1col_1col_1col_1col_1col_159 string, +col_1col_1col_1col_1col_1col_160 string, +col_1col_1col_1col_1col_1col_161 string, +col_1col_1col_1col_1col_1col_162 string, +col_1col_1col_1col_1col_1col_163 string, +col_1col_1col_1col_1col_1col_164 string, +col_1col_1col_1col_1col_1col_165 string, +col_1col_1col_1col_1col_1col_166 string, +col_1col_1col_1col_1col_1col_167 string, +col_1col_1col_1col_1col_1col_168 string, +col_1col_1col_1col_1col_1col_169 string, +col_1col_1col_1col_1col_1col_170 string, +col_1col_1col_1col_1col_1col_171 string, +col_1col_1col_1col_1col_1col_172 string, +col_1col_1col_1col_1col_1col_173 string, +col_1col_1col_1col_1col_1col_174 string, +col_1col_1col_1col_1col_1col_175 string, +col_1col_1col_1col_1col_1col_176 string, +col_1col_1col_1col_1col_1col_177 string, +col_1col_1col_1col_1col_1col_178 string, +col_1col_1col_1col_1col_1col_179 string, +col_1col_1col_1col_1col_1col_180 string, +col_1col_1col_1col_1col_1col_181 string, +col_1col_1col_1col_1col_1col_182 string, +col_1col_1col_1col_1col_1col_183 string, +col_1col_1col_1col_1col_1col_184 string, +col_1col_1col_1col_1col_1col_185 string, +col_1col_1col_1col_1col_1col_186 string, +col_1col_1col_1col_1col_1col_187 string, +col_1col_1col_1col_1col_1col_188 string, +col_1col_1col_1col_1col_1col_189 string, +col_1col_1col_1col_1col_1col_190 string, +col_1col_1col_1col_1col_1col_191 string, +col_1col_1col_1col_1col_1col_192 string, +col_1col_1col_1col_1col_1col_193 string, +col_1col_1col_1col_1col_1col_194 string, +col_1col_1col_1col_1col_1col_195 string, +col_1col_1col_1col_1col_1col_196 string, +col_1col_1col_1col_1col_1col_197 string, +col_1col_1col_1col_1col_1col_198 string, +col_1col_1col_1col_1col_1col_199 string, +col_1col_1col_1col_1col_1col_1100 string, +col_1col_1col_1col_1col_1col_1101 string, +col_1col_1col_1col_1col_1col_1102 string, +col_1col_1col_1col_1col_1col_1103 string, +col_1col_1col_1col_1col_1col_1104 string, +col_1col_1col_1col_1col_1col_1105 string, +col_1col_1col_1col_1col_1col_1106 string, +col_1col_1col_1col_1col_1col_1107 string, +col_1col_1col_1col_1col_1col_1108 string, +col_1col_1col_1col_1col_1col_1109 string, +col_1col_1col_1col_1col_1col_1110 string, +col_1col_1col_1col_1col_1col_1111 string, +col_1col_1col_1col_1col_1col_1112 string, +col_1col_1col_1col_1col_1col_1113 string, +col_1col_1col_1col_1col_1col_1114 string, +col_1col_1col_1col_1col_1col_1115 string, +col_1col_1col_1col_1col_1col_1116 string, +col_1col_1col_1col_1col_1col_1117 string, +col_1col_1col_1col_1col_1col_1118 string, +col_1col_1col_1col_1col_1col_1119 string, +col_1col_1col_1col_1col_1col_1120 string, +col_1col_1col_1col_1col_1col_1121 string, +col_1col_1col_1col_1col_1col_1122 string, +col_1col_1col_1col_1col_1col_1123 string, +col_1col_1col_1col_1col_1col_1124 string, +col_1col_1col_1col_1col_1col_1125 string, +col_1col_1col_1col_1col_1col_1126 string, +col_1col_1col_1col_1col_1col_1127 string, +col_1col_1col_1col_1col_1col_1128 string, +col_1col_1col_1col_1col_1col_1129 string, +col_1col_1col_1col_1col_1col_1130 string, +col_1col_1col_1col_1col_1col_1131 string, +col_1col_1col_1col_1col_1col_1132 string, +col_1col_1col_1col_1col_1col_1133 string, +col_1col_1col_1col_1col_1col_1134 string, +col_1col_1col_1col_1col_1col_1135 string, +col_1col_1col_1col_1col_1col_1136 string, +col_1col_1col_1col_1col_1col_1137 string, +col_1col_1col_1col_1col_1col_1138 string, +col_1col_1col_1col_1col_1col_1139 string, +col_1col_1col_1col_1col_1col_1140 string, +col_1col_1col_1col_1col_1col_1141 string, +col_1col_1col_1col_1col_1col_1142 string, +col_1col_1col_1col_1col_1col_1143 string, +col_1col_1col_1col_1col_1col_1144 string, +col_1col_1col_1col_1col_1col_1145 string, +col_1col_1col_1col_1col_1col_1146 string, +col_1col_1col_1col_1col_1col_1147 string, +col_1col_1col_1col_1col_1col_1148 string, +col_1col_1col_1col_1col_1col_1149 string, +col_1col_1col_1col_1col_1col_1150 string, +col_1col_1col_1col_1col_1col_1151 string, +col_1col_1col_1col_1col_1col_1152 string, +col_1col_1col_1col_1col_1col_1153 string, +col_1col_1col_1col_1col_1col_1154 string, +col_1col_1col_1col_1col_1col_1155 string, +col_1col_1col_1col_1col_1col_1156 string, +col_1col_1col_1col_1col_1col_1157 string, +col_1col_1col_1col_1col_1col_1158 string) + PARTITIONED BY ( + `partition_col` string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@alterPartTbl +PREHOOK: query: alter table alterPartTbl add partition(partition_col='CCL') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Output: default@alterparttbl +POSTHOOK: query: alter table alterPartTbl add partition(partition_col='CCL') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Output: default@alterparttbl +POSTHOOK: Output: default@alterparttbl@partition_col=CCL +PREHOOK: query: drop table alterPartTbl +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@alterparttbl +PREHOOK: Output: default@alterparttbl +POSTHOOK: query: drop table alterPartTbl +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@alterparttbl +POSTHOOK: Output: default@alterparttbl http://git-wip-us.apache.org/repos/asf/hive/blob/7ae4a2c8/ql/src/test/results/clientpositive/llap/alter_partition_change_col.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/alter_partition_change_col.q.out b/ql/src/test/results/clientpositive/llap/alter_partition_change_col.q.out new file mode 100644 index 0000000..d330026 --- /dev/null +++ b/ql/src/test/results/clientpositive/llap/alter_partition_change_col.q.out @@ -0,0 +1,1111 @@ +PREHOOK: query: create table alter_partition_change_col0 (c1 string, c2 string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@alter_partition_change_col0 +POSTHOOK: query: create table alter_partition_change_col0 (c1 string, c2 string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@alter_partition_change_col0 +PREHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_partition_change_col0 +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@alter_partition_change_col0 +POSTHOOK: query: load data local inpath '../../data/files/dec.txt' overwrite into table alter_partition_change_col0 +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@alter_partition_change_col0 +PREHOOK: query: create table alter_partition_change_col1 (c1 string, c2 string) partitioned by (p1 string comment 'Column p1', p2 string comment 'Column p2') +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@alter_partition_change_col1 +POSTHOOK: query: create table alter_partition_change_col1 (c1 string, c2 string) partitioned by (p1 string comment 'Column p1', p2 string comment 'Column p2') +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@alter_partition_change_col1 +PREHOOK: query: insert overwrite table alter_partition_change_col1 partition (p1, p2) + select c1, c2, 'abc', '123' from alter_partition_change_col0 + union all + select c1, c2, cast(null as string), '123' from alter_partition_change_col0 +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col0 +PREHOOK: Output: default@alter_partition_change_col1 +POSTHOOK: query: insert overwrite table alter_partition_change_col1 partition (p1, p2) + select c1, c2, 'abc', '123' from alter_partition_change_col0 + union all + select c1, c2, cast(null as string), '123' from alter_partition_change_col0 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col0 +POSTHOOK: Output: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: Lineage: alter_partition_change_col1 PARTITION(p1=__HIVE_DEFAULT_PARTITION__,p2=123).c1 EXPRESSION [(alter_partition_change_col0)alter_partition_change_col0.FieldSchema(name:c1, type:string, comment:null), ] +POSTHOOK: Lineage: alter_partition_change_col1 PARTITION(p1=__HIVE_DEFAULT_PARTITION__,p2=123).c2 EXPRESSION [(alter_partition_change_col0)alter_partition_change_col0.FieldSchema(name:c2, type:string, comment:null), ] +POSTHOOK: Lineage: alter_partition_change_col1 PARTITION(p1=abc,p2=123).c1 EXPRESSION [(alter_partition_change_col0)alter_partition_change_col0.FieldSchema(name:c1, type:string, comment:null), ] +POSTHOOK: Lineage: alter_partition_change_col1 PARTITION(p1=abc,p2=123).c2 EXPRESSION [(alter_partition_change_col0)alter_partition_change_col0.FieldSchema(name:c2, type:string, comment:null), ] +PREHOOK: query: show partitions alter_partition_change_col1 +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: show partitions alter_partition_change_col1 +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: default@alter_partition_change_col1 +p1=__HIVE_DEFAULT_PARTITION__/p2=123 +p1=abc/p2=123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +Beck 0.0 abc 123 +Beck 77.341 abc 123 +Beck 79.9 abc 123 +Cluck 5.96 abc 123 +Mary 33.33 abc 123 +Mary 4.329 abc 123 +Snow 55.71 abc 123 +Tom -12.25 abc 123 +Tom 19.00 abc 123 +Tom 234.79 abc 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0.0 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.341 __HIVE_DEFAULT_PARTITION__ 123 +Beck 79.9 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 5.96 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.33 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.329 __HIVE_DEFAULT_PARTITION__ 123 +Snow 55.71 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.25 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19.00 __HIVE_DEFAULT_PARTITION__ 123 +Tom 234.79 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' or lower(p1)='a' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' or lower(p1)='a' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0.0 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.341 __HIVE_DEFAULT_PARTITION__ 123 +Beck 79.9 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 5.96 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.33 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.329 __HIVE_DEFAULT_PARTITION__ 123 +Snow 55.71 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.25 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19.00 __HIVE_DEFAULT_PARTITION__ 123 +Tom 234.79 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: alter table alter_partition_change_col1 change c2 c2 decimal(10,0) +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1 +POSTHOOK: query: alter table alter_partition_change_col1 change c2 c2 decimal(10,0) +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Output: default@alter_partition_change_col1 +PREHOOK: query: alter table alter_partition_change_col1 partition (p1='abc', p2='123') change c2 c2 decimal(10,0) +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: query: alter table alter_partition_change_col1 partition (p1='abc', p2='123') change c2 c2 decimal(10,0) +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +PREHOOK: query: alter table alter_partition_change_col1 partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') change c2 c2 decimal(10,0) +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: query: alter table alter_partition_change_col1 partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') change c2 c2 decimal(10,0) +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +Beck 0 abc 123 +Beck 77 abc 123 +Beck 80 abc 123 +Cluck 6 abc 123 +Mary 33 abc 123 +Mary 4 abc 123 +Snow 56 abc 123 +Tom -12 abc 123 +Tom 19 abc 123 +Tom 235 abc 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77 __HIVE_DEFAULT_PARTITION__ 123 +Beck 80 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 6 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4 __HIVE_DEFAULT_PARTITION__ 123 +Snow 56 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19 __HIVE_DEFAULT_PARTITION__ 123 +Tom 235 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: alter table alter_partition_change_col1 change c2 c2 decimal(14,4) +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1 +POSTHOOK: query: alter table alter_partition_change_col1 change c2 c2 decimal(14,4) +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Output: default@alter_partition_change_col1 +PREHOOK: query: describe alter_partition_change_col1 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +c2 decimal(14,4) +p1 string Column p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Column p1 +p2 string Column p2 +PREHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +c2 decimal(10,0) +p1 string Column p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Column p1 +p2 string Column p2 +PREHOOK: query: select * from alter_partition_change_col1 where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +Beck 0.0000 abc 123 +Beck 77.0000 abc 123 +Beck 80.0000 abc 123 +Cluck 6.0000 abc 123 +Mary 33.0000 abc 123 +Mary 4.0000 abc 123 +Snow 56.0000 abc 123 +Tom -12.0000 abc 123 +Tom 19.0000 abc 123 +Tom 235.0000 abc 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0.0000 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.0000 __HIVE_DEFAULT_PARTITION__ 123 +Beck 80.0000 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 6.0000 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.0000 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.0000 __HIVE_DEFAULT_PARTITION__ 123 +Snow 56.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom 235.0000 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: alter table alter_partition_change_col1 partition column (p1 string comment 'Changed comment for p1') +PREHOOK: type: ALTERTABLE_PARTCOLTYPE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: alter table alter_partition_change_col1 partition column (p1 string comment 'Changed comment for p1') +POSTHOOK: type: ALTERTABLE_PARTCOLTYPE +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Output: default@alter_partition_change_col1 +PREHOOK: query: describe alter_partition_change_col1 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +c2 decimal(14,4) +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: alter table alter_partition_change_col1 partition (p1='abc', p2='123') change c2 c2 decimal(14,4) +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: query: alter table alter_partition_change_col1 partition (p1='abc', p2='123') change c2 c2 decimal(14,4) +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +PREHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +c2 decimal(14,4) +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: select * from alter_partition_change_col1 where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +Beck 0.0000 abc 123 +Beck 77.3410 abc 123 +Beck 79.9000 abc 123 +Cluck 5.9600 abc 123 +Mary 33.3300 abc 123 +Mary 4.3290 abc 123 +Snow 55.7100 abc 123 +Tom -12.2500 abc 123 +Tom 19.0000 abc 123 +Tom 234.7900 abc 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0.0000 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.0000 __HIVE_DEFAULT_PARTITION__ 123 +Beck 80.0000 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 6.0000 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.0000 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.0000 __HIVE_DEFAULT_PARTITION__ 123 +Snow 56.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom 235.0000 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: alter table alter_partition_change_col1 partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') change c2 c2 decimal(14,4) +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: query: alter table alter_partition_change_col1 partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') change c2 c2 decimal(14,4) +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: query: describe alter_partition_change_col1 partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +c2 decimal(14,4) +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: select * from alter_partition_change_col1 where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +Beck 0.0000 abc 123 +Beck 77.3410 abc 123 +Beck 79.9000 abc 123 +Cluck 5.9600 abc 123 +Mary 33.3300 abc 123 +Mary 4.3290 abc 123 +Snow 55.7100 abc 123 +Tom -12.2500 abc 123 +Tom 19.0000 abc 123 +Tom 234.7900 abc 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0.0000 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.3410 __HIVE_DEFAULT_PARTITION__ 123 +Beck 79.9000 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 5.9600 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.3300 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.3290 __HIVE_DEFAULT_PARTITION__ 123 +Snow 55.7100 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.2500 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom 234.7900 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: alter table alter_partition_change_col1 partition (p1='abc', p2='123') replace columns (c1 string) +PREHOOK: type: ALTERTABLE_REPLACECOLS +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: query: alter table alter_partition_change_col1 partition (p1='abc', p2='123') replace columns (c1 string) +POSTHOOK: type: ALTERTABLE_REPLACECOLS +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +PREHOOK: query: describe alter_partition_change_col1 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +c2 decimal(14,4) +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: select * from alter_partition_change_col1 where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +Beck NULL abc 123 +Beck NULL abc 123 +Beck NULL abc 123 +Cluck NULL abc 123 +Mary NULL abc 123 +Mary NULL abc 123 +Snow NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0.0000 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.3410 __HIVE_DEFAULT_PARTITION__ 123 +Beck 79.9000 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 5.9600 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.3300 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.3290 __HIVE_DEFAULT_PARTITION__ 123 +Snow 55.7100 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.2500 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom 234.7900 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: alter table alter_partition_change_col1 replace columns (c1 string) +PREHOOK: type: ALTERTABLE_REPLACECOLS +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1 +POSTHOOK: query: alter table alter_partition_change_col1 replace columns (c1 string) +POSTHOOK: type: ALTERTABLE_REPLACECOLS +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Output: default@alter_partition_change_col1 +PREHOOK: query: describe alter_partition_change_col1 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: select * from alter_partition_change_col1 where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +Beck abc 123 +Beck abc 123 +Beck abc 123 +Cluck abc 123 +Mary abc 123 +Mary abc 123 +Snow abc 123 +Tom abc 123 +Tom abc 123 +Tom abc 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck __HIVE_DEFAULT_PARTITION__ 123 +Beck __HIVE_DEFAULT_PARTITION__ 123 +Beck __HIVE_DEFAULT_PARTITION__ 123 +Cluck __HIVE_DEFAULT_PARTITION__ 123 +Mary __HIVE_DEFAULT_PARTITION__ 123 +Mary __HIVE_DEFAULT_PARTITION__ 123 +Snow __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +Tom __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: alter table alter_partition_change_col1 add columns (c2 decimal(14,4)) +PREHOOK: type: ALTERTABLE_ADDCOLS +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1 +POSTHOOK: query: alter table alter_partition_change_col1 add columns (c2 decimal(14,4)) +POSTHOOK: type: ALTERTABLE_ADDCOLS +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Output: default@alter_partition_change_col1 +PREHOOK: query: describe alter_partition_change_col1 +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +c2 decimal(14,4) +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: select * from alter_partition_change_col1 where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +Beck NULL abc 123 +Beck NULL abc 123 +Beck NULL abc 123 +Cluck NULL abc 123 +Mary NULL abc 123 +Mary NULL abc 123 +Snow NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +Tom NULL abc 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0.0000 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.3410 __HIVE_DEFAULT_PARTITION__ 123 +Beck 79.9000 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 5.9600 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.3300 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.3290 __HIVE_DEFAULT_PARTITION__ 123 +Snow 55.7100 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.2500 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom 234.7900 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: alter table alter_partition_change_col1 partition (p1='abc', p2='123') add columns (c2 decimal(14,4)) +PREHOOK: type: ALTERTABLE_ADDCOLS +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: query: alter table alter_partition_change_col1 partition (p1='abc', p2='123') add columns (c2 decimal(14,4)) +POSTHOOK: type: ALTERTABLE_ADDCOLS +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +PREHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +c2 decimal(14,4) +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: select * from alter_partition_change_col1 where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +Beck 0.0000 abc 123 +Beck 77.3410 abc 123 +Beck 79.9000 abc 123 +Cluck 5.9600 abc 123 +Mary 33.3300 abc 123 +Mary 4.3290 abc 123 +Snow 55.7100 abc 123 +Tom -12.2500 abc 123 +Tom 19.0000 abc 123 +Tom 234.7900 abc 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0.0000 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.3410 __HIVE_DEFAULT_PARTITION__ 123 +Beck 79.9000 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 5.9600 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.3300 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.3290 __HIVE_DEFAULT_PARTITION__ 123 +Snow 55.7100 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.2500 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom 234.7900 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: alter table alter_partition_change_col1 partition (p1, p2='123') change column c2 c2 decimal(10,0) +PREHOOK: type: ALTERTABLE_RENAMECOL +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Output: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +PREHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: query: alter table alter_partition_change_col1 partition (p1, p2='123') change column c2 c2 decimal(10,0) +POSTHOOK: type: ALTERTABLE_RENAMECOL +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +POSTHOOK: Output: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +POSTHOOK: Output: default@alter_partition_change_col1@p1=abc/p2=123 +PREHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 partition (p1='abc', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +c2 decimal(10,0) +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: describe alter_partition_change_col1 partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +PREHOOK: type: DESCTABLE +PREHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: query: describe alter_partition_change_col1 partition (p1='__HIVE_DEFAULT_PARTITION__', p2='123') +POSTHOOK: type: DESCTABLE +POSTHOOK: Input: default@alter_partition_change_col1 +c1 string +c2 decimal(10,0) +p1 string Changed comment for p1 +p2 string Column p2 + +# Partition Information +# col_name data_type comment +p1 string Changed comment for p1 +p2 string Column p2 +PREHOOK: query: select * from alter_partition_change_col1 where p1='abc' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='abc' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=abc/p2=123 +#### A masked pattern was here #### +Beck 0.0000 abc 123 +Beck 77.0000 abc 123 +Beck 80.0000 abc 123 +Cluck 6.0000 abc 123 +Mary 33.0000 abc 123 +Mary 4.0000 abc 123 +Snow 56.0000 abc 123 +Tom -12.0000 abc 123 +Tom 19.0000 abc 123 +Tom 235.0000 abc 123 +PREHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +PREHOOK: type: QUERY +PREHOOK: Input: default@alter_partition_change_col1 +PREHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +POSTHOOK: query: select * from alter_partition_change_col1 where p1='__HIVE_DEFAULT_PARTITION__' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@alter_partition_change_col1 +POSTHOOK: Input: default@alter_partition_change_col1@p1=__HIVE_DEFAULT_PARTITION__/p2=123 +#### A masked pattern was here #### +Beck 0.0000 __HIVE_DEFAULT_PARTITION__ 123 +Beck 77.0000 __HIVE_DEFAULT_PARTITION__ 123 +Beck 80.0000 __HIVE_DEFAULT_PARTITION__ 123 +Cluck 6.0000 __HIVE_DEFAULT_PARTITION__ 123 +Mary 33.0000 __HIVE_DEFAULT_PARTITION__ 123 +Mary 4.0000 __HIVE_DEFAULT_PARTITION__ 123 +Snow 56.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom -12.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom 19.0000 __HIVE_DEFAULT_PARTITION__ 123 +Tom 235.0000 __HIVE_DEFAULT_PARTITION__ 123 +PREHOOK: query: CREATE TABLE `alterPartTbl`( +col_1col_1col_1col_1col_1col_11 string, +col_1col_1col_1col_1col_1col_12 string, +col_1col_1col_1col_1col_1col_13 string, +col_1col_1col_1col_1col_1col_14 string, +col_1col_1col_1col_1col_1col_15 string, +col_1col_1col_1col_1col_1col_16 string, +col_1col_1col_1col_1col_1col_17 string, +col_1col_1col_1col_1col_1col_18 string, +col_1col_1col_1col_1col_1col_19 string, +col_1col_1col_1col_1col_1col_110 string, +col_1col_1col_1col_1col_1col_111 string, +col_1col_1col_1col_1col_1col_112 string, +col_1col_1col_1col_1col_1col_113 string, +col_1col_1col_1col_1col_1col_114 string, +col_1col_1col_1col_1col_1col_115 string, +col_1col_1col_1col_1col_1col_116 string, +col_1col_1col_1col_1col_1col_117 string, +col_1col_1col_1col_1col_1col_118 string, +col_1col_1col_1col_1col_1col_119 string, +col_1col_1col_1col_1col_1col_120 string, +col_1col_1col_1col_1col_1col_121 string, +col_1col_1col_1col_1col_1col_122 string, +col_1col_1col_1col_1col_1col_123 string, +col_1col_1col_1col_1col_1col_124 string, +col_1col_1col_1col_1col_1col_125 string, +col_1col_1col_1col_1col_1col_126 string, +col_1col_1col_1col_1col_1col_127 string, +col_1col_1col_1col_1col_1col_128 string, +col_1col_1col_1col_1col_1col_129 string, +col_1col_1col_1col_1col_1col_130 string, +col_1col_1col_1col_1col_1col_131 string, +col_1col_1col_1col_1col_1col_132 string, +col_1col_1col_1col_1col_1col_133 string, +col_1col_1col_1col_1col_1col_134 string, +col_1col_1col_1col_1col_1col_135 string, +col_1col_1col_1col_1col_1col_136 string, +col_1col_1col_1col_1col_1col_137 string, +col_1col_1col_1col_1col_1col_138 string, +col_1col_1col_1col_1col_1col_139 string, +col_1col_1col_1col_1col_1col_140 string, +col_1col_1col_1col_1col_1col_141 string, +col_1col_1col_1col_1col_1col_142 string, +col_1col_1col_1col_1col_1col_143 string, +col_1col_1col_1col_1col_1col_144 string, +col_1col_1col_1col_1col_1col_145 string, +col_1col_1col_1col_1col_1col_146 string, +col_1col_1col_1col_1col_1col_147 string, +col_1col_1col_1col_1col_1col_148 string, +col_1col_1col_1col_1col_1col_149 string, +col_1col_1col_1col_1col_1col_150 string, +col_1col_1col_1col_1col_1col_151 string, +col_1col_1col_1col_1col_1col_152 string, +col_1col_1col_1col_1col_1col_153 string, +col_1col_1col_1col_1col_1col_154 string, +col_1col_1col_1col_1col_1col_155 string, +col_1col_1col_1col_1col_1col_156 string, +col_1col_1col_1col_1col_1col_157 string, +col_1col_1col_1col_1col_1col_158 string, +col_1col_1col_1col_1col_1col_159 string, +col_1col_1col_1col_1col_1col_160 string, +col_1col_1col_1col_1col_1col_161 string, +col_1col_1col_1col_1col_1col_162 string, +col_1col_1col_1col_1col_1col_163 string, +col_1col_1col_1col_1col_1col_164 string, +col_1col_1col_1col_1col_1col_165 string, +col_1col_1col_1col_1col_1col_166 string, +col_1col_1col_1col_1col_1col_167 string, +col_1col_1col_1col_1col_1col_168 string, +col_1col_1col_1col_1col_1col_169 string, +col_1col_1col_1col_1col_1col_170 string, +col_1col_1col_1col_1col_1col_171 string, +col_1col_1col_1col_1col_1col_172 string, +col_1col_1col_1col_1col_1col_173 string, +col_1col_1col_1col_1col_1col_174 string, +col_1col_1col_1col_1col_1col_175 string, +col_1col_1col_1col_1col_1col_176 string, +col_1col_1col_1col_1col_1col_177 string, +col_1col_1col_1col_1col_1col_178 string, +col_1col_1col_1col_1col_1col_179 string, +col_1col_1col_1col_1col_1col_180 string, +col_1col_1col_1col_1col_1col_181 string, +col_1col_1col_1col_1col_1col_182 string, +col_1col_1col_1col_1col_1col_183 string, +col_1col_1col_1col_1col_1col_184 string, +col_1col_1col_1col_1col_1col_185 string, +col_1col_1col_1col_1col_1col_186 string, +col_1col_1col_1col_1col_1col_187 string, +col_1col_1col_1col_1col_1col_188 string, +col_1col_1col_1col_1col_1col_189 string, +col_1col_1col_1col_1col_1col_190 string, +col_1col_1col_1col_1col_1col_191 string, +col_1col_1col_1col_1col_1col_192 string, +col_1col_1col_1col_1col_1col_193 string, +col_1col_1col_1col_1col_1col_194 string, +col_1col_1col_1col_1col_1col_195 string, +col_1col_1col_1col_1col_1col_196 string, +col_1col_1col_1col_1col_1col_197 string, +col_1col_1col_1col_1col_1col_198 string, +col_1col_1col_1col_1col_1col_199 string, +col_1col_1col_1col_1col_1col_1100 string, +col_1col_1col_1col_1col_1col_1101 string, +col_1col_1col_1col_1col_1col_1102 string, +col_1col_1col_1col_1col_1col_1103 string, +col_1col_1col_1col_1col_1col_1104 string, +col_1col_1col_1col_1col_1col_1105 string, +col_1col_1col_1col_1col_1col_1106 string, +col_1col_1col_1col_1col_1col_1107 string, +col_1col_1col_1col_1col_1col_1108 string, +col_1col_1col_1col_1col_1col_1109 string, +col_1col_1col_1col_1col_1col_1110 string, +col_1col_1col_1col_1col_1col_1111 string, +col_1col_1col_1col_1col_1col_1112 string, +col_1col_1col_1col_1col_1col_1113 string, +col_1col_1col_1col_1col_1col_1114 string, +col_1col_1col_1col_1col_1col_1115 string, +col_1col_1col_1col_1col_1col_1116 string, +col_1col_1col_1col_1col_1col_1117 string, +col_1col_1col_1col_1col_1col_1118 string, +col_1col_1col_1col_1col_1col_1119 string, +col_1col_1col_1col_1col_1col_1120 string, +col_1col_1col_1col_1col_1col_1121 string, +col_1col_1col_1col_1col_1col_1122 string, +col_1col_1col_1col_1col_1col_1123 string, +col_1col_1col_1col_1col_1col_1124 string, +col_1col_1col_1col_1col_1col_1125 string, +col_1col_1col_1col_1col_1col_1126 string, +col_1col_1col_1col_1col_1col_1127 string, +col_1col_1col_1col_1col_1col_1128 string, +col_1col_1col_1col_1col_1col_1129 string, +col_1col_1col_1col_1col_1col_1130 string, +col_1col_1col_1col_1col_1col_1131 string, +col_1col_1col_1col_1col_1col_1132 string, +col_1col_1col_1col_1col_1col_1133 string, +col_1col_1col_1col_1col_1col_1134 string, +col_1col_1col_1col_1col_1col_1135 string, +col_1col_1col_1col_1col_1col_1136 string, +col_1col_1col_1col_1col_1col_1137 string, +col_1col_1col_1col_1col_1col_1138 string, +col_1col_1col_1col_1col_1col_1139 string, +col_1col_1col_1col_1col_1col_1140 string, +col_1col_1col_1col_1col_1col_1141 string, +col_1col_1col_1col_1col_1col_1142 string, +col_1col_1col_1col_1col_1col_1143 string, +col_1col_1col_1col_1col_1col_1144 string, +col_1col_1col_1col_1col_1col_1145 string, +col_1col_1col_1col_1col_1col_1146 string, +col_1col_1col_1col_1col_1col_1147 string, +col_1col_1col_1col_1col_1col_1148 string, +col_1col_1col_1col_1col_1col_1149 string, +col_1col_1col_1col_1col_1col_1150 string, +col_1col_1col_1col_1col_1col_1151 string, +col_1col_1col_1col_1col_1col_1152 string, +col_1col_1col_1col_1col_1col_1153 string, +col_1col_1col_1col_1col_1col_1154 string, +col_1col_1col_1col_1col_1col_1155 string, +col_1col_1col_1col_1col_1col_1156 string, +col_1col_1col_1col_1col_1col_1157 string, +col_1col_1col_1col_1col_1col_1158 string) + PARTITIONED BY ( + `partition_col` string) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@alterPartTbl +POSTHOOK: query: CREATE TABLE `alterPartTbl`( +col_1col_1col_1col_1col_1col_11 string, +col_1col_1col_1col_1col_1col_12 string, +col_1col_1col_1col_1col_1col_13 string, +col_1col_1col_1col_1col_1col_14 string, +col_1col_1col_1col_1col_1col_15 string, +col_1col_1col_1col_1col_1col_16 string, +col_1col_1col_1col_1col_1col_17 string, +col_1col_1col_1col_1col_1col_18 string, +col_1col_1col_1col_1col_1col_19 string, +col_1col_1col_1col_1col_1col_110 string, +col_1col_1col_1col_1col_1col_111 string, +col_1col_1col_1col_1col_1col_112 string, +col_1col_1col_1col_1col_1col_113 string, +col_1col_1col_1col_1col_1col_114 string, +col_1col_1col_1col_1col_1col_115 string, +col_1col_1col_1col_1col_1col_116 string, +col_1col_1col_1col_1col_1col_117 string, +col_1col_1col_1col_1col_1col_118 string, +col_1col_1col_1col_1col_1col_119 string, +col_1col_1col_1col_1col_1col_120 string, +col_1col_1col_1col_1col_1col_121 string, +col_1col_1col_1col_1col_1col_122 string, +col_1col_1col_1col_1col_1col_123 string, +col_1col_1col_1col_1col_1col_124 string, +col_1col_1col_1col_1col_1col_125 string, +col_1col_1col_1col_1col_1col_126 string, +col_1col_1col_1col_1col_1col_127 string, +col_1col_1col_1col_1col_1col_128 string, +col_1col_1col_1col_1col_1col_129 string, +col_1col_1col_1col_1col_1col_130 string, +col_1col_1col_1col_1col_1col_131 string, +col_1col_1col_1col_1col_1col_132 string, +col_1col_1col_1col_1col_1col_133 string, +col_1col_1col_1col_1col_1col_134 string, +col_1col_1col_1col_1col_1col_135 string, +col_1col_1col_1col_1col_1col_136 string, +col_1col_1col_1col_1col_1col_137 string, +col_1col_1col_1col_1col_1col_138 string, +col_1col_1col_1col_1col_1col_139 string, +col_1col_1col_1col_1col_1col_140 string, +col_1col_1col_1col_1col_1col_141 string, +col_1col_1col_1col_1col_1col_142 string, +col_1col_1col_1col_1col_1col_143 string, +col_1col_1col_1col_1col_1col_144 string, +col_1col_1col_1col_1col_1col_145 string, +col_1col_1col_1col_1col_1col_146 string, +col_1col_1col_1col_1col_1col_147 string, +col_1col_1col_1col_1col_1col_148 string, +col_1col_1col_1col_1col_1col_149 string, +col_1col_1col_1col_1col_1col_150 string, +col_1col_1col_1col_1col_1col_151 string, +col_1col_1col_1col_1col_1col_152 string, +col_1col_1col_1col_1col_1col_153 string, +col_1col_1col_1col_1col_1col_154 string, +col_1col_1col_1col_1col_1col_155 string, +col_1col_1col_1col_1col_1col_156 string, +col_1col_1col_1col_1col_1col_157 string, +col_1col_1col_1col_1col_1col_158 string, +col_1col_1col_1col_1col_1col_159 string, +col_1col_1col_1col_1col_1col_160 string, +col_1col_1col_1col_1col_1col_161 string, +col_1col_1col_1col_1col_1col_162 string, +col_1col_1col_1col_1col_1col_163 string, +col_1col_1col_1col_1col_1col_164 string, +col_1col_1col_1col_1col_1col_165 string, +col_1col_1col_1col_1col_1col_166 string, +col_1col_1col_1col_1col_1col_167 string, +col_1col_1col_1col_1col_1col_168 string, +col_1col_1col_1col_1col_1col_169 string, +col_1col_1col_1col_1col_1col_170 string, +col_1col_1col_1col_1col_1col_171 string, +col_1col_1col_1col_1col_1col_172 string, +col_1col_1col_1col_1col_1col_173 string, +col_1col_1col_1col_1col_1col_174 string, +col_1col_1col_1col_1col_1col_175 string, +col_1col_1col_1col_1col_1col_176 string, +col_1col_1col_1col_1col_1col_177 string, +col_1col_1col_1col_1col_1col_178 string, +col_1col_1col_1col_1col_1col_179 string, +col_1col_1col_1col_1col_1col_180 string, +col_1col_1col_1col_1col_1col_181 string, +col_1col_1col_1col_1col_1col_182 string, +col_1col_1col_1col_1col_1col_183 string, +col_1col_1col_1col_1col_1col_184 string, +col_1col_1col_1col_1col_1col_185 string, +col_1col_1col_1col_1col_1col_186 string, +col_1col_1col_1col_1col_1col_187 string, +col_1col_1col_1col_1col_1col_188 string, +col_1col_1col_1col_1col_1col_189 string, +col_1col_1col_1col_1col_1col_190 string, +col_1col_1col_1col_1col_1col_191 string, +col_1col_1col_1col_1col_1col_192 string, +col_1col_1col_1col_1col_1col_193 string, +col_1col_1col_1col_1col_1col_194 string, +col_1col_1col_1col_1col_1col_195 string, +col_1col_1col_1col_1col_1col_196 string, +col_1col_1col_1col_1col_1col_197 string, +col_1col_1col_1col_1col_1col_198 string, +col_1col_1col_1col_1col_1col_199 string, +col_1col_1col_1col_1col_1col_1100 string, +col_1col_1col_1col_1col_1col_1101 string, +col_1col_1col_1col_1col_1col_1102 string, +col_1col_1col_1col_1col_1col_1103 string, +col_1col_1col_1col_1col_1col_1104 string, +col_1col_1col_1col_1col_1col_1105 string, +col_1col_1col_1col_1col_1col_1106 string, +col_1col_1col_1col_1col_1col_1107 string, +col_1col_1col_1col_1col_1col_1108 string, +col_1col_1col_1col_1col_1col_1109 string, +col_1col_1col_1col_1col_1col_1110 string, +col_1col_1col_1col_1col_1col_1111 string, +col_1col_1col_1col_1col_1col_1112 string, +col_1col_1col_1col_1col_1col_1113 string, +col_1col_1col_1col_1col_1col_1114 string, +col_1col_1col_1col_1col_1col_1115 string, +col_1col_1col_1col_1col_1col_1116 string, +col_1col_1col_1col_1col_1col_1117 string, +col_1col_1col_1col_1col_1col_1118 string, +col_1col_1col_1col_1col_1col_1119 string, +col_1col_1col_1col_1col_1col_1120 string, +col_1col_1col_1col_1col_1col_1121 string, +col_1col_1col_1col_1col_1col_1122 string, +col_1col_1col_1col_1col_1col_1123 string, +col_1col_1col_1col_1col_1col_1124 string, +col_1col_1col_1col_1col_1col_1125 string, +col_1col_1col_1col_1col_1col_1126 string, +col_1col_1col_1col_1col_1col_1127 string, +col_1col_1col_1col_1col_1col_1128 string, +col_1col_1col_1col_1col_1col_1129 string, +col_1col_1col_1col_1col_1col_1130 string, +col_1col_1col_1col_1col_1col_1131 string, +col_1col_1col_1col_1col_1col_1132 string, +col_1col_1col_1col_1col_1col_1133 string, +col_1col_1col_1col_1col_1col_1134 string, +col_1col_1col_1col_1col_1col_1135 string, +col_1col_1col_1col_1col_1col_1136 string, +col_1col_1col_1col_1col_1col_1137 string, +col_1col_1col_1col_1col_1col_1138 string, +col_1col_1col_1col_1col_1col_1139 string, +col_1col_1col_1col_1col_1col_1140 string, +col_1col_1col_1col_1col_1col_1141 string, +col_1col_1col_1col_1col_1col_1142 string, +col_1col_1col_1col_1col_1col_1143 string, +col_1col_1col_1col_1col_1col_1144 string, +col_1col_1col_1col_1col_1col_1145 string, +col_1col_1col_1col_1col_1col_1146 string, +col_1col_1col_1col_1col_1col_1147 string, +col_1col_1col_1col_1col_1col_1148 string, +col_1col_1col_1col_1col_1col_1149 string, +col_1col_1col_1col_1col_1col_1150 string, +col_1col_1col_1col_1col_1col_1151 string, +col_1col_1col_1col_1col_1col_1152 string, +col_1col_1col_1col_1col_1col_1153 string, +col_1col_1col_1col_1col_1col_1154 string, +col_1col_1col_1col_1col_1col_1155 string, +col_1col_1col_1col_1col_1col_1156 string, +col_1col_1col_1col_1col_1col_1157 string, +col_1col_1col_1col_1col_1col_1158 string) + PARTITIONED BY ( + `partition_col` string) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@alterPartTbl +PREHOOK: query: alter table alterPartTbl add partition(partition_col='CCL') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Output: default@alterparttbl +POSTHOOK: query: alter table alterPartTbl add partition(partition_col='CCL') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Output: default@alterparttbl +POSTHOOK: Output: default@alterparttbl@partition_col=CCL +PREHOOK: query: drop table alterPartTbl +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@alterparttbl +PREHOOK: Output: default@alterparttbl +POSTHOOK: query: drop table alterPartTbl +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@alterparttbl +POSTHOOK: Output: default@alterparttbl http://git-wip-us.apache.org/repos/asf/hive/blob/7ae4a2c8/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetastoreDirectSqlUtils.java ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetastoreDirectSqlUtils.java b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetastoreDirectSqlUtils.java index 3905b9e..e476f8a 100644 --- a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetastoreDirectSqlUtils.java +++ b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/MetastoreDirectSqlUtils.java @@ -161,7 +161,7 @@ class MetastoreDirectSqlUtils { loopJoinOrderedResult(pm, partitions, queryText, 0, new ApplyFunc<Partition>() { @Override public void apply(Partition t, Object[] fields) { - t.putToParameters((String)fields[1], (String)fields[2]); + t.putToParameters((String)fields[1], extractSqlClob(fields[2])); }}); // Perform conversion of null map values for (Partition t : partitions.values()) { @@ -193,7 +193,7 @@ class MetastoreDirectSqlUtils { loopJoinOrderedResult(pm, partitions, queryText, queryParams.toArray(), 0, new ApplyFunc<Partition>() { @Override public void apply(Partition t, Object[] fields) { - t.putToParameters((String) fields[1], (String) fields[2]); + t.putToParameters((String) fields[1], extractSqlClob(fields[2])); } }); // Perform conversion of null map values http://git-wip-us.apache.org/repos/asf/hive/blob/7ae4a2c8/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnDbUtil.java ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnDbUtil.java b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnDbUtil.java index 6fcfbce..2a019d2 100644 --- a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnDbUtil.java +++ b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnDbUtil.java @@ -269,7 +269,7 @@ public final class TxnDbUtil { try { stmt.execute("CREATE TABLE \"APP\".\"PARTITION_PARAMS\" (" + " \"PART_ID\" BIGINT NOT NULL, \"PARAM_KEY\" VARCHAR(256) NOT NULL, " + - " \"PARAM_VALUE\" VARCHAR(4000), " + + " \"PARAM_VALUE\" CLOB, " + " PRIMARY KEY (PART_ID, PARAM_KEY))" ); } catch (SQLException e) { http://git-wip-us.apache.org/repos/asf/hive/blob/7ae4a2c8/standalone-metastore/metastore-server/src/main/resources/package.jdo ---------------------------------------------------------------------- diff --git a/standalone-metastore/metastore-server/src/main/resources/package.jdo b/standalone-metastore/metastore-server/src/main/resources/package.jdo index 01306e6..112cc5c 100644 --- a/standalone-metastore/metastore-server/src/main/resources/package.jdo +++ b/standalone-metastore/metastore-server/src/main/resources/package.jdo @@ -489,7 +489,7 @@ <column name="PARAM_KEY" length="256" jdbc-type="VARCHAR"/> </key> <value> - <column name="PARAM_VALUE" length="4000" jdbc-type="VARCHAR"/> + <column name="PARAM_VALUE" jdbc-type="CLOB"/> </value> </field> <field name="writeId">