Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, all,
May I know how to correctly load mysql table with binary column?
I need to use a table from a database implemented by a college, and found that one column is binary data.
After a normal "LOAD", this binary column is empty for some rows. Have no idea why. Dose any one knows about this?
Though I solved the problem as the reply below, but I do not understand why only some rows get "empty" data. It seems not null, as I use isNull() condition to check the value, it still get an empty column.
Thanks very much
Zhihong
Hi, all,
I solved the problem by first load binary in mysql load using HEX() function like this:
LOAD ...;
SQL SELECT
HEX(Id) as Id,
Name,
FROM table01;
Hi, all,
I solved the problem by first load binary in mysql load using HEX() function like this:
LOAD ...;
SQL SELECT
HEX(Id) as Id,
Name,
FROM table01;