CODEWITHSUNDEEP
sqldremio
user1179317
user1179317

Reputation: 2903

How to set variables in Dremio

How do you set a variable in dremio?

In sql, normally you can do something like:

SET @ID = (SELECT id FROM table LIMIT 1)

or

SELECT @ID = (SELECT id FROM table LIMIT 1)

This does not seem to work for Dremio query. Anybody know how variables work in dremio?

Upvotes: 1

Views: 1987

Answers (1)

ns15
ns15

Reputation: 8704

This is not possible. We can't set variables in Dremio.

Dremio uses ANSI SQL where there is no such construct.

Upvotes: 1

Related Questions