Re: advise for dim table

2019-02-27 Thread Tim Armstrong
I can't think of a reason why 0 would be parsed differently from 1, 2, 3, or 4. I can think of reasons why the first line would be dropped - You have a unicode BOM at the start of the file and Impala is hitting a parse error. You could try setting abort_on_error=True and seeing if the que

advise for dim table

2019-02-27 Thread Fawze Abujaber
Hi Community, I have a process importing file from vertica to hadoop and i create an impala table on it, i start see weird behaviour where 0 INT value are missing in the table, when i create the table and changing the column to STRING is see the record. *** The table definition in vertica is INT