hive and beeline in cloudera

Developer from somewhere

Quickstart:

  • start beeline
beeline
  • connect
beeline> !connect jdbc:hive2://localhost:10000 username password org.apache.hive.jdbc.HiveDriver
  • to insert data from a local file, the file had to have 
    1

    755
     permissions on it, and be owned by the user cloudera (?)
  • if it did not have that, I kept getting errors like this:
0: jdbc:hive2://localhost:10000> LOAD DATA LOCAL INPATH '/user/cloudera/employee.txt' overwrite into table employee;
Error: Error while compiling statement: FAILED: SemanticException Line 1:23 Invalid path ''/user/cloudera/employee.txt'': No files matching path file:/user/cloudera/employee.txt (state=42000,code=40000)