As far as i know you cannot do that and most likely you don't need it, here
are sample mappings between the two systems:
Teradata
Hive
DECIMAL(x,y) double DATE,TIMESTAMP timestamp INTEGER,SMALLINT,BYTINT
int VARCHAR,CHAR string DECIMAL(x,0) bigint
I would typically stage data in hadoop as all string and then move it to
hive managed/orc with the above mapping.
On Mon, Aug 25, 2014 at 8:42 PM, reena upadhyay <reena2...@gmail.com> wrote:
> Hi,
>
> Is there any way to create custom user defined data type in Hive? I want
> to move some table data from teradata database to Hive. But in teradata
> database tables, there are few columns data type that are not supported in
> Hive. So to map the source table columns to my destination table columns in
> Hive, I want to create my own data type in Hive.
>
> I know about writing UDF's in Hive but have no idea about creating user
> defined data type in HIve. Any idea and example on the same would be of
> great help.
>
> Thanks.
>
