Vikram Ahuja created HIVE-29100:
-----------------------------------
Summary: Query failure post adding non valid partitions to a
partition table
Key: HIVE-29100
URL: https://issues.apache.org/jira/browse/HIVE-29100
Project: Hive
Issue Type: Bug
Reporter: Vikram Ahuja
Assignee: Vikram Ahuja
Steps to reproduce this issue:
set hive.cbo.enable=true;
drop table if exists item;
create external table item
(
i_item_sk bigint
, i_item_id char(16)
, i_rec_start_date date
, i_product_name char(50)
)
stored as orc;
drop table if exists date_dim;
create external table date_dim
(
d_date_sk bigint
, d_date_id char(16)
, d_date date
, d_month_seq int
, d_week_seq int
, d_quarter_seq int
, d_year int
, d_dow int
, d_moy int
, d_current_year char(1)
)
stored as orc;
drop table if exists store_sales;
create external table store_sales
(
ss_sold_time_sk bigint
, ss_wholesale_cost int
)
partitioned by (ss_sold_date_sk bigint)
stored as orc
;
explain with
cross_sales as
(select i_product_name product_name
,sum(ss_wholesale_cost) s1
FROM store_sales
,date_dim d1
,item
WHERE
ss_sold_date_sk = d1.d_date_sk
group by i_product_name
)
select cs1.product_name
from cross_sales cs1,cross_sales cs2
order by cs1.s1
,cs2.s1;
add random directories to store_sales table
hdfs dfs -mkdir
/warehouse/tablespace/external/hive/random_db.db/store_sales/ss_sold_date_sk=part
hdfs dfs -mkdir
/warehouse/tablespace/external/hive/random_db.db/store_sales/ss_sold_date_sk=random
Msck repair table store_sales;
explain with
cross_sales as
(select i_product_name product_name
,sum(ss_wholesale_cost) s1
FROM store_sales
,date_dim d1
,item
WHERE
ss_sold_date_sk = d1.d_date_sk
group by i_product_name
)
select cs1.product_name
from cross_sales cs1,cross_sales cs2
order by cs1.s1
,cs2.s1;
Error: Error while compiling statement: FAILED: SemanticException [Error
10002]: Line 14:13 Invalid column reference 's1' (state=42000,code=10002)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
