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

when column type is decimal and the literal value contains space will return null

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 1.1.0
    • 2.0.0
    • None
    • None

    Description

      when column type is decimal and the literal value contains space will return null
      create table t2(id string,name string,score decimal) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' stored as textfile;
      SZX1000045568:/opt/data # hdfs dfs -cat /user/hive/warehouse/t2/t2.dat;
      1,laolv, 99.99
      2,laolv2,98.99
      select * from t2;
      -------------------------+

      t2.id t2.name t2.score

      -------------------------+

      1 laolv NULL
      2 laolv2 99

      -------------------------+

      Attachments

        Issue Links

          Activity

            People

              forrest_lv forrest lv
              forrest_lv forrest lv
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: