I have created a partition table as below
CREATE EXTERNAL TABLE `table`(
no of clomuns ))
PARTITIONED BY (year INT,month INT,day INT)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
STORED AS parquet
While querying the tables with on of the partition column, I am getting the following error, for all other regular column it is working fine. Thanks.
//> select * from table where year=2015;
Error: java.io.IOException: java.lang.IllegalArgumentException: Column [year] was not found in schema! (state=,code=0)
Can you please let me know what I am doing wrong here.