hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Keith Wiley <kwi...@keithwiley.com>
Subject csv boolean type
Date Tue, 13 Mar 2012 22:58:36 GMT
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     kwiley@keithwiley.com     keithwiley.com    music.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
________________________________________________________________________________


Mime
View raw message