Member since 
    
	
		
		
		01-07-2016
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                89
            
            
                Posts
            
        
                20
            
            
                Kudos Received
            
        
                6
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 12001 | 02-05-2016 02:17 PM | |
| 16726 | 02-05-2016 12:56 AM | |
| 5583 | 01-29-2016 03:24 AM | |
| 2749 | 01-20-2016 03:52 PM | |
| 2316 | 01-20-2016 08:48 AM | 
			
    
	
		
		
		08-22-2016
	
		
		09:18 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 hi,  not really its same issue....  [08S01]: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Current user : adf_admin is not allowed to grant role. User has to belong to ADMIN role and have it as current role, for this action. Otherwise, grantor need to have ADMIN OPTION on role being granted and have it as a current role for this action. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		08-19-2016
	
		
		03:36 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 I tried   GRANT admin TO USER adf_admin;  and got error below  [08S01]: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Current user : adf_admin is not allowed to grant role. User has to belong to ADMIN role and have it as current role, for this action. Otherwise, grantor need to have ADMIN OPTION on role being granted and have it as a current role for this action. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		08-19-2016
	
		
		03:34 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 hello @Brandon Wilson , im wondering how can i do this? im googling and i cant see anything related to the setting admin privs to the adf_admin user or whatever user. I thought i can do this putting the user name into conf variable "    hive.users.in.admin.role "   
 pls let me know. thank you  
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		08-19-2016
	
		
		10:37 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 hi,  im trying to setup SQL Standard-based Authorization based on the   https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_dataintegration/content/hive-013-feature-sql-standard-based-grant-revoke.html   but apparently it DOESNT work.  These are the values what are recommended.       -hiveconf hive.metastore.uris   
                     '' (a space inside single quotation marks)   
     -hiveconf hive.security.authorization.manager    org.apache.hadoop.hive.ql.security.
  authorization.
  MetaStoreAuthzAPIAuthorizerEmbedOnly   My ambari hive setup has other values...  hive.metastore.uristhrift://blabla.com:9083  and  hive.security.authorization.manager
                    
                    
                        org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdConfOnlyAuthorizerFactory  Right now when i try to   show roles; for the user which was defined in    hive.users.in.admin.role   i got the error below:  [08S01]: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Current user : adf_admin is not allowed to list roles. User has to belong to ADMIN role and have it as current role, for this action.  Thank you     
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
- 
						
							
		
			Apache Hive
			
    
	
		
		
		07-28-2016
	
		
		07:20 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 So i found appropriate components but it doesnt convert the file properly, any idea? input file is a binary 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		07-27-2016
	
		
		04:11 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi, where i can find the character set values that are accepted by ConvertCharacterSet processor?  Also what component can i use to load CSV file and to dump results into the converted CSV file? 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-09-2016
	
		
		01:37 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 its strange you cant reproduce error, does it work for you?  
  
                    Application application_1454923438220_0007 failed 2 
times due to AM Container for appattempt_1454923438220_0007_000002 
exited with  exitCode: 1
                                    
                    For more detailed output, check application tracking
 
page:http://sandbox.hortonworks.com:8088/cluster/app/application_1454923438220_0007Then,
 click on links to logs of each attempt.
                                    
                    Diagnostics: Exception from container-launch.
                                    
                    Container id: container_e10_1454923438220_0007_02_000001
                                    
                    Exit code: 1
                                    
                    Stack trace: ExitCodeException exitCode=1: 
                                    
                    	at org.apache.hadoop.util.Shell.runCommand(Shell.java:576)
                                    
                    	at org.apache.hadoop.util.Shell.run(Shell.java:487)
                                    
                    	at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:753)
                                    
                    	at 
org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:211)
                                    
                    	at 
org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:302)
                                    
                    	at 
org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:82)
                                    
                    	at java.util.concurrent.FutureTask.run(FutureTask.java:262)
                                    
                    	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)
                                    
                  
                  
                    Container exited with a non-zero exit code 1
                                    
                    Failing this attempt. Failing the application.
                   
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-05-2016
	
		
		04:01 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 well CSVExcelStorage doesnt work also....   
2016-02-05 16:01:28,917 [main] INFO  org.apache.pig.backend.hadoop.executionengine.mapReduceLayer.MapReduceLauncher - Failed!
2016-02-05 16:01:29,745 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1066: Unable to open iterator for alias sourceData
Details at logfile: /home/hdfs/pig_1454687855333.log
grunt>  Im confused... what is it. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-05-2016
	
		
		02:45 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 for 100% there is no problem with input dataset, i kept only first 5 records in file and its the same issue. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-05-2016
	
		
		02:18 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 you should fix that FORUM website its pain to format text, paste code etc....  
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		 
        













