gortiz commented on code in PR #14951:
URL: https://github.com/apache/pinot/pull/14951#discussion_r1942634833


##########
pinot-controller/src/main/java/org/apache/pinot/controller/api/resources/PinotQueryResource.java:
##########
@@ -210,51 +217,62 @@ private String getMultiStageQueryResponse(String query, 
String queryOptions, Htt
       queryOptionsMap.putAll(RequestUtils.getOptionsFromString(queryOptions));
     }
     String database = 
DatabaseUtils.extractDatabaseFromQueryRequest(queryOptionsMap, httpHeaders);
+    List<String> tableNames = getTableNames(query, database);
+    List<String> instanceIds = getInstanceIds(query, tableNames, database);
+    String instanceId = selectRandomInstanceId(instanceIds);
+    return sendRequestToBroker(query, instanceId, traceEnabled, queryOptions, 
httpHeaders);
+  }
+
+  private List<String> getTableNames(String query, String database) {
     QueryEnvironment queryEnvironment =
         new QueryEnvironment(database, 
_pinotHelixResourceManager.getTableCache(), null);
     List<String> tableNames;
     try {
       tableNames = queryEnvironment.getTableNamesForQuery(query);
+    } catch (QException e) {
+      if (e.getErrorCode() != QueryException.UNKNOWN_ERROR_CODE) {
+        throw e;
+      } else {
+        throw new QException(QException.SQL_PARSING_ERROR_CODE, e);
+      }
     } catch (Exception e) {
-      return QueryException.getException(QueryException.SQL_PARSING_ERROR,
-          new Exception("Unable to find table for this query", e)).toString();
+      throw new QException(QException.SQL_PARSING_ERROR_CODE, e);

Review Comment:
   Because we assume other error types will be more precise. The error codes 
being used are pretty chaotic. It looks like we added them without actual 
consideration and the fact that we cannot create hierarchies is not a good 
design. For example, is a UNKNOWN_COLUMN_ERROR_CODE a 
QUERY_VALIDATION_ERROR_CODE?



-- 
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