Github user jihoonson commented on a diff in the pull request:
https://github.com/apache/tajo/pull/653#discussion_r36604991
--- Diff:
tajo-catalog/tajo-catalog-server/src/main/java/org/apache/tajo/catalog/store/AbstractDBStore.java
---
@@ -2122,8 +2122,10 @@ private void setPartitionKeys(int pid,
PartitionDescProto.Builder partitionDesc)
List<TablePartitionProto> partitions = new
ArrayList<TablePartitionProto>();
try {
- String sql = "SELECT " + COL_PARTITIONS_PK + ", " + COL_TABLES_PK +
", PARTITION_NAME, " +
- " PATH FROM " + TB_PARTTIONS;
+ String sql = "SELECT A." + COL_PARTITIONS_PK + ", A." +
COL_TABLES_PK + ", A.PARTITION_NAME, " +
+ " A.PATH FROM " + TB_PARTTIONS + " A JOIN " + TB_TABLES + " B "
--- End diff --
Since it is guaranteed that the tables corresponding to partitions always
exist, join looks not necessary.
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
