[
https://issues.apache.org/jira/browse/HIVE-29100?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18033699#comment-18033699
]
Dmitriy Fingerman commented on HIVE-29100:
------------------------------------------
Hi [~vikramahuja_] , please set the affected version(s).
> 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
> Priority: Major
>
> 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)
