Hive
  1. Hive
  2. HIVE-1228

allow HBase key column to be anywhere in Hive table

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.6.0
    • Fix Version/s: 0.6.0
    • Component/s: HBase Handler
    • Labels:
      None

      Description

      Current column mapping support requires key column to be first in Hive table (and implicit rather than explicit in column mapping). We should allow it to be specified explicitly at any position within column mapping, e.g. with syntax :key to distinguish it from normal columns/families.

      Together with this, allow :timestamp column to be mapped. For writes, this would allow timestamp to be explicitly provided by query (although we may want to prevent this in some cases; see for example HIVE-1223 and HIVE-1225). For reads, this would allow timestamp to be fetched, and filters on timestamp could be used to find particular row versions. (If no filter is supplied, should we return all row versions or only the default latest version? The semantics need to be well-defined here.)

        Issue Links

          Activity

          Carl Steinbach made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Ning Zhang made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          John Sichi made changes -
          Link This issue is blocked by HIVE-1226 [ HIVE-1226 ]
          John Sichi made changes -
          Status In Progress [ 3 ] Patch Available [ 10002 ]
          John Sichi made changes -
          Attachment HIVE-1228.1.patch [ 12444354 ]
          John Sichi made changes -
          Summary allow HBase key column to be anywhere in Hive table, and expose timestamp column for read and write allow HBase key column to be anywhere in Hive table
          John Sichi made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          John Sichi made changes -
          Component/s HBase Handler [ 12313461 ]
          Component/s Contrib [ 12313001 ]
          John Sichi made changes -
          Link This issue is related to HIVE-1232 [ HIVE-1232 ]
          John Sichi made changes -
          Link This issue is blocked by HIVE-1226 [ HIVE-1226 ]
          John Sichi made changes -
          Link This issue relates to HIVE-705 [ HIVE-705 ]
          John Sichi made changes -
          Component/s Contrib [ 12313001 ]
          John Sichi made changes -
          Field Original Value New Value
          Assignee John Sichi [ jvs ]
          John Sichi created issue -

            People

            • Assignee:
              John Sichi
              Reporter:
              John Sichi
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development