hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HADOOP-4514) Hive web interface
Date Wed, 29 Oct 2008 03:20:45 GMT

    [ https://issues.apache.org/jira/browse/HADOOP-4514?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12643403#action_12643403

Zheng Shao commented on HADOOP-4514:

I think in most cases we can try to follow what phpmyadmin does for MySQL.

Hive does support SELECT table.* from table LIMIT 100; so that we can show only the first
100 lines.  The query is optimized in that it directly reads HDFS files (instead of doing
a map-reduce job).

There is a difference in that MySQL has a mysqld daemon while hive does not. So the web interface
need to have some process/thread/query management capability built-in.

Another difference is that Hive queries may run much longer than MySQL queries because a single
Hive query may go against terabytes of data.

> Hive web interface
> ------------------
>                 Key: HADOOP-4514
>                 URL: https://issues.apache.org/jira/browse/HADOOP-4514
>             Project: Hadoop Core
>          Issue Type: New Feature
>          Components: contrib/hive
>            Reporter: Jeff Hammerbacher
>            Priority: Minor
> Hive needs a web interface. The initial checkin should have:
> * simple schema browsing
> * query submission
> * query history (similar to MySQL's SHOW PROCESSLIST)
> A suggested feature: the ability to have a query notify the user when it's completed.
> Edward Capriolo has expressed some interest in driving this process.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message