Member since 
    
	
		
		
		11-11-2019
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                634
            
            
                Posts
            
        
                33
            
            
                Kudos Received
            
        
                27
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 247 | 10-09-2025 12:29 AM | |
| 4727 | 02-19-2025 09:43 PM | |
| 2117 | 02-28-2023 09:32 PM | |
| 3982 | 02-27-2023 03:33 AM | |
| 26001 | 12-24-2022 05:56 AM | 
			
    
	
		
		
		05-19-2023
	
		
		01:17 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 this is possible,please try parquet,instead of csv 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		05-19-2023
	
		
		12:16 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 @Josh2023 could you please accept as solution,if this has fixed your issue? 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		05-18-2023
	
		
		11:14 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 @Josh2023  can you try below:     SET hive.exec.compress.output=false; SET hive.exec.dynamic.partition.mode=nonstrict; -- Create a temporary table or select data from existing tables INSERT OVERWRITE DIRECTORY '/path/to/output_directory/filename_' || from_unixtime(unix_timestamp(), 'yyyyMMdd') || '.csv' SELECT * FROM your_table;    
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-20-2023
	
		
		02:15 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 @hive1 You need to follow https://docs.cloudera.com/runtime/7.2.10/using-hiveql/topics/hive-msck-repair.html 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-20-2023
	
		
		01:42 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 hi @hive1  WHat is the error you recieved?  Can you also try with set hive.msck.path.validation=ignore    
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-20-2023
	
		
		01:11 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 @hive1      Can you set below param:      set hive.msck.path.validation=skip;  Then use     MSCK REPAIR TABLE tablename DROP PARTITIONS;    
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-28-2023
	
		
		09:32 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 @APG_JWinthaegen  I see you are getting OOM     :java.lang.OutOfMemoryError: Java heap space      Please try increasing container size and check     set hive.tez.container.size=10240;  set tez.runtime.io.sort.mb=4096; (40% of hive.tez.container.size)     Please keep on increasing ,if it still fails. You can tweak the parameters in session level itself. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-27-2023
	
		
		03:33 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 I see that you are using CDP 7.1.7. Follow below steps if youare using autoTLS  1. Check TrustStore Password:  ======  # cat /etc/hive/conf/ssl-client.xml | grep -i -A1 "ssl.client.truststore.password"  <name>ssl.client.truststore.password</name>  <value>truststore_password</value>  ======    2. Below should be used for Kerberos + SSL  beeline -u "jdbc:hive2://xxxxxx10000/default;principal=hive/xxxxx@CREAL;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks;trustStorePassword=trsutpwd" 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-27-2023
	
		
		01:15 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							    @Nur      1. are you using SSL ?  2. Provide  beeline -u "jdbc:hive2://Example.com:10000/default;principal=hive/Example.com@EXAMPLE.COM" --berbose=true     3. Hiveserver2 logs    
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-06-2023
	
		
		01:02 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 @vi1   1. Navigate to CM ==> Hive on Tez ==> Configs ==> Configuration Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml     2. Set hive.server2.tez.initialize.default.sessions to false  3. Save and deploy change and start 
						
					
					... View more