Hive
  1. Hive
  2. HIVE-3682

when output hive table to file,users should could have a separator of their own choice

    Details

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

      Linux 3.0.0-14-generic #23-Ubuntu SMP Mon Nov 21 20:34:47 UTC 2011 i686 i686 i386 GNU/Linux
      java version "1.6.0_25"
      hadoop-0.20.2-cdh3u0
      hive-0.8.1

      Description

      By default,when output hive table to file ,columns of the Hive table are separated by ^A character (that is \001).
      But indeed users should have the right to set a seperator of their own choice.

      Usage Example:
      create table for_test (key string, value string);
      load data local inpath './in1.txt' into table for_test
      select * from for_test;
      UT-01:default separator is \001 line separator is \n
      insert overwrite local directory './test-01'
      select * from src ;

      create table array_table (a array<string>, b array<string>)
      ROW FORMAT DELIMITED
      FIELDS TERMINATED BY '\t'
      COLLECTION ITEMS TERMINATED BY ',';

      load data local inpath "../hive/examples/files/arraytest.txt" overwrite into table table2;

      CREATE TABLE map_table (foo STRING , bar MAP<STRING, STRING>)
      ROW FORMAT DELIMITED
      FIELDS TERMINATED BY '\t'
      COLLECTION ITEMS TERMINATED BY ','
      MAP KEYS TERMINATED BY ':'
      STORED AS TEXTFILE;

      UT-02:defined field separator as ':'
      insert overwrite local directory './test-02'
      row format delimited
      FIELDS TERMINATED BY ':'
      select * from src ;

      UT-03: line separator DO NOT ALLOWED to define as other separator
      insert overwrite local directory './test-03'
      row format delimited
      FIELDS TERMINATED BY ':'
      select * from src ;

      UT-04: define map separators
      insert overwrite local directory './test-04'
      row format delimited
      FIELDS TERMINATED BY '\t'
      COLLECTION ITEMS TERMINATED BY ','
      MAP KEYS TERMINATED BY ':'
      select * from src;

      1. HIVE-3682.D10275.1.patch
        42 kB
        Phabricator
      2. HIVE-3682.D10275.2.patch
        40 kB
        Phabricator
      3. HIVE-3682.D10275.3.patch
        40 kB
        Phabricator
      4. HIVE-3682.D10275.4.patch
        40 kB
        Phabricator
      5. HIVE-3682.D10275.4.patch.for.0.11
        40 kB
        Sushanth Sowmyan
      6. HIVE-3682.with.serde.patch
        11 kB
        Sushanth Sowmyan
      7. HIVE-3682-1.patch
        7 kB
        caofangkun

        Issue Links

          Activity

            People

            • Assignee:
              Sushanth Sowmyan
              Reporter:
              caofangkun
            • Votes:
              0 Vote for this issue
              Watchers:
              15 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development