Interactive

[rob mancuso]

Hi,

Was wondering how folks are handling interactive SQL use cases ... such as hive via beeline or cli?

Is there a cli tool or ui that can talk to genie instead of, say, hiveserver2? Or would that be managed outside the scope of genie?

Thx

[Amit Sharma]

Hi Rob,

Genie currently does not support any interactive mode to run jobs. It can only run jobs asynchronously in batch mode. It tries its best to minimize the start up time of jobs to just a few seconds, so that it does not increase the total job runtime. This allows you to run fast running queries using systems like Presto on Genie without adding any significant latency. The results of the query still need to be fetched though using the output URI of the Genie job. 

I am not sure what you mean by the second part of your question. I can tell you though that there is no cli tool for Genie and the UI is read-only. We are in the process of re-designing the UI for Genie 3.0 and somethings may change, but nothing has been finalized yet.If you have suggestions or ideas for the UI feel free to let us know or file issues in Github.

Thanks,

Amit

--
You received this message because you are subscribed to the Google Groups "genie" group.
To unsubscribe from this group and stop receiving emails from it, send an email to genieoss+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[rob mancuso]

Thanks Amit. Regarding my second comment, I was referring to an interactive shell that could be used to submit commands to Genie. I imagine it wouldn't be too difficult to write a wrapper around the APIs. I'm getting ahead of myself, though, as we're just beginning the eval stage.