The only option I know in that case is using 'string' in hive. Also have to see how something like sqoop will bring the data over, perhaps need to cast the data type in Teradata first, using views. Those are my thoughts, there could be other tricks.
On Mon, Aug 25, 2014 at 9:26 PM, reena upadhyay <reena2...@gmail.com> wrote: > Hi, > > As long as the data type is ANSI complaint, its equivalent type is > available in Hive. But there are few data types that are database specific. > Like there is a PERIOD data type in teradata, it is specific to teradata > only, So how to map such columns in Hive? > > Thanks. > > > On Tue, Aug 26, 2014 at 6:44 AM, Peyman Mohajerian <mohaj...@gmail.com> > wrote: > >> 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. >>> >> >> >
