Member since
07-24-2023
7
Posts
5
Kudos Received
0
Solutions
08-22-2024
04:03 AM
1 Kudo
I am currently migrating data from MSSQL to PostgreSQL. While fetching the data from MSSQL, I use the following query to ensure the time is in UTC: SELECT "time column" AT TIME ZONE 'UTC' AS "time column" This gives me the correct result in UTC. However, when I ingest the data into PostgreSQL using NiFi's PutDatabaseprocessor, I notice that the time is being increased by 5 hours. The destination column in PostgreSQL is of type timestamp with time zone. when I manually run an INSERT command in PostgreSQL with the same time value, the time remains unchanged. The time shift only occurs during the NiFi ingestion process. Any ideas on what could be causing this discrepancy?
... View more
Labels:
- Labels:
-
Apache NiFi
04-04-2024
05:24 AM
Hi @saquibsk I am running it on primary node only. I tried pinging the hostname as well, it is also correct. But I am not able to fetch files from the SFTP. The files exist in SFTP.
... View more
04-03-2024
11:55 AM
2 Kudos
When I just provide the hostname without sftp:// I don't get any error as such. But I am not able to fetch the files from the provided path. But the files are present in SFTP
... View more
04-03-2024
09:54 AM
2 Kudos
Can someone tell me how to use GETSFTP processor? For the hostname should we provide value like sftp://host or host I am not able to fetch the files from SFTP. I have provided hostname, Port, Username, Password, Remote path. For remote path, I am following this pattern : /folder/subfolder/
... View more
Labels:
- Labels:
-
Apache NiFi
04-03-2024
01:01 AM
How can I establish connection with MSSQL using DBCPconnectionpool if I have windows authentication. I tried adding integratedSecurity = true in the connection URL but it didn't work.
... View more
Labels:
- Labels:
-
Apache NiFi
-
Kerberos
09-19-2023
02:34 AM
I am using executesqlrecord processor to run select sql queries. I use the CSVRecordsetwriter to write the results. In the CSVRecordsetwriter properties, I have mentioned the date format as MM/dd/.yyyy but still the CSVrecordsetwriter is converting the date into epoch timestamps. How do i resolve this issue? This is a screenshot of my csvrecordsetwriter settings.
... View more
Labels:
- Labels:
-
Apache NiFi
-
NiFi Registry
07-24-2023
12:15 PM
I am trying to use putdatabaserecord record processor to migrate data from a csv without header row or the column names into the database using putdatabaserecord processor. I get this error: none of the columns in csv are mapped to the table columns
... View more
Labels:
- Labels:
-
Apache NiFi