I am having a problem in which the app frontend returns an error when running a SELECT query on a capital-case column. Example of a query returning an error:
SELECT NAVIGATE from inputTable
The problem does not occur in ONE DATA’s query executor, and this problem does not happen when running a query selecting all columns of the inputTable, despite there being a capital-case column. Using a * operator is not viable in my use case though, as I need to embed the column name in a GROUP BY statement.
SELECT * from inputTable