I created tickets for the issues you encountered @AlfonLinata (internal reference: AP-16953 and AP-16954). Can you maybe share your dataset or a sample of it so that we can reproduce the problems?
Best,
Simon
2 Likes
Hi @AlfonLinata
I currently have the same problem as you. How did you manage to fix it?
@SimonS Is there any way to load data type DATETIME to bigquery?
Confirming the issue still persists using KNIME 4.6.1 for Mac.
Executing DB Loader node for a BigQuery table results to an error, this is an example error message: Could not parse ‘18:00’ as TIME for field req_date_time (position 39) starting at location 2480 with message 'Invalid time string “18:00”
If we convert the Date&Time column to String which results to a string equivalent of the actual time value “18:00:00”, DB Loader will warn: The input and database columns do not match: The input column type at index 40 is “VARCHAR”, the database column type is “TIME”. and will not allow DB Loader node to be executed.
Converting the previously-converted String (“18:00:00”) back to Date&Time (HH:mm:ss) will still produce the “18:00” TIME in the CSV file prepared by the DB Loader Node.
Using parquet will have a different problem with error message: Parquet type could not be found for the database type: TIME
