Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Truncate hive table causing issues in impala insert.

Truncate hive table causing issues in impala insert.

New Contributor

Hi 

 

Please help to solve this issues.

 

I have hive table named HiveTable1. 

And am truncating that table using "TRUNCATE TABLE HIVETABLE1;" in hive.

 

After truncation, am trying to insert data to HIVETABLE1 using impala.

But it's says, user don't have write access for that table.

Impala insert is working fine if I didn't truncate the table. But after truncate , its not working.

 

Note: Drop and recreate table in hive and then insert using impala is also working fine.

 

Can you please guide me to solve this issues.