Uploaded image for project: 'Hadoop Common'
  1. Hadoop Common
  2. HADOOP-4265

[Hive] error when user specifies the delimiter

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.19.0
    • Component/s: None
    • Labels:
      None

      Description

      When the user specifies the delimiter (which is different from the default delimiter), the data is not processed correctly. Consider the test case:

      CREATE TABLE INPUT4_CB(KEY STRING, VALUE STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002' LINES TERMINATED BY '\012';
      LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT4_CB;
      SELECT INPUT4_CB.VALUE, INPUT4_CB.KEY FROM INPUT4_CB;
      DROP TABLE INPUT4_CB

      where kv1_cb.txt contains data seperated by Ctrl-B (\002) - the results are not as expected

        Attachments

          Activity

            People

            • Assignee:
              namit Namit Jain
              Reporter:
              namit Namit Jain
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: