Join this group to access featured content and participate in discussions related to DMX.
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.