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

load数据到hive,limit 显示用户名中文正确,where 用户名乱码,并且不能使用用户名比对

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.1.1
    • Fix Version/s: 2.1.1
    • Component/s: CLI
    • Labels:
      None
    • Target Version/s:

      Description

      建表语句:create table smg_t_usr_inf_23(
      Usr_ID string,
      RlgnSvcPltfrmUsr_TpCd string,
      Rlgn_InsID string,
      Usr_Nm string ,....
      ) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.MultiDelimitSerDe' WITH SERDEPROPERTIES ("field.delim"="|@|") stored as textfile

      导入数据:LOAD DATA LOCAL INPATH '/home/ap/USR_INF 20200622_0001.dat' INTO TABLE usr_inf

      select * from usr_inf limit 10;显示数据:

       

      select * from usr_inf where usr_nm = '胡学玲' ;无显示数据:

       

      其他select * from usr_inf where usr_id='***';显示数据 .

      求大神解答,为什么导入的数据是中文但是where就有问题,直接insert into table aa select * from usr_inf;新表 的usr_nm 字段也是同上 ????

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              wy993322 wang
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Due:
                Created:
                Updated: