Repository: hive Updated Branches: refs/heads/master 2d698b679 -> f3cb704a5
HIVE-17587 : Remove unnecessary filter from getPartitionsFromPartitionIds call (Tao Li, reviewed by Sergey Shelukhin) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/f3cb704a Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/f3cb704a Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/f3cb704a Branch: refs/heads/master Commit: f3cb704a552c211b191593618fcb12566d697a64 Parents: 2d698b6 Author: sergey <[email protected]> Authored: Tue Sep 26 14:29:02 2017 -0700 Committer: sergey <[email protected]> Committed: Tue Sep 26 14:29:02 2017 -0700 ---------------------------------------------------------------------- .../apache/hadoop/hive/metastore/MetaStoreDirectSql.java | 10 +++++----- 1 file changed, 5 insertions(+), 5 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/f3cb704a/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java ---------------------------------------------------------------------- diff --git a/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java b/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java index c1a8efe..a940040 100644 --- a/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java +++ b/metastore/src/java/org/apache/hadoop/hive/metastore/MetaStoreDirectSql.java @@ -686,7 +686,7 @@ class MetaStoreDirectSql { } queryText = "select \"PART_ID\", \"PART_KEY_VAL\" from " + PARTITION_KEY_VALS + "" - + " where \"PART_ID\" in (" + partIds + ") and \"INTEGER_IDX\" >= 0" + + " where \"PART_ID\" in (" + partIds + ")" + " order by \"PART_ID\" asc, \"INTEGER_IDX\" asc"; loopJoinOrderedResult(partitions, queryText, 0, new ApplyFunc<Partition>() { @Override @@ -720,7 +720,7 @@ class MetaStoreDirectSql { queryText = "select \"SD_ID\", \"COLUMN_NAME\", " + SORT_COLS + ".\"ORDER\"" + " from " + SORT_COLS + "" - + " where \"SD_ID\" in (" + sdIds + ") and \"INTEGER_IDX\" >= 0" + + " where \"SD_ID\" in (" + sdIds + ")" + " order by \"SD_ID\" asc, \"INTEGER_IDX\" asc"; loopJoinOrderedResult(sds, queryText, 0, new ApplyFunc<StorageDescriptor>() { @Override @@ -730,7 +730,7 @@ class MetaStoreDirectSql { }}); queryText = "select \"SD_ID\", \"BUCKET_COL_NAME\" from " + BUCKETING_COLS + "" - + " where \"SD_ID\" in (" + sdIds + ") and \"INTEGER_IDX\" >= 0" + + " where \"SD_ID\" in (" + sdIds + ")" + " order by \"SD_ID\" asc, \"INTEGER_IDX\" asc"; loopJoinOrderedResult(sds, queryText, 0, new ApplyFunc<StorageDescriptor>() { @Override @@ -740,7 +740,7 @@ class MetaStoreDirectSql { // Skewed columns stuff. queryText = "select \"SD_ID\", \"SKEWED_COL_NAME\" from " + SKEWED_COL_NAMES + "" - + " where \"SD_ID\" in (" + sdIds + ") and \"INTEGER_IDX\" >= 0" + + " where \"SD_ID\" in (" + sdIds + ")" + " order by \"SD_ID\" asc, \"INTEGER_IDX\" asc"; boolean hasSkewedColumns = loopJoinOrderedResult(sds, queryText, 0, new ApplyFunc<StorageDescriptor>() { @@ -837,7 +837,7 @@ class MetaStoreDirectSql { if (!colss.isEmpty()) { // We are skipping the CDS table here, as it seems to be totally useless. queryText = "select \"CD_ID\", \"COMMENT\", \"COLUMN_NAME\", \"TYPE_NAME\"" - + " from " + COLUMNS_V2 + " where \"CD_ID\" in (" + colIds + ") and \"INTEGER_IDX\" >= 0" + + " from " + COLUMNS_V2 + " where \"CD_ID\" in (" + colIds + ")" + " order by \"CD_ID\" asc, \"INTEGER_IDX\" asc"; loopJoinOrderedResult(colss, queryText, 0, new ApplyFunc<List<FieldSchema>>() { @Override
