[
https://issues.apache.org/jira/browse/HIVE-987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12790305#action_12790305
]
John Sichi commented on HIVE-987:
---------------------------------
In case it's useful (at least as a place from which to borrow code), here's a
jline-based pure Java CLI generic to any JDBC back end, with a BSD license:
http://sqlline.sourceforge.net/
It supports most of the features above, plus some other nice stuff like
Control-C for cancel. Development by the original author has tapered off, but
it used as the primary CLI for LucidDB, where new enhancements are made on it
occasionally.
> Hive CLI Omnibus Improvement ticket
> -----------------------------------
>
> Key: HIVE-987
> URL: https://issues.apache.org/jira/browse/HIVE-987
> Project: Hadoop Hive
> Issue Type: Improvement
> Reporter: Carl Steinbach
>
> Add the following features to the Hive CLI:
> * Command History
> * ReadLine support
> ** HIVE-120: Add readline support/support for alt-based commands in the CLI
> ** Java-ReadLine is LGPL, but it depends on GPL readline library. We probably
> need to use JLine instead.
> * Tab completion
> ** HIVE-97: tab completion for hive cli
> * Embedded/Standalone CLI modes, and ability to connect to different Hive
> Server instances.
> ** HIVE-818: Create a Hive CLI that connects to hive ThriftServer
> * .hiverc configuration file
> ** HIVE-920: .hiverc doesnt work
> * Improved support for comments.
> ** HIVE-430: Ability to comment desired for hive query files
> * Different output formats
> ** HIVE-49: display column header on CLI
> ** XML output format
> For additional inspiration we may want to look at the Postgres psql shell:
> http://www.postgresql.org/docs/8.1/static/app-psql.html
> Finally, it would be really cool if we implemented this in a generic fashion
> and spun it off as an apache-commons
> shell framework. It seems like most of the Apache Hadoop projects have their
> own shells, and I'm sure the same is true
> for non-Hadoop Apache projects as well.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
