Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.