Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Bit Datatype to Boolean Conversion in Hive Schema

I'm pulling data from SQL server which has a bit Datatype Column having values 0 & 1.In Streamset we are using a drift solution and the Table that gets created is defined as BOOLEAN.What happens is 0 and 1 from Source server is getting converted to False and True while Loading into BOOLEAN column.Is there a way in Streamset to Populate the BIT Column datatype as it is to Target.