hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <>
Subject [jira] [Resolved] (HIVE-887) Allow SELECT <col> without a mapreduce job
Date Tue, 11 Dec 2012 16:39:21 GMT


Ashutosh Chauhan resolved HIVE-887.

       Resolution: Fixed
    Fix Version/s: 0.10.0
     Release Note: Set hive-conf hive.fetch.task.conversion to more to make use of this feature.
Turned-off by default.

Most of this got implemented in HIVE-2925
> Allow SELECT <col> without a mapreduce job
> ------------------------------------------
>                 Key: HIVE-887
>                 URL:
>             Project: Hive
>          Issue Type: New Feature
>         Environment: All
>            Reporter: Eric Sun
>            Assignee: Ning Zhang
>             Fix For: 0.10.0
> 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 since it alleviates the need for column

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message