Member since 
    
	
		
		
		07-14-2017
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                99
            
            
                Posts
            
        
                5
            
            
                Kudos Received
            
        
                4
            
            
                Solutions
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 1890 | 09-05-2018 09:58 AM | |
| 2526 | 07-31-2018 12:59 PM | |
| 1987 | 01-15-2018 12:07 PM | |
| 1725 | 11-23-2017 04:19 PM | 
			
    
	
		
		
		04-25-2018
	
		
		09:52 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							@Shu I already have a validation query and have max wait time to 60 sec, it did not help.  I will check using the rest api 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		04-25-2018
	
		
		08:46 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 I am running a hive controller for puthivql processor.  It is failing daily with error  'failed to process sesion due to org.apache,nifi.processor.exception.ProcessorException: org.apache.commons.dbcp.SQLNestedException: cannot create PoolableConnectionFactory'  When I restart the controller service, it works till next day      Could you please help me how to overcome this error or is there a way to restart controller services automatically or scheduled restart of controller services.  Suggestions are highly appreciated. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache NiFi
 
			
    
	
		
		
		03-14-2018
	
		
		02:43 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							@Shu   Thanks, that works. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-19-2018
	
		
		09:28 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 @Shu   There is no quote characters in csv.  input is:  a, quick, brown,fox jumps, over, the, lazy  not   a, quick,"brown,fox jumps",over,"the, lazy" 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		02-18-2018
	
		
		03:09 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi,  I have data with semicolon as part of it.  I have to insert such data in to hive table.  ex:  create table semicolon(a string);  insert into semicolon values ('Mozilla/5.0 (iPhone; CPU iPhone OS 5_0)');  I am getting below error.  mismatched input '/' expecting ) near '...  could you please help 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache Hive
 
			
    
	
		
		
		02-18-2018
	
		
		02:11 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		1 Kudo
		
	
				
		
	
		
					
							 Hi,  I am getting a huge csv ingested in to nifi to process to a location.  The location is an external table location, from there data is processed in to orc tables.  I am getting comma(,) in between data of csv, can you please help me to handle it.  ex:  file: (here below are 5 fields "brown,fox jumps" and "the, lazy" are single fields)  a, quick, brown,fox jumps, over, the, lazy      When an external table is placed on the file only "a, quick, brown, fox, jumps" are shown  Thank you 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache Hive
 - 
						
							
		
			Apache Spark
 
			
    
	
		
		
		02-14-2018
	
		
		04:22 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 Hi All,  Can anyone guide me to understand how to query hbase data using solr.  background:  I have a huge table in hbase, I want an interface to index and query  hbase data and display in a user understandable format.  I understand that solr provides good flexibility for this use case.  Thanks 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
			
	
					
			
		
	
	
	
	
				
		
	
	
- Labels:
 - 
						
							
		
			Apache HBase
 - 
						
							
		
			Apache Solr
 
			
    
	
		
		
		01-24-2018
	
		
		02:08 PM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 @Sivaprasanna   I am not sure, if you are trying to explain Matt's answer in a otherway or could not understand my question.  I will try to put my question this way  replace text processor  search value: (\[flowfile )(.*?\")(\].*)  replace value: $2  case 1: file contains   [flowfile name="11" size="1KB"........ timestamp="2018-01-21 10:00:00.00000000"][end of file]  result will be:  name="11" size="1KB"........ timestamp="2018-01-21 10:00:00.00000000"  case 2: If thefile dont match as case 1 and some other error text enters.  "a new file with out the flowfile but something else"             -> Lets assume this is the content in the file  result will be : "a new file with out the flowfile but something else"            -> which is not expected and these should not be proceeded.  To avoid the above situation I was using extract text.  So, how to avoid the above using replace text.  Can you please suggest, Thanks in advance 
						
					
					... View more