Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-637

Add a simple way to create a blob table

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.3.0
    • None
    • Serializers/Deserializers
    • None

    Description

      A blob table has a single column of type string. We put all data from the row into that column.

      At present we are able to create blob table like this:

      CREATE TABLE blobTable1 (blob STRING)
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
  WITH SERDEPROPERTIES (
    'serialization.last.column.takes.rest'='true'
  )
  STORED AS TEXTFILE;

CREATE TABLE blobTable1 (blob STRING)
  ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
  WITH SERDEPROPERTIES (
    'serialization.last.column.takes.rest'='true'
  )
  STORED AS SEQUENCEFILE;

      We should add a simpler way to create such a table, since it's pretty popular.

      Attachments

        Issue Links

          blocks

          New Feature - A new feature of the product, which has yet to be developed. HIVE-411 Interaction of AS clause (from a TRANSFORM-USING-AS) with non-column formatted output

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              zshao Zheng Shao
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: