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:37:52 GMT

    [ https://issues.apache.org/jira/browse/HIVE-987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12859102#action_12859102
] 

John Sichi commented on HIVE-987:
---------------------------------

Some examples:

{noformat}
sqlline version 1.0.8-eb by Marc Prud'hommeaux
0: jdbc:hive://localhost:10000/default> CREATE TABLE pokes (foo INT, bar STRING);  
+--+
|  |
+--+
+--+
No rows selected (0.624 seconds)
Error: Method not supported (state=,code=0)
0: jdbc:hive://localhost:10000/default> LOAD DATA LOCAL INPATH '/Users/jsichi/open/hive-trunk/data/files/kv1.txt'
OVERWRITE INTO TABLE pokes;
+--+
|  |
+--+
+--+
No rows selected (0.265 seconds)
Error: Method not supported (state=,code=0)
0: jdbc:hive://localhost:10000/default> select * from pokes where foo=100;
+------+----------+
| foo  |   bar    |
+------+----------+
| 100  | val_100  |
| 100  | val_100  |
+------+----------+
2 rows selected (4.716 seconds)
Error: Method not supported (state=,code=0)
0: jdbc:hive://localhost:10000/default> !outputformat xmlattr             
0: jdbc:hive://localhost:10000/default> select * from pokes where foo=100;
<resultset>
  <result foo="100" bar="val_100"/>
  <result foo="100" bar="val_100"/>
</resultset>
2 rows selected (3.693 seconds)
Error: Method not supported (state=,code=0)
0: jdbc:hive://localhost:10000/default> !outputformat xmlelements         
0: jdbc:hive://localhost:10000/default> select * from pokes where foo=100;
<resultset>
  <result>
    <foo>100</foo>
    <bar>val_100</bar>
  </result>
  <result>
    <foo>100</foo>
    <bar>val_100</bar>
  </result>
</resultset>
2 rows selected (3.288 seconds)
Error: Method not supported (state=,code=0)
0: jdbc:hive://localhost:10000/default> !quit
Closing: org.apache.hadoop.hive.jdbc.HiveConnection
{noformat}


> 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