Member since
04-04-2014
5
Posts
2
Kudos Received
0
Solutions
10-30-2014
03:44 AM
I am trying to create a new table in the hive database using beeline. I can create a database, a table without any problem. But when I try to create a table with "location parameter", it provides the following error before. I checked that the directory exists and that the directory is owned by the group that user belongs to. CDH Version : 5.1.3 Hive Server 2 Security : Sentry with Kerberos Sentry : File policy file is used Any idea on what can cause this issue? -------------------------------- Error Received 2014-10-30 03:36:55,716 ERROR org.apache.hadoop.hive.ql.Driver: FAILED: SemanticException No valid privileges org.apache.hadoop.hive.ql.parse.SemanticException: No valid privileges at org.apache.sentry.binding.hive.HiveAuthzBindingHook.postAnalyze(HiveAuthzBindingHook.java:320) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:457) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:352) at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:995) at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:988) at org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:98) at org.apache.hive.service.cli.operation.SQLOperation.run(SQLOperation.java:163) at org.apache.hive.service.cli.session.HiveSessionImpl.runOperationWithLogCapture(HiveSessionImpl.java:514) at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:222) at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:204) at org.apache.hive.service.cli.CLIService.executeStatement(CLIService.java:168) at org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:316) at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1373) at org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1358) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) at org.apache.hadoop.hive.thrift.HadoopThriftAuthBridge20S$Server$TUGIAssumingProcessor.process(HadoopThriftAuthBridge20S.java:608) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.apache.hadoop.hive.ql.metadata.AuthorizationException: User newuser does not have privileges for CREATETABLE at org.apache.sentry.binding.hive.authz.HiveAuthzBinding.authorize(HiveAuthzBinding.java:317) at org.apache.sentry.binding.hive.HiveAuthzBindingHook.authorizeWithHiveBindings(HiveAuthzBindingHook.java:502) at org.apache.sentry.binding.hive.HiveAuthzBindingHook.postAnalyze(HiveAuthzBindingHook.java:312) ... 20 more
... View more
05-29-2014
11:15 PM
Hi I have installed CDH5. I was able to install all services including oozie. But when I try to configure Oozie to use our mysql database, I am getting the following error : SERVER[test.pldc.co.org] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[-] ACTION[-] E0103: Could not load service classes, Cannot create PoolableConnectionFactory (Table 'oozie.VALIDATE_CONN' doesn't exist) org.apache.oozie.service.ServiceException: E0103: Could not load service classes, Cannot create PoolableConnectionFactory (Table 'oozie.VALIDATE_CONN' doesn't exist I am not sure if Cloudera Manager is supposed to create the database automatically in mysql after you enter the databasein information. But when I get this error, I created the database myself(db = oozie). But I am still getting this error. Any help will be apprecaited. Thanks Ferds
... View more
Labels:
- Labels:
-
Apache Oozie
-
Cloudera Manager