hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-987) Hive CLI Omnibus Improvement ticket
Date Tue, 20 Apr 2010 22:55:52 GMT

    [ 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.


Mime
View raw message