This is my day 1 in Dremio. My background is mostly working in traditional RDBMS. I did complete Dremio Fundamental training today. I have a few quick answers to find out so looking for help. I have VDS in my Dremio database.
Is there a temporary table or #table in Dremio. For example, in sql databases we can create
SELECT C1, C2 INTO #TEMP_TBL FROM MYTABLE
SELECT * FROM #TEMP_TBL
How can I do the same in Dremio
How can write SQL block of Dremio? For example, in sql databases we can write
set @today = sysdate()
Basically is there any document which talks about RDBMS to Dremio transition?
Thanks - Ashok