Join this group to access featured content and participate in discussions related to DMX.

140 Members
Join Us!

How to map a field with value of 'true'/'false' in a csv file to a Hive table that has column of boolean type?

When I tried to map the record type of csv file for source, i found the drop down only provide 3 different kind of data type: text, number and date/time.

so I add a new value and try to use function = IfMatches(chassis_recordlayout.remanufacture_indicator,=,/true|TRUE/,'character') to see if I can catch boolean that way, but I get "YOU HAVE PROVIDED A CONDITION WHERE A VALUE IS EXPECTED" error message.

Does anyone have a way to handle this?  Appreciate any input.

Thanks

Fiona

You need to be a member of Syncsort Community to add comments!

Join Syncsort Community

Email me when people reply –

To access Syncsort Knowledge Base, visit:

My Support