Member since
01-23-2024
9
Posts
8
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
360 | 03-10-2024 06:13 AM |
07-06-2024
01:10 AM
2 Kudos
the above issue solved,. This idea is the picture will be sent through email , after we read and and convert to base64 String to we try to sent to oracle db by put sql process and insert statement , but we the received the following issues : java.sql.BatchUpdateException: ORA-01704: string literal too long Note : The type of picture filed is long raw
... View more
07-04-2024
02:20 AM
1 Kudo
How we can get the content of file from Extract Email Attachments process ? if we see there are Many process coming after ExtractEmailAttachments process and in the end the put file process create file but the content of file is the value of variables for process which before the putfile process ConsumeIMAP -> ExtractEmailHeaders -> ExtractEmailAttachments -> UpdateAttribute -> ExecuteSQL -> ConvertAvroToJSON -> EvaluateJsonPath -> put file
... View more
Labels:
- Labels:
-
Apache NiFi
04-16-2024
03:07 PM
is there way can Dashboard/monitor report which showing statistical report for running NIFI Template/process for example how many success/failure messages are processing and how many message in queue and ....etc. Thank you in advance.
... View more
Labels:
- Labels:
-
Apache NiFi
04-01-2024
03:17 AM
1 Kudo
When try to use ExecuteSQL 1.25.0 to query data from oracle 11g , we received the below errors can you guide me please , we have Apache NiFi in docker . Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found
... View more
Labels:
- Labels:
-
Apache NiFi
03-10-2024
06:13 AM
2 Kudos
we update the "JSON Handling Strategy" property to Nested into AttributesToJSON , then it's working . thank your for all
... View more
03-10-2024
05:19 AM
1 Kudo
How we can use AttributesToJSON process to reformat the n1,n2,n3 parameters to json string as below ? { "n1": 20, "n2": { "n3": "1400000474" } } we try to do that but the output of json string coming with \" , we want to pass the output of AttributesToJSON process to postHttp process { "n1" : "20" "n2" : "{\"n3\":\"8001001922\"}", }
... View more
Labels:
- Labels:
-
Apache NiFi
02-06-2024
05:18 AM
we make database connect to apache hive and it's 'ok , but , the following issues when try to browse tables when we try to create dataset 2024-02-06 09:58:58,682:DEBUG:pyhive.hive:TExecuteStatementReq(sessionHandle=TSessionHandle(sessionId=THandleIdentifier(guid=b'\x9d\xfc\x17\xd3acJ\x81\x87\xf2<\x92mk\x92C', secret=b'\x1b\x8f\x9cX_NIP\x96\xe55\xce\x16\x0e\xf1:')), statement='SHOW VIEWS IN hrdb', confOverlay=None, runAsync=False, queryTimeout=0) 12024-02-06 09:58:58,688:DEBUG:pyhive.hive:TExecuteStatementResp(status=TStatus(statusCode=3, infoMessages=["*org.apache.hive.service.cli.HiveSQLException:Error while compiling statement: FAILED: ParseException line 1:5 cannot recognize input near 'SHOW' 'VIEWS' 'IN' in ddl statement:28:27", 'org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:374', 'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:136', 'org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:206', 'org.apache.hive.service.cli.operation.Operation:run:Operation.java:316', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:425', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatement:HiveSessionImpl.java:395', 'sun.reflect.GeneratedMethodAccessor49:invoke::-1', 'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43', 'java.lang.reflect.Method:invoke:Method.java:606', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78', 'org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36', 'org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63', 'java.security.AccessController:doPrivileged:AccessController.java:-2', 'javax.security.auth.Subject:doAs:Subject.java:415', 'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1693', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59', 'com.sun.proxy.$Proxy23:executeStatement::-1', 'org.apache.hive.service.cli.CLIService:executeStatement:CLIService.java:245', 'org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:506', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1313', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1298', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:285', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:615', 'java.lang.Thread:run:Thread.java:745', "*org.apache.hadoop.hive.ql.parse.ParseException:line 1:5 cannot recognize input near 'SHOW' 'VIEWS' 'IN' in ddl statement:33:6", 'org.apache.hadoop.hive.ql.parse.ParseDriver:parse:ParseDriver.java:204', 'org.apache.hadoop.hive.ql.parse.ParseDriver:parse:ParseDriver.java:166', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:423', 'org.apache.hadoop.hive.ql.Driver:compile:Driver.java:311', 'org.apache.hadoop.hive.ql.Driver:compileInternal:Driver.java:1194', 'org.apache.hadoop.hive.ql.Driver:compileAndRespond:Driver.java:1181', 'org.apache.hive.service.cli.operation.SQLOperation:prepare:SQLOperation.java:134'], sqlState='42000', errorCode=40000, errorMessage="Error while compiling statement: FAILED: ParseException line 1:5 cannot recognize input near 'SHOW' 'VIEWS' 'IN' in ddl statement"), operationHandle=None) 2024-02-06 09:58:58,697:DEBUG:pyhive.hive:TCloseSessionResp(status=TStatus(statusCode=0, infoMessages=None, sqlState=None, errorCode=None, errorMessage=None)) 134.136.145.140 - - [06/Feb/2024:09:58:58 +0000] "GET /api/v1/database/3/tables/?q=(force:!f,schema_name:hrdb) HTTP/1.1" 422 76 "http://10.250.112.95:8088/dataset/add/" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36"
... View more
Labels:
01-31-2024
12:35 AM
1 Kudo
We try to use PutHDFS process ,automatically the owner of file which created by PutHDFS in Cloudera will be same domain user which NIFI running. The OS of NIFI is window 10 and the server of Hive is Cloudera docker. how we can update owner of file from domain user to Cloudera user.
... View more
Labels:
- Labels:
-
Apache NiFi
-
Cloudera Manager
01-23-2024
11:26 PM
Hi All, we try to fetch the results from database according to the content of cvs file.after converting the csv to json format by SpileRecord then we try to get the content of Json record by EvaluateJsonPath then we try to get value of attribute by UpdateAttribute but the FF_Content attribute into inEvaluateJsonPath not recognized . listFile->FetchFiles->SpileRecord->EvaluateJsonPath ->UpdateAttribute ->ExecuteSQL
... View more
Labels:
- Labels:
-
Apache NiFi