[
https://issues.apache.org/jira/browse/HIVE-28636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17900808#comment-17900808
]
Stamatis Zampetakis commented on HIVE-28636:
--------------------------------------------
This is a known issue and logged under HIVE-26168.
> partition_explain_ddl.q is flaky
> --------------------------------
>
> Key: HIVE-28636
> URL: https://issues.apache.org/jira/browse/HIVE-28636
> Project: Hive
> Issue Type: Improvement
> Security Level: Public(Viewable by anyone)
> Components: Test
> Affects Versions: 4.0.1
> Reporter: Shohei Okumiya
> Assignee: Shohei Okumiya
> Priority: Major
> Labels: pull-request-available
>
> I recently often observe partition_explain_ddl.q failing.
> [https://ci.hive.apache.org/blue/organizations/jenkins/hive-precommit/detail/master/2342/tests]
> {code:java}
> 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
> > {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
