How to set variables in Dremio

Question

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?

reading the dremio documentations , you can't 'declare` variables. so seems like you can't do this — eshirvana, Dec 03 '21 at 23:43

score 0 · Answer 1 · answered Apr 12 '22 at 07:59

0

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

Dremio uses ANSI SQL where there is no such construct.

answered Apr 12 '22 at 07:59

ns15

1 Answers1