I think we'd really like to add it but so far nobody has invested the time into doing it. It's a fairly big task because I think we would have to add a new internal type to Impala, which requires changes across the codebase and then some thought into adding builtins, etc.
That's my two cents. Other people have probably thought about it a lot more than I have though! - Tim On Mon, Nov 6, 2017 at 12:38 AM, Quanlong Huang <huang_quanl...@126.com> wrote: > Hi all, > > > AFAIK, Impala has not supported Date type, which describes a particular > year/month/day, in the form YYYY-MM-DD, in Hive. > However, Hive has supported Date type in Parquet two years ago in > Hive-1.2.0. (See https://issues.apache.org/jira/browse/HIVE-8119 and > https://cwiki.apache.org/confluence/display/Hive/Parquet#Parquet- > VersionsandLimitations.) I know that we have Timestamp type which can > totally cover the Date type. But we have huge legacy data in our Hive > warehouse containing the Date type. It's inconvenient that each time we > have to convert the data we need into types Impala supports. > > > Do we have some discussion before about this? Is this blocked by the fact > that the latest CDH still uses Hive-1.1.0? Finally, do we plan to support > Date type? > > Thanks, > > Quanlong