topic tHiveCreateTable schema doesn't have a Date DBType in Talend Studio

tHiveCreateTable schema doesn't have a Date DBType

Anonymous — Sat, 16 Nov 2024 11:01:10 GMT

Hello.
According to hive documentation, one of the columns available for hive is DATE.
When I create a hive table using tHiveRow and state that a column is DATE it works fine and create the table, but when I try to create it using tHiveCreateTable, there's no matching column type in the schema selection panel - only TIMESTAMP, which doesn't work for me.
I tried to edit the component (and compared the descriptor xml to tOracleInput, for example) and the fieldtype is SCHEMA_TYPE on both.
Why are they different?
Please advise.
If there's another way to get around this, it would also be appreciated.
Cheers.

Re: tHiveCreateTable schema doesn't have a Date DBType

Anonymous — Wed, 28 Oct 2015 08:24:43 GMT

It doesn't support Date type now, can you please report a feature request in our bugtracker?

Re: tHiveCreateTable schema doesn't have a Date DBType

Anonymous — Thu, 04 Feb 2016 11:18:18 GMT

found a tip:
If you go to windwos -> preferences -> Talend -> Specific Settings -> MetaData of TalendType
you can see how the types are represented.
you can edit the mapping_hive.xml and add a line (top)
<dbType type="DATE" ignoreLen="true" ignorePre="true"/>
and a line (bottom)
<dbType type="DATE">
<talendType type="id_Date" default="true"/>
</dbType>
and get the Date format in hive.