Advertisement
Guest User

Untitled

a guest
Jul 8th, 2016
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.77 KB | None | 0 0
  1. 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
  2.  
  3. CREATE TABLE cities_date (id integer,country varchar(150),city varchar(150), last_Updated timestamp);
  4.  
  5. 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
  6. Hint: You will need to rewrite or cast the expression.
  7. Position: 25
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement