Member since 
    
	
		
		
		07-17-2017
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                143
            
            
                Posts
            
        
                16
            
            
                Kudos Received
            
        
                17
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 1976 | 07-03-2019 02:49 AM | |
| 2185 | 04-22-2019 03:13 PM | |
| 1712 | 01-30-2019 10:21 AM | |
| 9463 | 07-25-2018 09:45 AM | |
| 8558 | 05-31-2018 10:21 AM | 
			
    
	
		
		
		04-17-2018
	
		
		06:03 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							Thanks for the reply Tim  It was CDH 5.12.0 and it was working great on the same servers..  I'll share the CPU info of those nodes ASAS.
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-17-2018
	
		
		04:08 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Sorry for the delay.  Hmm, now I have doubt in your backend application!  can you share the code used for read and browse your select query results.. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-17-2018
	
		
		04:04 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 Hi @messenjah00,    Can you share with us the proyecto1 table schema?  I think you must use PARTITIONED BY in the create statement. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-17-2018
	
		
		03:53 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi,    After I upgraded the cluster successfully to the last releases CM 5.14.0 / CDH 5.14.2, I have been faced to this problem in 6 of my nodes, suddenly in the first queries the impala deamon get stopped and the query cancelled and give the error messages below:    Impala-shell:  Cancelled due to unreachable impalad(s): node1.example.com:22000  ODBC:    Status: RPC Error: Client for node5.example.com:22000 hit an unexpected exception: Unknown: Interrupted system call, type: N6apache6thrift9transport19TTransportExceptionE, rpc: N6impala19TTransmitDataResultE, send: done  Impala Deamon log file:     CancelQueryFInstances query_id= 3423055f3fda78a:a2446bea00000000 failed to connect to node2.example.com:22000 :Couldn't open transport for node2.example.com:22000 (connect() failed: Connection refused)  Statestore log file:  I0413 20:07:01.767758 64122 statestore.cc:729] Unable to send heartbeat message to subscriber impalad@node5.exaple.com:22000, received error: Couldn't open transport for node5.exaple.com:23000 (connect() failed: Connection refused)    When I looking for the issue source I have found this crash message in the Impala Daemon logs:  #
# A fatal error has been detected by the Java Runtime Environment:
#
#  SIGILL (0x4) at pc=0x0000000000d863e5, pid=13065, tid=0x00007efc499cf700
#
# JRE version: Java(TM) SE Runtime Environment (8.0_144-b01) (build 1.8.0_144-b01)
# Java VM: Java HotSpot(TM) 64-Bit Server VM (25.144-b01 mixed mode linux-amd64 compressed oops)
# Problematic frame:
# C  [impalad+0x9863e5]  impala::HdfsScanNodeBase::StopAndFinalizeCounters()+0x965
#
# Failed to write core dump. Core dumps have been disabled. To enable core dumping, try "ulimit -c unlimited" before starting Java again
#
# An error report file with more information is saved as:
# /var/run/cloudera-scm-agent/process/13339-impala-IMPALAD/hs_err_pid13065.log
#
# If you would like to submit a bug report, please visit:
#   http://bugreport.java.com/bugreport/crash.jsp
# The crash happened outside the Java Virtual Machine in native code.
# See problematic frame for where to report the bug.
#    We have Centos OS v6.9 in the 6 servers, I tried to upgrade/downgrade to a several centos 6.9 kernel releases and jdk versions but no result, Here is the releases used:    Centos 6.9 kernel:  2.6.32-696.23.1.el6.x86_64  2.6.32-696.16.1.el6.x86_64  2.6.32-696.13.2.el6.x86_64  2.6.32-642.15.1.el6.x86_64  2.6.32-642.11.1.el6.x86_64    JDK:  jdk.1.8.0_144  jdk.1.8.0_121      Remark: The 6 nodes are the only nodes that does not support SSE4_2.    Thanks in advance. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
	
					
			
		
	
	
	
	
				
		
	
	
			
    
	
		
		
		04-05-2018
	
		
		07:54 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hmm, strange!  Let me propose a temporary solution, in your select query try always to fill the 5 th by a null value or write the 5th column name twice and just adapt your get method..  SELECT a,b,c,d,null,e,f,g,h,i,j,k,l FROM typetest;
or
SELECT a,b,c,d,e,e,f,g,h,i,j,k,l FROM typetest;    Lets me know if it doesn't work. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-05-2018
	
		
		07:35 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi @GopinathS    You are welcome man, It's okay.  You can work on them before the upload by removing the authentification code lines and replacing your domains/IPs.. else try to read it and if you find a abnormal, WARN or ERROR message try to share it here.    Good luck. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-03-2018
	
		
		03:32 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi @GopinathS,  You are welcome.    Try to use a website like this one Upload files for free nd share the links.. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-02-2018
	
		
		07:30 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 ok, so try to active the Impala ODBC driver log also active the unixODBC log and rerun the same test then send to me the two log files to have a clear vision on this issue.    To active impala odbc log, go to /opt/cloudera/impalaodbc/lib/64/cloudera.impalaodbc.ini and set this params:  LogLevel=6
LogPath=[your_log_path]  To active unixODBC go to /opt/cloudera/impalaodbc/Setup/odbcinst.ini and add this two line:  Trace=Yes
TraceFile=[your_log_path] 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-02-2018
	
		
		05:43 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Go in odbc.ini and set this param to 1  UseNativeQuery=1  Also try to use columns names in select:  Select col1, col2, ... From typetest; 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-02-2018
	
		
		01:59 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi @GopinathS    You are welcome man,  Do you work with CDH Impala ? if yes which release please ?  Give me the query that you run.  Also if it's possible try to active the odbc log and give us the whole logging file. 
						
					
					... View more