Dremio is a very interesting project.
I gave it a quick try using a pre-installed docker and version 1.1.0-201708121825170680-436784e,
and tried it against a local dockerized Hive install.
I wanted to give you some quick feedback to help you improve the project:
Compatibility with Protobuf 2.6+ ?
I tried to compile the source code but it failed with ClassNotFoundErrors for classes from the com.google.protobuf package. I do have protobuf installed as
protoc --version returns
I was wondering if it is because Dremio requires Protobuf 2.5 and not 2.6?
In that case it would be good to precise it in the readme.
- It would be nice to have a regexp_extract UDF similar to Hive’s.
Error messages for syntax error are not clear at all:
(line, column) isn’t enough information, especially since lines are not numbered in the editor.
SELECT T.time FROM table T gives this message
Failure parsing the query
instead of something explaining that
time is a reserved keyword.
Since simple and double quotes don’t have the same meaning, they should not be colored with the same color.
SELECT T."day", T.col FROM table T WHERE "day" = '2017-01-01'
It would be better to color the
"day" in green like
T.col instead of coloring it in blue like strings.
I looked into it a little, and it does not seem to be that easy to do, as the CodeMirror sql mode
seems to make no difference between strings escaped with simple or double quotes.
no NULL ???
SELECT NULL FROM table gives me the error message
Illegal use of "NULL"
It would be nice to have something like a ‘CTRL + ENTER’ shortkey to execute or preview the query.
(Hive) No partition pruning for Preview
I tried doing a
SELECT * FROM table WHERE partition = ... ,
and the ‘Preview’ told me the results were empty, while the ‘Run’ button gave me results.
It would be nice if it could actually be capable of fetching a sample from the right partitions,
when a filter on partitions is applied.
no graph feature (yet)?
I am trying Dremio version 1.1.0-201708121825170680-436784e against Hive, but I don’t see the 'Graph’
button that is mentionned in the documentation. Maybe it is only available in the premium edition?
Or maybe my docker installation has some issues…
And that’s all. I hope this feedback will be useful to you.
It is a really interesting project, keep up the good work guys!