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.
