| |
| set hive.mapred.mode=nonstrict; |
| set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; |
| set hive.support.concurrency=true; |
| set hive.explain.user=true; |
| set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager; |
| |
| |
| set hive.auto.convert.join=true; |
| set hive.auto.convert.join.noconditionaltask=true; |
| set hive.auto.convert.join.noconditionaltask.size=88888888; |
| -- set hive.auto.convert.sortmerge.join=true; |
| -- set hive.auto.convert.sortmerge.join.to.mapjoin=true; |
| |
| create table lineitem1 (L_ORDERKEY integer); |
| |
| insert into lineitem1 values (1),(2),(3); |
| |
| create table lineitem2 |
| stored as orc TBLPROPERTIES ('transactional'='true') |
| as select * from lineitem1; |
| create table lineitem_stage |
| stored as orc TBLPROPERTIES ('transactional'='true') |
| as select * from lineitem1 limit 1; |
| |
| |
| analyze table lineitem2 compute statistics for columns; |
| analyze table lineitem_stage compute statistics for columns; |
| |
| explain reoptimization |
| merge into lineitem2 using |
| (select * from lineitem_stage) sub |
| on sub.L_ORDERKEY = lineitem2.L_ORDERKEY |
| when matched then delete; |
| |
| merge into lineitem2 using |
| (select * from lineitem_stage) sub |
| on sub.L_ORDERKEY = lineitem2.L_ORDERKEY |
| when matched then delete; |
| |
| |