Member since
06-26-2015
515
Posts
137
Kudos Received
114
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2022 | 09-20-2022 03:33 PM | |
5602 | 09-19-2022 04:47 PM | |
3037 | 09-11-2022 05:01 PM | |
3354 | 09-06-2022 02:23 PM | |
5297 | 09-06-2022 04:30 AM |
09-09-2022
04:43 PM
@VenkatG Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks
... View more
09-07-2022
05:04 AM
1 Kudo
Everything you do in the NiFi UI can also be done using the NiFi REST API. So if you want/need to automate it, it's totally possible and not difficult. Cheers, André
... View more
09-07-2022
12:34 AM
@JimHalfpenny and @araujo thanks both of you for your help! The solution of creating a view with some kind of placeholders worked for me!
... View more
09-06-2022
03:24 PM
@rafy , Same approach. Just create the processor(s) and let the files flow through it 🙂 Cheers, André
... View more
09-06-2022
10:57 AM
Thanks for the info, that's very useful. It's Hive 3.1.2, Cloudera ODBC for Hive 2.6.1 Interestingly I get the following results querying though the ODBC driver (use native query = false) SELECT extract (year FROM "datecolumn") -- accepted SELECT { fn extract (year FROM "datecolumn") } -- ParseException and yet SELECT { fn year("datecolumn") } - accepted So there may be an inconsistency in the way the driver parses the ODBC function syntax. Mark
... View more
09-05-2022
03:54 PM
@Ahmed_Abuhaimed , Have you looked into change data capture functionality for Hana? https://help.sap.com/docs/SAP_DATA_INTELLIGENCE/1c1341f6911f4da5a35b191b40b426c8/023c75aedfdd4646934f2d9ccde5660a.html Cheers, André
... View more
09-05-2022
03:48 PM
@samrathal , Is seems that "subtract" only works for integers and your value is a long. The longSubtract function only works if longs are passed as parameters and I don't know if there's a way to specify a long literal in Jolt (I tried 60L but that doesn't work). The following does a little bit more work but also achieves what you want: [
{
"operation": "modify-overwrite-beta",
"spec": {
"currenttime": "=toLong(${now():toNumber()})",
"minute": "=toLong(60)"
}
},
{
"operation": "modify-overwrite-beta",
"spec": {
"timeOneMinu": "=longSubtract(@(1,currenttime), @(1,minute))"
}
},
{
"operation": "remove",
"spec": {
"minute": ""
}
}
] Output: {
"currenttime": 1662417935173,
"timeOneMinu": 1662417935113
} Cheers, André
... View more
09-05-2022
03:19 AM
Hi André, With or without domain in the configuration, its taking default domain. If we provide multiple domains also its not authenticating new one. Thanks, Uday
... View more
09-04-2022
11:09 PM
1 Kudo
Yes, it works. Thank you so much!!
... View more
09-04-2022
10:29 PM
@Omarb, Has any of the replies helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.
... View more