csv boolean type

2012-03-13 Thread Keith Wiley 
What string values in a csv field are parsable by Hive as booleans?  If I 
indicate that a column is of type boolean when wrapping an external table 
around a csv file, what are the legal values?  I can imagine numerous 
possibilities, for example (for the true values):
0
t
T
true
True
TRUE
y
Y
yes
Yes
YES

etc.


Keith Wiley kwi...@keithwiley.com keithwiley.commusic.keithwiley.com

I used to be with it, but then they changed what it was.  Now, what I'm with
isn't it, and what's it seems weird and scary to me.
   --  Abe (Grandpa) Simpson

Re: csv boolean type

2012-03-13 Thread Keith Wiley 
I obviously intended '1', not '0' as an example of a true value.


Keith Wiley kwi...@keithwiley.com keithwiley.commusic.keithwiley.com

The easy confidence with which I know another man's religion is folly teaches
me to suspect that my own is also.
   --  Mark Twain