Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Column is of type timestamp without time zone but expression is of type character varying

Highlighted

Column is of type timestamp without time zone but expression is of type character varying

Explorer

I am trying to insert CSV records to Postgres database using nifi.

 

Sample csv file :

```

timenow,location

'2019-10-21 15:13:11','colombo'

```

 

When nifi scenario runs,

it gives following error > Error column 'timenow' is of type timestamp without time zone but expression is of type character varying...

 

If I use normal `insert into conditions (timenow,location) values ('2019-10-21 15:13:11','colombo');` No errors values inserted to table. Do I have to change nifi configurations to add this to table?

 

 `INSERT INTO public.conditions (timenow, location) VALUES ('2019-10-21 15:13:11','colombo')` I have used this with timescaledb terminal and it inserted the record.

Don't have an account?
Coming from Hortonworks? Activate your account here