Re: boolean types thru a transform script

2010-10-13 Thread Dave Brondsema
Transform scripts only output text, so Hive has to convert from string to the column's data type (boolean in this case). So if you send an empty string "", that will be converted to boolean FALSE. FYI, on the way in to a transform script, booleans come through as strings "true" and "false". On T

boolean types thru a transform script

2010-10-12 Thread Luke Crouch
I'm trying to pass a FALSE value thru a custom transform script to another table, like so: FROM ( FROM downloads SELECT project, file, os, FALSE as folder, country, dt WHERE dt='2010-05-14' DISTRIBUTE BY project SORT BY project as