Hi sir, will query works in dremio,
“select * from sdk.accts
QUALIFY rank(end_bal) = 2” ? if not what is the equivalent query in dremio db?
hi sir, thanks for the reply
will this query work in new dremio instance?
select * from table_name where qualify rank(column_name) = 5;
while running the query its giving this error :-
(org.apache.calcite.sql.parser.SqlParseException) Encountered “where qualify” at line 1, column 52.
or any equivalent query for this in dremio
@Vijay1 Try this
select * from hive."tpch_parquet".customer qualify c_custkey = 5;
https://docs.dremio.com/software/sql-reference/sql-commands/SELECT-statements/