xiangfu0 commented on a change in pull request #7590:
URL: https://github.com/apache/pinot/pull/7590#discussion_r736967088



##########
File path: 
pinot-broker/src/main/java/org/apache/pinot/broker/requesthandler/BaseBrokerRequestHandler.java
##########
@@ -1413,25 +1448,43 @@ private void fixColumnName(String rawTableName, 
Expression expression, @Nullable
    * - Case-insensitive cluster
    * - Column name in the format of [table_name].[column_name]
    */
-  private String getActualColumnName(String rawTableName, String columnName,
-      @Nullable Map<String, String> columnNameMap) {
+  private static String getActualColumnName(String rawTableName, String 
columnName,
+      @Nullable Map<String, String> columnNameMap, @Nullable Map<String, 
String> aliasMap, boolean isCaseInsensitive) {
+    if ("*".equals(columnName)) {
+      return columnName;
+    }
     // Check if column is in the format of [table_name].[column_name]
     String[] splits = StringUtils.split(columnName, ".", 2);
-    if (_tableCache.isCaseInsensitive()) {
+    if (isCaseInsensitive) {
       if (splits.length == 2 && rawTableName.equalsIgnoreCase(splits[0])) {
         columnName = splits[1];
       }
+      String columnNameLowerCase = columnName.toLowerCase();
       if (columnNameMap != null) {
-        return columnNameMap.getOrDefault(columnName.toLowerCase(), 
columnName);
-      } else {
-        return columnName;
+        String actualColumnName = columnNameMap.get(columnNameLowerCase);
+        if (actualColumnName != null) {
+          return actualColumnName;
+        }
+      }
+      if (aliasMap != null) {
+        String actualAlias = aliasMap.get(columnNameLowerCase);
+        if (actualAlias != null) {
+          return actualAlias;
+        }
       }
     } else {
       if (splits.length == 2 && rawTableName.equals(splits[0])) {
         columnName = splits[1];
       }
-      return columnName;
+      String columnNameLowerCase = columnName.toLowerCase();

Review comment:
       This means for case sensitive check, the correct case `Col` won't pass, 
which means you have to check value to ensure the correctness.




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org

Reply via email to