Custom SQL Command Parsing - With Example Code

1

Recently I wanted to create Spaces and Folders through SQL commands in Dremio, but found that it was not possible. I spent some time digging into the innards of how custom SQL commands and parsing work in Dremio, and implemented this functionality myself.

For those of you comfortable with working with custom Dremio-OSS builds, I have included a link below to the commit, which shows an example of how to create a recursive space/folder SQL command. This could also be used as the basis for building any sort of custom SQL command Parser (which is very different from a UDF, which you would include in a SELECT statement).

Original Question:

1 Like
2

@patricker Did you ever PR this back so it ended up in the main Dremio repo/make it into a normal release?

3

Hi @MichaelPearce , you will find this among 41 others :

Best,
Fabrice

4

@Benny_Chow Hello can you give us some feedback about Dremio OSS , No pull request has been accepted for years.

@balaji.ramaswamy

we really want contribute to Dremio but github repo is abandoned, same for sqlalchemy repo