01 Feb 21 · Ryan-Dallas · #bigquery ·   Bookmark   ×

Timestamp values sent to BigQuery libraries returns error "This field is not a record"

Example:

Hashmap<String,Object> rowContent = new Hashmap<>();
rowContent.put("Time", new Date());
rowContent.put("Name", "Harry");

Solution:

Send the date/time as UTC seconds since 1970:

Hashmap<String,Object> rowContent = new Hashmap<>();
rowContent.put("Time", Math.floor(new Date().getTime()/1000));
rowContent.put("Name", "Harry");

Ryan-Dallas

posted on 01 Feb 21

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds