When using a Live connection to StarRocks, the “Sort by → Field” option does not appear in Tableau. However, this issue does not occur when using an Extract connection.
I contacted Tableau Support, and here is a summary of their findings:
“This is expected behavior and is driven by the capabilities exposed by the StarRocks JDBC connector. Tableau dynamically enables or disables certain UI features based on what the connector reports it supports. In this case, the connector does not advertise full support for sorting by aggregated or calculated fields, so Tableau hides this option to avoid generating unsupported SQL.”
They advised me to contact CelerData, since the StarRocks Tableau connector and JDBC driver are provided and maintained by CelerData Inc.
However, I’ve noticed the following behavior:
-
If I first create the data source as an Extract and use “Sort by → Field”,
-
then switch the data source to Live,
-
the sort-by-field behavior continues to work,
-
but if I open Edit Sort, the Field option is no longer available to select.
Has anyone encountered this issue or knows whom I should contact (at CelerData or StarRocks) to address this? Any guidance or workaround would be greatly appreciated.
Sort by → Field option missing when using live connection”
