[jira] [Created] (HIVE-25135) Vectorization: Wrong Results issues in IF expressions about Two-level nested UDF

[ZhangQiDong (Jira)]

ZhangQiDong created HIVE-25135:
--

 Summary: Vectorization: Wrong Results issues in IF expressions 
about Two-level nested UDF
 Key: HIVE-25135
 URL: https://issues.apache.org/jira/browse/HIVE-25135
 Project: Hive
  Issue Type: Bug
  Components: Vectorization
Affects Versions: 3.1.0, 4.0.0
Reporter: ZhangQiDong


After set hive.vectorized.execution.enabled = true, if there are two levels 
nested UDF conversion fields in the IF expression, the result will be incorrect.

Test case：
create table if_orc (col string, col2 string) stored as orc;
insert into table if_orc values('1', 'abc'),('1', 'abc'),('2', 'def'),( '2', 
'def');
set hive.vectorized.execution.enabled = true;
select if(col='2', col2, reverse(upper(col2))) from if_orc;

Hivesql：
select if(col='2', col2, reverse(lupper (col2))) from if_orc;

set hive.vectorized.execution.enabled = false;
Right Result：
+--+
| _c0  |
+--+
| CBA  |
| CBA  |
| def  |
| def  |
+--+

set hive.vectorized.execution.enabled = true;
Wrong result：
+--+
| _c0  |
+--+
| CBA  |
| CBA  |
| ABC  |
| ABC  |
+--+



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Created] (HIVE-24944) When the default engine of the hiveserver is MR and the tez engine is set by the client, the client TEZ progress log cannot be printed normally

[ZhangQiDong (Jira)]

ZhangQiDong created HIVE-24944:
--

 Summary: When the default engine of the hiveserver is MR and the 
tez engine is set by the client, the client TEZ progress log cannot be printed 
normally
 Key: HIVE-24944
 URL: https://issues.apache.org/jira/browse/HIVE-24944
 Project: Hive
  Issue Type: Bug
  Components: Tez
Affects Versions: 3.1.0
Reporter: ZhangQiDong
 Attachments: image-2021-03-26-10-33-00-511.png

HiveServer configuration parameter execution default MR. When set 
hive.execution.engine = tez, the client cannot print the TEZ log.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

[jira] [Created] (HIVE-23809) Data loss occurs when using tez engine to join different bucketing_version tables

[zhangqidong (Jira)]

zhangqidong created HIVE-23809:
--

 Summary: Data loss occurs when using tez engine to join different 
bucketing_version tables
 Key: HIVE-23809
 URL: https://issues.apache.org/jira/browse/HIVE-23809
 Project: Hive
  Issue Type: Bug
  Components: Hive, Tez
Affects Versions: 3.1.0
Reporter: zhangqidong


*Test case：*
create table tb_a (a int, b string,c string);
create table tb_b (a int, b string,c string);
insert into tb_a values 
(11,'a','aa'),(22,'b','bb'),(33,'c','cc'),(44,'d','dd'),(5,'e','ee'),(6,'f','ff'),(7,'g','gg');
insert into tb_b values 
(11,'a','aa'),(22,'b','bb'),(33,'c','cc'),(44,'d','dd'),(5,'e','ee'),(6,'f','ff'),(7,'g','gg');
alter table tb_a set tblproperties ("bucketing_version"='1');
alter table tb_b set tblproperties ("bucketing_version"='2');
*Hivesql：*
*set hive.auto.convert.join=false;*
*set mapred.reduce.tasks=2;*
select ta.a as a_a, tb.b as b_b from table_a ta join table_b tb on(ta.a=tb.a);


set hive.execution.engine=mr;
+--+--+
| a_a | b_b |
+--+--+
| 5 | e |
| 6 | f |
| 7 | g |
| 11 | a |
| 22 | b |
| 33 | c |
| 44 | d |
+--+--+


set hive.execution.engine=tez;
+--+--+
| a_a | b_b |
+--+--+
| 6 | f |
| 5 | e |
| 11 | a |
| 33 | c |
+--+--+

 
 
 
 
 
 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)