hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Sun (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-887) Allow SELECT <col> without a mapreduce job
Date Mon, 19 Oct 2009 16:35:59 GMT
Allow SELECT <col> without a mapreduce job
------------------------------------------

                 Key: HIVE-887
                 URL: https://issues.apache.org/jira/browse/HIVE-887
             Project: Hadoop Hive
          Issue Type: New Feature
         Environment: All
            Reporter: Eric Sun


I often find myself needing to take a quick look at a particular column of a Hive table.

I usually do this by doing a 
SELECT * from <table> LIMIT 20;
from the CLI.  Doing this is pretty fast since it doesn't require a mapreduce job.  However,
it's tough to examine just 1 or 2 columns when the table is very wide.

So, I might do
SELECT <col> from <table> LIMIT 20;
but it's much slower since it requires a map-reduce.  It'd be really convenient if a map-reduce
wasn't necessary.

Currently a good work around is to do
hive -e "select * from table" | cut --key=n
but it'd be more convenient if it were built in.

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