[
https://issues.apache.org/jira/browse/HIVE-987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12859112#action_12859112
]
John Sichi commented on HIVE-987:
---------------------------------
If people are +1 on sqlline, we could create a new beeline wrapper script
(instead of invoking it via hive --service). We could leave the old hive CLI
command available for backwards compatibility as well as for those who prefer
its hardcore feel. We would also need to make Hive JDBC driver embedded mode
work again (at least it doesn't seem to be working for me) to avoid having to
run a server.
We'd also need to fix/suppress whatever JDBC calls are throwing "Method not
supported", and some other problems (e.g. currently running Hive's "set"
command to show settings does not work through sqlline). In general, using
sqlline should help drive improvements to Hive's JDBC driver.
Note that sqlline is BSD-licensed, so I think it should be OK as a dependency.
(It also depends on jline, which is already part of Hive CLI.) The provenance
for the version I attached is described here:
http://pub.eigenbase.org/wiki/SqllineDocs
> 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
> Attachments: HIVE-987.1.patch, sqlline-1.0.8_eb.jar
>
>
> 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.
