Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- job create ss1_cities_hdfsjdbc --definition "hdfsjdbc -- resources=/springXD/cities/*.csv --driverClassName=org.postgresql.Driver -- url=jdbc:postgresql://postgresDB:5432/postgres --username=admin --password=admin --names=id,city,country,last_updated --tableName=cities " --deploy
- CREATE TABLE cities_date (id integer,country varchar(150),city varchar(150), last_Updated timestamp);
- org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [insert into cities_date(id, city, country, last_Updated) values (?, ?, ?, ?)]; nested exception is org.postgresql.util.PSQLException: ERROR: column "id" is of type integer but expression is of type character varying
- Hint: You will need to rewrite or cast the expression.
- Position: 25
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement