Member since
06-26-2015
515
Posts
138
Kudos Received
114
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 2271 | 09-20-2022 03:33 PM | |
| 6048 | 09-19-2022 04:47 PM | |
| 3259 | 09-11-2022 05:01 PM | |
| 3734 | 09-06-2022 02:23 PM | |
| 5819 | 09-06-2022 04:30 AM |
03-14-2022
10:08 PM
Hi @gaofzhan, For what reason are you copying the JDBC driver to the NiFi's lib folder? When you need to JDBC driver for connecting to the remote sources, you typically only need to copy the ojdbc8.jar file. If you copy all the files that come in the tarball downloaded from Oracle it can cause errors like the one you describe. Please remove the copied files from the lib folder, copy only the ojdbc8.jar one and try again. Cheers, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.
... View more
03-14-2022
07:38 PM
1 Kudo
Hi, @VikasNayak07 , An easy way to achieve this is to use a JoltTransformRecord processor with a JsonTreeReader and a CSVRecordSetWriter. The following "Chain" transformation will produce the output that you want: [
{
"operation": "shift",
"spec": {
"tokens": {
"*": "[&].token"
}
}
}
] Cheers, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.
... View more
03-14-2022
07:14 PM
Hi, @Onkar_Gagre , You can use a Record Path expression to do what you want in a QueryRecord processor. Please try the example below: SELECT *
FROM FLOWFILE
WHERE RPATH(labels, '/site_identifier') = 'xyz' Cheers, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.
... View more
03-14-2022
06:39 PM
Yep, I know. Would you be able to share the content of that file? You can send it to me in pvt if you prefer. André
... View more
03-14-2022
03:48 PM
@gaofzhan , What's the exact JDBC driver and version that you added to the lib folder? André
... View more
03-14-2022
03:46 PM
@krishna123 , What's the Java version that you are using? Cheers, André
... View more
03-14-2022
03:44 PM
@Swagat , Please check that the file /opt/cloudera/security/x509/key/host.pem exists and has read permissions for the impala user. If the file exists, you can grant permission to the impala user by running the following command as root: setfacl -m user:impala:r-- /opt/cloudera/security/x509/key/host.pem Cheers, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.
... View more
03-14-2022
03:41 PM
@Dave0x1 , Would you be able to share your current configuration? Cheers, André
... View more
03-14-2022
03:37 PM
1 Kudo
@JohnnyC , You can download the latest JDBC driver from here. Cheers, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.
... View more