This message was deleted.
# generals
Slackbot
12/12/2023, 3:10 PMThis message was deleted.
k
Kyle Hoondert
12/12/2023, 3:34 PMHave you seen this? https://druid.apache.org/docs/latest/querying/sql#order-by
Kyle Hoondert
12/12/2023, 3:34 PMFor non-aggregation queries, ORDER BY can only order by thecolumn__time
s
Sergio Ferragut
12/12/2023, 5:19 PMYou can group by all columns you select and then order by any of them. What is the intent of the query? Perhaps we can suggest alternatives.
v
Vignesh Shetty
12/13/2023, 1:50 PMError: SQL query is unsupported
Query not supported. Possible error: SQL query requires order by non-time column [full_name DESC] that is not supported.
Vignesh Shetty
12/13/2023, 1:51 PM@Sergio Ferragut SELECT "full_name" from "entity_test" ORDER BY full_name desc limit 10
Vignesh Shetty
12/13/2023, 2:28 PM Copy code
select address, city, county_id, state_id, msa_id, taxonomy, state, contact
from sample_table
order by city discVignesh Shetty
12/13/2023, 2:29 PMthis table has around 2.5 million records and has no time column and we should be able to sort data by every column based on user selection. This result we will perform a CTE LEFT join with a table which has close to 14 billion records
2 Views