I am creating a temp table from another table using AS clause where i am including the partition column of another table also be part of temp table and then i am getting the below error. Below is the table create statement where col4 is the partition column of table xyz.
And while running the create statement i am getting the below error. And when i am removing the col4 from the create statement its running fine
Error: Error while compiling statement: FAILED: NumberFormatException For input string: "HIVE_DEFAULT_PARTITION" (state=42000,code=40000)
Please help.
Example: CREATE TEMPORARY TABLE abc STORED AS PARQUET AS SELECT
col1 AS col1,
col2 AS col2,
col3 AS col3,
col4 AS col4
FROM xyz;
Regards,
Vimarsh