From e66e31be51f396c8f6b7a45119b8b31c4d8cdf79 Mon Sep 17 00:00:00 2001 From: Stevo Slavić Date: Thu, 15 May 2014 16:44:14 -0700 Subject: SPARK-1803 Replaced colon in filenames with a dash MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit This patch replaces colon in several filenames with dash to make these filenames Windows compatible. Author: Stevo Slavić Author: Stevo Slavic Closes #739 from sslavic/SPARK-1803 and squashes the following commits: 3ec66eb [Stevo Slavic] Removed extra empty line which was causing test to fail b967cc3 [Stevo Slavić] Aligned tests and names of test resources 2b12776 [Stevo Slavić] Fixed a typo in file name 1c5dfff [Stevo Slavić] Replaced colon in file name with dash 8f5bf7f [Stevo Slavić] Replaced colon in file name with dash c5b5083 [Stevo Slavić] Replaced colon in file name with dash a49801f [Stevo Slavić] Replaced colon in file name with dash 401d99e [Stevo Slavić] Replaced colon in file name with dash 40a9621 [Stevo Slavić] Replaced colon in file name with dash 4774580 [Stevo Slavić] Replaced colon in file name with dash 004f8bb [Stevo Slavić] Replaced colon in file name with dash d6a3e2c [Stevo Slavić] Replaced colon in file name with dash b585126 [Stevo Slavić] Replaced colon in file name with dash 028e48a [Stevo Slavić] Replaced colon in file name with dash ece0507 [Stevo Slavić] Replaced colon in file name with dash 84f5d2f [Stevo Slavić] Replaced colon in file name with dash 2fc7854 [Stevo Slavić] Replaced colon in file name with dash 9e1467d [Stevo Slavić] Replaced colon in file name with dash --- ...- query test-0-cb0737d268260da971487a8ac5e3d8be | 3 + ...- query test-0-c89dcddb8539bae211ea28cd1e695e35 | 3 + ...- query test-0-9589ac54d6de575083765ee64051ebaa | 3 + ...- query test-0-d6d2726928df920ab99078015b8ff494 | 3 + ... - query test-0-cfe78c68302bd143d989c383c3b0477 | 3 + ...- query test-0-358525951e893ed9686c46bf1f7447ee | 3 + ...- query test-0-d9d50146537344742300ce7b52c18c91 | 3 + ...- query test-0-c25cdafe7d85c42a9d9cd559d88a6049 | 3 + ...- query test-0-cb0737d268260da971487a8ac5e3d8be | 3 - ...- query test-0-c89dcddb8539bae211ea28cd1e695e35 | 3 - ...- query test-0-9589ac54d6de575083765ee64051ebaa | 3 - ...- query test-0-d6d2726928df920ab99078015b8ff494 | 3 - ... - query test-0-cfe78c68302bd143d989c383c3b0477 | 3 - ...- query test-0-358525951e893ed9686c46bf1f7447ee | 3 - ...- query test-0-d9d50146537344742300ce7b52c18c91 | 3 - ...- query test-0-c25cdafe7d85c42a9d9cd559d88a6049 | 3 - ...- query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7 | 0 ...- query test-0-3adc3a7f76b2abd059904ba81a595db3 | 500 ++++++++++ ...- query test-0-681332efaff7b12e3ca12d9f021cd344 | 500 ++++++++++ ...- query test-0-3893ec7a86062215d9f817f1495a69bb | 500 ++++++++++ ...- query test-0-75148567b91227053f728d72f7dc7c10 | 1000 ++++++++++++++++++++ ...- query test-0-4e4d2651e1e6e3c224242078d0201190 | 1000 ++++++++++++++++++++ ...- query test-0-b6e59464383591f02408f8765ac6a5d5 | 1000 ++++++++++++++++++++ ...- query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7 | 0 ...- query test-0-3adc3a7f76b2abd059904ba81a595db3 | 500 ---------- ...- query test-0-3893ec7a86062215d9f817f1495a69bb | 500 ---------- ...- query test-0-75148567b91227053f728d72f7dc7c10 | 1000 -------------------- ...- query test-0-4e4d2651e1e6e3c224242078d0201190 | 1000 -------------------- ...- query test-0-b6e59464383591f02408f8765ac6a5d5 | 1000 -------------------- ...- query test-0-681332efaff7b12e3ca12d9f021cd344 | 500 ---------- .../spark/sql/hive/execution/PruningSuite.scala | 30 +- 31 files changed, 4539 insertions(+), 4539 deletions(-) create mode 100644 sql/hive/src/test/resources/golden/Column pruning - filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be create mode 100644 sql/hive/src/test/resources/golden/Column pruning - non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35 create mode 100644 sql/hive/src/test/resources/golden/Column pruning - projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa create mode 100644 sql/hive/src/test/resources/golden/Column pruning - simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494 create mode 100644 sql/hive/src/test/resources/golden/Column pruning - with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477 create mode 100644 sql/hive/src/test/resources/golden/Column pruning - with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee create mode 100644 sql/hive/src/test/resources/golden/Column pruning - with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91 create mode 100644 sql/hive/src/test/resources/golden/Column pruning - without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049 delete mode 100644 sql/hive/src/test/resources/golden/Column pruning: filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be delete mode 100644 sql/hive/src/test/resources/golden/Column pruning: non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35 delete mode 100644 sql/hive/src/test/resources/golden/Column pruning: projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa delete mode 100644 sql/hive/src/test/resources/golden/Column pruning: simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494 delete mode 100644 sql/hive/src/test/resources/golden/Column pruning: with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477 delete mode 100644 sql/hive/src/test/resources/golden/Column pruning: with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee delete mode 100644 sql/hive/src/test/resources/golden/Column pruning: with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91 delete mode 100644 sql/hive/src/test/resources/golden/Column pruning: without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049 create mode 100644 sql/hive/src/test/resources/golden/Partition pruning - all partitions pruned - query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7 create mode 100644 sql/hive/src/test/resources/golden/Partition pruning - left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3 create mode 100644 sql/hive/src/test/resources/golden/Partition pruning - non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344 create mode 100644 sql/hive/src/test/resources/golden/Partition pruning - non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb create mode 100644 sql/hive/src/test/resources/golden/Partition pruning - pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10 create mode 100644 sql/hive/src/test/resources/golden/Partition pruning - with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190 create mode 100644 sql/hive/src/test/resources/golden/Partition pruning - with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5 delete mode 100644 sql/hive/src/test/resources/golden/Partition pruning: all partitions pruned - query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7 delete mode 100644 sql/hive/src/test/resources/golden/Partition pruning: left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3 delete mode 100644 sql/hive/src/test/resources/golden/Partition pruning: non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb delete mode 100644 sql/hive/src/test/resources/golden/Partition pruning: pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10 delete mode 100644 sql/hive/src/test/resources/golden/Partition pruning: with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190 delete mode 100644 sql/hive/src/test/resources/golden/Partition pruning: with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5 delete mode 100644 sql/hive/src/test/resources/golden/Partiton pruning: non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344 (limited to 'sql/hive') diff --git a/sql/hive/src/test/resources/golden/Column pruning - filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be b/sql/hive/src/test/resources/golden/Column pruning - filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be new file mode 100644 index 0000000000..913a609968 --- /dev/null +++ b/sql/hive/src/test/resources/golden/Column pruning - filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be @@ -0,0 +1,3 @@ +86 +27 +98 diff --git a/sql/hive/src/test/resources/golden/Column pruning - non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35 b/sql/hive/src/test/resources/golden/Column pruning - non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35 new file mode 100644 index 0000000000..9a276bc794 --- /dev/null +++ b/sql/hive/src/test/resources/golden/Column pruning - non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35 @@ -0,0 +1,3 @@ +476 +172 +622 diff --git a/sql/hive/src/test/resources/golden/Column pruning - projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa b/sql/hive/src/test/resources/golden/Column pruning - projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa new file mode 100644 index 0000000000..1c8e28554a --- /dev/null +++ b/sql/hive/src/test/resources/golden/Column pruning - projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa @@ -0,0 +1,3 @@ +238 +86 +311 diff --git a/sql/hive/src/test/resources/golden/Column pruning - simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494 b/sql/hive/src/test/resources/golden/Column pruning - simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494 new file mode 100644 index 0000000000..913a609968 --- /dev/null +++ b/sql/hive/src/test/resources/golden/Column pruning - simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494 @@ -0,0 +1,3 @@ +86 +27 +98 diff --git a/sql/hive/src/test/resources/golden/Column pruning - with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477 b/sql/hive/src/test/resources/golden/Column pruning - with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477 new file mode 100644 index 0000000000..1c8e28554a --- /dev/null +++ b/sql/hive/src/test/resources/golden/Column pruning - with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477 @@ -0,0 +1,3 @@ +238 +86 +311 diff --git a/sql/hive/src/test/resources/golden/Column pruning - with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee b/sql/hive/src/test/resources/golden/Column pruning - with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee new file mode 100644 index 0000000000..1c8e28554a --- /dev/null +++ b/sql/hive/src/test/resources/golden/Column pruning - with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee @@ -0,0 +1,3 @@ +238 +86 +311 diff --git a/sql/hive/src/test/resources/golden/Column pruning - with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91 b/sql/hive/src/test/resources/golden/Column pruning - with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91 new file mode 100644 index 0000000000..1c8e28554a --- /dev/null +++ b/sql/hive/src/test/resources/golden/Column pruning - with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91 @@ -0,0 +1,3 @@ +238 +86 +311 diff --git a/sql/hive/src/test/resources/golden/Column pruning - without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049 b/sql/hive/src/test/resources/golden/Column pruning - without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049 new file mode 100644 index 0000000000..1c8e28554a --- /dev/null +++ b/sql/hive/src/test/resources/golden/Column pruning - without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049 @@ -0,0 +1,3 @@ +238 +86 +311 diff --git a/sql/hive/src/test/resources/golden/Column pruning: filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be b/sql/hive/src/test/resources/golden/Column pruning: filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be deleted file mode 100644 index 913a609968..0000000000 --- a/sql/hive/src/test/resources/golden/Column pruning: filter alias in-lining - query test-0-cb0737d268260da971487a8ac5e3d8be +++ /dev/null @@ -1,3 +0,0 @@ -86 -27 -98 diff --git a/sql/hive/src/test/resources/golden/Column pruning: non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35 b/sql/hive/src/test/resources/golden/Column pruning: non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35 deleted file mode 100644 index 9a276bc794..0000000000 --- a/sql/hive/src/test/resources/golden/Column pruning: non-trivial top project with aliases - query test-0-c89dcddb8539bae211ea28cd1e695e35 +++ /dev/null @@ -1,3 +0,0 @@ -476 -172 -622 diff --git a/sql/hive/src/test/resources/golden/Column pruning: projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa b/sql/hive/src/test/resources/golden/Column pruning: projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa deleted file mode 100644 index 1c8e28554a..0000000000 --- a/sql/hive/src/test/resources/golden/Column pruning: projects alias substituting - query test-0-9589ac54d6de575083765ee64051ebaa +++ /dev/null @@ -1,3 +0,0 @@ -238 -86 -311 diff --git a/sql/hive/src/test/resources/golden/Column pruning: simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494 b/sql/hive/src/test/resources/golden/Column pruning: simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494 deleted file mode 100644 index 913a609968..0000000000 --- a/sql/hive/src/test/resources/golden/Column pruning: simple top project without aliases - query test-0-d6d2726928df920ab99078015b8ff494 +++ /dev/null @@ -1,3 +0,0 @@ -86 -27 -98 diff --git a/sql/hive/src/test/resources/golden/Column pruning: with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477 b/sql/hive/src/test/resources/golden/Column pruning: with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477 deleted file mode 100644 index 1c8e28554a..0000000000 --- a/sql/hive/src/test/resources/golden/Column pruning: with multiple projects - query test-0-cfe78c68302bd143d989c383c3b0477 +++ /dev/null @@ -1,3 +0,0 @@ -238 -86 -311 diff --git a/sql/hive/src/test/resources/golden/Column pruning: with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee b/sql/hive/src/test/resources/golden/Column pruning: with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee deleted file mode 100644 index 1c8e28554a..0000000000 --- a/sql/hive/src/test/resources/golden/Column pruning: with non-partitioned table - query test-0-358525951e893ed9686c46bf1f7447ee +++ /dev/null @@ -1,3 +0,0 @@ -238 -86 -311 diff --git a/sql/hive/src/test/resources/golden/Column pruning: with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91 b/sql/hive/src/test/resources/golden/Column pruning: with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91 deleted file mode 100644 index 1c8e28554a..0000000000 --- a/sql/hive/src/test/resources/golden/Column pruning: with partitioned table - query test-0-d9d50146537344742300ce7b52c18c91 +++ /dev/null @@ -1,3 +0,0 @@ -238 -86 -311 diff --git a/sql/hive/src/test/resources/golden/Column pruning: without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049 b/sql/hive/src/test/resources/golden/Column pruning: without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049 deleted file mode 100644 index 1c8e28554a..0000000000 --- a/sql/hive/src/test/resources/golden/Column pruning: without filters - query test-0-c25cdafe7d85c42a9d9cd559d88a6049 +++ /dev/null @@ -1,3 +0,0 @@ -238 -86 -311 diff --git a/sql/hive/src/test/resources/golden/Partition pruning - all partitions pruned - query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7 b/sql/hive/src/test/resources/golden/Partition pruning - all partitions pruned - query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7 new file mode 100644 index 0000000000..e69de29bb2 diff --git a/sql/hive/src/test/resources/golden/Partition pruning - left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3 b/sql/hive/src/test/resources/golden/Partition pruning - left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3 new file mode 100644 index 0000000000..0fe6b905e7 --- /dev/null +++ b/sql/hive/src/test/resources/golden/Partition pruning - left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3 @@ -0,0 +1,500 @@ +val_238 11 +val_86 11 +val_311 11 +val_27 11 +val_165 11 +val_409 11 +val_255 11 +val_278 11 +val_98 11 +val_484 11 +val_265 11 +val_193 11 +val_401 11 +val_150 11 +val_273 11 +val_224 11 +val_369 11 +val_66 11 +val_128 11 +val_213 11 +val_146 11 +val_406 11 +val_429 11 +val_374 11 +val_152 11 +val_469 11 +val_145 11 +val_495 11 +val_37 11 +val_327 11 +val_281 11 +val_277 11 +val_209 11 +val_15 11 +val_82 11 +val_403 11 +val_166 11 +val_417 11 +val_430 11 +val_252 11 +val_292 11 +val_219 11 +val_287 11 +val_153 11 +val_193 11 +val_338 11 +val_446 11 +val_459 11 +val_394 11 +val_237 11 +val_482 11 +val_174 11 +val_413 11 +val_494 11 +val_207 11 +val_199 11 +val_466 11 +val_208 11 +val_174 11 +val_399 11 +val_396 11 +val_247 11 +val_417 11 +val_489 11 +val_162 11 +val_377 11 +val_397 11 +val_309 11 +val_365 11 +val_266 11 +val_439 11 +val_342 11 +val_367 11 +val_325 11 +val_167 11 +val_195 11 +val_475 11 +val_17 11 +val_113 11 +val_155 11 +val_203 11 +val_339 11 +val_0 11 +val_455 11 +val_128 11 +val_311 11 +val_316 11 +val_57 11 +val_302 11 +val_205 11 +val_149 11 +val_438 11 +val_345 11 +val_129 11 +val_170 11 +val_20 11 +val_489 11 +val_157 11 +val_378 11 +val_221 11 +val_92 11 +val_111 11 +val_47 11 +val_72 11 +val_4 11 +val_280 11 +val_35 11 +val_427 11 +val_277 11 +val_208 11 +val_356 11 +val_399 11 +val_169 11 +val_382 11 +val_498 11 +val_125 11 +val_386 11 +val_437 11 +val_469 11 +val_192 11 +val_286 11 +val_187 11 +val_176 11 +val_54 11 +val_459 11 +val_51 11 +val_138 11 +val_103 11 +val_239 11 +val_213 11 +val_216 11 +val_430 11 +val_278 11 +val_176 11 +val_289 11 +val_221 11 +val_65 11 +val_318 11 +val_332 11 +val_311 11 +val_275 11 +val_137 11 +val_241 11 +val_83 11 +val_333 11 +val_180 11 +val_284 11 +val_12 11 +val_230 11 +val_181 11 +val_67 11 +val_260 11 +val_404 11 +val_384 11 +val_489 11 +val_353 11 +val_373 11 +val_272 11 +val_138 11 +val_217 11 +val_84 11 +val_348 11 +val_466 11 +val_58 11 +val_8 11 +val_411 11 +val_230 11 +val_208 11 +val_348 11 +val_24 11 +val_463 11 +val_431 11 +val_179 11 +val_172 11 +val_42 11 +val_129 11 +val_158 11 +val_119 11 +val_496 11 +val_0 11 +val_322 11 +val_197 11 +val_468 11 +val_393 11 +val_454 11 +val_100 11 +val_298 11 +val_199 11 +val_191 11 +val_418 11 +val_96 11 +val_26 11 +val_165 11 +val_327 11 +val_230 11 +val_205 11 +val_120 11 +val_131 11 +val_51 11 +val_404 11 +val_43 11 +val_436 11 +val_156 11 +val_469 11 +val_468 11 +val_308 11 +val_95 11 +val_196 11 +val_288 11 +val_481 11 +val_457 11 +val_98 11 +val_282 11 +val_197 11 +val_187 11 +val_318 11 +val_318 11 +val_409 11 +val_470 11 +val_137 11 +val_369 11 +val_316 11 +val_169 11 +val_413 11 +val_85 11 +val_77 11 +val_0 11 +val_490 11 +val_87 11 +val_364 11 +val_179 11 +val_118 11 +val_134 11 +val_395 11 +val_282 11 +val_138 11 +val_238 11 +val_419 11 +val_15 11 +val_118 11 +val_72 11 +val_90 11 +val_307 11 +val_19 11 +val_435 11 +val_10 11 +val_277 11 +val_273 11 +val_306 11 +val_224 11 +val_309 11 +val_389 11 +val_327 11 +val_242 11 +val_369 11 +val_392 11 +val_272 11 +val_331 11 +val_401 11 +val_242 11 +val_452 11 +val_177 11 +val_226 11 +val_5 11 +val_497 11 +val_402 11 +val_396 11 +val_317 11 +val_395 11 +val_58 11 +val_35 11 +val_336 11 +val_95 11 +val_11 11 +val_168 11 +val_34 11 +val_229 11 +val_233 11 +val_143 11 +val_472 11 +val_322 11 +val_498 11 +val_160 11 +val_195 11 +val_42 11 +val_321 11 +val_430 11 +val_119 11 +val_489 11 +val_458 11 +val_78 11 +val_76 11 +val_41 11 +val_223 11 +val_492 11 +val_149 11 +val_449 11 +val_218 11 +val_228 11 +val_138 11 +val_453 11 +val_30 11 +val_209 11 +val_64 11 +val_468 11 +val_76 11 +val_74 11 +val_342 11 +val_69 11 +val_230 11 +val_33 11 +val_368 11 +val_103 11 +val_296 11 +val_113 11 +val_216 11 +val_367 11 +val_344 11 +val_167 11 +val_274 11 +val_219 11 +val_239 11 +val_485 11 +val_116 11 +val_223 11 +val_256 11 +val_263 11 +val_70 11 +val_487 11 +val_480 11 +val_401 11 +val_288 11 +val_191 11 +val_5 11 +val_244 11 +val_438 11 +val_128 11 +val_467 11 +val_432 11 +val_202 11 +val_316 11 +val_229 11 +val_469 11 +val_463 11 +val_280 11 +val_2 11 +val_35 11 +val_283 11 +val_331 11 +val_235 11 +val_80 11 +val_44 11 +val_193 11 +val_321 11 +val_335 11 +val_104 11 +val_466 11 +val_366 11 +val_175 11 +val_403 11 +val_483 11 +val_53 11 +val_105 11 +val_257 11 +val_406 11 +val_409 11 +val_190 11 +val_406 11 +val_401 11 +val_114 11 +val_258 11 +val_90 11 +val_203 11 +val_262 11 +val_348 11 +val_424 11 +val_12 11 +val_396 11 +val_201 11 +val_217 11 +val_164 11 +val_431 11 +val_454 11 +val_478 11 +val_298 11 +val_125 11 +val_431 11 +val_164 11 +val_424 11 +val_187 11 +val_382 11 +val_5 11 +val_70 11 +val_397 11 +val_480 11 +val_291 11 +val_24 11 +val_351 11 +val_255 11 +val_104 11 +val_70 11 +val_163 11 +val_438 11 +val_119 11 +val_414 11 +val_200 11 +val_491 11 +val_237 11 +val_439 11 +val_360 11 +val_248 11 +val_479 11 +val_305 11 +val_417 11 +val_199 11 +val_444 11 +val_120 11 +val_429 11 +val_169 11 +val_443 11 +val_323 11 +val_325 11 +val_277 11 +val_230 11 +val_478 11 +val_178 11 +val_468 11 +val_310 11 +val_317 11 +val_333 11 +val_493 11 +val_460 11 +val_207 11 +val_249 11 +val_265 11 +val_480 11 +val_83 11 +val_136 11 +val_353 11 +val_172 11 +val_214 11 +val_462 11 +val_233 11 +val_406 11 +val_133 11 +val_175 11 +val_189 11 +val_454 11 +val_375 11 +val_401 11 +val_421 11 +val_407 11 +val_384 11 +val_256 11 +val_26 11 +val_134 11 +val_67 11 +val_384 11 +val_379 11 +val_18 11 +val_462 11 +val_492 11 +val_100 11 +val_298 11 +val_9 11 +val_341 11 +val_498 11 +val_146 11 +val_458 11 +val_362 11 +val_186 11 +val_285 11 +val_348 11 +val_167 11 +val_18 11 +val_273 11 +val_183 11 +val_281 11 +val_344 11 +val_97 11 +val_469 11 +val_315 11 +val_84 11 +val_28 11 +val_37 11 +val_448 11 +val_152 11 +val_348 11 +val_307 11 +val_194 11 +val_414 11 +val_477 11 +val_222 11 +val_126 11 +val_90 11 +val_169 11 +val_403 11 +val_400 11 +val_200 11 +val_97 11 diff --git a/sql/hive/src/test/resources/golden/Partition pruning - non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344 b/sql/hive/src/test/resources/golden/Partition pruning - non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344 new file mode 100644 index 0000000000..7ba6caf9d8 --- /dev/null +++ b/sql/hive/src/test/resources/golden/Partition pruning - non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344 @@ -0,0 +1,500 @@ +val_238 +val_86 +val_311 +val_27 +val_165 +val_409 +val_255 +val_278 +val_98 +val_484 +val_265 +val_193 +val_401 +val_150 +val_273 +val_224 +val_369 +val_66 +val_128 +val_213 +val_146 +val_406 +val_429 +val_374 +val_152 +val_469 +val_145 +val_495 +val_37 +val_327 +val_281 +val_277 +val_209 +val_15 +val_82 +val_403 +val_166 +val_417 +val_430 +val_252 +val_292 +val_219 +val_287 +val_153 +val_193 +val_338 +val_446 +val_459 +val_394 +val_237 +val_482 +val_174 +val_413 +val_494 +val_207 +val_199 +val_466 +val_208 +val_174 +val_399 +val_396 +val_247 +val_417 +val_489 +val_162 +val_377 +val_397 +val_309 +val_365 +val_266 +val_439 +val_342 +val_367 +val_325 +val_167 +val_195 +val_475 +val_17 +val_113 +val_155 +val_203 +val_339 +val_0 +val_455 +val_128 +val_311 +val_316 +val_57 +val_302 +val_205 +val_149 +val_438 +val_345 +val_129 +val_170 +val_20 +val_489 +val_157 +val_378 +val_221 +val_92 +val_111 +val_47 +val_72 +val_4 +val_280 +val_35 +val_427 +val_277 +val_208 +val_356 +val_399 +val_169 +val_382 +val_498 +val_125 +val_386 +val_437 +val_469 +val_192 +val_286 +val_187 +val_176 +val_54 +val_459 +val_51 +val_138 +val_103 +val_239 +val_213 +val_216 +val_430 +val_278 +val_176 +val_289 +val_221 +val_65 +val_318 +val_332 +val_311 +val_275 +val_137 +val_241 +val_83 +val_333 +val_180 +val_284 +val_12 +val_230 +val_181 +val_67 +val_260 +val_404 +val_384 +val_489 +val_353 +val_373 +val_272 +val_138 +val_217 +val_84 +val_348 +val_466 +val_58 +val_8 +val_411 +val_230 +val_208 +val_348 +val_24 +val_463 +val_431 +val_179 +val_172 +val_42 +val_129 +val_158 +val_119 +val_496 +val_0 +val_322 +val_197 +val_468 +val_393 +val_454 +val_100 +val_298 +val_199 +val_191 +val_418 +val_96 +val_26 +val_165 +val_327 +val_230 +val_205 +val_120 +val_131 +val_51 +val_404 +val_43 +val_436 +val_156 +val_469 +val_468 +val_308 +val_95 +val_196 +val_288 +val_481 +val_457 +val_98 +val_282 +val_197 +val_187 +val_318 +val_318 +val_409 +val_470 +val_137 +val_369 +val_316 +val_169 +val_413 +val_85 +val_77 +val_0 +val_490 +val_87 +val_364 +val_179 +val_118 +val_134 +val_395 +val_282 +val_138 +val_238 +val_419 +val_15 +val_118 +val_72 +val_90 +val_307 +val_19 +val_435 +val_10 +val_277 +val_273 +val_306 +val_224 +val_309 +val_389 +val_327 +val_242 +val_369 +val_392 +val_272 +val_331 +val_401 +val_242 +val_452 +val_177 +val_226 +val_5 +val_497 +val_402 +val_396 +val_317 +val_395 +val_58 +val_35 +val_336 +val_95 +val_11 +val_168 +val_34 +val_229 +val_233 +val_143 +val_472 +val_322 +val_498 +val_160 +val_195 +val_42 +val_321 +val_430 +val_119 +val_489 +val_458 +val_78 +val_76 +val_41 +val_223 +val_492 +val_149 +val_449 +val_218 +val_228 +val_138 +val_453 +val_30 +val_209 +val_64 +val_468 +val_76 +val_74 +val_342 +val_69 +val_230 +val_33 +val_368 +val_103 +val_296 +val_113 +val_216 +val_367 +val_344 +val_167 +val_274 +val_219 +val_239 +val_485 +val_116 +val_223 +val_256 +val_263 +val_70 +val_487 +val_480 +val_401 +val_288 +val_191 +val_5 +val_244 +val_438 +val_128 +val_467 +val_432 +val_202 +val_316 +val_229 +val_469 +val_463 +val_280 +val_2 +val_35 +val_283 +val_331 +val_235 +val_80 +val_44 +val_193 +val_321 +val_335 +val_104 +val_466 +val_366 +val_175 +val_403 +val_483 +val_53 +val_105 +val_257 +val_406 +val_409 +val_190 +val_406 +val_401 +val_114 +val_258 +val_90 +val_203 +val_262 +val_348 +val_424 +val_12 +val_396 +val_201 +val_217 +val_164 +val_431 +val_454 +val_478 +val_298 +val_125 +val_431 +val_164 +val_424 +val_187 +val_382 +val_5 +val_70 +val_397 +val_480 +val_291 +val_24 +val_351 +val_255 +val_104 +val_70 +val_163 +val_438 +val_119 +val_414 +val_200 +val_491 +val_237 +val_439 +val_360 +val_248 +val_479 +val_305 +val_417 +val_199 +val_444 +val_120 +val_429 +val_169 +val_443 +val_323 +val_325 +val_277 +val_230 +val_478 +val_178 +val_468 +val_310 +val_317 +val_333 +val_493 +val_460 +val_207 +val_249 +val_265 +val_480 +val_83 +val_136 +val_353 +val_172 +val_214 +val_462 +val_233 +val_406 +val_133 +val_175 +val_189 +val_454 +val_375 +val_401 +val_421 +val_407 +val_384 +val_256 +val_26 +val_134 +val_67 +val_384 +val_379 +val_18 +val_462 +val_492 +val_100 +val_298 +val_9 +val_341 +val_498 +val_146 +val_458 +val_362 +val_186 +val_285 +val_348 +val_167 +val_18 +val_273 +val_183 +val_281 +val_344 +val_97 +val_469 +val_315 +val_84 +val_28 +val_37 +val_448 +val_152 +val_348 +val_307 +val_194 +val_414 +val_477 +val_222 +val_126 +val_90 +val_169 +val_403 +val_400 +val_200 +val_97 diff --git a/sql/hive/src/test/resources/golden/Partition pruning - non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb b/sql/hive/src/test/resources/golden/Partition pruning - non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb new file mode 100644 index 0000000000..444039e75f --- /dev/null +++ b/sql/hive/src/test/resources/golden/Partition pruning - non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb @@ -0,0 +1,500 @@ +476 +172 +622 +54 +330 +818 +510 +556 +196 +968 +530 +386 +802 +300 +546 +448 +738 +132 +256 +426 +292 +812 +858 +748 +304 +938 +290 +990 +74 +654 +562 +554 +418 +30 +164 +806 +332 +834 +860 +504 +584 +438 +574 +306 +386 +676 +892 +918 +788 +474 +964 +348 +826 +988 +414 +398 +932 +416 +348 +798 +792 +494 +834 +978 +324 +754 +794 +618 +730 +532 +878 +684 +734 +650 +334 +390 +950 +34 +226 +310 +406 +678 +0 +910 +256 +622 +632 +114 +604 +410 +298 +876 +690 +258 +340 +40 +978 +314 +756 +442 +184 +222 +94 +144 +8 +560 +70 +854 +554 +416 +712 +798 +338 +764 +996 +250 +772 +874 +938 +384 +572 +374 +352 +108 +918 +102 +276 +206 +478 +426 +432 +860 +556 +352 +578 +442 +130 +636 +664 +622 +550 +274 +482 +166 +666 +360 +568 +24 +460 +362 +134 +520 +808 +768 +978 +706 +746 +544 +276 +434 +168 +696 +932 +116 +16 +822 +460 +416 +696 +48 +926 +862 +358 +344 +84 +258 +316 +238 +992 +0 +644 +394 +936 +786 +908 +200 +596 +398 +382 +836 +192 +52 +330 +654 +460 +410 +240 +262 +102 +808 +86 +872 +312 +938 +936 +616 +190 +392 +576 +962 +914 +196 +564 +394 +374 +636 +636 +818 +940 +274 +738 +632 +338 +826 +170 +154 +0 +980 +174 +728 +358 +236 +268 +790 +564 +276 +476 +838 +30 +236 +144 +180 +614 +38 +870 +20 +554 +546 +612 +448 +618 +778 +654 +484 +738 +784 +544 +662 +802 +484 +904 +354 +452 +10 +994 +804 +792 +634 +790 +116 +70 +672 +190 +22 +336 +68 +458 +466 +286 +944 +644 +996 +320 +390 +84 +642 +860 +238 +978 +916 +156 +152 +82 +446 +984 +298 +898 +436 +456 +276 +906 +60 +418 +128 +936 +152 +148 +684 +138 +460 +66 +736 +206 +592 +226 +432 +734 +688 +334 +548 +438 +478 +970 +232 +446 +512 +526 +140 +974 +960 +802 +576 +382 +10 +488 +876 +256 +934 +864 +404 +632 +458 +938 +926 +560 +4 +70 +566 +662 +470 +160 +88 +386 +642 +670 +208 +932 +732 +350 +806 +966 +106 +210 +514 +812 +818 +380 +812 +802 +228 +516 +180 +406 +524 +696 +848 +24 +792 +402 +434 +328 +862 +908 +956 +596 +250 +862 +328 +848 +374 +764 +10 +140 +794 +960 +582 +48 +702 +510 +208 +140 +326 +876 +238 +828 +400 +982 +474 +878 +720 +496 +958 +610 +834 +398 +888 +240 +858 +338 +886 +646 +650 +554 +460 +956 +356 +936 +620 +634 +666 +986 +920 +414 +498 +530 +960 +166 +272 +706 +344 +428 +924 +466 +812 +266 +350 +378 +908 +750 +802 +842 +814 +768 +512 +52 +268 +134 +768 +758 +36 +924 +984 +200 +596 +18 +682 +996 +292 +916 +724 +372 +570 +696 +334 +36 +546 +366 +562 +688 +194 +938 +630 +168 +56 +74 +896 +304 +696 +614 +388 +828 +954 +444 +252 +180 +338 +806 +800 +400 +194 diff --git a/sql/hive/src/test/resources/golden/Partition pruning - pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10 b/sql/hive/src/test/resources/golden/Partition pruning - pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10 new file mode 100644 index 0000000000..d83d8b62b7 --- /dev/null +++ b/sql/hive/src/test/resources/golden/Partition pruning - pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10 @@ -0,0 +1,1000 @@ +val_238 11 +val_86 11 +val_311 11 +val_27 11 +val_165 11 +val_409 11 +val_255 11 +val_278 11 +val_98 11 +val_484 11 +val_265 11 +val_193 11 +val_401 11 +val_150 11 +val_273 11 +val_224 11 +val_369 11 +val_66 11 +val_128 11 +val_213 11 +val_146 11 +val_406 11 +val_429 11 +val_374 11 +val_152 11 +val_469 11 +val_145 11 +val_495 11 +val_37 11 +val_327 11 +val_281 11 +val_277 11 +val_209 11 +val_15 11 +val_82 11 +val_403 11 +val_166 11 +val_417 11 +val_430 11 +val_252 11 +val_292 11 +val_219 11 +val_287 11 +val_153 11 +val_193 11 +val_338 11 +val_446 11 +val_459 11 +val_394 11 +val_237 11 +val_482 11 +val_174 11 +val_413 11 +val_494 11 +val_207 11 +val_199 11 +val_466 11 +val_208 11 +val_174 11 +val_399 11 +val_396 11 +val_247 11 +val_417 11 +val_489 11 +val_162 11 +val_377 11 +val_397 11 +val_309 11 +val_365 11 +val_266 11 +val_439 11 +val_342 11 +val_367 11 +val_325 11 +val_167 11 +val_195 11 +val_475 11 +val_17 11 +val_113 11 +val_155 11 +val_203 11 +val_339 11 +val_0 11 +val_455 11 +val_128 11 +val_311 11 +val_316 11 +val_57 11 +val_302 11 +val_205 11 +val_149 11 +val_438 11 +val_345 11 +val_129 11 +val_170 11 +val_20 11 +val_489 11 +val_157 11 +val_378 11 +val_221 11 +val_92 11 +val_111 11 +val_47 11 +val_72 11 +val_4 11 +val_280 11 +val_35 11 +val_427 11 +val_277 11 +val_208 11 +val_356 11 +val_399 11 +val_169 11 +val_382 11 +val_498 11 +val_125 11 +val_386 11 +val_437 11 +val_469 11 +val_192 11 +val_286 11 +val_187 11 +val_176 11 +val_54 11 +val_459 11 +val_51 11 +val_138 11 +val_103 11 +val_239 11 +val_213 11 +val_216 11 +val_430 11 +val_278 11 +val_176 11 +val_289 11 +val_221 11 +val_65 11 +val_318 11 +val_332 11 +val_311 11 +val_275 11 +val_137 11 +val_241 11 +val_83 11 +val_333 11 +val_180 11 +val_284 11 +val_12 11 +val_230 11 +val_181 11 +val_67 11 +val_260 11 +val_404 11 +val_384 11 +val_489 11 +val_353 11 +val_373 11 +val_272 11 +val_138 11 +val_217 11 +val_84 11 +val_348 11 +val_466 11 +val_58 11 +val_8 11 +val_411 11 +val_230 11 +val_208 11 +val_348 11 +val_24 11 +val_463 11 +val_431 11 +val_179 11 +val_172 11 +val_42 11 +val_129 11 +val_158 11 +val_119 11 +val_496 11 +val_0 11 +val_322 11 +val_197 11 +val_468 11 +val_393 11 +val_454 11 +val_100 11 +val_298 11 +val_199 11 +val_191 11 +val_418 11 +val_96 11 +val_26 11 +val_165 11 +val_327 11 +val_230 11 +val_205 11 +val_120 11 +val_131 11 +val_51 11 +val_404 11 +val_43 11 +val_436 11 +val_156 11 +val_469 11 +val_468 11 +val_308 11 +val_95 11 +val_196 11 +val_288 11 +val_481 11 +val_457 11 +val_98 11 +val_282 11 +val_197 11 +val_187 11 +val_318 11 +val_318 11 +val_409 11 +val_470 11 +val_137 11 +val_369 11 +val_316 11 +val_169 11 +val_413 11 +val_85 11 +val_77 11 +val_0 11 +val_490 11 +val_87 11 +val_364 11 +val_179 11 +val_118 11 +val_134 11 +val_395 11 +val_282 11 +val_138 11 +val_238 11 +val_419 11 +val_15 11 +val_118 11 +val_72 11 +val_90 11 +val_307 11 +val_19 11 +val_435 11 +val_10 11 +val_277 11 +val_273 11 +val_306 11 +val_224 11 +val_309 11 +val_389 11 +val_327 11 +val_242 11 +val_369 11 +val_392 11 +val_272 11 +val_331 11 +val_401 11 +val_242 11 +val_452 11 +val_177 11 +val_226 11 +val_5 11 +val_497 11 +val_402 11 +val_396 11 +val_317 11 +val_395 11 +val_58 11 +val_35 11 +val_336 11 +val_95 11 +val_11 11 +val_168 11 +val_34 11 +val_229 11 +val_233 11 +val_143 11 +val_472 11 +val_322 11 +val_498 11 +val_160 11 +val_195 11 +val_42 11 +val_321 11 +val_430 11 +val_119 11 +val_489 11 +val_458 11 +val_78 11 +val_76 11 +val_41 11 +val_223 11 +val_492 11 +val_149 11 +val_449 11 +val_218 11 +val_228 11 +val_138 11 +val_453 11 +val_30 11 +val_209 11 +val_64 11 +val_468 11 +val_76 11 +val_74 11 +val_342 11 +val_69 11 +val_230 11 +val_33 11 +val_368 11 +val_103 11 +val_296 11 +val_113 11 +val_216 11 +val_367 11 +val_344 11 +val_167 11 +val_274 11 +val_219 11 +val_239 11 +val_485 11 +val_116 11 +val_223 11 +val_256 11 +val_263 11 +val_70 11 +val_487 11 +val_480 11 +val_401 11 +val_288 11 +val_191 11 +val_5 11 +val_244 11 +val_438 11 +val_128 11 +val_467 11 +val_432 11 +val_202 11 +val_316 11 +val_229 11 +val_469 11 +val_463 11 +val_280 11 +val_2 11 +val_35 11 +val_283 11 +val_331 11 +val_235 11 +val_80 11 +val_44 11 +val_193 11 +val_321 11 +val_335 11 +val_104 11 +val_466 11 +val_366 11 +val_175 11 +val_403 11 +val_483 11 +val_53 11 +val_105 11 +val_257 11 +val_406 11 +val_409 11 +val_190 11 +val_406 11 +val_401 11 +val_114 11 +val_258 11 +val_90 11 +val_203 11 +val_262 11 +val_348 11 +val_424 11 +val_12 11 +val_396 11 +val_201 11 +val_217 11 +val_164 11 +val_431 11 +val_454 11 +val_478 11 +val_298 11 +val_125 11 +val_431 11 +val_164 11 +val_424 11 +val_187 11 +val_382 11 +val_5 11 +val_70 11 +val_397 11 +val_480 11 +val_291 11 +val_24 11 +val_351 11 +val_255 11 +val_104 11 +val_70 11 +val_163 11 +val_438 11 +val_119 11 +val_414 11 +val_200 11 +val_491 11 +val_237 11 +val_439 11 +val_360 11 +val_248 11 +val_479 11 +val_305 11 +val_417 11 +val_199 11 +val_444 11 +val_120 11 +val_429 11 +val_169 11 +val_443 11 +val_323 11 +val_325 11 +val_277 11 +val_230 11 +val_478 11 +val_178 11 +val_468 11 +val_310 11 +val_317 11 +val_333 11 +val_493 11 +val_460 11 +val_207 11 +val_249 11 +val_265 11 +val_480 11 +val_83 11 +val_136 11 +val_353 11 +val_172 11 +val_214 11 +val_462 11 +val_233 11 +val_406 11 +val_133 11 +val_175 11 +val_189 11 +val_454 11 +val_375 11 +val_401 11 +val_421 11 +val_407 11 +val_384 11 +val_256 11 +val_26 11 +val_134 11 +val_67 11 +val_384 11 +val_379 11 +val_18 11 +val_462 11 +val_492 11 +val_100 11 +val_298 11 +val_9 11 +val_341 11 +val_498 11 +val_146 11 +val_458 11 +val_362 11 +val_186 11 +val_285 11 +val_348 11 +val_167 11 +val_18 11 +val_273 11 +val_183 11 +val_281 11 +val_344 11 +val_97 11 +val_469 11 +val_315 11 +val_84 11 +val_28 11 +val_37 11 +val_448 11 +val_152 11 +val_348 11 +val_307 11 +val_194 11 +val_414 11 +val_477 11 +val_222 11 +val_126 11 +val_90 11 +val_169 11 +val_403 11 +val_400 11 +val_200 11 +val_97 11 +val_238 11 +val_86 11 +val_311 11 +val_27 11 +val_165 11 +val_409 11 +val_255 11 +val_278 11 +val_98 11 +val_484 11 +val_265 11 +val_193 11 +val_401 11 +val_150 11 +val_273 11 +val_224 11 +val_369 11 +val_66 11 +val_128 11 +val_213 11 +val_146 11 +val_406 11 +val_429 11 +val_374 11 +val_152 11 +val_469 11 +val_145 11 +val_495 11 +val_37 11 +val_327 11 +val_281 11 +val_277 11 +val_209 11 +val_15 11 +val_82 11 +val_403 11 +val_166 11 +val_417 11 +val_430 11 +val_252 11 +val_292 11 +val_219 11 +val_287 11 +val_153 11 +val_193 11 +val_338 11 +val_446 11 +val_459 11 +val_394 11 +val_237 11 +val_482 11 +val_174 11 +val_413 11 +val_494 11 +val_207 11 +val_199 11 +val_466 11 +val_208 11 +val_174 11 +val_399 11 +val_396 11 +val_247 11 +val_417 11 +val_489 11 +val_162 11 +val_377 11 +val_397 11 +val_309 11 +val_365 11 +val_266 11 +val_439 11 +val_342 11 +val_367 11 +val_325 11 +val_167 11 +val_195 11 +val_475 11 +val_17 11 +val_113 11 +val_155 11 +val_203 11 +val_339 11 +val_0 11 +val_455 11 +val_128 11 +val_311 11 +val_316 11 +val_57 11 +val_302 11 +val_205 11 +val_149 11 +val_438 11 +val_345 11 +val_129 11 +val_170 11 +val_20 11 +val_489 11 +val_157 11 +val_378 11 +val_221 11 +val_92 11 +val_111 11 +val_47 11 +val_72 11 +val_4 11 +val_280 11 +val_35 11 +val_427 11 +val_277 11 +val_208 11 +val_356 11 +val_399 11 +val_169 11 +val_382 11 +val_498 11 +val_125 11 +val_386 11 +val_437 11 +val_469 11 +val_192 11 +val_286 11 +val_187 11 +val_176 11 +val_54 11 +val_459 11 +val_51 11 +val_138 11 +val_103 11 +val_239 11 +val_213 11 +val_216 11 +val_430 11 +val_278 11 +val_176 11 +val_289 11 +val_221 11 +val_65 11 +val_318 11 +val_332 11 +val_311 11 +val_275 11 +val_137 11 +val_241 11 +val_83 11 +val_333 11 +val_180 11 +val_284 11 +val_12 11 +val_230 11 +val_181 11 +val_67 11 +val_260 11 +val_404 11 +val_384 11 +val_489 11 +val_353 11 +val_373 11 +val_272 11 +val_138 11 +val_217 11 +val_84 11 +val_348 11 +val_466 11 +val_58 11 +val_8 11 +val_411 11 +val_230 11 +val_208 11 +val_348 11 +val_24 11 +val_463 11 +val_431 11 +val_179 11 +val_172 11 +val_42 11 +val_129 11 +val_158 11 +val_119 11 +val_496 11 +val_0 11 +val_322 11 +val_197 11 +val_468 11 +val_393 11 +val_454 11 +val_100 11 +val_298 11 +val_199 11 +val_191 11 +val_418 11 +val_96 11 +val_26 11 +val_165 11 +val_327 11 +val_230 11 +val_205 11 +val_120 11 +val_131 11 +val_51 11 +val_404 11 +val_43 11 +val_436 11 +val_156 11 +val_469 11 +val_468 11 +val_308 11 +val_95 11 +val_196 11 +val_288 11 +val_481 11 +val_457 11 +val_98 11 +val_282 11 +val_197 11 +val_187 11 +val_318 11 +val_318 11 +val_409 11 +val_470 11 +val_137 11 +val_369 11 +val_316 11 +val_169 11 +val_413 11 +val_85 11 +val_77 11 +val_0 11 +val_490 11 +val_87 11 +val_364 11 +val_179 11 +val_118 11 +val_134 11 +val_395 11 +val_282 11 +val_138 11 +val_238 11 +val_419 11 +val_15 11 +val_118 11 +val_72 11 +val_90 11 +val_307 11 +val_19 11 +val_435 11 +val_10 11 +val_277 11 +val_273 11 +val_306 11 +val_224 11 +val_309 11 +val_389 11 +val_327 11 +val_242 11 +val_369 11 +val_392 11 +val_272 11 +val_331 11 +val_401 11 +val_242 11 +val_452 11 +val_177 11 +val_226 11 +val_5 11 +val_497 11 +val_402 11 +val_396 11 +val_317 11 +val_395 11 +val_58 11 +val_35 11 +val_336 11 +val_95 11 +val_11 11 +val_168 11 +val_34 11 +val_229 11 +val_233 11 +val_143 11 +val_472 11 +val_322 11 +val_498 11 +val_160 11 +val_195 11 +val_42 11 +val_321 11 +val_430 11 +val_119 11 +val_489 11 +val_458 11 +val_78 11 +val_76 11 +val_41 11 +val_223 11 +val_492 11 +val_149 11 +val_449 11 +val_218 11 +val_228 11 +val_138 11 +val_453 11 +val_30 11 +val_209 11 +val_64 11 +val_468 11 +val_76 11 +val_74 11 +val_342 11 +val_69 11 +val_230 11 +val_33 11 +val_368 11 +val_103 11 +val_296 11 +val_113 11 +val_216 11 +val_367 11 +val_344 11 +val_167 11 +val_274 11 +val_219 11 +val_239 11 +val_485 11 +val_116 11 +val_223 11 +val_256 11 +val_263 11 +val_70 11 +val_487 11 +val_480 11 +val_401 11 +val_288 11 +val_191 11 +val_5 11 +val_244 11 +val_438 11 +val_128 11 +val_467 11 +val_432 11 +val_202 11 +val_316 11 +val_229 11 +val_469 11 +val_463 11 +val_280 11 +val_2 11 +val_35 11 +val_283 11 +val_331 11 +val_235 11 +val_80 11 +val_44 11 +val_193 11 +val_321 11 +val_335 11 +val_104 11 +val_466 11 +val_366 11 +val_175 11 +val_403 11 +val_483 11 +val_53 11 +val_105 11 +val_257 11 +val_406 11 +val_409 11 +val_190 11 +val_406 11 +val_401 11 +val_114 11 +val_258 11 +val_90 11 +val_203 11 +val_262 11 +val_348 11 +val_424 11 +val_12 11 +val_396 11 +val_201 11 +val_217 11 +val_164 11 +val_431 11 +val_454 11 +val_478 11 +val_298 11 +val_125 11 +val_431 11 +val_164 11 +val_424 11 +val_187 11 +val_382 11 +val_5 11 +val_70 11 +val_397 11 +val_480 11 +val_291 11 +val_24 11 +val_351 11 +val_255 11 +val_104 11 +val_70 11 +val_163 11 +val_438 11 +val_119 11 +val_414 11 +val_200 11 +val_491 11 +val_237 11 +val_439 11 +val_360 11 +val_248 11 +val_479 11 +val_305 11 +val_417 11 +val_199 11 +val_444 11 +val_120 11 +val_429 11 +val_169 11 +val_443 11 +val_323 11 +val_325 11 +val_277 11 +val_230 11 +val_478 11 +val_178 11 +val_468 11 +val_310 11 +val_317 11 +val_333 11 +val_493 11 +val_460 11 +val_207 11 +val_249 11 +val_265 11 +val_480 11 +val_83 11 +val_136 11 +val_353 11 +val_172 11 +val_214 11 +val_462 11 +val_233 11 +val_406 11 +val_133 11 +val_175 11 +val_189 11 +val_454 11 +val_375 11 +val_401 11 +val_421 11 +val_407 11 +val_384 11 +val_256 11 +val_26 11 +val_134 11 +val_67 11 +val_384 11 +val_379 11 +val_18 11 +val_462 11 +val_492 11 +val_100 11 +val_298 11 +val_9 11 +val_341 11 +val_498 11 +val_146 11 +val_458 11 +val_362 11 +val_186 11 +val_285 11 +val_348 11 +val_167 11 +val_18 11 +val_273 11 +val_183 11 +val_281 11 +val_344 11 +val_97 11 +val_469 11 +val_315 11 +val_84 11 +val_28 11 +val_37 11 +val_448 11 +val_152 11 +val_348 11 +val_307 11 +val_194 11 +val_414 11 +val_477 11 +val_222 11 +val_126 11 +val_90 11 +val_169 11 +val_403 11 +val_400 11 +val_200 11 +val_97 11 diff --git a/sql/hive/src/test/resources/golden/Partition pruning - with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190 b/sql/hive/src/test/resources/golden/Partition pruning - with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190 new file mode 100644 index 0000000000..d83d8b62b7 --- /dev/null +++ b/sql/hive/src/test/resources/golden/Partition pruning - with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190 @@ -0,0 +1,1000 @@ +val_238 11 +val_86 11 +val_311 11 +val_27 11 +val_165 11 +val_409 11 +val_255 11 +val_278 11 +val_98 11 +val_484 11 +val_265 11 +val_193 11 +val_401 11 +val_150 11 +val_273 11 +val_224 11 +val_369 11 +val_66 11 +val_128 11 +val_213 11 +val_146 11 +val_406 11 +val_429 11 +val_374 11 +val_152 11 +val_469 11 +val_145 11 +val_495 11 +val_37 11 +val_327 11 +val_281 11 +val_277 11 +val_209 11 +val_15 11 +val_82 11 +val_403 11 +val_166 11 +val_417 11 +val_430 11 +val_252 11 +val_292 11 +val_219 11 +val_287 11 +val_153 11 +val_193 11 +val_338 11 +val_446 11 +val_459 11 +val_394 11 +val_237 11 +val_482 11 +val_174 11 +val_413 11 +val_494 11 +val_207 11 +val_199 11 +val_466 11 +val_208 11 +val_174 11 +val_399 11 +val_396 11 +val_247 11 +val_417 11 +val_489 11 +val_162 11 +val_377 11 +val_397 11 +val_309 11 +val_365 11 +val_266 11 +val_439 11 +val_342 11 +val_367 11 +val_325 11 +val_167 11 +val_195 11 +val_475 11 +val_17 11 +val_113 11 +val_155 11 +val_203 11 +val_339 11 +val_0 11 +val_455 11 +val_128 11 +val_311 11 +val_316 11 +val_57 11 +val_302 11 +val_205 11 +val_149 11 +val_438 11 +val_345 11 +val_129 11 +val_170 11 +val_20 11 +val_489 11 +val_157 11 +val_378 11 +val_221 11 +val_92 11 +val_111 11 +val_47 11 +val_72 11 +val_4 11 +val_280 11 +val_35 11 +val_427 11 +val_277 11 +val_208 11 +val_356 11 +val_399 11 +val_169 11 +val_382 11 +val_498 11 +val_125 11 +val_386 11 +val_437 11 +val_469 11 +val_192 11 +val_286 11 +val_187 11 +val_176 11 +val_54 11 +val_459 11 +val_51 11 +val_138 11 +val_103 11 +val_239 11 +val_213 11 +val_216 11 +val_430 11 +val_278 11 +val_176 11 +val_289 11 +val_221 11 +val_65 11 +val_318 11 +val_332 11 +val_311 11 +val_275 11 +val_137 11 +val_241 11 +val_83 11 +val_333 11 +val_180 11 +val_284 11 +val_12 11 +val_230 11 +val_181 11 +val_67 11 +val_260 11 +val_404 11 +val_384 11 +val_489 11 +val_353 11 +val_373 11 +val_272 11 +val_138 11 +val_217 11 +val_84 11 +val_348 11 +val_466 11 +val_58 11 +val_8 11 +val_411 11 +val_230 11 +val_208 11 +val_348 11 +val_24 11 +val_463 11 +val_431 11 +val_179 11 +val_172 11 +val_42 11 +val_129 11 +val_158 11 +val_119 11 +val_496 11 +val_0 11 +val_322 11 +val_197 11 +val_468 11 +val_393 11 +val_454 11 +val_100 11 +val_298 11 +val_199 11 +val_191 11 +val_418 11 +val_96 11 +val_26 11 +val_165 11 +val_327 11 +val_230 11 +val_205 11 +val_120 11 +val_131 11 +val_51 11 +val_404 11 +val_43 11 +val_436 11 +val_156 11 +val_469 11 +val_468 11 +val_308 11 +val_95 11 +val_196 11 +val_288 11 +val_481 11 +val_457 11 +val_98 11 +val_282 11 +val_197 11 +val_187 11 +val_318 11 +val_318 11 +val_409 11 +val_470 11 +val_137 11 +val_369 11 +val_316 11 +val_169 11 +val_413 11 +val_85 11 +val_77 11 +val_0 11 +val_490 11 +val_87 11 +val_364 11 +val_179 11 +val_118 11 +val_134 11 +val_395 11 +val_282 11 +val_138 11 +val_238 11 +val_419 11 +val_15 11 +val_118 11 +val_72 11 +val_90 11 +val_307 11 +val_19 11 +val_435 11 +val_10 11 +val_277 11 +val_273 11 +val_306 11 +val_224 11 +val_309 11 +val_389 11 +val_327 11 +val_242 11 +val_369 11 +val_392 11 +val_272 11 +val_331 11 +val_401 11 +val_242 11 +val_452 11 +val_177 11 +val_226 11 +val_5 11 +val_497 11 +val_402 11 +val_396 11 +val_317 11 +val_395 11 +val_58 11 +val_35 11 +val_336 11 +val_95 11 +val_11 11 +val_168 11 +val_34 11 +val_229 11 +val_233 11 +val_143 11 +val_472 11 +val_322 11 +val_498 11 +val_160 11 +val_195 11 +val_42 11 +val_321 11 +val_430 11 +val_119 11 +val_489 11 +val_458 11 +val_78 11 +val_76 11 +val_41 11 +val_223 11 +val_492 11 +val_149 11 +val_449 11 +val_218 11 +val_228 11 +val_138 11 +val_453 11 +val_30 11 +val_209 11 +val_64 11 +val_468 11 +val_76 11 +val_74 11 +val_342 11 +val_69 11 +val_230 11 +val_33 11 +val_368 11 +val_103 11 +val_296 11 +val_113 11 +val_216 11 +val_367 11 +val_344 11 +val_167 11 +val_274 11 +val_219 11 +val_239 11 +val_485 11 +val_116 11 +val_223 11 +val_256 11 +val_263 11 +val_70 11 +val_487 11 +val_480 11 +val_401 11 +val_288 11 +val_191 11 +val_5 11 +val_244 11 +val_438 11 +val_128 11 +val_467 11 +val_432 11 +val_202 11 +val_316 11 +val_229 11 +val_469 11 +val_463 11 +val_280 11 +val_2 11 +val_35 11 +val_283 11 +val_331 11 +val_235 11 +val_80 11 +val_44 11 +val_193 11 +val_321 11 +val_335 11 +val_104 11 +val_466 11 +val_366 11 +val_175 11 +val_403 11 +val_483 11 +val_53 11 +val_105 11 +val_257 11 +val_406 11 +val_409 11 +val_190 11 +val_406 11 +val_401 11 +val_114 11 +val_258 11 +val_90 11 +val_203 11 +val_262 11 +val_348 11 +val_424 11 +val_12 11 +val_396 11 +val_201 11 +val_217 11 +val_164 11 +val_431 11 +val_454 11 +val_478 11 +val_298 11 +val_125 11 +val_431 11 +val_164 11 +val_424 11 +val_187 11 +val_382 11 +val_5 11 +val_70 11 +val_397 11 +val_480 11 +val_291 11 +val_24 11 +val_351 11 +val_255 11 +val_104 11 +val_70 11 +val_163 11 +val_438 11 +val_119 11 +val_414 11 +val_200 11 +val_491 11 +val_237 11 +val_439 11 +val_360 11 +val_248 11 +val_479 11 +val_305 11 +val_417 11 +val_199 11 +val_444 11 +val_120 11 +val_429 11 +val_169 11 +val_443 11 +val_323 11 +val_325 11 +val_277 11 +val_230 11 +val_478 11 +val_178 11 +val_468 11 +val_310 11 +val_317 11 +val_333 11 +val_493 11 +val_460 11 +val_207 11 +val_249 11 +val_265 11 +val_480 11 +val_83 11 +val_136 11 +val_353 11 +val_172 11 +val_214 11 +val_462 11 +val_233 11 +val_406 11 +val_133 11 +val_175 11 +val_189 11 +val_454 11 +val_375 11 +val_401 11 +val_421 11 +val_407 11 +val_384 11 +val_256 11 +val_26 11 +val_134 11 +val_67 11 +val_384 11 +val_379 11 +val_18 11 +val_462 11 +val_492 11 +val_100 11 +val_298 11 +val_9 11 +val_341 11 +val_498 11 +val_146 11 +val_458 11 +val_362 11 +val_186 11 +val_285 11 +val_348 11 +val_167 11 +val_18 11 +val_273 11 +val_183 11 +val_281 11 +val_344 11 +val_97 11 +val_469 11 +val_315 11 +val_84 11 +val_28 11 +val_37 11 +val_448 11 +val_152 11 +val_348 11 +val_307 11 +val_194 11 +val_414 11 +val_477 11 +val_222 11 +val_126 11 +val_90 11 +val_169 11 +val_403 11 +val_400 11 +val_200 11 +val_97 11 +val_238 11 +val_86 11 +val_311 11 +val_27 11 +val_165 11 +val_409 11 +val_255 11 +val_278 11 +val_98 11 +val_484 11 +val_265 11 +val_193 11 +val_401 11 +val_150 11 +val_273 11 +val_224 11 +val_369 11 +val_66 11 +val_128 11 +val_213 11 +val_146 11 +val_406 11 +val_429 11 +val_374 11 +val_152 11 +val_469 11 +val_145 11 +val_495 11 +val_37 11 +val_327 11 +val_281 11 +val_277 11 +val_209 11 +val_15 11 +val_82 11 +val_403 11 +val_166 11 +val_417 11 +val_430 11 +val_252 11 +val_292 11 +val_219 11 +val_287 11 +val_153 11 +val_193 11 +val_338 11 +val_446 11 +val_459 11 +val_394 11 +val_237 11 +val_482 11 +val_174 11 +val_413 11 +val_494 11 +val_207 11 +val_199 11 +val_466 11 +val_208 11 +val_174 11 +val_399 11 +val_396 11 +val_247 11 +val_417 11 +val_489 11 +val_162 11 +val_377 11 +val_397 11 +val_309 11 +val_365 11 +val_266 11 +val_439 11 +val_342 11 +val_367 11 +val_325 11 +val_167 11 +val_195 11 +val_475 11 +val_17 11 +val_113 11 +val_155 11 +val_203 11 +val_339 11 +val_0 11 +val_455 11 +val_128 11 +val_311 11 +val_316 11 +val_57 11 +val_302 11 +val_205 11 +val_149 11 +val_438 11 +val_345 11 +val_129 11 +val_170 11 +val_20 11 +val_489 11 +val_157 11 +val_378 11 +val_221 11 +val_92 11 +val_111 11 +val_47 11 +val_72 11 +val_4 11 +val_280 11 +val_35 11 +val_427 11 +val_277 11 +val_208 11 +val_356 11 +val_399 11 +val_169 11 +val_382 11 +val_498 11 +val_125 11 +val_386 11 +val_437 11 +val_469 11 +val_192 11 +val_286 11 +val_187 11 +val_176 11 +val_54 11 +val_459 11 +val_51 11 +val_138 11 +val_103 11 +val_239 11 +val_213 11 +val_216 11 +val_430 11 +val_278 11 +val_176 11 +val_289 11 +val_221 11 +val_65 11 +val_318 11 +val_332 11 +val_311 11 +val_275 11 +val_137 11 +val_241 11 +val_83 11 +val_333 11 +val_180 11 +val_284 11 +val_12 11 +val_230 11 +val_181 11 +val_67 11 +val_260 11 +val_404 11 +val_384 11 +val_489 11 +val_353 11 +val_373 11 +val_272 11 +val_138 11 +val_217 11 +val_84 11 +val_348 11 +val_466 11 +val_58 11 +val_8 11 +val_411 11 +val_230 11 +val_208 11 +val_348 11 +val_24 11 +val_463 11 +val_431 11 +val_179 11 +val_172 11 +val_42 11 +val_129 11 +val_158 11 +val_119 11 +val_496 11 +val_0 11 +val_322 11 +val_197 11 +val_468 11 +val_393 11 +val_454 11 +val_100 11 +val_298 11 +val_199 11 +val_191 11 +val_418 11 +val_96 11 +val_26 11 +val_165 11 +val_327 11 +val_230 11 +val_205 11 +val_120 11 +val_131 11 +val_51 11 +val_404 11 +val_43 11 +val_436 11 +val_156 11 +val_469 11 +val_468 11 +val_308 11 +val_95 11 +val_196 11 +val_288 11 +val_481 11 +val_457 11 +val_98 11 +val_282 11 +val_197 11 +val_187 11 +val_318 11 +val_318 11 +val_409 11 +val_470 11 +val_137 11 +val_369 11 +val_316 11 +val_169 11 +val_413 11 +val_85 11 +val_77 11 +val_0 11 +val_490 11 +val_87 11 +val_364 11 +val_179 11 +val_118 11 +val_134 11 +val_395 11 +val_282 11 +val_138 11 +val_238 11 +val_419 11 +val_15 11 +val_118 11 +val_72 11 +val_90 11 +val_307 11 +val_19 11 +val_435 11 +val_10 11 +val_277 11 +val_273 11 +val_306 11 +val_224 11 +val_309 11 +val_389 11 +val_327 11 +val_242 11 +val_369 11 +val_392 11 +val_272 11 +val_331 11 +val_401 11 +val_242 11 +val_452 11 +val_177 11 +val_226 11 +val_5 11 +val_497 11 +val_402 11 +val_396 11 +val_317 11 +val_395 11 +val_58 11 +val_35 11 +val_336 11 +val_95 11 +val_11 11 +val_168 11 +val_34 11 +val_229 11 +val_233 11 +val_143 11 +val_472 11 +val_322 11 +val_498 11 +val_160 11 +val_195 11 +val_42 11 +val_321 11 +val_430 11 +val_119 11 +val_489 11 +val_458 11 +val_78 11 +val_76 11 +val_41 11 +val_223 11 +val_492 11 +val_149 11 +val_449 11 +val_218 11 +val_228 11 +val_138 11 +val_453 11 +val_30 11 +val_209 11 +val_64 11 +val_468 11 +val_76 11 +val_74 11 +val_342 11 +val_69 11 +val_230 11 +val_33 11 +val_368 11 +val_103 11 +val_296 11 +val_113 11 +val_216 11 +val_367 11 +val_344 11 +val_167 11 +val_274 11 +val_219 11 +val_239 11 +val_485 11 +val_116 11 +val_223 11 +val_256 11 +val_263 11 +val_70 11 +val_487 11 +val_480 11 +val_401 11 +val_288 11 +val_191 11 +val_5 11 +val_244 11 +val_438 11 +val_128 11 +val_467 11 +val_432 11 +val_202 11 +val_316 11 +val_229 11 +val_469 11 +val_463 11 +val_280 11 +val_2 11 +val_35 11 +val_283 11 +val_331 11 +val_235 11 +val_80 11 +val_44 11 +val_193 11 +val_321 11 +val_335 11 +val_104 11 +val_466 11 +val_366 11 +val_175 11 +val_403 11 +val_483 11 +val_53 11 +val_105 11 +val_257 11 +val_406 11 +val_409 11 +val_190 11 +val_406 11 +val_401 11 +val_114 11 +val_258 11 +val_90 11 +val_203 11 +val_262 11 +val_348 11 +val_424 11 +val_12 11 +val_396 11 +val_201 11 +val_217 11 +val_164 11 +val_431 11 +val_454 11 +val_478 11 +val_298 11 +val_125 11 +val_431 11 +val_164 11 +val_424 11 +val_187 11 +val_382 11 +val_5 11 +val_70 11 +val_397 11 +val_480 11 +val_291 11 +val_24 11 +val_351 11 +val_255 11 +val_104 11 +val_70 11 +val_163 11 +val_438 11 +val_119 11 +val_414 11 +val_200 11 +val_491 11 +val_237 11 +val_439 11 +val_360 11 +val_248 11 +val_479 11 +val_305 11 +val_417 11 +val_199 11 +val_444 11 +val_120 11 +val_429 11 +val_169 11 +val_443 11 +val_323 11 +val_325 11 +val_277 11 +val_230 11 +val_478 11 +val_178 11 +val_468 11 +val_310 11 +val_317 11 +val_333 11 +val_493 11 +val_460 11 +val_207 11 +val_249 11 +val_265 11 +val_480 11 +val_83 11 +val_136 11 +val_353 11 +val_172 11 +val_214 11 +val_462 11 +val_233 11 +val_406 11 +val_133 11 +val_175 11 +val_189 11 +val_454 11 +val_375 11 +val_401 11 +val_421 11 +val_407 11 +val_384 11 +val_256 11 +val_26 11 +val_134 11 +val_67 11 +val_384 11 +val_379 11 +val_18 11 +val_462 11 +val_492 11 +val_100 11 +val_298 11 +val_9 11 +val_341 11 +val_498 11 +val_146 11 +val_458 11 +val_362 11 +val_186 11 +val_285 11 +val_348 11 +val_167 11 +val_18 11 +val_273 11 +val_183 11 +val_281 11 +val_344 11 +val_97 11 +val_469 11 +val_315 11 +val_84 11 +val_28 11 +val_37 11 +val_448 11 +val_152 11 +val_348 11 +val_307 11 +val_194 11 +val_414 11 +val_477 11 +val_222 11 +val_126 11 +val_90 11 +val_169 11 +val_403 11 +val_400 11 +val_200 11 +val_97 11 diff --git a/sql/hive/src/test/resources/golden/Partition pruning - with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5 b/sql/hive/src/test/resources/golden/Partition pruning - with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5 new file mode 100644 index 0000000000..83bc6257ba --- /dev/null +++ b/sql/hive/src/test/resources/golden/Partition pruning - with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5 @@ -0,0 +1,1000 @@ +val_238 11 +val_86 11 +val_311 11 +val_27 11 +val_165 11 +val_409 11 +val_255 11 +val_278 11 +val_98 11 +val_484 11 +val_265 11 +val_193 11 +val_401 11 +val_150 11 +val_273 11 +val_224 11 +val_369 11 +val_66 11 +val_128 11 +val_213 11 +val_146 11 +val_406 11 +val_429 11 +val_374 11 +val_152 11 +val_469 11 +val_145 11 +val_495 11 +val_37 11 +val_327 11 +val_281 11 +val_277 11 +val_209 11 +val_15 11 +val_82 11 +val_403 11 +val_166 11 +val_417 11 +val_430 11 +val_252 11 +val_292 11 +val_219 11 +val_287 11 +val_153 11 +val_193 11 +val_338 11 +val_446 11 +val_459 11 +val_394 11 +val_237 11 +val_482 11 +val_174 11 +val_413 11 +val_494 11 +val_207 11 +val_199 11 +val_466 11 +val_208 11 +val_174 11 +val_399 11 +val_396 11 +val_247 11 +val_417 11 +val_489 11 +val_162 11 +val_377 11 +val_397 11 +val_309 11 +val_365 11 +val_266 11 +val_439 11 +val_342 11 +val_367 11 +val_325 11 +val_167 11 +val_195 11 +val_475 11 +val_17 11 +val_113 11 +val_155 11 +val_203 11 +val_339 11 +val_0 11 +val_455 11 +val_128 11 +val_311 11 +val_316 11 +val_57 11 +val_302 11 +val_205 11 +val_149 11 +val_438 11 +val_345 11 +val_129 11 +val_170 11 +val_20 11 +val_489 11 +val_157 11 +val_378 11 +val_221 11 +val_92 11 +val_111 11 +val_47 11 +val_72 11 +val_4 11 +val_280 11 +val_35 11 +val_427 11 +val_277 11 +val_208 11 +val_356 11 +val_399 11 +val_169 11 +val_382 11 +val_498 11 +val_125 11 +val_386 11 +val_437 11 +val_469 11 +val_192 11 +val_286 11 +val_187 11 +val_176 11 +val_54 11 +val_459 11 +val_51 11 +val_138 11 +val_103 11 +val_239 11 +val_213 11 +val_216 11 +val_430 11 +val_278 11 +val_176 11 +val_289 11 +val_221 11 +val_65 11 +val_318 11 +val_332 11 +val_311 11 +val_275 11 +val_137 11 +val_241 11 +val_83 11 +val_333 11 +val_180 11 +val_284 11 +val_12 11 +val_230 11 +val_181 11 +val_67 11 +val_260 11 +val_404 11 +val_384 11 +val_489 11 +val_353 11 +val_373 11 +val_272 11 +val_138 11 +val_217 11 +val_84 11 +val_348 11 +val_466 11 +val_58 11 +val_8 11 +val_411 11 +val_230 11 +val_208 11 +val_348 11 +val_24 11 +val_463 11 +val_431 11 +val_179 11 +val_172 11 +val_42 11 +val_129 11 +val_158 11 +val_119 11 +val_496 11 +val_0 11 +val_322 11 +val_197 11 +val_468 11 +val_393 11 +val_454 11 +val_100 11 +val_298 11 +val_199 11 +val_191 11 +val_418 11 +val_96 11 +val_26 11 +val_165 11 +val_327 11 +val_230 11 +val_205 11 +val_120 11 +val_131 11 +val_51 11 +val_404 11 +val_43 11 +val_436 11 +val_156 11 +val_469 11 +val_468 11 +val_308 11 +val_95 11 +val_196 11 +val_288 11 +val_481 11 +val_457 11 +val_98 11 +val_282 11 +val_197 11 +val_187 11 +val_318 11 +val_318 11 +val_409 11 +val_470 11 +val_137 11 +val_369 11 +val_316 11 +val_169 11 +val_413 11 +val_85 11 +val_77 11 +val_0 11 +val_490 11 +val_87 11 +val_364 11 +val_179 11 +val_118 11 +val_134 11 +val_395 11 +val_282 11 +val_138 11 +val_238 11 +val_419 11 +val_15 11 +val_118 11 +val_72 11 +val_90 11 +val_307 11 +val_19 11 +val_435 11 +val_10 11 +val_277 11 +val_273 11 +val_306 11 +val_224 11 +val_309 11 +val_389 11 +val_327 11 +val_242 11 +val_369 11 +val_392 11 +val_272 11 +val_331 11 +val_401 11 +val_242 11 +val_452 11 +val_177 11 +val_226 11 +val_5 11 +val_497 11 +val_402 11 +val_396 11 +val_317 11 +val_395 11 +val_58 11 +val_35 11 +val_336 11 +val_95 11 +val_11 11 +val_168 11 +val_34 11 +val_229 11 +val_233 11 +val_143 11 +val_472 11 +val_322 11 +val_498 11 +val_160 11 +val_195 11 +val_42 11 +val_321 11 +val_430 11 +val_119 11 +val_489 11 +val_458 11 +val_78 11 +val_76 11 +val_41 11 +val_223 11 +val_492 11 +val_149 11 +val_449 11 +val_218 11 +val_228 11 +val_138 11 +val_453 11 +val_30 11 +val_209 11 +val_64 11 +val_468 11 +val_76 11 +val_74 11 +val_342 11 +val_69 11 +val_230 11 +val_33 11 +val_368 11 +val_103 11 +val_296 11 +val_113 11 +val_216 11 +val_367 11 +val_344 11 +val_167 11 +val_274 11 +val_219 11 +val_239 11 +val_485 11 +val_116 11 +val_223 11 +val_256 11 +val_263 11 +val_70 11 +val_487 11 +val_480 11 +val_401 11 +val_288 11 +val_191 11 +val_5 11 +val_244 11 +val_438 11 +val_128 11 +val_467 11 +val_432 11 +val_202 11 +val_316 11 +val_229 11 +val_469 11 +val_463 11 +val_280 11 +val_2 11 +val_35 11 +val_283 11 +val_331 11 +val_235 11 +val_80 11 +val_44 11 +val_193 11 +val_321 11 +val_335 11 +val_104 11 +val_466 11 +val_366 11 +val_175 11 +val_403 11 +val_483 11 +val_53 11 +val_105 11 +val_257 11 +val_406 11 +val_409 11 +val_190 11 +val_406 11 +val_401 11 +val_114 11 +val_258 11 +val_90 11 +val_203 11 +val_262 11 +val_348 11 +val_424 11 +val_12 11 +val_396 11 +val_201 11 +val_217 11 +val_164 11 +val_431 11 +val_454 11 +val_478 11 +val_298 11 +val_125 11 +val_431 11 +val_164 11 +val_424 11 +val_187 11 +val_382 11 +val_5 11 +val_70 11 +val_397 11 +val_480 11 +val_291 11 +val_24 11 +val_351 11 +val_255 11 +val_104 11 +val_70 11 +val_163 11 +val_438 11 +val_119 11 +val_414 11 +val_200 11 +val_491 11 +val_237 11 +val_439 11 +val_360 11 +val_248 11 +val_479 11 +val_305 11 +val_417 11 +val_199 11 +val_444 11 +val_120 11 +val_429 11 +val_169 11 +val_443 11 +val_323 11 +val_325 11 +val_277 11 +val_230 11 +val_478 11 +val_178 11 +val_468 11 +val_310 11 +val_317 11 +val_333 11 +val_493 11 +val_460 11 +val_207 11 +val_249 11 +val_265 11 +val_480 11 +val_83 11 +val_136 11 +val_353 11 +val_172 11 +val_214 11 +val_462 11 +val_233 11 +val_406 11 +val_133 11 +val_175 11 +val_189 11 +val_454 11 +val_375 11 +val_401 11 +val_421 11 +val_407 11 +val_384 11 +val_256 11 +val_26 11 +val_134 11 +val_67 11 +val_384 11 +val_379 11 +val_18 11 +val_462 11 +val_492 11 +val_100 11 +val_298 11 +val_9 11 +val_341 11 +val_498 11 +val_146 11 +val_458 11 +val_362 11 +val_186 11 +val_285 11 +val_348 11 +val_167 11 +val_18 11 +val_273 11 +val_183 11 +val_281 11 +val_344 11 +val_97 11 +val_469 11 +val_315 11 +val_84 11 +val_28 11 +val_37 11 +val_448 11 +val_152 11 +val_348 11 +val_307 11 +val_194 11 +val_414 11 +val_477 11 +val_222 11 +val_126 11 +val_90 11 +val_169 11 +val_403 11 +val_400 11 +val_200 11 +val_97 11 +val_238 12 +val_86 12 +val_311 12 +val_27 12 +val_165 12 +val_409 12 +val_255 12 +val_278 12 +val_98 12 +val_484 12 +val_265 12 +val_193 12 +val_401 12 +val_150 12 +val_273 12 +val_224 12 +val_369 12 +val_66 12 +val_128 12 +val_213 12 +val_146 12 +val_406 12 +val_429 12 +val_374 12 +val_152 12 +val_469 12 +val_145 12 +val_495 12 +val_37 12 +val_327 12 +val_281 12 +val_277 12 +val_209 12 +val_15 12 +val_82 12 +val_403 12 +val_166 12 +val_417 12 +val_430 12 +val_252 12 +val_292 12 +val_219 12 +val_287 12 +val_153 12 +val_193 12 +val_338 12 +val_446 12 +val_459 12 +val_394 12 +val_237 12 +val_482 12 +val_174 12 +val_413 12 +val_494 12 +val_207 12 +val_199 12 +val_466 12 +val_208 12 +val_174 12 +val_399 12 +val_396 12 +val_247 12 +val_417 12 +val_489 12 +val_162 12 +val_377 12 +val_397 12 +val_309 12 +val_365 12 +val_266 12 +val_439 12 +val_342 12 +val_367 12 +val_325 12 +val_167 12 +val_195 12 +val_475 12 +val_17 12 +val_113 12 +val_155 12 +val_203 12 +val_339 12 +val_0 12 +val_455 12 +val_128 12 +val_311 12 +val_316 12 +val_57 12 +val_302 12 +val_205 12 +val_149 12 +val_438 12 +val_345 12 +val_129 12 +val_170 12 +val_20 12 +val_489 12 +val_157 12 +val_378 12 +val_221 12 +val_92 12 +val_111 12 +val_47 12 +val_72 12 +val_4 12 +val_280 12 +val_35 12 +val_427 12 +val_277 12 +val_208 12 +val_356 12 +val_399 12 +val_169 12 +val_382 12 +val_498 12 +val_125 12 +val_386 12 +val_437 12 +val_469 12 +val_192 12 +val_286 12 +val_187 12 +val_176 12 +val_54 12 +val_459 12 +val_51 12 +val_138 12 +val_103 12 +val_239 12 +val_213 12 +val_216 12 +val_430 12 +val_278 12 +val_176 12 +val_289 12 +val_221 12 +val_65 12 +val_318 12 +val_332 12 +val_311 12 +val_275 12 +val_137 12 +val_241 12 +val_83 12 +val_333 12 +val_180 12 +val_284 12 +val_12 12 +val_230 12 +val_181 12 +val_67 12 +val_260 12 +val_404 12 +val_384 12 +val_489 12 +val_353 12 +val_373 12 +val_272 12 +val_138 12 +val_217 12 +val_84 12 +val_348 12 +val_466 12 +val_58 12 +val_8 12 +val_411 12 +val_230 12 +val_208 12 +val_348 12 +val_24 12 +val_463 12 +val_431 12 +val_179 12 +val_172 12 +val_42 12 +val_129 12 +val_158 12 +val_119 12 +val_496 12 +val_0 12 +val_322 12 +val_197 12 +val_468 12 +val_393 12 +val_454 12 +val_100 12 +val_298 12 +val_199 12 +val_191 12 +val_418 12 +val_96 12 +val_26 12 +val_165 12 +val_327 12 +val_230 12 +val_205 12 +val_120 12 +val_131 12 +val_51 12 +val_404 12 +val_43 12 +val_436 12 +val_156 12 +val_469 12 +val_468 12 +val_308 12 +val_95 12 +val_196 12 +val_288 12 +val_481 12 +val_457 12 +val_98 12 +val_282 12 +val_197 12 +val_187 12 +val_318 12 +val_318 12 +val_409 12 +val_470 12 +val_137 12 +val_369 12 +val_316 12 +val_169 12 +val_413 12 +val_85 12 +val_77 12 +val_0 12 +val_490 12 +val_87 12 +val_364 12 +val_179 12 +val_118 12 +val_134 12 +val_395 12 +val_282 12 +val_138 12 +val_238 12 +val_419 12 +val_15 12 +val_118 12 +val_72 12 +val_90 12 +val_307 12 +val_19 12 +val_435 12 +val_10 12 +val_277 12 +val_273 12 +val_306 12 +val_224 12 +val_309 12 +val_389 12 +val_327 12 +val_242 12 +val_369 12 +val_392 12 +val_272 12 +val_331 12 +val_401 12 +val_242 12 +val_452 12 +val_177 12 +val_226 12 +val_5 12 +val_497 12 +val_402 12 +val_396 12 +val_317 12 +val_395 12 +val_58 12 +val_35 12 +val_336 12 +val_95 12 +val_11 12 +val_168 12 +val_34 12 +val_229 12 +val_233 12 +val_143 12 +val_472 12 +val_322 12 +val_498 12 +val_160 12 +val_195 12 +val_42 12 +val_321 12 +val_430 12 +val_119 12 +val_489 12 +val_458 12 +val_78 12 +val_76 12 +val_41 12 +val_223 12 +val_492 12 +val_149 12 +val_449 12 +val_218 12 +val_228 12 +val_138 12 +val_453 12 +val_30 12 +val_209 12 +val_64 12 +val_468 12 +val_76 12 +val_74 12 +val_342 12 +val_69 12 +val_230 12 +val_33 12 +val_368 12 +val_103 12 +val_296 12 +val_113 12 +val_216 12 +val_367 12 +val_344 12 +val_167 12 +val_274 12 +val_219 12 +val_239 12 +val_485 12 +val_116 12 +val_223 12 +val_256 12 +val_263 12 +val_70 12 +val_487 12 +val_480 12 +val_401 12 +val_288 12 +val_191 12 +val_5 12 +val_244 12 +val_438 12 +val_128 12 +val_467 12 +val_432 12 +val_202 12 +val_316 12 +val_229 12 +val_469 12 +val_463 12 +val_280 12 +val_2 12 +val_35 12 +val_283 12 +val_331 12 +val_235 12 +val_80 12 +val_44 12 +val_193 12 +val_321 12 +val_335 12 +val_104 12 +val_466 12 +val_366 12 +val_175 12 +val_403 12 +val_483 12 +val_53 12 +val_105 12 +val_257 12 +val_406 12 +val_409 12 +val_190 12 +val_406 12 +val_401 12 +val_114 12 +val_258 12 +val_90 12 +val_203 12 +val_262 12 +val_348 12 +val_424 12 +val_12 12 +val_396 12 +val_201 12 +val_217 12 +val_164 12 +val_431 12 +val_454 12 +val_478 12 +val_298 12 +val_125 12 +val_431 12 +val_164 12 +val_424 12 +val_187 12 +val_382 12 +val_5 12 +val_70 12 +val_397 12 +val_480 12 +val_291 12 +val_24 12 +val_351 12 +val_255 12 +val_104 12 +val_70 12 +val_163 12 +val_438 12 +val_119 12 +val_414 12 +val_200 12 +val_491 12 +val_237 12 +val_439 12 +val_360 12 +val_248 12 +val_479 12 +val_305 12 +val_417 12 +val_199 12 +val_444 12 +val_120 12 +val_429 12 +val_169 12 +val_443 12 +val_323 12 +val_325 12 +val_277 12 +val_230 12 +val_478 12 +val_178 12 +val_468 12 +val_310 12 +val_317 12 +val_333 12 +val_493 12 +val_460 12 +val_207 12 +val_249 12 +val_265 12 +val_480 12 +val_83 12 +val_136 12 +val_353 12 +val_172 12 +val_214 12 +val_462 12 +val_233 12 +val_406 12 +val_133 12 +val_175 12 +val_189 12 +val_454 12 +val_375 12 +val_401 12 +val_421 12 +val_407 12 +val_384 12 +val_256 12 +val_26 12 +val_134 12 +val_67 12 +val_384 12 +val_379 12 +val_18 12 +val_462 12 +val_492 12 +val_100 12 +val_298 12 +val_9 12 +val_341 12 +val_498 12 +val_146 12 +val_458 12 +val_362 12 +val_186 12 +val_285 12 +val_348 12 +val_167 12 +val_18 12 +val_273 12 +val_183 12 +val_281 12 +val_344 12 +val_97 12 +val_469 12 +val_315 12 +val_84 12 +val_28 12 +val_37 12 +val_448 12 +val_152 12 +val_348 12 +val_307 12 +val_194 12 +val_414 12 +val_477 12 +val_222 12 +val_126 12 +val_90 12 +val_169 12 +val_403 12 +val_400 12 +val_200 12 +val_97 12 diff --git a/sql/hive/src/test/resources/golden/Partition pruning: all partitions pruned - query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7 b/sql/hive/src/test/resources/golden/Partition pruning: all partitions pruned - query test-0-63ab78355dbc6fa0d7619c8a35b0f7a7 deleted file mode 100644 index e69de29bb2..0000000000 diff --git a/sql/hive/src/test/resources/golden/Partition pruning: left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3 b/sql/hive/src/test/resources/golden/Partition pruning: left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3 deleted file mode 100644 index 0fe6b905e7..0000000000 --- a/sql/hive/src/test/resources/golden/Partition pruning: left only 1 partition - query test-0-3adc3a7f76b2abd059904ba81a595db3 +++ /dev/null @@ -1,500 +0,0 @@ -val_238 11 -val_86 11 -val_311 11 -val_27 11 -val_165 11 -val_409 11 -val_255 11 -val_278 11 -val_98 11 -val_484 11 -val_265 11 -val_193 11 -val_401 11 -val_150 11 -val_273 11 -val_224 11 -val_369 11 -val_66 11 -val_128 11 -val_213 11 -val_146 11 -val_406 11 -val_429 11 -val_374 11 -val_152 11 -val_469 11 -val_145 11 -val_495 11 -val_37 11 -val_327 11 -val_281 11 -val_277 11 -val_209 11 -val_15 11 -val_82 11 -val_403 11 -val_166 11 -val_417 11 -val_430 11 -val_252 11 -val_292 11 -val_219 11 -val_287 11 -val_153 11 -val_193 11 -val_338 11 -val_446 11 -val_459 11 -val_394 11 -val_237 11 -val_482 11 -val_174 11 -val_413 11 -val_494 11 -val_207 11 -val_199 11 -val_466 11 -val_208 11 -val_174 11 -val_399 11 -val_396 11 -val_247 11 -val_417 11 -val_489 11 -val_162 11 -val_377 11 -val_397 11 -val_309 11 -val_365 11 -val_266 11 -val_439 11 -val_342 11 -val_367 11 -val_325 11 -val_167 11 -val_195 11 -val_475 11 -val_17 11 -val_113 11 -val_155 11 -val_203 11 -val_339 11 -val_0 11 -val_455 11 -val_128 11 -val_311 11 -val_316 11 -val_57 11 -val_302 11 -val_205 11 -val_149 11 -val_438 11 -val_345 11 -val_129 11 -val_170 11 -val_20 11 -val_489 11 -val_157 11 -val_378 11 -val_221 11 -val_92 11 -val_111 11 -val_47 11 -val_72 11 -val_4 11 -val_280 11 -val_35 11 -val_427 11 -val_277 11 -val_208 11 -val_356 11 -val_399 11 -val_169 11 -val_382 11 -val_498 11 -val_125 11 -val_386 11 -val_437 11 -val_469 11 -val_192 11 -val_286 11 -val_187 11 -val_176 11 -val_54 11 -val_459 11 -val_51 11 -val_138 11 -val_103 11 -val_239 11 -val_213 11 -val_216 11 -val_430 11 -val_278 11 -val_176 11 -val_289 11 -val_221 11 -val_65 11 -val_318 11 -val_332 11 -val_311 11 -val_275 11 -val_137 11 -val_241 11 -val_83 11 -val_333 11 -val_180 11 -val_284 11 -val_12 11 -val_230 11 -val_181 11 -val_67 11 -val_260 11 -val_404 11 -val_384 11 -val_489 11 -val_353 11 -val_373 11 -val_272 11 -val_138 11 -val_217 11 -val_84 11 -val_348 11 -val_466 11 -val_58 11 -val_8 11 -val_411 11 -val_230 11 -val_208 11 -val_348 11 -val_24 11 -val_463 11 -val_431 11 -val_179 11 -val_172 11 -val_42 11 -val_129 11 -val_158 11 -val_119 11 -val_496 11 -val_0 11 -val_322 11 -val_197 11 -val_468 11 -val_393 11 -val_454 11 -val_100 11 -val_298 11 -val_199 11 -val_191 11 -val_418 11 -val_96 11 -val_26 11 -val_165 11 -val_327 11 -val_230 11 -val_205 11 -val_120 11 -val_131 11 -val_51 11 -val_404 11 -val_43 11 -val_436 11 -val_156 11 -val_469 11 -val_468 11 -val_308 11 -val_95 11 -val_196 11 -val_288 11 -val_481 11 -val_457 11 -val_98 11 -val_282 11 -val_197 11 -val_187 11 -val_318 11 -val_318 11 -val_409 11 -val_470 11 -val_137 11 -val_369 11 -val_316 11 -val_169 11 -val_413 11 -val_85 11 -val_77 11 -val_0 11 -val_490 11 -val_87 11 -val_364 11 -val_179 11 -val_118 11 -val_134 11 -val_395 11 -val_282 11 -val_138 11 -val_238 11 -val_419 11 -val_15 11 -val_118 11 -val_72 11 -val_90 11 -val_307 11 -val_19 11 -val_435 11 -val_10 11 -val_277 11 -val_273 11 -val_306 11 -val_224 11 -val_309 11 -val_389 11 -val_327 11 -val_242 11 -val_369 11 -val_392 11 -val_272 11 -val_331 11 -val_401 11 -val_242 11 -val_452 11 -val_177 11 -val_226 11 -val_5 11 -val_497 11 -val_402 11 -val_396 11 -val_317 11 -val_395 11 -val_58 11 -val_35 11 -val_336 11 -val_95 11 -val_11 11 -val_168 11 -val_34 11 -val_229 11 -val_233 11 -val_143 11 -val_472 11 -val_322 11 -val_498 11 -val_160 11 -val_195 11 -val_42 11 -val_321 11 -val_430 11 -val_119 11 -val_489 11 -val_458 11 -val_78 11 -val_76 11 -val_41 11 -val_223 11 -val_492 11 -val_149 11 -val_449 11 -val_218 11 -val_228 11 -val_138 11 -val_453 11 -val_30 11 -val_209 11 -val_64 11 -val_468 11 -val_76 11 -val_74 11 -val_342 11 -val_69 11 -val_230 11 -val_33 11 -val_368 11 -val_103 11 -val_296 11 -val_113 11 -val_216 11 -val_367 11 -val_344 11 -val_167 11 -val_274 11 -val_219 11 -val_239 11 -val_485 11 -val_116 11 -val_223 11 -val_256 11 -val_263 11 -val_70 11 -val_487 11 -val_480 11 -val_401 11 -val_288 11 -val_191 11 -val_5 11 -val_244 11 -val_438 11 -val_128 11 -val_467 11 -val_432 11 -val_202 11 -val_316 11 -val_229 11 -val_469 11 -val_463 11 -val_280 11 -val_2 11 -val_35 11 -val_283 11 -val_331 11 -val_235 11 -val_80 11 -val_44 11 -val_193 11 -val_321 11 -val_335 11 -val_104 11 -val_466 11 -val_366 11 -val_175 11 -val_403 11 -val_483 11 -val_53 11 -val_105 11 -val_257 11 -val_406 11 -val_409 11 -val_190 11 -val_406 11 -val_401 11 -val_114 11 -val_258 11 -val_90 11 -val_203 11 -val_262 11 -val_348 11 -val_424 11 -val_12 11 -val_396 11 -val_201 11 -val_217 11 -val_164 11 -val_431 11 -val_454 11 -val_478 11 -val_298 11 -val_125 11 -val_431 11 -val_164 11 -val_424 11 -val_187 11 -val_382 11 -val_5 11 -val_70 11 -val_397 11 -val_480 11 -val_291 11 -val_24 11 -val_351 11 -val_255 11 -val_104 11 -val_70 11 -val_163 11 -val_438 11 -val_119 11 -val_414 11 -val_200 11 -val_491 11 -val_237 11 -val_439 11 -val_360 11 -val_248 11 -val_479 11 -val_305 11 -val_417 11 -val_199 11 -val_444 11 -val_120 11 -val_429 11 -val_169 11 -val_443 11 -val_323 11 -val_325 11 -val_277 11 -val_230 11 -val_478 11 -val_178 11 -val_468 11 -val_310 11 -val_317 11 -val_333 11 -val_493 11 -val_460 11 -val_207 11 -val_249 11 -val_265 11 -val_480 11 -val_83 11 -val_136 11 -val_353 11 -val_172 11 -val_214 11 -val_462 11 -val_233 11 -val_406 11 -val_133 11 -val_175 11 -val_189 11 -val_454 11 -val_375 11 -val_401 11 -val_421 11 -val_407 11 -val_384 11 -val_256 11 -val_26 11 -val_134 11 -val_67 11 -val_384 11 -val_379 11 -val_18 11 -val_462 11 -val_492 11 -val_100 11 -val_298 11 -val_9 11 -val_341 11 -val_498 11 -val_146 11 -val_458 11 -val_362 11 -val_186 11 -val_285 11 -val_348 11 -val_167 11 -val_18 11 -val_273 11 -val_183 11 -val_281 11 -val_344 11 -val_97 11 -val_469 11 -val_315 11 -val_84 11 -val_28 11 -val_37 11 -val_448 11 -val_152 11 -val_348 11 -val_307 11 -val_194 11 -val_414 11 -val_477 11 -val_222 11 -val_126 11 -val_90 11 -val_169 11 -val_403 11 -val_400 11 -val_200 11 -val_97 11 diff --git a/sql/hive/src/test/resources/golden/Partition pruning: non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb b/sql/hive/src/test/resources/golden/Partition pruning: non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb deleted file mode 100644 index 444039e75f..0000000000 --- a/sql/hive/src/test/resources/golden/Partition pruning: non-partitioned, non-trivial project - query test-0-3893ec7a86062215d9f817f1495a69bb +++ /dev/null @@ -1,500 +0,0 @@ -476 -172 -622 -54 -330 -818 -510 -556 -196 -968 -530 -386 -802 -300 -546 -448 -738 -132 -256 -426 -292 -812 -858 -748 -304 -938 -290 -990 -74 -654 -562 -554 -418 -30 -164 -806 -332 -834 -860 -504 -584 -438 -574 -306 -386 -676 -892 -918 -788 -474 -964 -348 -826 -988 -414 -398 -932 -416 -348 -798 -792 -494 -834 -978 -324 -754 -794 -618 -730 -532 -878 -684 -734 -650 -334 -390 -950 -34 -226 -310 -406 -678 -0 -910 -256 -622 -632 -114 -604 -410 -298 -876 -690 -258 -340 -40 -978 -314 -756 -442 -184 -222 -94 -144 -8 -560 -70 -854 -554 -416 -712 -798 -338 -764 -996 -250 -772 -874 -938 -384 -572 -374 -352 -108 -918 -102 -276 -206 -478 -426 -432 -860 -556 -352 -578 -442 -130 -636 -664 -622 -550 -274 -482 -166 -666 -360 -568 -24 -460 -362 -134 -520 -808 -768 -978 -706 -746 -544 -276 -434 -168 -696 -932 -116 -16 -822 -460 -416 -696 -48 -926 -862 -358 -344 -84 -258 -316 -238 -992 -0 -644 -394 -936 -786 -908 -200 -596 -398 -382 -836 -192 -52 -330 -654 -460 -410 -240 -262 -102 -808 -86 -872 -312 -938 -936 -616 -190 -392 -576 -962 -914 -196 -564 -394 -374 -636 -636 -818 -940 -274 -738 -632 -338 -826 -170 -154 -0 -980 -174 -728 -358 -236 -268 -790 -564 -276 -476 -838 -30 -236 -144 -180 -614 -38 -870 -20 -554 -546 -612 -448 -618 -778 -654 -484 -738 -784 -544 -662 -802 -484 -904 -354 -452 -10 -994 -804 -792 -634 -790 -116 -70 -672 -190 -22 -336 -68 -458 -466 -286 -944 -644 -996 -320 -390 -84 -642 -860 -238 -978 -916 -156 -152 -82 -446 -984 -298 -898 -436 -456 -276 -906 -60 -418 -128 -936 -152 -148 -684 -138 -460 -66 -736 -206 -592 -226 -432 -734 -688 -334 -548 -438 -478 -970 -232 -446 -512 -526 -140 -974 -960 -802 -576 -382 -10 -488 -876 -256 -934 -864 -404 -632 -458 -938 -926 -560 -4 -70 -566 -662 -470 -160 -88 -386 -642 -670 -208 -932 -732 -350 -806 -966 -106 -210 -514 -812 -818 -380 -812 -802 -228 -516 -180 -406 -524 -696 -848 -24 -792 -402 -434 -328 -862 -908 -956 -596 -250 -862 -328 -848 -374 -764 -10 -140 -794 -960 -582 -48 -702 -510 -208 -140 -326 -876 -238 -828 -400 -982 -474 -878 -720 -496 -958 -610 -834 -398 -888 -240 -858 -338 -886 -646 -650 -554 -460 -956 -356 -936 -620 -634 -666 -986 -920 -414 -498 -530 -960 -166 -272 -706 -344 -428 -924 -466 -812 -266 -350 -378 -908 -750 -802 -842 -814 -768 -512 -52 -268 -134 -768 -758 -36 -924 -984 -200 -596 -18 -682 -996 -292 -916 -724 -372 -570 -696 -334 -36 -546 -366 -562 -688 -194 -938 -630 -168 -56 -74 -896 -304 -696 -614 -388 -828 -954 -444 -252 -180 -338 -806 -800 -400 -194 diff --git a/sql/hive/src/test/resources/golden/Partition pruning: pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10 b/sql/hive/src/test/resources/golden/Partition pruning: pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10 deleted file mode 100644 index d83d8b62b7..0000000000 --- a/sql/hive/src/test/resources/golden/Partition pruning: pruning with both column key and partition key - query test-0-75148567b91227053f728d72f7dc7c10 +++ /dev/null @@ -1,1000 +0,0 @@ -val_238 11 -val_86 11 -val_311 11 -val_27 11 -val_165 11 -val_409 11 -val_255 11 -val_278 11 -val_98 11 -val_484 11 -val_265 11 -val_193 11 -val_401 11 -val_150 11 -val_273 11 -val_224 11 -val_369 11 -val_66 11 -val_128 11 -val_213 11 -val_146 11 -val_406 11 -val_429 11 -val_374 11 -val_152 11 -val_469 11 -val_145 11 -val_495 11 -val_37 11 -val_327 11 -val_281 11 -val_277 11 -val_209 11 -val_15 11 -val_82 11 -val_403 11 -val_166 11 -val_417 11 -val_430 11 -val_252 11 -val_292 11 -val_219 11 -val_287 11 -val_153 11 -val_193 11 -val_338 11 -val_446 11 -val_459 11 -val_394 11 -val_237 11 -val_482 11 -val_174 11 -val_413 11 -val_494 11 -val_207 11 -val_199 11 -val_466 11 -val_208 11 -val_174 11 -val_399 11 -val_396 11 -val_247 11 -val_417 11 -val_489 11 -val_162 11 -val_377 11 -val_397 11 -val_309 11 -val_365 11 -val_266 11 -val_439 11 -val_342 11 -val_367 11 -val_325 11 -val_167 11 -val_195 11 -val_475 11 -val_17 11 -val_113 11 -val_155 11 -val_203 11 -val_339 11 -val_0 11 -val_455 11 -val_128 11 -val_311 11 -val_316 11 -val_57 11 -val_302 11 -val_205 11 -val_149 11 -val_438 11 -val_345 11 -val_129 11 -val_170 11 -val_20 11 -val_489 11 -val_157 11 -val_378 11 -val_221 11 -val_92 11 -val_111 11 -val_47 11 -val_72 11 -val_4 11 -val_280 11 -val_35 11 -val_427 11 -val_277 11 -val_208 11 -val_356 11 -val_399 11 -val_169 11 -val_382 11 -val_498 11 -val_125 11 -val_386 11 -val_437 11 -val_469 11 -val_192 11 -val_286 11 -val_187 11 -val_176 11 -val_54 11 -val_459 11 -val_51 11 -val_138 11 -val_103 11 -val_239 11 -val_213 11 -val_216 11 -val_430 11 -val_278 11 -val_176 11 -val_289 11 -val_221 11 -val_65 11 -val_318 11 -val_332 11 -val_311 11 -val_275 11 -val_137 11 -val_241 11 -val_83 11 -val_333 11 -val_180 11 -val_284 11 -val_12 11 -val_230 11 -val_181 11 -val_67 11 -val_260 11 -val_404 11 -val_384 11 -val_489 11 -val_353 11 -val_373 11 -val_272 11 -val_138 11 -val_217 11 -val_84 11 -val_348 11 -val_466 11 -val_58 11 -val_8 11 -val_411 11 -val_230 11 -val_208 11 -val_348 11 -val_24 11 -val_463 11 -val_431 11 -val_179 11 -val_172 11 -val_42 11 -val_129 11 -val_158 11 -val_119 11 -val_496 11 -val_0 11 -val_322 11 -val_197 11 -val_468 11 -val_393 11 -val_454 11 -val_100 11 -val_298 11 -val_199 11 -val_191 11 -val_418 11 -val_96 11 -val_26 11 -val_165 11 -val_327 11 -val_230 11 -val_205 11 -val_120 11 -val_131 11 -val_51 11 -val_404 11 -val_43 11 -val_436 11 -val_156 11 -val_469 11 -val_468 11 -val_308 11 -val_95 11 -val_196 11 -val_288 11 -val_481 11 -val_457 11 -val_98 11 -val_282 11 -val_197 11 -val_187 11 -val_318 11 -val_318 11 -val_409 11 -val_470 11 -val_137 11 -val_369 11 -val_316 11 -val_169 11 -val_413 11 -val_85 11 -val_77 11 -val_0 11 -val_490 11 -val_87 11 -val_364 11 -val_179 11 -val_118 11 -val_134 11 -val_395 11 -val_282 11 -val_138 11 -val_238 11 -val_419 11 -val_15 11 -val_118 11 -val_72 11 -val_90 11 -val_307 11 -val_19 11 -val_435 11 -val_10 11 -val_277 11 -val_273 11 -val_306 11 -val_224 11 -val_309 11 -val_389 11 -val_327 11 -val_242 11 -val_369 11 -val_392 11 -val_272 11 -val_331 11 -val_401 11 -val_242 11 -val_452 11 -val_177 11 -val_226 11 -val_5 11 -val_497 11 -val_402 11 -val_396 11 -val_317 11 -val_395 11 -val_58 11 -val_35 11 -val_336 11 -val_95 11 -val_11 11 -val_168 11 -val_34 11 -val_229 11 -val_233 11 -val_143 11 -val_472 11 -val_322 11 -val_498 11 -val_160 11 -val_195 11 -val_42 11 -val_321 11 -val_430 11 -val_119 11 -val_489 11 -val_458 11 -val_78 11 -val_76 11 -val_41 11 -val_223 11 -val_492 11 -val_149 11 -val_449 11 -val_218 11 -val_228 11 -val_138 11 -val_453 11 -val_30 11 -val_209 11 -val_64 11 -val_468 11 -val_76 11 -val_74 11 -val_342 11 -val_69 11 -val_230 11 -val_33 11 -val_368 11 -val_103 11 -val_296 11 -val_113 11 -val_216 11 -val_367 11 -val_344 11 -val_167 11 -val_274 11 -val_219 11 -val_239 11 -val_485 11 -val_116 11 -val_223 11 -val_256 11 -val_263 11 -val_70 11 -val_487 11 -val_480 11 -val_401 11 -val_288 11 -val_191 11 -val_5 11 -val_244 11 -val_438 11 -val_128 11 -val_467 11 -val_432 11 -val_202 11 -val_316 11 -val_229 11 -val_469 11 -val_463 11 -val_280 11 -val_2 11 -val_35 11 -val_283 11 -val_331 11 -val_235 11 -val_80 11 -val_44 11 -val_193 11 -val_321 11 -val_335 11 -val_104 11 -val_466 11 -val_366 11 -val_175 11 -val_403 11 -val_483 11 -val_53 11 -val_105 11 -val_257 11 -val_406 11 -val_409 11 -val_190 11 -val_406 11 -val_401 11 -val_114 11 -val_258 11 -val_90 11 -val_203 11 -val_262 11 -val_348 11 -val_424 11 -val_12 11 -val_396 11 -val_201 11 -val_217 11 -val_164 11 -val_431 11 -val_454 11 -val_478 11 -val_298 11 -val_125 11 -val_431 11 -val_164 11 -val_424 11 -val_187 11 -val_382 11 -val_5 11 -val_70 11 -val_397 11 -val_480 11 -val_291 11 -val_24 11 -val_351 11 -val_255 11 -val_104 11 -val_70 11 -val_163 11 -val_438 11 -val_119 11 -val_414 11 -val_200 11 -val_491 11 -val_237 11 -val_439 11 -val_360 11 -val_248 11 -val_479 11 -val_305 11 -val_417 11 -val_199 11 -val_444 11 -val_120 11 -val_429 11 -val_169 11 -val_443 11 -val_323 11 -val_325 11 -val_277 11 -val_230 11 -val_478 11 -val_178 11 -val_468 11 -val_310 11 -val_317 11 -val_333 11 -val_493 11 -val_460 11 -val_207 11 -val_249 11 -val_265 11 -val_480 11 -val_83 11 -val_136 11 -val_353 11 -val_172 11 -val_214 11 -val_462 11 -val_233 11 -val_406 11 -val_133 11 -val_175 11 -val_189 11 -val_454 11 -val_375 11 -val_401 11 -val_421 11 -val_407 11 -val_384 11 -val_256 11 -val_26 11 -val_134 11 -val_67 11 -val_384 11 -val_379 11 -val_18 11 -val_462 11 -val_492 11 -val_100 11 -val_298 11 -val_9 11 -val_341 11 -val_498 11 -val_146 11 -val_458 11 -val_362 11 -val_186 11 -val_285 11 -val_348 11 -val_167 11 -val_18 11 -val_273 11 -val_183 11 -val_281 11 -val_344 11 -val_97 11 -val_469 11 -val_315 11 -val_84 11 -val_28 11 -val_37 11 -val_448 11 -val_152 11 -val_348 11 -val_307 11 -val_194 11 -val_414 11 -val_477 11 -val_222 11 -val_126 11 -val_90 11 -val_169 11 -val_403 11 -val_400 11 -val_200 11 -val_97 11 -val_238 11 -val_86 11 -val_311 11 -val_27 11 -val_165 11 -val_409 11 -val_255 11 -val_278 11 -val_98 11 -val_484 11 -val_265 11 -val_193 11 -val_401 11 -val_150 11 -val_273 11 -val_224 11 -val_369 11 -val_66 11 -val_128 11 -val_213 11 -val_146 11 -val_406 11 -val_429 11 -val_374 11 -val_152 11 -val_469 11 -val_145 11 -val_495 11 -val_37 11 -val_327 11 -val_281 11 -val_277 11 -val_209 11 -val_15 11 -val_82 11 -val_403 11 -val_166 11 -val_417 11 -val_430 11 -val_252 11 -val_292 11 -val_219 11 -val_287 11 -val_153 11 -val_193 11 -val_338 11 -val_446 11 -val_459 11 -val_394 11 -val_237 11 -val_482 11 -val_174 11 -val_413 11 -val_494 11 -val_207 11 -val_199 11 -val_466 11 -val_208 11 -val_174 11 -val_399 11 -val_396 11 -val_247 11 -val_417 11 -val_489 11 -val_162 11 -val_377 11 -val_397 11 -val_309 11 -val_365 11 -val_266 11 -val_439 11 -val_342 11 -val_367 11 -val_325 11 -val_167 11 -val_195 11 -val_475 11 -val_17 11 -val_113 11 -val_155 11 -val_203 11 -val_339 11 -val_0 11 -val_455 11 -val_128 11 -val_311 11 -val_316 11 -val_57 11 -val_302 11 -val_205 11 -val_149 11 -val_438 11 -val_345 11 -val_129 11 -val_170 11 -val_20 11 -val_489 11 -val_157 11 -val_378 11 -val_221 11 -val_92 11 -val_111 11 -val_47 11 -val_72 11 -val_4 11 -val_280 11 -val_35 11 -val_427 11 -val_277 11 -val_208 11 -val_356 11 -val_399 11 -val_169 11 -val_382 11 -val_498 11 -val_125 11 -val_386 11 -val_437 11 -val_469 11 -val_192 11 -val_286 11 -val_187 11 -val_176 11 -val_54 11 -val_459 11 -val_51 11 -val_138 11 -val_103 11 -val_239 11 -val_213 11 -val_216 11 -val_430 11 -val_278 11 -val_176 11 -val_289 11 -val_221 11 -val_65 11 -val_318 11 -val_332 11 -val_311 11 -val_275 11 -val_137 11 -val_241 11 -val_83 11 -val_333 11 -val_180 11 -val_284 11 -val_12 11 -val_230 11 -val_181 11 -val_67 11 -val_260 11 -val_404 11 -val_384 11 -val_489 11 -val_353 11 -val_373 11 -val_272 11 -val_138 11 -val_217 11 -val_84 11 -val_348 11 -val_466 11 -val_58 11 -val_8 11 -val_411 11 -val_230 11 -val_208 11 -val_348 11 -val_24 11 -val_463 11 -val_431 11 -val_179 11 -val_172 11 -val_42 11 -val_129 11 -val_158 11 -val_119 11 -val_496 11 -val_0 11 -val_322 11 -val_197 11 -val_468 11 -val_393 11 -val_454 11 -val_100 11 -val_298 11 -val_199 11 -val_191 11 -val_418 11 -val_96 11 -val_26 11 -val_165 11 -val_327 11 -val_230 11 -val_205 11 -val_120 11 -val_131 11 -val_51 11 -val_404 11 -val_43 11 -val_436 11 -val_156 11 -val_469 11 -val_468 11 -val_308 11 -val_95 11 -val_196 11 -val_288 11 -val_481 11 -val_457 11 -val_98 11 -val_282 11 -val_197 11 -val_187 11 -val_318 11 -val_318 11 -val_409 11 -val_470 11 -val_137 11 -val_369 11 -val_316 11 -val_169 11 -val_413 11 -val_85 11 -val_77 11 -val_0 11 -val_490 11 -val_87 11 -val_364 11 -val_179 11 -val_118 11 -val_134 11 -val_395 11 -val_282 11 -val_138 11 -val_238 11 -val_419 11 -val_15 11 -val_118 11 -val_72 11 -val_90 11 -val_307 11 -val_19 11 -val_435 11 -val_10 11 -val_277 11 -val_273 11 -val_306 11 -val_224 11 -val_309 11 -val_389 11 -val_327 11 -val_242 11 -val_369 11 -val_392 11 -val_272 11 -val_331 11 -val_401 11 -val_242 11 -val_452 11 -val_177 11 -val_226 11 -val_5 11 -val_497 11 -val_402 11 -val_396 11 -val_317 11 -val_395 11 -val_58 11 -val_35 11 -val_336 11 -val_95 11 -val_11 11 -val_168 11 -val_34 11 -val_229 11 -val_233 11 -val_143 11 -val_472 11 -val_322 11 -val_498 11 -val_160 11 -val_195 11 -val_42 11 -val_321 11 -val_430 11 -val_119 11 -val_489 11 -val_458 11 -val_78 11 -val_76 11 -val_41 11 -val_223 11 -val_492 11 -val_149 11 -val_449 11 -val_218 11 -val_228 11 -val_138 11 -val_453 11 -val_30 11 -val_209 11 -val_64 11 -val_468 11 -val_76 11 -val_74 11 -val_342 11 -val_69 11 -val_230 11 -val_33 11 -val_368 11 -val_103 11 -val_296 11 -val_113 11 -val_216 11 -val_367 11 -val_344 11 -val_167 11 -val_274 11 -val_219 11 -val_239 11 -val_485 11 -val_116 11 -val_223 11 -val_256 11 -val_263 11 -val_70 11 -val_487 11 -val_480 11 -val_401 11 -val_288 11 -val_191 11 -val_5 11 -val_244 11 -val_438 11 -val_128 11 -val_467 11 -val_432 11 -val_202 11 -val_316 11 -val_229 11 -val_469 11 -val_463 11 -val_280 11 -val_2 11 -val_35 11 -val_283 11 -val_331 11 -val_235 11 -val_80 11 -val_44 11 -val_193 11 -val_321 11 -val_335 11 -val_104 11 -val_466 11 -val_366 11 -val_175 11 -val_403 11 -val_483 11 -val_53 11 -val_105 11 -val_257 11 -val_406 11 -val_409 11 -val_190 11 -val_406 11 -val_401 11 -val_114 11 -val_258 11 -val_90 11 -val_203 11 -val_262 11 -val_348 11 -val_424 11 -val_12 11 -val_396 11 -val_201 11 -val_217 11 -val_164 11 -val_431 11 -val_454 11 -val_478 11 -val_298 11 -val_125 11 -val_431 11 -val_164 11 -val_424 11 -val_187 11 -val_382 11 -val_5 11 -val_70 11 -val_397 11 -val_480 11 -val_291 11 -val_24 11 -val_351 11 -val_255 11 -val_104 11 -val_70 11 -val_163 11 -val_438 11 -val_119 11 -val_414 11 -val_200 11 -val_491 11 -val_237 11 -val_439 11 -val_360 11 -val_248 11 -val_479 11 -val_305 11 -val_417 11 -val_199 11 -val_444 11 -val_120 11 -val_429 11 -val_169 11 -val_443 11 -val_323 11 -val_325 11 -val_277 11 -val_230 11 -val_478 11 -val_178 11 -val_468 11 -val_310 11 -val_317 11 -val_333 11 -val_493 11 -val_460 11 -val_207 11 -val_249 11 -val_265 11 -val_480 11 -val_83 11 -val_136 11 -val_353 11 -val_172 11 -val_214 11 -val_462 11 -val_233 11 -val_406 11 -val_133 11 -val_175 11 -val_189 11 -val_454 11 -val_375 11 -val_401 11 -val_421 11 -val_407 11 -val_384 11 -val_256 11 -val_26 11 -val_134 11 -val_67 11 -val_384 11 -val_379 11 -val_18 11 -val_462 11 -val_492 11 -val_100 11 -val_298 11 -val_9 11 -val_341 11 -val_498 11 -val_146 11 -val_458 11 -val_362 11 -val_186 11 -val_285 11 -val_348 11 -val_167 11 -val_18 11 -val_273 11 -val_183 11 -val_281 11 -val_344 11 -val_97 11 -val_469 11 -val_315 11 -val_84 11 -val_28 11 -val_37 11 -val_448 11 -val_152 11 -val_348 11 -val_307 11 -val_194 11 -val_414 11 -val_477 11 -val_222 11 -val_126 11 -val_90 11 -val_169 11 -val_403 11 -val_400 11 -val_200 11 -val_97 11 diff --git a/sql/hive/src/test/resources/golden/Partition pruning: with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190 b/sql/hive/src/test/resources/golden/Partition pruning: with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190 deleted file mode 100644 index d83d8b62b7..0000000000 --- a/sql/hive/src/test/resources/golden/Partition pruning: with filter on int partition key - query test-0-4e4d2651e1e6e3c224242078d0201190 +++ /dev/null @@ -1,1000 +0,0 @@ -val_238 11 -val_86 11 -val_311 11 -val_27 11 -val_165 11 -val_409 11 -val_255 11 -val_278 11 -val_98 11 -val_484 11 -val_265 11 -val_193 11 -val_401 11 -val_150 11 -val_273 11 -val_224 11 -val_369 11 -val_66 11 -val_128 11 -val_213 11 -val_146 11 -val_406 11 -val_429 11 -val_374 11 -val_152 11 -val_469 11 -val_145 11 -val_495 11 -val_37 11 -val_327 11 -val_281 11 -val_277 11 -val_209 11 -val_15 11 -val_82 11 -val_403 11 -val_166 11 -val_417 11 -val_430 11 -val_252 11 -val_292 11 -val_219 11 -val_287 11 -val_153 11 -val_193 11 -val_338 11 -val_446 11 -val_459 11 -val_394 11 -val_237 11 -val_482 11 -val_174 11 -val_413 11 -val_494 11 -val_207 11 -val_199 11 -val_466 11 -val_208 11 -val_174 11 -val_399 11 -val_396 11 -val_247 11 -val_417 11 -val_489 11 -val_162 11 -val_377 11 -val_397 11 -val_309 11 -val_365 11 -val_266 11 -val_439 11 -val_342 11 -val_367 11 -val_325 11 -val_167 11 -val_195 11 -val_475 11 -val_17 11 -val_113 11 -val_155 11 -val_203 11 -val_339 11 -val_0 11 -val_455 11 -val_128 11 -val_311 11 -val_316 11 -val_57 11 -val_302 11 -val_205 11 -val_149 11 -val_438 11 -val_345 11 -val_129 11 -val_170 11 -val_20 11 -val_489 11 -val_157 11 -val_378 11 -val_221 11 -val_92 11 -val_111 11 -val_47 11 -val_72 11 -val_4 11 -val_280 11 -val_35 11 -val_427 11 -val_277 11 -val_208 11 -val_356 11 -val_399 11 -val_169 11 -val_382 11 -val_498 11 -val_125 11 -val_386 11 -val_437 11 -val_469 11 -val_192 11 -val_286 11 -val_187 11 -val_176 11 -val_54 11 -val_459 11 -val_51 11 -val_138 11 -val_103 11 -val_239 11 -val_213 11 -val_216 11 -val_430 11 -val_278 11 -val_176 11 -val_289 11 -val_221 11 -val_65 11 -val_318 11 -val_332 11 -val_311 11 -val_275 11 -val_137 11 -val_241 11 -val_83 11 -val_333 11 -val_180 11 -val_284 11 -val_12 11 -val_230 11 -val_181 11 -val_67 11 -val_260 11 -val_404 11 -val_384 11 -val_489 11 -val_353 11 -val_373 11 -val_272 11 -val_138 11 -val_217 11 -val_84 11 -val_348 11 -val_466 11 -val_58 11 -val_8 11 -val_411 11 -val_230 11 -val_208 11 -val_348 11 -val_24 11 -val_463 11 -val_431 11 -val_179 11 -val_172 11 -val_42 11 -val_129 11 -val_158 11 -val_119 11 -val_496 11 -val_0 11 -val_322 11 -val_197 11 -val_468 11 -val_393 11 -val_454 11 -val_100 11 -val_298 11 -val_199 11 -val_191 11 -val_418 11 -val_96 11 -val_26 11 -val_165 11 -val_327 11 -val_230 11 -val_205 11 -val_120 11 -val_131 11 -val_51 11 -val_404 11 -val_43 11 -val_436 11 -val_156 11 -val_469 11 -val_468 11 -val_308 11 -val_95 11 -val_196 11 -val_288 11 -val_481 11 -val_457 11 -val_98 11 -val_282 11 -val_197 11 -val_187 11 -val_318 11 -val_318 11 -val_409 11 -val_470 11 -val_137 11 -val_369 11 -val_316 11 -val_169 11 -val_413 11 -val_85 11 -val_77 11 -val_0 11 -val_490 11 -val_87 11 -val_364 11 -val_179 11 -val_118 11 -val_134 11 -val_395 11 -val_282 11 -val_138 11 -val_238 11 -val_419 11 -val_15 11 -val_118 11 -val_72 11 -val_90 11 -val_307 11 -val_19 11 -val_435 11 -val_10 11 -val_277 11 -val_273 11 -val_306 11 -val_224 11 -val_309 11 -val_389 11 -val_327 11 -val_242 11 -val_369 11 -val_392 11 -val_272 11 -val_331 11 -val_401 11 -val_242 11 -val_452 11 -val_177 11 -val_226 11 -val_5 11 -val_497 11 -val_402 11 -val_396 11 -val_317 11 -val_395 11 -val_58 11 -val_35 11 -val_336 11 -val_95 11 -val_11 11 -val_168 11 -val_34 11 -val_229 11 -val_233 11 -val_143 11 -val_472 11 -val_322 11 -val_498 11 -val_160 11 -val_195 11 -val_42 11 -val_321 11 -val_430 11 -val_119 11 -val_489 11 -val_458 11 -val_78 11 -val_76 11 -val_41 11 -val_223 11 -val_492 11 -val_149 11 -val_449 11 -val_218 11 -val_228 11 -val_138 11 -val_453 11 -val_30 11 -val_209 11 -val_64 11 -val_468 11 -val_76 11 -val_74 11 -val_342 11 -val_69 11 -val_230 11 -val_33 11 -val_368 11 -val_103 11 -val_296 11 -val_113 11 -val_216 11 -val_367 11 -val_344 11 -val_167 11 -val_274 11 -val_219 11 -val_239 11 -val_485 11 -val_116 11 -val_223 11 -val_256 11 -val_263 11 -val_70 11 -val_487 11 -val_480 11 -val_401 11 -val_288 11 -val_191 11 -val_5 11 -val_244 11 -val_438 11 -val_128 11 -val_467 11 -val_432 11 -val_202 11 -val_316 11 -val_229 11 -val_469 11 -val_463 11 -val_280 11 -val_2 11 -val_35 11 -val_283 11 -val_331 11 -val_235 11 -val_80 11 -val_44 11 -val_193 11 -val_321 11 -val_335 11 -val_104 11 -val_466 11 -val_366 11 -val_175 11 -val_403 11 -val_483 11 -val_53 11 -val_105 11 -val_257 11 -val_406 11 -val_409 11 -val_190 11 -val_406 11 -val_401 11 -val_114 11 -val_258 11 -val_90 11 -val_203 11 -val_262 11 -val_348 11 -val_424 11 -val_12 11 -val_396 11 -val_201 11 -val_217 11 -val_164 11 -val_431 11 -val_454 11 -val_478 11 -val_298 11 -val_125 11 -val_431 11 -val_164 11 -val_424 11 -val_187 11 -val_382 11 -val_5 11 -val_70 11 -val_397 11 -val_480 11 -val_291 11 -val_24 11 -val_351 11 -val_255 11 -val_104 11 -val_70 11 -val_163 11 -val_438 11 -val_119 11 -val_414 11 -val_200 11 -val_491 11 -val_237 11 -val_439 11 -val_360 11 -val_248 11 -val_479 11 -val_305 11 -val_417 11 -val_199 11 -val_444 11 -val_120 11 -val_429 11 -val_169 11 -val_443 11 -val_323 11 -val_325 11 -val_277 11 -val_230 11 -val_478 11 -val_178 11 -val_468 11 -val_310 11 -val_317 11 -val_333 11 -val_493 11 -val_460 11 -val_207 11 -val_249 11 -val_265 11 -val_480 11 -val_83 11 -val_136 11 -val_353 11 -val_172 11 -val_214 11 -val_462 11 -val_233 11 -val_406 11 -val_133 11 -val_175 11 -val_189 11 -val_454 11 -val_375 11 -val_401 11 -val_421 11 -val_407 11 -val_384 11 -val_256 11 -val_26 11 -val_134 11 -val_67 11 -val_384 11 -val_379 11 -val_18 11 -val_462 11 -val_492 11 -val_100 11 -val_298 11 -val_9 11 -val_341 11 -val_498 11 -val_146 11 -val_458 11 -val_362 11 -val_186 11 -val_285 11 -val_348 11 -val_167 11 -val_18 11 -val_273 11 -val_183 11 -val_281 11 -val_344 11 -val_97 11 -val_469 11 -val_315 11 -val_84 11 -val_28 11 -val_37 11 -val_448 11 -val_152 11 -val_348 11 -val_307 11 -val_194 11 -val_414 11 -val_477 11 -val_222 11 -val_126 11 -val_90 11 -val_169 11 -val_403 11 -val_400 11 -val_200 11 -val_97 11 -val_238 11 -val_86 11 -val_311 11 -val_27 11 -val_165 11 -val_409 11 -val_255 11 -val_278 11 -val_98 11 -val_484 11 -val_265 11 -val_193 11 -val_401 11 -val_150 11 -val_273 11 -val_224 11 -val_369 11 -val_66 11 -val_128 11 -val_213 11 -val_146 11 -val_406 11 -val_429 11 -val_374 11 -val_152 11 -val_469 11 -val_145 11 -val_495 11 -val_37 11 -val_327 11 -val_281 11 -val_277 11 -val_209 11 -val_15 11 -val_82 11 -val_403 11 -val_166 11 -val_417 11 -val_430 11 -val_252 11 -val_292 11 -val_219 11 -val_287 11 -val_153 11 -val_193 11 -val_338 11 -val_446 11 -val_459 11 -val_394 11 -val_237 11 -val_482 11 -val_174 11 -val_413 11 -val_494 11 -val_207 11 -val_199 11 -val_466 11 -val_208 11 -val_174 11 -val_399 11 -val_396 11 -val_247 11 -val_417 11 -val_489 11 -val_162 11 -val_377 11 -val_397 11 -val_309 11 -val_365 11 -val_266 11 -val_439 11 -val_342 11 -val_367 11 -val_325 11 -val_167 11 -val_195 11 -val_475 11 -val_17 11 -val_113 11 -val_155 11 -val_203 11 -val_339 11 -val_0 11 -val_455 11 -val_128 11 -val_311 11 -val_316 11 -val_57 11 -val_302 11 -val_205 11 -val_149 11 -val_438 11 -val_345 11 -val_129 11 -val_170 11 -val_20 11 -val_489 11 -val_157 11 -val_378 11 -val_221 11 -val_92 11 -val_111 11 -val_47 11 -val_72 11 -val_4 11 -val_280 11 -val_35 11 -val_427 11 -val_277 11 -val_208 11 -val_356 11 -val_399 11 -val_169 11 -val_382 11 -val_498 11 -val_125 11 -val_386 11 -val_437 11 -val_469 11 -val_192 11 -val_286 11 -val_187 11 -val_176 11 -val_54 11 -val_459 11 -val_51 11 -val_138 11 -val_103 11 -val_239 11 -val_213 11 -val_216 11 -val_430 11 -val_278 11 -val_176 11 -val_289 11 -val_221 11 -val_65 11 -val_318 11 -val_332 11 -val_311 11 -val_275 11 -val_137 11 -val_241 11 -val_83 11 -val_333 11 -val_180 11 -val_284 11 -val_12 11 -val_230 11 -val_181 11 -val_67 11 -val_260 11 -val_404 11 -val_384 11 -val_489 11 -val_353 11 -val_373 11 -val_272 11 -val_138 11 -val_217 11 -val_84 11 -val_348 11 -val_466 11 -val_58 11 -val_8 11 -val_411 11 -val_230 11 -val_208 11 -val_348 11 -val_24 11 -val_463 11 -val_431 11 -val_179 11 -val_172 11 -val_42 11 -val_129 11 -val_158 11 -val_119 11 -val_496 11 -val_0 11 -val_322 11 -val_197 11 -val_468 11 -val_393 11 -val_454 11 -val_100 11 -val_298 11 -val_199 11 -val_191 11 -val_418 11 -val_96 11 -val_26 11 -val_165 11 -val_327 11 -val_230 11 -val_205 11 -val_120 11 -val_131 11 -val_51 11 -val_404 11 -val_43 11 -val_436 11 -val_156 11 -val_469 11 -val_468 11 -val_308 11 -val_95 11 -val_196 11 -val_288 11 -val_481 11 -val_457 11 -val_98 11 -val_282 11 -val_197 11 -val_187 11 -val_318 11 -val_318 11 -val_409 11 -val_470 11 -val_137 11 -val_369 11 -val_316 11 -val_169 11 -val_413 11 -val_85 11 -val_77 11 -val_0 11 -val_490 11 -val_87 11 -val_364 11 -val_179 11 -val_118 11 -val_134 11 -val_395 11 -val_282 11 -val_138 11 -val_238 11 -val_419 11 -val_15 11 -val_118 11 -val_72 11 -val_90 11 -val_307 11 -val_19 11 -val_435 11 -val_10 11 -val_277 11 -val_273 11 -val_306 11 -val_224 11 -val_309 11 -val_389 11 -val_327 11 -val_242 11 -val_369 11 -val_392 11 -val_272 11 -val_331 11 -val_401 11 -val_242 11 -val_452 11 -val_177 11 -val_226 11 -val_5 11 -val_497 11 -val_402 11 -val_396 11 -val_317 11 -val_395 11 -val_58 11 -val_35 11 -val_336 11 -val_95 11 -val_11 11 -val_168 11 -val_34 11 -val_229 11 -val_233 11 -val_143 11 -val_472 11 -val_322 11 -val_498 11 -val_160 11 -val_195 11 -val_42 11 -val_321 11 -val_430 11 -val_119 11 -val_489 11 -val_458 11 -val_78 11 -val_76 11 -val_41 11 -val_223 11 -val_492 11 -val_149 11 -val_449 11 -val_218 11 -val_228 11 -val_138 11 -val_453 11 -val_30 11 -val_209 11 -val_64 11 -val_468 11 -val_76 11 -val_74 11 -val_342 11 -val_69 11 -val_230 11 -val_33 11 -val_368 11 -val_103 11 -val_296 11 -val_113 11 -val_216 11 -val_367 11 -val_344 11 -val_167 11 -val_274 11 -val_219 11 -val_239 11 -val_485 11 -val_116 11 -val_223 11 -val_256 11 -val_263 11 -val_70 11 -val_487 11 -val_480 11 -val_401 11 -val_288 11 -val_191 11 -val_5 11 -val_244 11 -val_438 11 -val_128 11 -val_467 11 -val_432 11 -val_202 11 -val_316 11 -val_229 11 -val_469 11 -val_463 11 -val_280 11 -val_2 11 -val_35 11 -val_283 11 -val_331 11 -val_235 11 -val_80 11 -val_44 11 -val_193 11 -val_321 11 -val_335 11 -val_104 11 -val_466 11 -val_366 11 -val_175 11 -val_403 11 -val_483 11 -val_53 11 -val_105 11 -val_257 11 -val_406 11 -val_409 11 -val_190 11 -val_406 11 -val_401 11 -val_114 11 -val_258 11 -val_90 11 -val_203 11 -val_262 11 -val_348 11 -val_424 11 -val_12 11 -val_396 11 -val_201 11 -val_217 11 -val_164 11 -val_431 11 -val_454 11 -val_478 11 -val_298 11 -val_125 11 -val_431 11 -val_164 11 -val_424 11 -val_187 11 -val_382 11 -val_5 11 -val_70 11 -val_397 11 -val_480 11 -val_291 11 -val_24 11 -val_351 11 -val_255 11 -val_104 11 -val_70 11 -val_163 11 -val_438 11 -val_119 11 -val_414 11 -val_200 11 -val_491 11 -val_237 11 -val_439 11 -val_360 11 -val_248 11 -val_479 11 -val_305 11 -val_417 11 -val_199 11 -val_444 11 -val_120 11 -val_429 11 -val_169 11 -val_443 11 -val_323 11 -val_325 11 -val_277 11 -val_230 11 -val_478 11 -val_178 11 -val_468 11 -val_310 11 -val_317 11 -val_333 11 -val_493 11 -val_460 11 -val_207 11 -val_249 11 -val_265 11 -val_480 11 -val_83 11 -val_136 11 -val_353 11 -val_172 11 -val_214 11 -val_462 11 -val_233 11 -val_406 11 -val_133 11 -val_175 11 -val_189 11 -val_454 11 -val_375 11 -val_401 11 -val_421 11 -val_407 11 -val_384 11 -val_256 11 -val_26 11 -val_134 11 -val_67 11 -val_384 11 -val_379 11 -val_18 11 -val_462 11 -val_492 11 -val_100 11 -val_298 11 -val_9 11 -val_341 11 -val_498 11 -val_146 11 -val_458 11 -val_362 11 -val_186 11 -val_285 11 -val_348 11 -val_167 11 -val_18 11 -val_273 11 -val_183 11 -val_281 11 -val_344 11 -val_97 11 -val_469 11 -val_315 11 -val_84 11 -val_28 11 -val_37 11 -val_448 11 -val_152 11 -val_348 11 -val_307 11 -val_194 11 -val_414 11 -val_477 11 -val_222 11 -val_126 11 -val_90 11 -val_169 11 -val_403 11 -val_400 11 -val_200 11 -val_97 11 diff --git a/sql/hive/src/test/resources/golden/Partition pruning: with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5 b/sql/hive/src/test/resources/golden/Partition pruning: with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5 deleted file mode 100644 index 83bc6257ba..0000000000 --- a/sql/hive/src/test/resources/golden/Partition pruning: with filter on string partition key - query test-0-b6e59464383591f02408f8765ac6a5d5 +++ /dev/null @@ -1,1000 +0,0 @@ -val_238 11 -val_86 11 -val_311 11 -val_27 11 -val_165 11 -val_409 11 -val_255 11 -val_278 11 -val_98 11 -val_484 11 -val_265 11 -val_193 11 -val_401 11 -val_150 11 -val_273 11 -val_224 11 -val_369 11 -val_66 11 -val_128 11 -val_213 11 -val_146 11 -val_406 11 -val_429 11 -val_374 11 -val_152 11 -val_469 11 -val_145 11 -val_495 11 -val_37 11 -val_327 11 -val_281 11 -val_277 11 -val_209 11 -val_15 11 -val_82 11 -val_403 11 -val_166 11 -val_417 11 -val_430 11 -val_252 11 -val_292 11 -val_219 11 -val_287 11 -val_153 11 -val_193 11 -val_338 11 -val_446 11 -val_459 11 -val_394 11 -val_237 11 -val_482 11 -val_174 11 -val_413 11 -val_494 11 -val_207 11 -val_199 11 -val_466 11 -val_208 11 -val_174 11 -val_399 11 -val_396 11 -val_247 11 -val_417 11 -val_489 11 -val_162 11 -val_377 11 -val_397 11 -val_309 11 -val_365 11 -val_266 11 -val_439 11 -val_342 11 -val_367 11 -val_325 11 -val_167 11 -val_195 11 -val_475 11 -val_17 11 -val_113 11 -val_155 11 -val_203 11 -val_339 11 -val_0 11 -val_455 11 -val_128 11 -val_311 11 -val_316 11 -val_57 11 -val_302 11 -val_205 11 -val_149 11 -val_438 11 -val_345 11 -val_129 11 -val_170 11 -val_20 11 -val_489 11 -val_157 11 -val_378 11 -val_221 11 -val_92 11 -val_111 11 -val_47 11 -val_72 11 -val_4 11 -val_280 11 -val_35 11 -val_427 11 -val_277 11 -val_208 11 -val_356 11 -val_399 11 -val_169 11 -val_382 11 -val_498 11 -val_125 11 -val_386 11 -val_437 11 -val_469 11 -val_192 11 -val_286 11 -val_187 11 -val_176 11 -val_54 11 -val_459 11 -val_51 11 -val_138 11 -val_103 11 -val_239 11 -val_213 11 -val_216 11 -val_430 11 -val_278 11 -val_176 11 -val_289 11 -val_221 11 -val_65 11 -val_318 11 -val_332 11 -val_311 11 -val_275 11 -val_137 11 -val_241 11 -val_83 11 -val_333 11 -val_180 11 -val_284 11 -val_12 11 -val_230 11 -val_181 11 -val_67 11 -val_260 11 -val_404 11 -val_384 11 -val_489 11 -val_353 11 -val_373 11 -val_272 11 -val_138 11 -val_217 11 -val_84 11 -val_348 11 -val_466 11 -val_58 11 -val_8 11 -val_411 11 -val_230 11 -val_208 11 -val_348 11 -val_24 11 -val_463 11 -val_431 11 -val_179 11 -val_172 11 -val_42 11 -val_129 11 -val_158 11 -val_119 11 -val_496 11 -val_0 11 -val_322 11 -val_197 11 -val_468 11 -val_393 11 -val_454 11 -val_100 11 -val_298 11 -val_199 11 -val_191 11 -val_418 11 -val_96 11 -val_26 11 -val_165 11 -val_327 11 -val_230 11 -val_205 11 -val_120 11 -val_131 11 -val_51 11 -val_404 11 -val_43 11 -val_436 11 -val_156 11 -val_469 11 -val_468 11 -val_308 11 -val_95 11 -val_196 11 -val_288 11 -val_481 11 -val_457 11 -val_98 11 -val_282 11 -val_197 11 -val_187 11 -val_318 11 -val_318 11 -val_409 11 -val_470 11 -val_137 11 -val_369 11 -val_316 11 -val_169 11 -val_413 11 -val_85 11 -val_77 11 -val_0 11 -val_490 11 -val_87 11 -val_364 11 -val_179 11 -val_118 11 -val_134 11 -val_395 11 -val_282 11 -val_138 11 -val_238 11 -val_419 11 -val_15 11 -val_118 11 -val_72 11 -val_90 11 -val_307 11 -val_19 11 -val_435 11 -val_10 11 -val_277 11 -val_273 11 -val_306 11 -val_224 11 -val_309 11 -val_389 11 -val_327 11 -val_242 11 -val_369 11 -val_392 11 -val_272 11 -val_331 11 -val_401 11 -val_242 11 -val_452 11 -val_177 11 -val_226 11 -val_5 11 -val_497 11 -val_402 11 -val_396 11 -val_317 11 -val_395 11 -val_58 11 -val_35 11 -val_336 11 -val_95 11 -val_11 11 -val_168 11 -val_34 11 -val_229 11 -val_233 11 -val_143 11 -val_472 11 -val_322 11 -val_498 11 -val_160 11 -val_195 11 -val_42 11 -val_321 11 -val_430 11 -val_119 11 -val_489 11 -val_458 11 -val_78 11 -val_76 11 -val_41 11 -val_223 11 -val_492 11 -val_149 11 -val_449 11 -val_218 11 -val_228 11 -val_138 11 -val_453 11 -val_30 11 -val_209 11 -val_64 11 -val_468 11 -val_76 11 -val_74 11 -val_342 11 -val_69 11 -val_230 11 -val_33 11 -val_368 11 -val_103 11 -val_296 11 -val_113 11 -val_216 11 -val_367 11 -val_344 11 -val_167 11 -val_274 11 -val_219 11 -val_239 11 -val_485 11 -val_116 11 -val_223 11 -val_256 11 -val_263 11 -val_70 11 -val_487 11 -val_480 11 -val_401 11 -val_288 11 -val_191 11 -val_5 11 -val_244 11 -val_438 11 -val_128 11 -val_467 11 -val_432 11 -val_202 11 -val_316 11 -val_229 11 -val_469 11 -val_463 11 -val_280 11 -val_2 11 -val_35 11 -val_283 11 -val_331 11 -val_235 11 -val_80 11 -val_44 11 -val_193 11 -val_321 11 -val_335 11 -val_104 11 -val_466 11 -val_366 11 -val_175 11 -val_403 11 -val_483 11 -val_53 11 -val_105 11 -val_257 11 -val_406 11 -val_409 11 -val_190 11 -val_406 11 -val_401 11 -val_114 11 -val_258 11 -val_90 11 -val_203 11 -val_262 11 -val_348 11 -val_424 11 -val_12 11 -val_396 11 -val_201 11 -val_217 11 -val_164 11 -val_431 11 -val_454 11 -val_478 11 -val_298 11 -val_125 11 -val_431 11 -val_164 11 -val_424 11 -val_187 11 -val_382 11 -val_5 11 -val_70 11 -val_397 11 -val_480 11 -val_291 11 -val_24 11 -val_351 11 -val_255 11 -val_104 11 -val_70 11 -val_163 11 -val_438 11 -val_119 11 -val_414 11 -val_200 11 -val_491 11 -val_237 11 -val_439 11 -val_360 11 -val_248 11 -val_479 11 -val_305 11 -val_417 11 -val_199 11 -val_444 11 -val_120 11 -val_429 11 -val_169 11 -val_443 11 -val_323 11 -val_325 11 -val_277 11 -val_230 11 -val_478 11 -val_178 11 -val_468 11 -val_310 11 -val_317 11 -val_333 11 -val_493 11 -val_460 11 -val_207 11 -val_249 11 -val_265 11 -val_480 11 -val_83 11 -val_136 11 -val_353 11 -val_172 11 -val_214 11 -val_462 11 -val_233 11 -val_406 11 -val_133 11 -val_175 11 -val_189 11 -val_454 11 -val_375 11 -val_401 11 -val_421 11 -val_407 11 -val_384 11 -val_256 11 -val_26 11 -val_134 11 -val_67 11 -val_384 11 -val_379 11 -val_18 11 -val_462 11 -val_492 11 -val_100 11 -val_298 11 -val_9 11 -val_341 11 -val_498 11 -val_146 11 -val_458 11 -val_362 11 -val_186 11 -val_285 11 -val_348 11 -val_167 11 -val_18 11 -val_273 11 -val_183 11 -val_281 11 -val_344 11 -val_97 11 -val_469 11 -val_315 11 -val_84 11 -val_28 11 -val_37 11 -val_448 11 -val_152 11 -val_348 11 -val_307 11 -val_194 11 -val_414 11 -val_477 11 -val_222 11 -val_126 11 -val_90 11 -val_169 11 -val_403 11 -val_400 11 -val_200 11 -val_97 11 -val_238 12 -val_86 12 -val_311 12 -val_27 12 -val_165 12 -val_409 12 -val_255 12 -val_278 12 -val_98 12 -val_484 12 -val_265 12 -val_193 12 -val_401 12 -val_150 12 -val_273 12 -val_224 12 -val_369 12 -val_66 12 -val_128 12 -val_213 12 -val_146 12 -val_406 12 -val_429 12 -val_374 12 -val_152 12 -val_469 12 -val_145 12 -val_495 12 -val_37 12 -val_327 12 -val_281 12 -val_277 12 -val_209 12 -val_15 12 -val_82 12 -val_403 12 -val_166 12 -val_417 12 -val_430 12 -val_252 12 -val_292 12 -val_219 12 -val_287 12 -val_153 12 -val_193 12 -val_338 12 -val_446 12 -val_459 12 -val_394 12 -val_237 12 -val_482 12 -val_174 12 -val_413 12 -val_494 12 -val_207 12 -val_199 12 -val_466 12 -val_208 12 -val_174 12 -val_399 12 -val_396 12 -val_247 12 -val_417 12 -val_489 12 -val_162 12 -val_377 12 -val_397 12 -val_309 12 -val_365 12 -val_266 12 -val_439 12 -val_342 12 -val_367 12 -val_325 12 -val_167 12 -val_195 12 -val_475 12 -val_17 12 -val_113 12 -val_155 12 -val_203 12 -val_339 12 -val_0 12 -val_455 12 -val_128 12 -val_311 12 -val_316 12 -val_57 12 -val_302 12 -val_205 12 -val_149 12 -val_438 12 -val_345 12 -val_129 12 -val_170 12 -val_20 12 -val_489 12 -val_157 12 -val_378 12 -val_221 12 -val_92 12 -val_111 12 -val_47 12 -val_72 12 -val_4 12 -val_280 12 -val_35 12 -val_427 12 -val_277 12 -val_208 12 -val_356 12 -val_399 12 -val_169 12 -val_382 12 -val_498 12 -val_125 12 -val_386 12 -val_437 12 -val_469 12 -val_192 12 -val_286 12 -val_187 12 -val_176 12 -val_54 12 -val_459 12 -val_51 12 -val_138 12 -val_103 12 -val_239 12 -val_213 12 -val_216 12 -val_430 12 -val_278 12 -val_176 12 -val_289 12 -val_221 12 -val_65 12 -val_318 12 -val_332 12 -val_311 12 -val_275 12 -val_137 12 -val_241 12 -val_83 12 -val_333 12 -val_180 12 -val_284 12 -val_12 12 -val_230 12 -val_181 12 -val_67 12 -val_260 12 -val_404 12 -val_384 12 -val_489 12 -val_353 12 -val_373 12 -val_272 12 -val_138 12 -val_217 12 -val_84 12 -val_348 12 -val_466 12 -val_58 12 -val_8 12 -val_411 12 -val_230 12 -val_208 12 -val_348 12 -val_24 12 -val_463 12 -val_431 12 -val_179 12 -val_172 12 -val_42 12 -val_129 12 -val_158 12 -val_119 12 -val_496 12 -val_0 12 -val_322 12 -val_197 12 -val_468 12 -val_393 12 -val_454 12 -val_100 12 -val_298 12 -val_199 12 -val_191 12 -val_418 12 -val_96 12 -val_26 12 -val_165 12 -val_327 12 -val_230 12 -val_205 12 -val_120 12 -val_131 12 -val_51 12 -val_404 12 -val_43 12 -val_436 12 -val_156 12 -val_469 12 -val_468 12 -val_308 12 -val_95 12 -val_196 12 -val_288 12 -val_481 12 -val_457 12 -val_98 12 -val_282 12 -val_197 12 -val_187 12 -val_318 12 -val_318 12 -val_409 12 -val_470 12 -val_137 12 -val_369 12 -val_316 12 -val_169 12 -val_413 12 -val_85 12 -val_77 12 -val_0 12 -val_490 12 -val_87 12 -val_364 12 -val_179 12 -val_118 12 -val_134 12 -val_395 12 -val_282 12 -val_138 12 -val_238 12 -val_419 12 -val_15 12 -val_118 12 -val_72 12 -val_90 12 -val_307 12 -val_19 12 -val_435 12 -val_10 12 -val_277 12 -val_273 12 -val_306 12 -val_224 12 -val_309 12 -val_389 12 -val_327 12 -val_242 12 -val_369 12 -val_392 12 -val_272 12 -val_331 12 -val_401 12 -val_242 12 -val_452 12 -val_177 12 -val_226 12 -val_5 12 -val_497 12 -val_402 12 -val_396 12 -val_317 12 -val_395 12 -val_58 12 -val_35 12 -val_336 12 -val_95 12 -val_11 12 -val_168 12 -val_34 12 -val_229 12 -val_233 12 -val_143 12 -val_472 12 -val_322 12 -val_498 12 -val_160 12 -val_195 12 -val_42 12 -val_321 12 -val_430 12 -val_119 12 -val_489 12 -val_458 12 -val_78 12 -val_76 12 -val_41 12 -val_223 12 -val_492 12 -val_149 12 -val_449 12 -val_218 12 -val_228 12 -val_138 12 -val_453 12 -val_30 12 -val_209 12 -val_64 12 -val_468 12 -val_76 12 -val_74 12 -val_342 12 -val_69 12 -val_230 12 -val_33 12 -val_368 12 -val_103 12 -val_296 12 -val_113 12 -val_216 12 -val_367 12 -val_344 12 -val_167 12 -val_274 12 -val_219 12 -val_239 12 -val_485 12 -val_116 12 -val_223 12 -val_256 12 -val_263 12 -val_70 12 -val_487 12 -val_480 12 -val_401 12 -val_288 12 -val_191 12 -val_5 12 -val_244 12 -val_438 12 -val_128 12 -val_467 12 -val_432 12 -val_202 12 -val_316 12 -val_229 12 -val_469 12 -val_463 12 -val_280 12 -val_2 12 -val_35 12 -val_283 12 -val_331 12 -val_235 12 -val_80 12 -val_44 12 -val_193 12 -val_321 12 -val_335 12 -val_104 12 -val_466 12 -val_366 12 -val_175 12 -val_403 12 -val_483 12 -val_53 12 -val_105 12 -val_257 12 -val_406 12 -val_409 12 -val_190 12 -val_406 12 -val_401 12 -val_114 12 -val_258 12 -val_90 12 -val_203 12 -val_262 12 -val_348 12 -val_424 12 -val_12 12 -val_396 12 -val_201 12 -val_217 12 -val_164 12 -val_431 12 -val_454 12 -val_478 12 -val_298 12 -val_125 12 -val_431 12 -val_164 12 -val_424 12 -val_187 12 -val_382 12 -val_5 12 -val_70 12 -val_397 12 -val_480 12 -val_291 12 -val_24 12 -val_351 12 -val_255 12 -val_104 12 -val_70 12 -val_163 12 -val_438 12 -val_119 12 -val_414 12 -val_200 12 -val_491 12 -val_237 12 -val_439 12 -val_360 12 -val_248 12 -val_479 12 -val_305 12 -val_417 12 -val_199 12 -val_444 12 -val_120 12 -val_429 12 -val_169 12 -val_443 12 -val_323 12 -val_325 12 -val_277 12 -val_230 12 -val_478 12 -val_178 12 -val_468 12 -val_310 12 -val_317 12 -val_333 12 -val_493 12 -val_460 12 -val_207 12 -val_249 12 -val_265 12 -val_480 12 -val_83 12 -val_136 12 -val_353 12 -val_172 12 -val_214 12 -val_462 12 -val_233 12 -val_406 12 -val_133 12 -val_175 12 -val_189 12 -val_454 12 -val_375 12 -val_401 12 -val_421 12 -val_407 12 -val_384 12 -val_256 12 -val_26 12 -val_134 12 -val_67 12 -val_384 12 -val_379 12 -val_18 12 -val_462 12 -val_492 12 -val_100 12 -val_298 12 -val_9 12 -val_341 12 -val_498 12 -val_146 12 -val_458 12 -val_362 12 -val_186 12 -val_285 12 -val_348 12 -val_167 12 -val_18 12 -val_273 12 -val_183 12 -val_281 12 -val_344 12 -val_97 12 -val_469 12 -val_315 12 -val_84 12 -val_28 12 -val_37 12 -val_448 12 -val_152 12 -val_348 12 -val_307 12 -val_194 12 -val_414 12 -val_477 12 -val_222 12 -val_126 12 -val_90 12 -val_169 12 -val_403 12 -val_400 12 -val_200 12 -val_97 12 diff --git a/sql/hive/src/test/resources/golden/Partiton pruning: non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344 b/sql/hive/src/test/resources/golden/Partiton pruning: non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344 deleted file mode 100644 index 7ba6caf9d8..0000000000 --- a/sql/hive/src/test/resources/golden/Partiton pruning: non-partitioned table - query test-0-681332efaff7b12e3ca12d9f021cd344 +++ /dev/null @@ -1,500 +0,0 @@ -val_238 -val_86 -val_311 -val_27 -val_165 -val_409 -val_255 -val_278 -val_98 -val_484 -val_265 -val_193 -val_401 -val_150 -val_273 -val_224 -val_369 -val_66 -val_128 -val_213 -val_146 -val_406 -val_429 -val_374 -val_152 -val_469 -val_145 -val_495 -val_37 -val_327 -val_281 -val_277 -val_209 -val_15 -val_82 -val_403 -val_166 -val_417 -val_430 -val_252 -val_292 -val_219 -val_287 -val_153 -val_193 -val_338 -val_446 -val_459 -val_394 -val_237 -val_482 -val_174 -val_413 -val_494 -val_207 -val_199 -val_466 -val_208 -val_174 -val_399 -val_396 -val_247 -val_417 -val_489 -val_162 -val_377 -val_397 -val_309 -val_365 -val_266 -val_439 -val_342 -val_367 -val_325 -val_167 -val_195 -val_475 -val_17 -val_113 -val_155 -val_203 -val_339 -val_0 -val_455 -val_128 -val_311 -val_316 -val_57 -val_302 -val_205 -val_149 -val_438 -val_345 -val_129 -val_170 -val_20 -val_489 -val_157 -val_378 -val_221 -val_92 -val_111 -val_47 -val_72 -val_4 -val_280 -val_35 -val_427 -val_277 -val_208 -val_356 -val_399 -val_169 -val_382 -val_498 -val_125 -val_386 -val_437 -val_469 -val_192 -val_286 -val_187 -val_176 -val_54 -val_459 -val_51 -val_138 -val_103 -val_239 -val_213 -val_216 -val_430 -val_278 -val_176 -val_289 -val_221 -val_65 -val_318 -val_332 -val_311 -val_275 -val_137 -val_241 -val_83 -val_333 -val_180 -val_284 -val_12 -val_230 -val_181 -val_67 -val_260 -val_404 -val_384 -val_489 -val_353 -val_373 -val_272 -val_138 -val_217 -val_84 -val_348 -val_466 -val_58 -val_8 -val_411 -val_230 -val_208 -val_348 -val_24 -val_463 -val_431 -val_179 -val_172 -val_42 -val_129 -val_158 -val_119 -val_496 -val_0 -val_322 -val_197 -val_468 -val_393 -val_454 -val_100 -val_298 -val_199 -val_191 -val_418 -val_96 -val_26 -val_165 -val_327 -val_230 -val_205 -val_120 -val_131 -val_51 -val_404 -val_43 -val_436 -val_156 -val_469 -val_468 -val_308 -val_95 -val_196 -val_288 -val_481 -val_457 -val_98 -val_282 -val_197 -val_187 -val_318 -val_318 -val_409 -val_470 -val_137 -val_369 -val_316 -val_169 -val_413 -val_85 -val_77 -val_0 -val_490 -val_87 -val_364 -val_179 -val_118 -val_134 -val_395 -val_282 -val_138 -val_238 -val_419 -val_15 -val_118 -val_72 -val_90 -val_307 -val_19 -val_435 -val_10 -val_277 -val_273 -val_306 -val_224 -val_309 -val_389 -val_327 -val_242 -val_369 -val_392 -val_272 -val_331 -val_401 -val_242 -val_452 -val_177 -val_226 -val_5 -val_497 -val_402 -val_396 -val_317 -val_395 -val_58 -val_35 -val_336 -val_95 -val_11 -val_168 -val_34 -val_229 -val_233 -val_143 -val_472 -val_322 -val_498 -val_160 -val_195 -val_42 -val_321 -val_430 -val_119 -val_489 -val_458 -val_78 -val_76 -val_41 -val_223 -val_492 -val_149 -val_449 -val_218 -val_228 -val_138 -val_453 -val_30 -val_209 -val_64 -val_468 -val_76 -val_74 -val_342 -val_69 -val_230 -val_33 -val_368 -val_103 -val_296 -val_113 -val_216 -val_367 -val_344 -val_167 -val_274 -val_219 -val_239 -val_485 -val_116 -val_223 -val_256 -val_263 -val_70 -val_487 -val_480 -val_401 -val_288 -val_191 -val_5 -val_244 -val_438 -val_128 -val_467 -val_432 -val_202 -val_316 -val_229 -val_469 -val_463 -val_280 -val_2 -val_35 -val_283 -val_331 -val_235 -val_80 -val_44 -val_193 -val_321 -val_335 -val_104 -val_466 -val_366 -val_175 -val_403 -val_483 -val_53 -val_105 -val_257 -val_406 -val_409 -val_190 -val_406 -val_401 -val_114 -val_258 -val_90 -val_203 -val_262 -val_348 -val_424 -val_12 -val_396 -val_201 -val_217 -val_164 -val_431 -val_454 -val_478 -val_298 -val_125 -val_431 -val_164 -val_424 -val_187 -val_382 -val_5 -val_70 -val_397 -val_480 -val_291 -val_24 -val_351 -val_255 -val_104 -val_70 -val_163 -val_438 -val_119 -val_414 -val_200 -val_491 -val_237 -val_439 -val_360 -val_248 -val_479 -val_305 -val_417 -val_199 -val_444 -val_120 -val_429 -val_169 -val_443 -val_323 -val_325 -val_277 -val_230 -val_478 -val_178 -val_468 -val_310 -val_317 -val_333 -val_493 -val_460 -val_207 -val_249 -val_265 -val_480 -val_83 -val_136 -val_353 -val_172 -val_214 -val_462 -val_233 -val_406 -val_133 -val_175 -val_189 -val_454 -val_375 -val_401 -val_421 -val_407 -val_384 -val_256 -val_26 -val_134 -val_67 -val_384 -val_379 -val_18 -val_462 -val_492 -val_100 -val_298 -val_9 -val_341 -val_498 -val_146 -val_458 -val_362 -val_186 -val_285 -val_348 -val_167 -val_18 -val_273 -val_183 -val_281 -val_344 -val_97 -val_469 -val_315 -val_84 -val_28 -val_37 -val_448 -val_152 -val_348 -val_307 -val_194 -val_414 -val_477 -val_222 -val_126 -val_90 -val_169 -val_403 -val_400 -val_200 -val_97 diff --git a/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/PruningSuite.scala b/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/PruningSuite.scala index 25eca39746..34434449a0 100644 --- a/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/PruningSuite.scala +++ b/sql/hive/src/test/scala/org/apache/spark/sql/hive/execution/PruningSuite.scala @@ -28,7 +28,7 @@ import scala.collection.JavaConversions._ class PruningSuite extends HiveComparisonTest { // Column pruning tests - createPruningTest("Column pruning: with partitioned table", + createPruningTest("Column pruning - with partitioned table", "SELECT key FROM srcpart WHERE ds = '2008-04-08' LIMIT 3", Seq("key"), Seq("key"), @@ -36,43 +36,43 @@ class PruningSuite extends HiveComparisonTest { Seq("2008-04-08", "11"), Seq("2008-04-08", "12"))) - createPruningTest("Column pruning: with non-partitioned table", + createPruningTest("Column pruning - with non-partitioned table", "SELECT key FROM src WHERE key > 10 LIMIT 3", Seq("key"), Seq("key"), Seq.empty) - createPruningTest("Column pruning: with multiple projects", + createPruningTest("Column pruning - with multiple projects", "SELECT c1 FROM (SELECT key AS c1 FROM src WHERE key > 10) t1 LIMIT 3", Seq("c1"), Seq("key"), Seq.empty) - createPruningTest("Column pruning: projects alias substituting", + createPruningTest("Column pruning - projects alias substituting", "SELECT c1 AS c2 FROM (SELECT key AS c1 FROM src WHERE key > 10) t1 LIMIT 3", Seq("c2"), Seq("key"), Seq.empty) - createPruningTest("Column pruning: filter alias in-lining", + createPruningTest("Column pruning - filter alias in-lining", "SELECT c1 FROM (SELECT key AS c1 FROM src WHERE key > 10) t1 WHERE c1 < 100 LIMIT 3", Seq("c1"), Seq("key"), Seq.empty) - createPruningTest("Column pruning: without filters", + createPruningTest("Column pruning - without filters", "SELECT c1 FROM (SELECT key AS c1 FROM src) t1 LIMIT 3", Seq("c1"), Seq("key"), Seq.empty) - createPruningTest("Column pruning: simple top project without aliases", + createPruningTest("Column pruning - simple top project without aliases", "SELECT key FROM (SELECT key FROM src WHERE key > 10) t1 WHERE key < 100 LIMIT 3", Seq("key"), Seq("key"), Seq.empty) - createPruningTest("Column pruning: non-trivial top project with aliases", + createPruningTest("Column pruning - non-trivial top project with aliases", "SELECT c1 * 2 AS double FROM (SELECT key AS c1 FROM src WHERE key > 10) t1 LIMIT 3", Seq("double"), Seq("key"), @@ -80,19 +80,19 @@ class PruningSuite extends HiveComparisonTest { // Partition pruning tests - createPruningTest("Partition pruning: non-partitioned, non-trivial project", + createPruningTest("Partition pruning - non-partitioned, non-trivial project", "SELECT key * 2 AS double FROM src WHERE value IS NOT NULL", Seq("double"), Seq("key", "value"), Seq.empty) - createPruningTest("Partiton pruning: non-partitioned table", + createPruningTest("Partition pruning - non-partitioned table", "SELECT value FROM src WHERE key IS NOT NULL", Seq("value"), Seq("value", "key"), Seq.empty) - createPruningTest("Partition pruning: with filter on string partition key", + createPruningTest("Partition pruning - with filter on string partition key", "SELECT value, hr FROM srcpart1 WHERE ds = '2008-04-08'", Seq("value", "hr"), Seq("value", "hr"), @@ -100,7 +100,7 @@ class PruningSuite extends HiveComparisonTest { Seq("2008-04-08", "11"), Seq("2008-04-08", "12"))) - createPruningTest("Partition pruning: with filter on int partition key", + createPruningTest("Partition pruning - with filter on int partition key", "SELECT value, hr FROM srcpart1 WHERE hr < 12", Seq("value", "hr"), Seq("value", "hr"), @@ -108,20 +108,20 @@ class PruningSuite extends HiveComparisonTest { Seq("2008-04-08", "11"), Seq("2008-04-09", "11"))) - createPruningTest("Partition pruning: left only 1 partition", + createPruningTest("Partition pruning - left only 1 partition", "SELECT value, hr FROM srcpart1 WHERE ds = '2008-04-08' AND hr < 12", Seq("value", "hr"), Seq("value", "hr"), Seq( Seq("2008-04-08", "11"))) - createPruningTest("Partition pruning: all partitions pruned", + createPruningTest("Partition pruning - all partitions pruned", "SELECT value, hr FROM srcpart1 WHERE ds = '2014-01-27' AND hr = 11", Seq("value", "hr"), Seq("value", "hr"), Seq.empty) - createPruningTest("Partition pruning: pruning with both column key and partition key", + createPruningTest("Partition pruning - pruning with both column key and partition key", "SELECT value, hr FROM srcpart1 WHERE value IS NOT NULL AND hr < 12", Seq("value", "hr"), Seq("value", "hr"), -- cgit v1.2.3