Member since 
    
	
		
		
		02-19-2016
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                158
            
            
                Posts
            
        
                69
            
            
                Kudos Received
            
        
                24
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 1864 | 11-29-2017 08:47 PM | |
| 2221 | 10-24-2017 06:37 PM | |
| 20189 | 08-04-2017 06:58 PM | |
| 2292 | 05-15-2017 06:42 PM | |
| 2997 | 03-27-2017 06:36 PM | 
			
    
	
		
		
		07-28-2017
	
		
		07:14 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Make sure  that both hbase and hadoop conf dirs are in the classpath. It can be configured through Extra Class Path tab of the Phoenix driver. Also make sure that you added directories, but not xml files.  Similar type of timeouts usually happen because HBase client (which is a part of Phoenix) to detect secured environment requires from cluster both hbase-site.xml and core-site.xml. If it doesn't find that both hbase and hadoop are secured, it tries to use plain connection to region servers which will be timed out.  
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		07-20-2017
	
		
		08:18 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 You need to install phoenix-server.jar to all Region and Master servers. MetaDataEndpointImpl  
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		06-12-2017
	
		
		07:08 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Could you please provide the spark and phoenix versions (or just HDP version) you are using. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		05-15-2017
	
		
		06:42 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 256 is the default value for hbase.hconnection.threads.max  phoenix.client.connection.max.allowed.connections was introduced recently in Apache Phoenix 4.10 only. So it's not relevant to HDP 2.4 nor even more recent HDP 2.6.   
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-27-2017
	
		
		10:31 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Once we support custom select (PHOENIX-1505, PHOENIX-1506) it will be possible to do that (like ... select column_1 as c1,  ... ). Honestly speaking I can't say when it will be done.  
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		03-27-2017
	
		
		06:36 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 No, view has the same column names.  
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-24-2017
	
		
		06:44 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Can you check master log for the exception (it usually located at /var/log/hbase or $HBASE_HOME/logs, depending on the way you installed HBase). It usually quite easy to understand why the service was stopped.  
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-15-2017
	
		
		05:57 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		2 Kudos
		
	
				
		
	
		
					
							 There are two types of upserts in Phoenix. One is upsert values and it doesn't support where clause. Another is upsert select.  You need the last one and it should look like   upsert into table1(id, "column2") select id,'replacing string' from table1 where "column2" is null and <other conditions>;  Don't forget that you must specify primary key values for any upsert statement (id in my example). 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		01-27-2017
	
		
		10:11 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 That's definitely strange. Just tried a fresh install of 5.1.14  with sandbox 2.5 on my Windows 8 laptop and everything works just fine without problems.   Have you tried to start it with other setting for network adapter (I would suggest to try  "Not attached") to check whether it's really adapter settings problem or something else? 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		01-27-2017
	
		
		08:56 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Check what you have 'NAT' adapter in the Network settings for the VM.   
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		 
        













