[jira] [Created] (HIVE-25135) Vectorization: Wrong Results issues in IF expressions about Two-level nested UDF
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 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 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)