VM cloudera - user cloudera and permissions?
I had same issue with permissions -> chgrp: changing ownership of '/user/hive/warehouse/test/_log24310.txt': User does not belong to hive.
- Added the existing user named cloudera to existing group named hive with command: usermod -a -G hive cloudera
- Restarted the system
- Used Load Command and after that did a select * from table_name -> No data was getting displayed.
- Executed select count(*) from table_name and a MapReduce job got started.
- Executed select * from table and now results was returned correctly.
- Opened a impala shell using impala-shell command.
- Executed a select * from table_name and no results was getting returned.
- Executed command invalidate metadata in the impala-shell
- Executed command refresh
table_name - Executed command show tables
- Executed command select * from table_name and now results are getting displayed both in the impala-shell and hive shell.