question Re: Modify Data Type in Hive in Archives of Support Questions (Read Only)

Modify Data Type in Hive

prodgers125 — Wed, 24 Feb 2016 03:21:55 GMT

- 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...

Re: Modify Data Type in Hive

Shelton — Wed, 24 Feb 2016 04:04:11 GMT

@Pedro Alves

Have a look at this example

These are the possible conversion

Re: Modify Data Type in Hive

prodgers125 — Wed, 24 Feb 2016 05:24:41 GMT

Thanks 🙂 So I use the code in Hive Script