Hive
  1. Hive
  2. HIVE-887

Allow SELECT <col> without a mapreduce job

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.10.0
    • Component/s: None
    • Labels:
      None
    • Environment:

      All

    • Release Note:
      Set hive-conf hive.fetch.task.conversion to more to make use of this feature. Turned-off by default.

      Description

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

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Ning Zhang
              Reporter:
              Eric Sun
            • Votes:
              2 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development