Member since 
    
	
		
		
		02-17-2017
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                22
            
            
                Posts
            
        
                0
            
            
                Kudos Received
            
        
                0
            
            
                Solutions
            
        
			
    
	
		
		
		04-12-2017
	
		
		12:51 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 i got this error   17/04/12 15:28:29 INFO mapreduce.Job: Counters: 8
        Job Counters
                Failed map tasks=1
                Launched map tasks=1
                Rack-local map tasks=1
                Total time spent by all maps in occupied slots (ms)=654614
                Total time spent by all reduces in occupied slots (ms)=0
                Total time spent by all map tasks (ms)=327307
                Total vcore-milliseconds taken by all map tasks=327307
                Total megabyte-milliseconds taken by all map tasks=502743552
17/04/12 15:28:29 WARN mapreduce.Counters: Group FileSystemCounters is deprecated. Use org.apache.hadoop.mapreduce.FileSystemCounter instead
17/04/12 15:28:29 INFO mapreduce.ExportJobBase: Transferred 0 bytes in 342.7432 seconds (0 bytes/sec)
17/04/12 15:28:29 WARN mapreduce.Counters: Group org.apache.hadoop.mapred.Task$Counter is deprecated. Use org.apache.hadoop.mapreduce.TaskCounter instead
17/04/12 15:28:29 INFO mapreduce.ExportJobBase: Exported 0 records.
17/04/12 15:28:29 ERROR mapreduce.ExportJobBase: Export job failed!
17/04/12 15:28:29 ERROR tool.ExportTool: Error during export: Export job failed! 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-12-2017
	
		
		07:17 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi @Deepesh,  thank you for your response, but i have some question.  --table TABLENAME - is this the table on sql server where i want to dump the data?  --export-dir HDFS_EXPORT_DIR - and this command is for HDFS? but my data is on Hive.  Please correct me if im wrong 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-12-2017
	
		
		12:53 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi,  Can anyone can help me to find a solution on transfering data from Hive to Sql Server? The Idea is Hive is our back up and im trying to load it to sql server.  Thank you in advance.!  
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache Hive
 
			
    
	
		
		
		03-20-2017
	
		
		03:15 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi @Ravi Mutyala,  is there any disadvantage when importing a table from Sql Server directly to HIVE? what is the best way to do it?  Can you help me with this. thank you in advance 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-17-2017
	
		
		09:33 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							     Hi ,  Im trying to import table from SQL Server to Hive with the commands below:  sqoop import --connect "jdbc:sqlserver://11.11.111.11;databaseName=dswFICO"     --username sqoop--password sqoop --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --table KNA1 --target-dir "/tmp/dbo-customer"  When i check on Hive View i cant see any KNA1 table created. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache Hive
 - 
						
							
		
			Apache Sqoop
 
			
    
	
		
		
		03-17-2017
	
		
		01:08 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi @Rajendra Manjunath,  I try to revise my commands , i dont see any error but still no data transferred on the hdfs directory, please the image     
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-16-2017
	
		
		07:03 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 @Jay SenSharma,  i successfully moved the sqljdbc42.jar here : /usr/hdp/current/sqoop-client/lib/   what else should i do after i moved the jar file? i try again another import command but somethings wrong again.      
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-16-2017
	
		
		07:01 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi @Rajendra Manjunath,  can you help me to identify whats wrong on my sqoop commands?      
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-16-2017
	
		
		03:28 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi @Jay SenSharma,  i got two .jar files , is it ok if i put this both in /usr/hdp/current/sqoop-client/lib/ ?     
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-13-2017
	
		
		08:01 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi @Jay SenSharma,    im now able to login on the sqoop client, but after executing some import commands i got this warning.       
						
					
					... View more