You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Jesús Camacho Rodríguez <jc...@hortonworks.com> on 2016/03/01 14:58:13 UTC

Re: Review Request 43145: HIVE-12994

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/43145/
-----------------------------------------------------------

(Updated March 1, 2016, 1:57 p.m.)


Review request for hive and Ashutosh Chauhan.


Bugs: HIVE-12994
    https://issues.apache.org/jira/browse/HIVE-12994


Repository: hive-git


Description
-------

Implement support for NULLS FIRST/NULLS LAST


Diffs (updated)
-----

  data/files/over4_null PRE-CREATION 
  itests/src/test/resources/testconfiguration.properties 68dbd0c8385019c6d39ea784134941516bae2de4 
  metastore/if/hive_metastore.thrift e8f0a68fd640fddf6f711e1063bf97195a42f83d 
  metastore/scripts/upgrade/derby/034-HIVE-12994.derby.sql PRE-CREATION 
  metastore/scripts/upgrade/derby/hive-schema-2.1.0.derby.sql 42f4eb643d0073a80f4ba505e788abb19f31fb4c 
  metastore/scripts/upgrade/derby/upgrade-2.0.0-to-2.1.0.derby.sql a0bac3ced7024afff964b298da52c1aa4f77bb2e 
  metastore/scripts/upgrade/mssql/019-HIVE-12994.mssql.sql PRE-CREATION 
  metastore/scripts/upgrade/mssql/hive-schema-2.1.0.mssql.sql cf5a6620610461eed9aa1b35cc282ced3c2e877f 
  metastore/scripts/upgrade/mssql/upgrade-2.0.0-to-2.1.0.mssql.sql f25daf26bea2d6c8abb8f40803f2e99307813462 
  metastore/scripts/upgrade/mysql/034-HIVE-12994.mysql.sql PRE-CREATION 
  metastore/scripts/upgrade/mysql/hive-schema-2.1.0.mysql.sql 6fd32095af797c0a0925ab6b9ebce528bc42cb3e 
  metastore/scripts/upgrade/mysql/upgrade-2.0.0-to-2.1.0.mysql.sql e7906368efb490f7c8951a1b8e6a4ec45890d475 
  metastore/scripts/upgrade/oracle/034-HIVE-12994.oracle.sql PRE-CREATION 
  metastore/scripts/upgrade/oracle/hive-schema-2.1.0.oracle.sql 774f6bea712ed2a1def8ab502a3f957c31c87d6d 
  metastore/scripts/upgrade/oracle/upgrade-2.0.0-to-2.1.0.oracle.sql 8368d088c9332d43b62aa0f29802e81e896635ec 
  metastore/scripts/upgrade/postgres/033-HIVE-12994.postgres.sql PRE-CREATION 
  metastore/scripts/upgrade/postgres/hive-schema-2.1.0.postgres.sql 7463a373384bb1b3ff0944566971f65c9faf144d 
  metastore/scripts/upgrade/postgres/upgrade-2.0.0-to-2.1.0.postgres.sql 6172407b18c235a39fc7b85720b3aa04455e9cf6 
  metastore/src/gen/protobuf/gen-java/org/apache/hadoop/hive/metastore/Metastore.java 416ae9d68d99110a2d9c2524e4156a43aac18ea6 
  metastore/src/gen/protobuf/gen-java/org/apache/hadoop/hive/metastore/hbase/HbaseMetastoreProto.java 3b2d7b5db638dc6b35f968279d6b5129977e6f1d 
  metastore/src/gen/thrift/gen-cpp/hive_metastore_types.h 97c07a568a1b8451fa9843552eebdc828d122aaf 
  metastore/src/gen/thrift/gen-cpp/hive_metastore_types.cpp 2695ffa17c5d3fccf8d1e99b7d78846f7b8a8f20 
  metastore/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/metastore/api/Order.java cc0e2dd027d2e909ea4a39a742b33218c3f8411f 
  metastore/src/gen/thrift/gen-php/metastore/Types.php 488a920e2fe1c6d9f9d966ec98f16d82c12b74d5 
  metastore/src/gen/thrift/gen-py/hive_metastore/ttypes.py 10eaf4a01f1ee8130b0f67340635ed462a24ab77 
  metastore/src/gen/thrift/gen-rb/hive_metastore_types.rb 1cf40ae568bc2749ee1775d165da6685351694e3 
  metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java 6da295e246e2259647e32d8ba33c783b28d41550 
  metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java d4852b025503eb0087555fa3ca9a72cbafa6a22e 
  metastore/src/java/org/apache/hadoop/hive/metastore/hbase/HBaseUtils.java d6d01bdbb879397d1b28675f5dfaa345d9b1066f 
  metastore/src/model/org/apache/hadoop/hive/metastore/model/MOrder.java 1fa82a4fde9d315d4955ee5698796f58ce8a0921 
  metastore/src/protobuf/org/apache/hadoop/hive/metastore/hbase/hbase_metastore_proto.proto 466fdf9dc0b0e9d1c58c9b44977896780963e2ac 
  metastore/src/test/org/apache/hadoop/hive/metastore/hbase/TestHBaseStore.java 29d5a64154fdb9ab9586fb919fbeae7106b1a874 
  metastore/src/test/org/apache/hadoop/hive/metastore/hbase/TestHBaseStoreBitVector.java b0d76620b94b25c66b8e08571066660e6a8c8343 
  metastore/src/test/org/apache/hadoop/hive/metastore/hbase/TestSharedStorageDescriptor.java e0d8ce4dede474ad1b752794379342993bf89fa4 
  ql/src/java/org/apache/hadoop/hive/ql/exec/DDLTask.java 6fca9f7ec86574a6053af3672c551c6a63aa4870 
  ql/src/java/org/apache/hadoop/hive/ql/exec/MapJoinOperator.java 4d2447b683c529479b523878a4da0eb4e5202d55 
  ql/src/java/org/apache/hadoop/hive/ql/exec/MoveTask.java 27e7b43ca92cf081e34415002c2b2f6ecc7a18d9 
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/HybridHashTableContainer.java fdc1dfffd977ef3a71fcf56da19a3b2b91538921 
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinBytesTableContainer.java 5c2ff9276b575f93a3df0fd2da378b85f7074a22 
  ql/src/java/org/apache/hadoop/hive/ql/exec/persistence/MapJoinKey.java cfb9abc380880da2cefe6968fd81dc3b974ec1ed 
  ql/src/java/org/apache/hadoop/hive/ql/exec/tez/DynamicPartitionPruner.java 1510fdd555223514786dfd9137103c1339c4fc2a 
  ql/src/java/org/apache/hadoop/hive/ql/exec/vector/reducesink/VectorReduceSinkCommonOperator.java 7bdd11a1e46ac41f16fe26abebe8371fd1e41275 
  ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java aa1c9253df13e7c07ad7d9f2c1ec4c577edbce5c 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/AbstractSMBJoinProc.java b57dc77c23767f46c27fad0c5761bd2a79489f18 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/BucketingSortingReduceSinkOptimizer.java d5f3057a5c070a22786d3151132dc59d38a0ebb4 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/ReduceSinkMapJoinProc.java c38c6d7f7b8503fed45ad9034b45064bbe3100dd 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedDynPartitionOptimizer.java ad120918dd289561dcdd6f59a8f8d84e6835997d 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java 02db680c51f7767cd1369bff3b202eaa2367c481 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/rules/HiveRelFieldTrimmer.java 997b82c3d9f499b5d8329ff87c521a31dfee5615 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ASTConverter.java 3f2267dc7926243b82d69cc65400b5b536081e53 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/ExprNodeConverter.java 739faa9110f1fb89405957ee9dedf879ee60fdc1 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/HiveOpConverter.java b841315f823f956015af820a0e2b04f5b8f60b81 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/correlation/ReduceSinkDeDuplication.java 638b91ec9f6a8cdc7af66d96955c40dca879776c 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/BucketingSortingCtx.java 296fecbb1ee8989cd9d1c5b3ba3ab858cec61ddc 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/physical/BucketingSortingOpProcFactory.java aa412000fb989b22dc06e0307ba88d92cd3170fe 
  ql/src/java/org/apache/hadoop/hive/ql/optimizer/spark/SparkReduceSinkMapJoinProc.java f48fac138033b7cd128c34c3046644c4add838d3 
  ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java 28c8fdb924e3ca7598ccb34b40dbf67de11379f0 
  ql/src/java/org/apache/hadoop/hive/ql/parse/CalcitePlanner.java d056c5d6d809ca0a1095776ee7e981e9dc48b882 
  ql/src/java/org/apache/hadoop/hive/ql/parse/HiveLexer.g 3f92d1657e4358ce3ea58656447812e00d5b2ced 
  ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g 9cca100dc706b3b3950b636f625405f089691f3e 
  ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g 61bd10c9336a3e294675d055eab85ad9f7ff9122 
  ql/src/java/org/apache/hadoop/hive/ql/parse/PTFInvocationSpec.java a8980ebd8e0cad32f0e087f15d19cd6d015490da 
  ql/src/java/org/apache/hadoop/hive/ql/parse/PTFTranslator.java 2370ec06cebdb49da4ef3d56d11d7fef8025be6b 
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 0db1dab2cc0c90b4b72f053627368578dfc783dd 
  ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java 598520c133f56ac515a90c4800dce13b16a0d71e 
  ql/src/java/org/apache/hadoop/hive/ql/plan/PlanUtils.java 990a10c60c1728133f03ce0fdd08cff94c52496d 
  ql/src/java/org/apache/hadoop/hive/ql/plan/ReduceSinkDesc.java 41d9ffe5ca13863e35d106f41e35a46af0d0ecf1 
  ql/src/java/org/apache/hadoop/hive/ql/plan/ptf/OrderExpressionDef.java e367d138335a4484b0704b5333648896a86d7551 
  ql/src/java/org/apache/hadoop/hive/ql/plan/ptf/PartitionedTableFunctionDef.java 2a8b1c01da7b99f033c3b53db7c5942777b8ef7d 
  ql/src/java/org/apache/hadoop/hive/ql/udf/ptf/WindowingTableFunction.java 2c076f509d5597c48c491f72831fb2c5ae3e1c2e 
  ql/src/test/org/apache/hadoop/hive/ql/txn/compactor/TestWorker.java cf7eb703a158dd5d1236641eb1f9f004a04d5e7b 
  ql/src/test/queries/clientpositive/keyword_3.q PRE-CREATION 
  ql/src/test/queries/clientpositive/order_null.q PRE-CREATION 
  ql/src/test/queries/clientpositive/windowing_order_null.q PRE-CREATION 
  ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table2_h23.q.out 3b71598e6f5c0623edc19c82d31c6fbe67c1e5c0 
  ql/src/test/results/clientpositive/alter_numbuckets_partitioned_table_h23.q.out cab3de4d0229d82134e9ce44899f1b2703790baa 
  ql/src/test/results/clientpositive/alter_partition_clusterby_sortby.q.out 184d2e42d5b1acedf3ea45015811b12f82fe9ec5 
  ql/src/test/results/clientpositive/alter_partition_coltype.q.out 20ef536f9cca76736e44d464597652fe79f56295 
  ql/src/test/results/clientpositive/alter_table_not_sorted.q.out 6e1ec59b143897a50603f3d039829915fa57ad20 
  ql/src/test/results/clientpositive/authorization_index.q.out adc02ad5c19a3a153546db5d61b6351fcb00cbb1 
  ql/src/test/results/clientpositive/auto_join_reordering_values.q.out 22c8300f9236e9a196203600ad030f10cac82f64 
  ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out 3a9194774d6e9b3db029f246fa9cc9d0ff936399 
  ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out efdd94ab4cd479cb6f0435f8fd89552dab030464 
  ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out 33e2deff0a35b4b979b54cd2e3e63e65f46bb942 
  ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out fbbe9c4139e05f0fdde8beddf810dfa980e2ae92 
  ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out 52cea3622b6fd45f035aa5984424af4b0d119aa8 
  ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out c50865eb0165a4c94a1e24bc3493ea224a016e07 
  ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out 2e63698d0b06cc9f6b7d0a210a26acca8fc53ce3 
  ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out 2675eca9416deba4066d5103c154c61acbc77507 
  ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out 9de9d73581f8e5ae2896d302fc476d2eebeed644 
  ql/src/test/results/clientpositive/bucket1.q.out 9e03236223444d5374365ee57ffdf8c85ba9730c 
  ql/src/test/results/clientpositive/bucket2.q.out 374b0e1212e68e59cab1382d60afdae51a35391b 
  ql/src/test/results/clientpositive/bucket3.q.out 542bbb734d80195b95f442b4aae57dd26852a552 
  ql/src/test/results/clientpositive/bucket4.q.out 5c7126b8709f22674b8b39dda575b75e91c02dab 
  ql/src/test/results/clientpositive/bucket5.q.out 46e3d54c4b8898eeb864b2c2f6d223263450f883 
  ql/src/test/results/clientpositive/bucket_many.q.out ecd5e29264558be5c2a15dbe1d131f76f1fbec32 
  ql/src/test/results/clientpositive/bucket_map_join_1.q.out 5f1e9b9400d88203beb326d702e2612fd17b6686 
  ql/src/test/results/clientpositive/bucket_map_join_2.q.out 07958ce4ebf79aaa3b955afb8900107fa48fb5d1 
  ql/src/test/results/clientpositive/bucketcontext_1.q.out 8b2ebb09b1ee987d503f5c6a77694c2bf6f2cd3b 
  ql/src/test/results/clientpositive/bucketcontext_2.q.out 9168ee1a64cb6d6364f814b015a8b5541b95ec80 
  ql/src/test/results/clientpositive/bucketcontext_3.q.out e9e340626df8830dbefc72bd1e75474ec1224439 
  ql/src/test/results/clientpositive/bucketcontext_4.q.out f95e0ae1c415166b03698244fe0793713ce27df7 
  ql/src/test/results/clientpositive/bucketcontext_5.q.out 031ce7841f132e3117463df4ba83e8b34458e345 
  ql/src/test/results/clientpositive/bucketcontext_6.q.out bada9ce9b4d823b4f01fab76a9ee9c007dc7a041 
  ql/src/test/results/clientpositive/bucketcontext_7.q.out f87ce5fe07ed46ea0efa80bab395a188a3a18454 
  ql/src/test/results/clientpositive/bucketcontext_8.q.out daa67674cf981739841f60cf129c9253f54f7c4a 
  ql/src/test/results/clientpositive/bucketmapjoin10.q.out b09ccbea765add543409f5b7262fb2ec77b7b627 
  ql/src/test/results/clientpositive/bucketmapjoin11.q.out 1387aa5a58a95858b4b6e739a895060ace4eb4fc 
  ql/src/test/results/clientpositive/bucketmapjoin12.q.out c5627fa5a4069247bc423a821e393c3dc00fd47a 
  ql/src/test/results/clientpositive/bucketmapjoin13.q.out b07ad4f7044307b50efd1adf9d548d306628034d 
  ql/src/test/results/clientpositive/bucketmapjoin7.q.out 1b9eb47545e2cb99db732fef8c1d26f1f6e081d2 
  ql/src/test/results/clientpositive/bucketmapjoin8.q.out 48c7e39c2e76b808b0c03a60d190c7caf9d07fe7 
  ql/src/test/results/clientpositive/bucketmapjoin9.q.out 8518b17b2ed301ae0c949ab65471acb6a5d4fe5c 
  ql/src/test/results/clientpositive/cbo_rp_outer_join_ppr.q.java1.7.out 7074ccb634016a8c8b7a664d8fb4f0533458c67a 
  ql/src/test/results/clientpositive/columnstats_partlvl.q.out 655847e58eeaeaf1ff90581c9cbe0abb777544bb 
  ql/src/test/results/clientpositive/columnstats_tbllvl.q.out cb51f5bc9a69c7280b6e222dbd7d81c0178f0aa6 
  ql/src/test/results/clientpositive/combine2.q.out 2469f09b148d92333cb6a1fc6c2501f7e629f762 
  ql/src/test/results/clientpositive/constantPropagateForSubQuery.q.out 57d8dca9717ace563bafa35e2ca1bb3e063d105a 
  ql/src/test/results/clientpositive/correlationoptimizer12.q.out 615e47a4b30b530ce81ebb3b607fa80c6c4d3467 
  ql/src/test/results/clientpositive/ctas.q.out bf6db75852ba03a34da4dd022049b63577620821 
  ql/src/test/results/clientpositive/ctas_colname.q.out 435b9e0a057481b7518d5ef13ad2b0dbc12c2def 
  ql/src/test/results/clientpositive/disable_merge_for_bucketing.q.out fe55531fe9d74d54002b71b4c57c6985c3f7cf5d 
  ql/src/test/results/clientpositive/display_colstats_tbllvl.q.out 7154ac7c08c87938cf73ddc8981ef0c76dc261f0 
  ql/src/test/results/clientpositive/dynpart_sort_opt_vectorization.q.out d03bfe422743d9a5a6b85f9a6198e1e27024f129 
  ql/src/test/results/clientpositive/dynpart_sort_optimization.q.out 857d60904cdadca8e57deab210a667ae34f5e869 
  ql/src/test/results/clientpositive/encrypted/encryption_join_unencrypted_tbl.q.out d173e0131a98a2eb922d48a82ec6737b4043a6ef 
  ql/src/test/results/clientpositive/explain_logical.q.out 59bd9e918d62856eda02b28062c3c45d62cf68a5 
  ql/src/test/results/clientpositive/filter_join_breaktask.q.out 8ccd129120e9665df8859c1061110bbfb5a0e55a 
  ql/src/test/results/clientpositive/fouter_join_ppr.q.out d7b83a1bf2841e88ec5c06da9c2258ded7b28a40 
  ql/src/test/results/clientpositive/groupby_grouping_window.q.out 03248364a6a60422ffca8a31a7fff4b986b28006 
  ql/src/test/results/clientpositive/groupby_map_ppr.q.out 9f779d0224ccfa8a1c5c534996cac273fc312a5c 
  ql/src/test/results/clientpositive/groupby_map_ppr_multi_distinct.q.out 6d78acaf7f5d8c51d2ae560ebf8801f584732d8c 
  ql/src/test/results/clientpositive/groupby_ppr.q.out 035f3154430a397f16eff88fb15081f6ae93339c 
  ql/src/test/results/clientpositive/groupby_ppr_multi_distinct.q.out a7aba12410696642795fe7edabd5a51ca0642ee7 
  ql/src/test/results/clientpositive/groupby_resolution.q.out 83fc57654e21c1af06e53ab6cc1e0823bf925832 
  ql/src/test/results/clientpositive/groupby_sort_1_23.q.out 07c95535f298799247359bab51f473b730e6bf5a 
  ql/src/test/results/clientpositive/groupby_sort_6.q.out 9738c15cb88632522faac6b3a91f86b9a60bebb9 
  ql/src/test/results/clientpositive/groupby_sort_skew_1_23.q.out fdc114c7ab29f06edf109f96725818b14a68428e 
  ql/src/test/results/clientpositive/index_skewtable.q.out 972789dc36c795b2919457e8b08215d7a8487655 
  ql/src/test/results/clientpositive/infer_bucket_sort.q.out 182dd3ad8ac09d04ab19c5030ed0eaffeda5fbfd 
  ql/src/test/results/clientpositive/infer_bucket_sort_bucketed_table.q.out 33d795b795569b1435ebc0812f06c6d9f656f931 
  ql/src/test/results/clientpositive/infer_bucket_sort_convert_join.q.out 2f7e53813dc364a073d78a31d397d02b00e8bc85 
  ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out 7e3b48f75e16962216d887899299da91e8a0ea07 
  ql/src/test/results/clientpositive/infer_bucket_sort_grouping_operators.q.out ebfce60c5920c6565fc1a6e2108016a548a52f12 
  ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out 4ca65173cc84f83af8956e515a81c3c5b5c29d09 
  ql/src/test/results/clientpositive/infer_bucket_sort_merge.q.out 53407c5b97214d23b7b1e1bb753face87d983ffa 
  ql/src/test/results/clientpositive/infer_bucket_sort_multi_insert.q.out d4c22f4da6d9b332382be5f75919140c49af4297 
  ql/src/test/results/clientpositive/infer_bucket_sort_reducers_power_two.q.out 1e4db29110bb32555d76c613f8216ef9bbfa62b9 
  ql/src/test/results/clientpositive/input23.q.out 773eac3a3a49e56fd8b75f505245a78b82ddf749 
  ql/src/test/results/clientpositive/input_part7.q.out a0cf9af15b675029e57b0cffeb93150c9c353ede 
  ql/src/test/results/clientpositive/join17.q.out 0f1286e7114060a891a6fdb774048c362a4ea7fd 
  ql/src/test/results/clientpositive/join35.q.out 663642c7d1c00a47993c497ac76d6f036221f06b 
  ql/src/test/results/clientpositive/join9.q.out 14ae66aa544903987a0bf428cf1548c96b81d7ad 
  ql/src/test/results/clientpositive/join_filters_overlap.q.out d681a20c089969242888b95c796e6e84999b4ee1 
  ql/src/test/results/clientpositive/keyword_3.q.out PRE-CREATION 
  ql/src/test/results/clientpositive/lineage2.q.out 66929dd1cd058e02d9103b5f59798c31c31913e9 
  ql/src/test/results/clientpositive/lineage3.q.out 0e9c2a99f231c2b4019af0f4bc8c964183b7f4e9 
  ql/src/test/results/clientpositive/list_bucket_query_multiskew_3.q.out cc1379a7f6f577040d1812dc13a899ff8463a47d 
  ql/src/test/results/clientpositive/list_bucket_query_oneskew_2.q.out 804ef9d76f83ef7726d4c6e045a9172113349fd1 
  ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out 1a7e831765358884e8f96af942c3b54eb8516715 
  ql/src/test/results/clientpositive/louter_join_ppr.q.out c170031de9472de9beac6f5c63894c3ffef61d3a 
  ql/src/test/results/clientpositive/merge3.q.out 296722c57e836b32f27c3799c8ef3928550aee10 
  ql/src/test/results/clientpositive/metadataonly1.q.out 772d94845a1020c65eb3251f404c9c9e59a05bc5 
  ql/src/test/results/clientpositive/optimize_nullscan.q.out a814934dc9319e08f4adbff8c93cbb1985b7318b 
  ql/src/test/results/clientpositive/orc_analyze.q.out 87855fa9861ba443eea404f320fb306e09e7cfc0 
  ql/src/test/results/clientpositive/order_null.q.out PRE-CREATION 
  ql/src/test/results/clientpositive/outer_join_ppr.q.java1.7.out e54ef21c8e3e07a9a457c3506143ee8ff6a3fcbc 
  ql/src/test/results/clientpositive/partition_coltype_literals.q.out bc159eb064cafc8bda630ee97a3a6fee49beee9a 
  ql/src/test/results/clientpositive/pcr.q.out 89c5c22ebe705d5e31253f14817d98fe35253709 
  ql/src/test/results/clientpositive/pcs.q.out 51a21dd0b210eee649ce261824fb8a08733afe96 
  ql/src/test/results/clientpositive/perf/query12.q.out f326a926e8a14e3d94788b457ab1ced66321289d 
  ql/src/test/results/clientpositive/perf/query20.q.out 74d286a68ef49f18ecc0c11cead3e89bc63560ab 
  ql/src/test/results/clientpositive/perf/query51.q.out f568ead3120e157bce37837a241e225c0f83cd6f 
  ql/src/test/results/clientpositive/perf/query67.q.out f158829f7446c0698a258f4b0bfcc928ad92d6c6 
  ql/src/test/results/clientpositive/perf/query70.q.out b921346daf8bed55e23aafc4b322780686d456a7 
  ql/src/test/results/clientpositive/perf/query89.q.out 71db5d45816e435267f97db2c12244b9ae48459c 
  ql/src/test/results/clientpositive/perf/query98.q.out f51744dacf0dbc70e26ecdd15f3d0b18687c671f 
  ql/src/test/results/clientpositive/pointlookup2.q.out 5192e1a76e1e4710143b72f3d1dda00f48b51ec6 
  ql/src/test/results/clientpositive/pointlookup3.q.out 791be617db25eed1d6df3ca6dce5e584ac7bdf3e 
  ql/src/test/results/clientpositive/pointlookup4.q.out 948ea7ab16298837180631b390ab319831e2e53e 
  ql/src/test/results/clientpositive/ppd_join_filter.q.out 8b640e1c45cabd7e035bfbe33676af4401814223 
  ql/src/test/results/clientpositive/ppd_union_view.q.out 210cece10ad56932d9a8b4417b5fbe763e5579d0 
  ql/src/test/results/clientpositive/ppd_vc.q.out 69a9bc66b7002f0e7d695d44c907ce796253bdc6 
  ql/src/test/results/clientpositive/ppd_windowing1.q.out 071b73022093e812917a1d24f5d38a069eebc724 
  ql/src/test/results/clientpositive/ptf.q.out c8d37dfacf5716b8b0b5ad86954dd26dc94f8b9b 
  ql/src/test/results/clientpositive/ptf_matchpath.q.out 042982fbd7a7dcf80846bfcaf46a28d76d0f90a1 
  ql/src/test/results/clientpositive/ptf_streaming.q.out 35c6d0448a6cdcb62a942c5880ac3c4298b2d58b 
  ql/src/test/results/clientpositive/ptfgroupbyjoin.q.out cddee5613ab7b606ac22c007d4e7bc8214a6f3ff 
  ql/src/test/results/clientpositive/push_or.q.out 83680e1645f7b82c0eb036de9eb726d99071e9bc 
  ql/src/test/results/clientpositive/quotedid_basic.q.out 052e4d063e7683cbd074254b163a70f1237977c6 
  ql/src/test/results/clientpositive/reduce_deduplicate.q.out e82f31a7171fa249de444d00ad3fbfee83be35aa 
  ql/src/test/results/clientpositive/regexp_extract.q.out d2a0099c97d5f14d786df09db76a5aa7a43aa31a 
  ql/src/test/results/clientpositive/router_join_ppr.q.out c9432c7718caab19f47ed4aaecc8c7380eb9e2c9 
  ql/src/test/results/clientpositive/sample10.q.out 8ccb5779dcf1237741b32834880887adadb5b68e 
  ql/src/test/results/clientpositive/sample6.q.out 38e21debf40c201578c2f242583f03c311bc3624 
  ql/src/test/results/clientpositive/sample8.q.out 63eeb35ba8771c5c049ee0abf19626bfea956bc9 
  ql/src/test/results/clientpositive/semijoin2.q.out 3fe0a892cdc5ceaf5ef834ddb649c8ed3675c1ee 
  ql/src/test/results/clientpositive/semijoin4.q.out 4dca08b0efbac1a71b7ba93a415cab6e0f270ca6 
  ql/src/test/results/clientpositive/show_create_table_alter.q.out 32819ea34ee15dc23dfaca0ec4fde504a397b7de 
  ql/src/test/results/clientpositive/smb_mapjoin_11.q.out a05dd6f1d5036b1ddc6ea095d4e9c09c098e7d1e 
  ql/src/test/results/clientpositive/smb_mapjoin_13.q.out fc12e35d237eb2b2c866b28cde234bf1264d6ae6 
  ql/src/test/results/clientpositive/smb_mapjoin_15.q.out 6f6d80bc21b85d9071bb9c301bf7ab93647c06e5 
  ql/src/test/results/clientpositive/sort_merge_join_desc_5.q.out 48767bddf7a2500ff3f26f0eb60b21143fe488c3 
  ql/src/test/results/clientpositive/sort_merge_join_desc_6.q.out dd2f849dacbdf9dea140030c6d546a4a3f82039f 
  ql/src/test/results/clientpositive/sort_merge_join_desc_7.q.out 76efef507aa1112ad55cb2ae648625b2de446621 
  ql/src/test/results/clientpositive/spark/auto_join_reordering_values.q.out 73f62e98976b989b6965974437ae0a449fa045d8 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_1.q.out f580ac4ff9c296aa8e40a40287f7e422ff116b8a 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_12.q.out 166b8377eb65d60b9e7bbb23e9b509699966637b 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_3.q.out de0b4cd4abf1dae9cb55b06e5aa3cb13f422a824 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_4.q.out 8707e8202127efee41858504c3acfbeb9647a465 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_5.q.out 91784417d0d8f54c9805427392a280aece504c8a 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_7.q.out 91dc16e345d5b02819761ae0ed6dce9506874bbf 
  ql/src/test/results/clientpositive/spark/auto_sortmerge_join_8.q.out e3ae9a403711ea6590c4ff6c9557f6223fca61ac 
  ql/src/test/results/clientpositive/spark/bucket2.q.out 8d0795f2693c020924b6c6c82f27e808fe7c9564 
  ql/src/test/results/clientpositive/spark/bucket3.q.out 6cb6ef691737f40cbe3d738a3338da54cf3149da 
  ql/src/test/results/clientpositive/spark/bucket4.q.out ef101cd79e3fe778cb2db0ede5d81d8e27942377 
  ql/src/test/results/clientpositive/spark/bucket5.q.out 547b0cdad7a9c3b3e0bfed0b847c372f1da67430 
  ql/src/test/results/clientpositive/spark/bucket_map_join_1.q.out d6b6eca43cbb6bf9aad11fca95c79d699a75694f 
  ql/src/test/results/clientpositive/spark/bucket_map_join_2.q.out d4aee47077e04fcb0d02de0576d3b4ccd4ae4ca4 
  ql/src/test/results/clientpositive/spark/bucketmapjoin10.q.out 73fe1cda1444fce89287ad2297d3a0d1d95b7dac 
  ql/src/test/results/clientpositive/spark/bucketmapjoin11.q.out 97c7f8fcacc2a27fdeddcb4f5aae136a415c96cb 
  ql/src/test/results/clientpositive/spark/bucketmapjoin12.q.out d15f2512f8be89e814798568cd2d3522285c1e3e 
  ql/src/test/results/clientpositive/spark/bucketmapjoin13.q.out d9ac9c290525ae9ff7abd52551ce71e400ed3900 
  ql/src/test/results/clientpositive/spark/bucketmapjoin7.q.out d754df29b13068bfe82016ef223e84af8d491010 
  ql/src/test/results/clientpositive/spark/bucketmapjoin8.q.out f29d54c3b01bf5342bf671001e5a2da468e61baa 
  ql/src/test/results/clientpositive/spark/bucketmapjoin9.q.out 9d0c95ff2e5e0c78345deeeacb122117590c9223 
  ql/src/test/results/clientpositive/spark/ctas.q.out 175344cc28c131080ec0a6bd0247a8e84e765dfa 
  ql/src/test/results/clientpositive/spark/disable_merge_for_bucketing.q.out 0b92309aeb1d4b652bb97d7af3462a4a9840b8d0 
  ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out 425be20a865d3987eb8ca9a4f47925c97c7eb9bf 
  ql/src/test/results/clientpositive/spark/groupby_map_ppr.q.out d05105719cc6e3ecb033fefb7851a46420a9086f 
  ql/src/test/results/clientpositive/spark/groupby_map_ppr_multi_distinct.q.out df6a8897cb22368d246099ba153cf5e4a4e9d1e3 
  ql/src/test/results/clientpositive/spark/groupby_ppr.q.out fbeb0713a53c4642389e13bb19996c2094d62c79 
  ql/src/test/results/clientpositive/spark/groupby_ppr_multi_distinct.q.out c774f8751c604bd53c84e464bac0c5b4aa4af562 
  ql/src/test/results/clientpositive/spark/groupby_resolution.q.out bea647961004b4d2bad1f211ab05e83bff1d59cc 
  ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out 36a7d7520914a86cef8a214d73bdbd721f1bfa34 
  ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out 06c0323aa4cc80094c1e264859a2d7e5378bfb54 
  ql/src/test/results/clientpositive/spark/infer_bucket_sort_bucketed_table.q.out 33d795b795569b1435ebc0812f06c6d9f656f931 
  ql/src/test/results/clientpositive/spark/join17.q.out 0b17aa39d6364f84fda4177804565d9f3d05978f 
  ql/src/test/results/clientpositive/spark/join34.q.out a4cbc79b4755c0ab74177e7804bb4e16204345c2 
  ql/src/test/results/clientpositive/spark/join35.q.out 598143f021681214e5da79f87c76dd676281f6a1 
  ql/src/test/results/clientpositive/spark/join9.q.out 81f359e76c891e07672d3b207ff114e3155d64bc 
  ql/src/test/results/clientpositive/spark/join_filters_overlap.q.out 374f2cef27d2c49ac0f3e3ded612aaeb8170a290 
  ql/src/test/results/clientpositive/spark/louter_join_ppr.q.out d789eb9ef9ac7901c126636b3cbf6d702a8b4ed9 
  ql/src/test/results/clientpositive/spark/optimize_nullscan.q.out c71a22f432508c8769e3aec12c4145b0bcfd9a7e 
  ql/src/test/results/clientpositive/spark/outer_join_ppr.q.java1.7.out 4edb4a9aeacb719fab4b5b4c8cf86453abb90157 
  ql/src/test/results/clientpositive/spark/pcr.q.out 681251d5577f5506ceaf4f30f183569f10f7e3ac 
  ql/src/test/results/clientpositive/spark/ppd_join_filter.q.out e87ded795db066a79ac523778c2b2f4bc37af028 
  ql/src/test/results/clientpositive/spark/ptf.q.out a826bc3ff0d9ba6b48c88206d4ec5fd2a6605e38 
  ql/src/test/results/clientpositive/spark/ptf_matchpath.q.out fc35091b1b30fae0996d7e0b484c3a8571af8385 
  ql/src/test/results/clientpositive/spark/ptf_streaming.q.out ecaa779a011b608c15bf270746263b5b4af0ce1e 
  ql/src/test/results/clientpositive/spark/reduce_deduplicate.q.out b38a96bcbc7440584c29825d3b9b4ebf70ad7dfc 
  ql/src/test/results/clientpositive/spark/router_join_ppr.q.out 7d32a79d715ebf01ed73f3a38a606ba482d0b1a9 
  ql/src/test/results/clientpositive/spark/sample10.q.out 372545ad06f126abaf237b2678ade453ecf7ee4b 
  ql/src/test/results/clientpositive/spark/sample6.q.out 70537dee8814055140c90a5e547d819fba3ea308 
  ql/src/test/results/clientpositive/spark/sample8.q.out 48293e18cd8c8c87f292aa9996c5e4d75b7bca34 
  ql/src/test/results/clientpositive/spark/smb_mapjoin_11.q.out 2ff157ef5e01f35e3ca665ccf521bfe2cefcbdba 
  ql/src/test/results/clientpositive/spark/smb_mapjoin_12.q.out f6c92ef288a9e12c4398f8cc9161c984c688878d 
  ql/src/test/results/clientpositive/spark/smb_mapjoin_13.q.out 41379b63dbe5b8300c8b9105c7479a06992656dd 
  ql/src/test/results/clientpositive/spark/smb_mapjoin_15.q.out 3779fb6574dcca34029f63c2be2e5eb632d322de 
  ql/src/test/results/clientpositive/spark/subquery_in.q.out 62be68204cfac477afc131244a7bfbffb9e99131 
  ql/src/test/results/clientpositive/spark/transform_ppr1.q.out 2f88651e9137e3e7afa64c83dbe8e02fd9721965 
  ql/src/test/results/clientpositive/spark/union24.q.out 31f25b54bcfb264ea552f7bc535b82b5940e5c34 
  ql/src/test/results/clientpositive/spark/union_ppr.q.out e95128373172707ef68ae67fca23c12f90797848 
  ql/src/test/results/clientpositive/spark/union_remove_6_subq.q.out 22b0fea7d72e6aaa80e9e112f0d9fd905afc0919 
  ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out 426527f2fb3b65a7a92accfa89c3fd126c650503 
  ql/src/test/results/clientpositive/subquery_in.q.out e59e1920b886e30dc3eb85cb3d94cca891a89d7c 
  ql/src/test/results/clientpositive/subquery_in_having.q.out d27304f438d35162436ae9661d3e15604e7c5218 
  ql/src/test/results/clientpositive/subquery_notin.q.out f1fcebac0ddb15c17b619ef831a082b024f6c8ee 
  ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out 7f70e399ba40b23e7d539680844d864ccc8f878c 
  ql/src/test/results/clientpositive/temp_table_display_colstats_tbllvl.q.out 0762dcef54a40e4fcbd199e76ed439c837a06d4f 
  ql/src/test/results/clientpositive/tez/auto_sortmerge_join_1.q.out c175580d8770ca5c65ce2ed8ee5750bebc4632df 
  ql/src/test/results/clientpositive/tez/auto_sortmerge_join_11.q.out e4692b51781a5ca8eb316ad23994b5266cc69702 
  ql/src/test/results/clientpositive/tez/auto_sortmerge_join_12.q.out a219e59c95506a7160374ff6e1b26a794c638d13 
  ql/src/test/results/clientpositive/tez/auto_sortmerge_join_2.q.out 78fe2e99df597ea114485ae2061f80affd1bafbf 
  ql/src/test/results/clientpositive/tez/auto_sortmerge_join_3.q.out c67c816841a45adfaf8c9536cd225b09b902cdff 
  ql/src/test/results/clientpositive/tez/auto_sortmerge_join_4.q.out 33cb0ae58d6244bf8ee2ed4164cba572e2f79acb 
  ql/src/test/results/clientpositive/tez/auto_sortmerge_join_5.q.out 7bb05f109113ca80aeee3b40109bb54a4d5c5135 
  ql/src/test/results/clientpositive/tez/auto_sortmerge_join_7.q.out dbb6ecb091e9f46b4483fd6cd65cd3083ad14415 
  ql/src/test/results/clientpositive/tez/auto_sortmerge_join_8.q.out 89034ded3b25fa59f42456c8ae2bb1a6978086a4 
  ql/src/test/results/clientpositive/tez/bucket2.q.out 952fe13b03bddd4b7584b9a61bbfae29e2328540 
  ql/src/test/results/clientpositive/tez/bucket3.q.out b63ebbd07522da8ed00a959823d6c48a8c2929bd 
  ql/src/test/results/clientpositive/tez/bucket4.q.out 5f4c2e9b206d660179ab2b1717777afcafbed1ef 
  ql/src/test/results/clientpositive/tez/ctas.q.out 74e8b98bacb3121fe227f29e04c0b855deaaa30a 
  ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out 7b59dea53619435a9bb1060e459583acd7f7caf9 
  ql/src/test/results/clientpositive/tez/dynpart_sort_opt_vectorization.q.out a90e3f63b4646cf0ade9785a501ebd1a6b2a3406 
  ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out 5292106074ed1eb222375f68df3e77d94d2e81fb 
  ql/src/test/results/clientpositive/tez/explainuser_1.q.out 9942b8c6934f63198276f9063ac393c70cf755a6 
  ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out 83c4734d6c326f078a85517f5e2fa782f92d68a2 
  ql/src/test/results/clientpositive/tez/mapjoin_mapjoin.q.out efe4ebfe23b71dbd5cf6e6ae6d98c3b8cf71dc7d 
  ql/src/test/results/clientpositive/tez/metadataonly1.q.out 3b9b51da04e0faf9621568a2eeabf33e6481cee6 
  ql/src/test/results/clientpositive/tez/optimize_nullscan.q.out 4b04177adbfb04aeb821931bb207bd68627fac82 
  ql/src/test/results/clientpositive/tez/orc_analyze.q.out 87855fa9861ba443eea404f320fb306e09e7cfc0 
  ql/src/test/results/clientpositive/tez/order_null.q.out PRE-CREATION 
  ql/src/test/results/clientpositive/tez/ptf.q.out 8685bdbb836b9aa5ba9c6850832d7fe501025940 
  ql/src/test/results/clientpositive/tez/ptf_matchpath.q.out af886348ac09e9a3dfbf0af2df677107cb256ebf 
  ql/src/test/results/clientpositive/tez/ptf_streaming.q.out 57f33347603895feac8fe03df38896d22be54f4a 
  ql/src/test/results/clientpositive/tez/subquery_in.q.out 517e3220bda6c552e4fa8c120d40b0b750f0652d 
  ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out 3d64a9f1d99a150ed486c536a741e0f88d9fe400 
  ql/src/test/results/clientpositive/tez/transform_ppr1.q.out 3ca5cf20f2a9dff2523bec43044e5516ff1a8e47 
  ql/src/test/results/clientpositive/tez/transform_ppr2.q.out ebb8a18d61100fb7117bf32727b87a61979a6d3c 
  ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out de3cf5bcd7f09f40085cc6362dae3d4aab6767e6 
  ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out 431e334625d84619bb134b3c6b0ddbb4b65e41ce 
  ql/src/test/results/clientpositive/tez/windowing_gby.q.out 2af3e580f09e82e20de479c44affe8a5dddb7aaa 
  ql/src/test/results/clientpositive/transform_ppr1.q.out a7032cb489acc397ba487acf6eea561a72ea4ae3 
  ql/src/test/results/clientpositive/transform_ppr2.q.out 156fcc961ddf4810f732866cdfaec157d02edcc6 
  ql/src/test/results/clientpositive/udf_explode.q.out b12c280f086d107a193e6c781e4dcd329854644e 
  ql/src/test/results/clientpositive/udtf_explode.q.out c3692256f65fda224d8e9f24924d802b93ab6818 
  ql/src/test/results/clientpositive/union22.q.out 83ec81b806df89b961ee3b33fa40396ed335d1c9 
  ql/src/test/results/clientpositive/union24.q.out 246581ca802a830719f1a35a108f87c668f2b77c 
  ql/src/test/results/clientpositive/unionDistinct_1.q.out a0b8a6e63b68bcf1f8517fb4af32fb8685fe522d 
  ql/src/test/results/clientpositive/union_ppr.q.out b1a3bcf9ba971df9ab8f143f3f93997bb2281499 
  ql/src/test/results/clientpositive/union_remove_6_subq.q.out fe586863eec1fb76050b03d73fb13d70f5971085 
  ql/src/test/results/clientpositive/vectorized_ptf.q.out 479953c619a55522ab2774041fe7f89cf05c2fe0 
  ql/src/test/results/clientpositive/windowing_order_null.q.out PRE-CREATION 
  ql/src/test/results/clientpositive/windowing_streaming.q.out d3226a14986e8cbd7296fa1fe960fa3e92c7f327 
  serde/if/serde.thrift 40d5f47391bcb6408ba53f727d3020aadcc29c5c 
  serde/src/gen/thrift/gen-cpp/serde_constants.h 3566ead87ebcf7b76bfb71f0bd9874d7acd5603b 
  serde/src/gen/thrift/gen-cpp/serde_constants.cpp 243d3b8f11a999142c1801bfa7d3c5deab846628 
  serde/src/gen/thrift/gen-javabean/org/apache/hadoop/hive/serde/serdeConstants.java 8b3eeb763bdab677a520535884abb2893ee85643 
  serde/src/gen/thrift/gen-php/org/apache/hadoop/hive/serde/Types.php 8370698933b2c2466aa7d5cdf499f640c5920996 
  serde/src/gen/thrift/gen-py/org_apache_hadoop_hive_serde/constants.py 6ef3bcfd6e7faa448c31722b9ba78d68eb331a6d 
  serde/src/gen/thrift/gen-rb/serde_constants.rb f98441b48b113ddd801755b72b87ed39ad1f4ab2 
  serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDe.java 144ea5a025e5b0c118ab35230ee4059d08efe38f 
  serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDeWithEndPrefix.java ec43ae3e6480deaa0cc15e96da76dd8e776f3268 
  serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/fast/BinarySortableSerializeWrite.java 74567258a282ea58598c9f6c427f03fa477d6374 
  serde/src/test/org/apache/hadoop/hive/serde2/binarysortable/TestBinarySortableFast.java ae476aeeb143b83f1773e40eff0d629150560b76 
  serde/src/test/org/apache/hadoop/hive/serde2/binarysortable/TestBinarySortableSerDe.java af47e6f7082e464079a62df898d38ceecd9bfb61 

Diff: https://reviews.apache.org/r/43145/diff/


Testing
-------

Current testsuite to verify that default behavior has not changed.
Added q file with different cases, including windowing.


Thanks,

Jesús Camacho Rodríguez