Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-28636

partition_explain_ddl.q is flaky

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 4.0.1
    • 4.1.0
    • Test

    Description

      I recently often observe partition_explain_ddl.q failing.

      https://ci.hive.apache.org/blue/organizations/jenkins/hive-precommit/detail/master/2342/tests

      Running: diff -a /home/jenkins/agent/workspace/hive-precommit_master/itests/qtest/target/qfile-results/clientpositive/partition_explain_ddl.q.out /home/jenkins/agent/workspace/hive-precommit_master/ql/src/test/results/clientpositive/llap/partition_explain_ddl.q.out
903,908d902
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='6.625','maxColLen'='10','numNulls'='0','numDVs'='16' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Tennis' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBAQw9jy4wbApZ6a/v////8B/sPU3fv/////AcCHp9kGgN/fv/r/////AYLFxPn+/////wGBkrK3Av2Ry8cCgc676Pv/////Ab/A89YBxOTiEvzixO/+/////wHD55ygA77R9+T6/////wHFq+mVB7vOpY39/////wE= 
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1007','highValue'='1086','numNulls'='0','numDVs'='16' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Tennis' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBAQgsirL7+NuZgFgJSyrf7/////AcDw1/3//////wGAw9/iAoGurff//////wH//tG+/v////8BhMDytf//////Abya/vb+/////wHCpbPM//////8B/v+D1v7/////AcD2p9r//////wGApJdwwLKYgQTByo7U//////8BwdS26vv/////AQ== 
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='5.875','maxColLen'='10','numNulls'='0','numDVs'='16' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Tennis' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBAQgp+Lswf/6/Gw+/////8BgM2YkAPB0+LF/f////8B/8ulC8DngZ0CgJ+o9v//////AcDR9AWBwp7N+v////8BwZT4/QH/qIfj//////8BgP+t//3/////Ab+a5YgDxoiV3QK8+K/t/v////8Bgdruk/7/////AQ== 
913,918c907,912
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='6.2','maxColLen'='8','numNulls'='0','numDVs'='15' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Basketball' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA8PgZ/tvgSA18jgAoGZwtb+/////wH/zaeIAcDWpIP//////wGC/43R+/////8B/5/ogwGDhYerAfz89K4DgL6l8v7/////AYDwwZj//////wHAlpaV/f////8BgLqSK8GJg9D9/////wHCiZiWAw== 
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1001','highValue'='1097','numNulls'='0','numDVs'='15' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Basketball' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA8PgYCNxQOA2pic/f////8BxuPc2AP8m7G4A7+Ix+z7/////wG/xNKo/f////8BgLCJswSAxK+U/f////8BgPmo2gHE6pNr/pSPjQK+4MTY+v////8BgIiW4ASEgZT0+/////8B/OCGvQE= 
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='6.466666666666667','maxColLen'='9','numNulls'='0','numDVs'='15' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Basketball' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA8PgbilpAeC7+ssvtnsxfj/////AcCW6PAFwLLw9f7/////AcHwo4v9/////wH/nYz3AoGH1J/9/////wH/7Jv7/f////8BxNrM2wK85uvN/v////8BgJnvHMCdv9b//////wGAw7/oBcLAloD5/////wE= 
---
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='6.625','maxColLen'='10','numNulls'='0','numDVs'='16' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Tennis' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBAQw9jy4wbApZ6a/v////8B/sPU3fv/////AcCHp9kGgN/fv/r/////AYLFxPn+/////wGBkrK3Av2Ry8cCgc676Pv/////Ab/A89YBxOTiEvzixO/+/////wHD55ygA77R9+T6/////wHFq+mVB7vOpY39/////wE= 
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='5.875','maxColLen'='10','numNulls'='0','numDVs'='16' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Tennis' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBAQgp+Lswf/6/Gw+/////8BgM2YkAPB0+LF/f////8B/8ulC8DngZ0CgJ+o9v//////AcDR9AWBwp7N+v////8BwZT4/QH/qIfj//////8BgP+t//3/////Ab+a5YgDxoiV3QK8+K/t/v////8Bgdruk/7/////AQ== 
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Tennis') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1007','highValue'='1086','numNulls'='0','numDVs'='16' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Tennis' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBAQgsirL7+NuZgFgJSyrf7/////AcDw1/3//////wGAw9/iAoGurff//////wH//tG+/v////8BhMDytf//////Abya/vb+/////wHCpbPM//////8B/v+D1v7/////AcD2p9r//////wGApJdwwLKYgQTByo7U//////8BwdS26vv/////AQ== 
923,928c917,922
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Football') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='5.6521739130434785','maxColLen'='8','numNulls'='0','numDVs'='23' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Football' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBcXgqW6lwS/7cK2AsGpjOz7/////wGCm5fW//////8BvbT96wTA5rbf/P////8Bgoq+hwO/6qXp/P////8B/8GzqP7/////AcCqq+L//////wGA5PWu/v////8Bwa37xwa/u+SQ/P////8Bwcrsrf3/////Ab+2k+ADgNahiAHAyNff/v////8BwNftnP7/////AYDDkyfB/tKCA4DswM8Bgoeop/3/////Af3g8/oB 
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Football') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1006','highValue'='1100','numNulls'='0','numDVs'='23' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Football' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBcXgaCXhwXA1P+S/f////8Bg93J8wG91quf/P////8Bg8OW9gG9v/KA//////8Bhbns+AW7mZtJwM2xGcCm2JD7/////wHAzv2WAsDMyob9/////wHCpeL4/v////8Bv4iY4wW/56Sb+f////8BgLbX1QHB2tTlBP+Sqp36/////wGA9fLJAcGhkpcBgIXC0QPBxYbz//////8B/uGZ+vv/////AQ== 
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Football') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='5.782608695652174','maxColLen'='9','numNulls'='0','numDVs'='23' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Football' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBcXwbS80wPA08+OBMDEmZT6/////wHA7fi1BMLU84kBvs2zyfr/////AcDRiGfCgsLrA4DDgsb9/////wG+ipqK/v////8BwMjJowWC5Jyw//////8Bv5j19Pn/////AYDBosL//////wHA9t7fAb/QhPkDgJCxk/v/////AYKK0Qb+ra2ZAoOA5Pj//////wH9vuKJAcH15av8/////wGA1v/hAg== 
---
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='6.2','maxColLen'='8','numNulls'='0','numDVs'='15' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Basketball' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA8PgZ/tvgSA18jgAoGZwtb+/////wH/zaeIAcDWpIP//////wGC/43R+/////8B/5/ogwGDhYerAfz89K4DgL6l8v7/////AYDwwZj//////wHAlpaV/f////8BgLqSK8GJg9D9/////wHCiZiWAw== 
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='6.466666666666667','maxColLen'='9','numNulls'='0','numDVs'='15' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Basketball' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA8PgbilpAeC7+ssvtnsxfj/////AcCW6PAFwLLw9f7/////AcHwo4v9/////wH/nYz3AoGH1J/9/////wH/7Jv7/f////8BxNrM2wK85uvN/v////8BgJnvHMCdv9b//////wGAw7/oBcLAloD5/////wE= 
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Basketball') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1001','highValue'='1097','numNulls'='0','numDVs'='15' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Basketball' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA8PgYCNxQOA2pic/f////8BxuPc2AP8m7G4A7+Ix+z7/////wG/xNKo/f////8BgLCJswSAxK+U/f////8BgPmo2gHE6pNr/pSPjQK+4MTY+v////8BgIiW4ASEgZT0+/////8B/OCGvQE= 
933,938c927,932
< -- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='6.333333333333333','maxColLen'='8','numNulls'='0','numDVs'='6' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAYGgbePuQfB9sjg+P////8Bw93qogW83dm9/P////8BwYbtqQK/yYTa/v////8B 
< -- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1005','highValue'='1098','numNulls'='0','numDVs'='6' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAYGgeXMkgKAqeDgAYDOgWfAjve+/P////8Bga6jv///////Af/B69cD 
< -- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='7.0','maxColLen'='9','numNulls'='0','numDVs'='6' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAYGwe3GFsGq05QBv6XU8P7/////AYHCq/AGwJ7v2Pr/////AcG15yw= 
---
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Football') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='5.6521739130434785','maxColLen'='8','numNulls'='0','numDVs'='23' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Football' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBcXgqW6lwS/7cK2AsGpjOz7/////wGCm5fW//////8BvbT96wTA5rbf/P////8Bgoq+hwO/6qXp/P////8B/8GzqP7/////AcCqq+L//////wGA5PWu/v////8Bwa37xwa/u+SQ/P////8Bwcrsrf3/////Ab+2k+ADgNahiAHAyNff/v////8BwNftnP7/////AYDDkyfB/tKCA4DswM8Bgoeop/3/////Af3g8/oB 
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Football') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='5.782608695652174','maxColLen'='9','numNulls'='0','numDVs'='23' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Football' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBcXwbS80wPA08+OBMDEmZT6/////wHA7fi1BMLU84kBvs2zyfr/////AcDRiGfCgsLrA4DDgsb9/////wG+ipqK/v////8BwMjJowWC5Jyw//////8Bv5j19Pn/////AYDBosL//////wHA9t7fAb/QhPkDgJCxk/v/////AYKK0Qb+ra2ZAoOA5Pj//////wH9vuKJAcH15av8/////wGA1v/hAg== 
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Football') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1006','highValue'='1100','numNulls'='0','numDVs'='23' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Football' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBcXgaCXhwXA1P+S/f////8Bg93J8wG91quf/P////8Bg8OW9gG9v/KA//////8Bhbns+AW7mZtJwM2xGcCm2JD7/////wHAzv2WAsDMyob9/////wHCpeL4/v////8Bv4iY4wW/56Sb+f////8BgLbX1QHB2tTlBP+Sqp36/////wGA9fLJAcGhkpcBgIXC0QPBxYbz//////8B/uGZ+vv/////AQ== 
943,948c937,942
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='6.642857142857143','maxColLen'='10','numNulls'='0','numDVs'='14' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Cricket' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA4Oh/eB3gH6kIqEBoDm49H7/////wGBzfvyAcDCzlTC2eaU/P////8B/q3H8v3/////Af+bxdoFgJL6jPv/////AYG84W//1I1igqC6pwH+kKX+/v////8Bwr362gQ= 
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1002','highValue'='1099','numNulls'='0','numDVs'='14' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Cricket' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA4Owp+5vgXAgIGC+/////8B/6frowTArIixAcCvrknA3Jmv//////8BgIHmBoGA38n6/////wHAhO5lgs76yAG+9dT6Ar+cjO36/////wGAx7GYBML+3Mj8/////wE= 
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='5.285714285714286','maxColLen'='9','numNulls'='0','numDVs'='14' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Cricket' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA4OwbS80wOB6fyi/f////8B/4eU6QKB+P2a/f////8Bw7z4qQT8+8KdAsKaipb9/////wH/pLfZ//////8Bg/367/3/////Af72zOj//////wG+8a95gvbxuf3/////Ab7LzcwFwNTv8Pz/////AQ== 
---
> -- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='6.333333333333333','maxColLen'='8','numNulls'='0','numDVs'='6' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAYGgbePuQfB9sjg+P////8Bw93qogW83dm9/P////8BwYbtqQK/yYTa/v////8B 
> -- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='7.0','maxColLen'='9','numNulls'='0','numDVs'='6' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAYGwe3GFsGq05QBv6XU8P7/////AYHCq/AGwJ7v2Pr/////AcG15yw= 
> -- ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='__HIVE_DEFAULT_PARTITION__') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1005','highValue'='1098','numNulls'='0','numDVs'='6' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='__HIVE_DEFAULT_PARTITION__' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoAYGgeXMkgKAqeDgAYDOgWfAjve+/P////8Bga6jv///////Af/B69cD 
953,958c947,952
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='6.269230769230769','maxColLen'='9','numNulls'='0','numDVs'='26' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Badminton' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBoaw5bxWsDKgKgE/pbs5vz/////AYDw18AEguubl/3/////AcHBj579/////wH9pu6ABYKuotL+/////wH+x+S0//////8BgMj+2QLAjorG+f////8BwJm1pwLBgbeMBL/BgaD8/////wHAuJDKA4CXh93//////wHBuPXl+v////8B//SC/wWAweCB//////8BwMTBhv7/////AYC+l/cBwI3g1fr/////AYTay4cBvtbOsAL//sj+A8Hd+ZH4/////wE= 
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1004','highValue'='1094','numNulls'='0','numDVs'='26' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Badminton' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBoahd3Cdf32590G/6SLj/3/////AYCykT7Av92e/f////8BwYfGqwP/9oKWAYD4z638/////wGBwrxzv+i89wHA0Niv/f////8BgLL2rgGAstnL+/////8BguuQrAH+1vPaBMG99/D5/////wH//4P6BcDSr2WAnKXH/P////8BgKfB3P3/////AYCTgJEEgqb8+Pv/////AcCCvmq+0O7IAoDBhvb+/////wHA0dlC 
< ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='5.615384615384615','maxColLen'='8','numNulls'='0','numDVs'='25' );
< -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Badminton' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBkZyJCAxAK5lvTQBMDlqKP5/////wHAl7CAA8CbmRzA8faZ/f////8Bgf/q/f//////Ab/LlfIGgNTwqvz/////AcDcuH6Ay4aWAoDC4QXA6L+q/f////8BwPv+XoDLzxPAzvF9waDs/Pz/////AcCQvbL+/////wHAuJKC//////8Bv8CUgAXAzNZPw+WL8vz/////AYD4gCH9tourAcPksWU= 
---
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='6.642857142857143','maxColLen'='10','numNulls'='0','numDVs'='14' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Cricket' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA4Oh/eB3gH6kIqEBoDm49H7/////wGBzfvyAcDCzlTC2eaU/P////8B/q3H8v3/////Af+bxdoFgJL6jPv/////AYG84W//1I1igqC6pwH+kKX+/v////8Bwr362gQ= 
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='5.285714285714286','maxColLen'='9','numNulls'='0','numDVs'='14' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Cricket' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA4OwbS80wOB6fyi/f////8B/4eU6QKB+P2a/f////8Bw7z4qQT8+8KdAsKaipb9/////wH/pLfZ//////8Bg/367/3/////Af72zOj//////wG+8a95gvbxuf3/////Ab7LzcwFwNTv8Pz/////AQ== 
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Cricket') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1002','highValue'='1099','numNulls'='0','numDVs'='14' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Cricket' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoA4Owp+5vgXAgIGC+/////8B/6frowTArIixAcCvrknA3Jmv//////8BgIHmBoGA38n6/////wHAhO5lgs76yAG+9dT6Ar+cjO36/////wGAx7GYBML+3Mj8/////wE= 
962a957,962
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `lastname` SET('avgColLen'='6.269230769230769','maxColLen'='9','numNulls'='0','numDVs'='26' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Badminton' FOR COLUMN `lastname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBoaw5bxWsDKgKgE/pbs5vz/////AYDw18AEguubl/3/////AcHBj579/////wH9pu6ABYKuotL+/////wH+x+S0//////8BgMj+2QLAjorG+f////8BwJm1pwLBgbeMBL/BgaD8/////wHAuJDKA4CXh93//////wHBuPXl+v////8B//SC/wWAweCB//////8BwMTBhv7/////AYC+l/cBwI3g1fr/////AYTay4cBvtbOsAL//sj+A8Hd+ZH4/////wE= 
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `firstname` SET('avgColLen'='5.615384615384615','maxColLen'='8','numNulls'='0','numDVs'='25' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Badminton' FOR COLUMN `firstname` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBkZyJCAxAK5lvTQBMDlqKP5/////wHAl7CAA8CbmRzA8faZ/f////8Bgf/q/f//////Ab/LlfIGgNTwqvz/////AcDcuH6Ay4aWAoDC4QXA6L+q/f////8BwPv+XoDLzxPAzvF9waDs/Pz/////AcCQvbL+/////wHAuJKC//////8Bv8CUgAXAzNZPw+WL8vz/////AYD4gCH9tourAcPksWU= 
> ALTER TABLE `db_bdpbase`.`default_partition_test` PARTITION (`sports`='Badminton') UPDATE STATISTICS FOR COLUMN `id` SET('lowValue'='1004','highValue'='1094','numNulls'='0','numDVs'='26' );
> -- BIT VECTORS PRESENT FOR `db_bdpbase`.`default_partition_test` PARTITION `sports`='Badminton' FOR COLUMN `id` BUT THEY ARE NOT SUPPORTED YET. THE BASE64 VALUE FOR THE BITVECTOR IS SExMoBoahd3Cdf32590G/6SLj/3/////AYCykT7Av92e/f////8BwYfGqwP/9oKWAYD4z638/////wGBwrxzv+i89wHA0Niv/f////8BgLL2rgGAstnL+/////8BguuQrAH+1vPaBMG99/D5/////wH//4P6BcDSr2WAnKXH/P////8BgKfB3P3/////AYCTgJEEgqb8+Pv/////AcCCvmq+0O7IAoDBhvb+/////wHA0dlC

      Attachments

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. HIVE-28640 partition_explain_ddl.q is flaky

          • Major - Major loss of function.
          • Resolved

          Test - A new unit, integration or system test. HIVE-28634 Fix the flaky test partition_explain_ddl.q

          • Major - Major loss of function.
          • Resolved
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-26168 EXPLAIN DDL command output is not deterministic

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          links to

          Web Link GitHub Pull Request #5555

          Activity

            People

              okumin Shohei Okumiya
              okumin Shohei Okumiya
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: