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