from teradata documentation
A PERIOD column in Teradata can be any date or timestamp type
I think both of these are supported in hive-0.13 if not as Peyman
suggested, strings are best friends when we are not sure
On Tue, Aug 26, 2014 at 6:56 AM, reena upadhyay wrote:
> Hi,
>
> As long as the
Thanks a lot for sharing your views.
On Tue, Aug 26, 2014 at 7:06 AM, Peyman Mohajerian
wrote:
> 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 vie
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
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
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
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 i
