Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tHiveCreateTable schema doesn't have a Date DBType

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.
Labels (4)
2 Replies
Anonymous
Not applicable
Author

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

found a tip:
If you go to windwos -> preferences -> Talend -> Specific Settings -> MetaData of TalendType
you can see how the types are represented.
0683p000009MBDs.pngyou 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.