Would anybody tried connecting SelectHiveQL processor in nifi to Hive with Date Columns and Timestamp Columns and inserted the data in postgres.
Need some help i have a table in Hive with Date and Timestamp Columns so i have created same structure has Hive in Postgres database, while inserting the data from Hive to Postgres am facing issues with Dates Columns.
If i skip Date Columns it is getting inserted the data, please help me to resolve the issue.
If anybody done this before please let me know how you have achieved it.
For more information can you can get it from here
https://community.hortonworks.com/questions/147666/facing-issues-with-date-and-timestamp-columns.htm...
Help is Appreicated