search

google-code-export / google-bigquery

Automatically exported from code.google.com/p/google-bigquery
1 stars 0 forks source link

Added Support for \N to be recognized as NULLs fields, needed to supported CSV's generated by MySQL #206

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
From mysql, some fields (integer, float) are null but are shown as \N when 
exported.

For example:

123 456 '2.2.0.159' 'monday' 'London' 'GB' \N 1026 0

Trying to import these fields into BigQuery leads to an error. It would nice to 
add support for  `\N` to represent NULL values as that's a syntax used by 
mysql. 

See: 
http://stackoverflow.com/questions/13050296/insert-null-integer-into-google-bigq
uery
http://dev.mysql.com/doc/refman/5.0/en/null-values.html

Original issue reported on code.google.com by gary4...@gmail.com on 3 Jan 2015 at 6:11