I tried to begin a discussion along these lines earlier but that kind of
went into a digression. My plan is to build a custom front-end for hive.
Hive cli and hwi are great for the needs of developers and such but the idea
here is to make hive a lot more accessible to non-technical and non-sql
users (mostly business and marketing types). It front-end will have some
standard features where you can "build and save" queries for reuse, run
queries and retrieve results in CSV/XLS format, etc. Ideally the front-end
also enables multiple users submitting and running jobs simultaneously I see
2 approaches to this problem.
1. Leverage the JDBC driver with an off-the-shelf or open source report
designing software that has most of the above features already built-in.
There seem to be issues integrating hadoop+hive+jdbcdriver with some of the
existing tools but hopefully those issues could be solved. I believe there
are known integration issues with existing tools due to the minimal JDBC
implementation of hive. Not sure if this should be a major concern.
2. Just build a custom ui from scratch. I guess I could start with hwi and
customize it. Some of the features above probably make sense to fold into
hwi (may be) but some of them would be very specific to our internal systems
and applications. May be it'd be possible to somehow achieve both.
Any thoughts or suggestions are greatly appreciated.