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

Add fiexed-length column serde

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Hive does not support setting the column delimiter as a space. Some systems require storing files in fixed-length format. I am thinking that maybe we can add this feature. I can submit the code, and create tables like this.

      ```sql

      CREATE TABLE fixed_length_table (
        column1 STRING,
        column2 STRING,
        column3 STRING
      )
      ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.fixed.FixedLengthTextSerDe'
      WITH SERDEPROPERTIES (
        "field.lengths"="10,5,8"
      )
      STORED AS TEXTFILE;

      ```

      Attachments

        Activity

          People

            Unassigned Unassigned
            mggger Jiamin Wang
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: