Modify Data Type in Hive

[#1]

- Hello, I create a table in Hive and I set all the fields in String. However I wanna to transform to other data type using SerDe... But I don't know how to do it... I need to create a class in java to create the SerDe properties (I'm not a programmer)? Can I use some Serde Properties that already exists? Where? In the scipt that creates the Table? Sorry but I'm very confusing about this...

[#2 · Accepted solution]

@Pedro Alves

Have a look at this example

These are the possible conversion

[#3]

Thanks 🙂 So I use the code in Hive Script