You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "yuxuqi (Jira)" <ji...@apache.org> on 2019/12/16 12:50:00 UTC
[jira] [Updated] (HIVE-22650) hive udf I can use the udf select
,but when insert into table ,the value is null
[ https://issues.apache.org/jira/browse/HIVE-22650?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
yuxuqi updated HIVE-22650:
--------------------------
Attachment: sources.rar
Component/s: UDF
Affects Version/s: 1.2.1
Description:
hive udf I can use the udf select ,but when insert into table ,the value is null :
hive> select transCity(name) as city,name
> from bd_area t1
> where t1.level_id='1'
> limit 10;
110100000000 北京市
120100000000 天津市
130100000000 石家庄市
130200000000 唐山市
130300000000 秦皇岛市
130400000000 邯郸市
130500000000 邢台市
130600000000 保定市
130700000000 张家口市
130800000000 承德市
hive> create table test
> as
> select transCity(name) as city,name
> from bd_area t1
> where t1.level_id='1'
> limit 10;
hive> select * from test;
OK
NULL 北京市
NULL 天津市
NULL 石家庄市
NULL 唐山市
NULL 秦皇岛市
NULL 邯郸市
NULL 邢台市
NULL 保定市
NULL 张家口市
NULL 承德市
Environment: hdp 2.6.2 hive1.2.1
Summary: hive udf I can use the udf select ,but when insert into table ,the value is null (was: hive udf)
> hive udf I can use the udf select ,but when insert into table ,the value is null
> ----------------------------------------------------------------------------------
>
> Key: HIVE-22650
> URL: https://issues.apache.org/jira/browse/HIVE-22650
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Affects Versions: 1.2.1
> Environment: hdp 2.6.2 hive1.2.1
> Reporter: yuxuqi
> Priority: Major
> Attachments: sources.rar
>
>
> hive udf I can use the udf select ,but when insert into table ,the value is null :
> hive> select transCity(name) as city,name
> > from bd_area t1
> > where t1.level_id='1'
> > limit 10;
> 110100000000 北京市
> 120100000000 天津市
> 130100000000 石家庄市
> 130200000000 唐山市
> 130300000000 秦皇岛市
> 130400000000 邯郸市
> 130500000000 邢台市
> 130600000000 保定市
> 130700000000 张家口市
> 130800000000 承德市
> hive> create table test
> > as
> > select transCity(name) as city,name
> > from bd_area t1
> > where t1.level_id='1'
> > limit 10;
> hive> select * from test;
> OK
> NULL 北京市
> NULL 天津市
> NULL 石家庄市
> NULL 唐山市
> NULL 秦皇岛市
> NULL 邯郸市
> NULL 邢台市
> NULL 保定市
> NULL 张家口市
> NULL 承德市
--
This message was sent by Atlassian Jira
(v8.3.4#803005)